Re: [U2] UniVerse LIST statement question [not-secure]

2012-07-05 Thread Hennessey, Mark F.
Thanks for all of the responses. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hennessey, Mark F. Sent: Monday, July 02, 2012 9:53 AM To: 'U2 Users List' Subject: [U2] UniVerse LIST statement question [not-secure

Re: [U2] UniVerse LIST statement question [not-secure]

2012-07-03 Thread Charles Stevenson
What Brian said, except don't replace LIST! Rather, write your subroutine to be called from an I-descriptors: MARKH 0001 FUNCTION MARKH( INARG ) 0002 COMMON /MARKH/ START.IDT, END.IDT, PREV.ID, VLIST 0003 * 0004 * Assumes common has been initialized properly before this function

Re: [U2] UniVerse LIST statement question [not-secure]

2012-07-03 Thread Charles Stevenson
Ed is quite right. 1: I just did it for simplicity in the example. 2: @SENTENCE, without a wrapper: you have do get ReTrieve to ignore part of the sentence. I've never come up with a good way to do that other than via EVAL. Anyone? 3. EVAL: Yes, it is a way to pass run-time

Re: [U2] UniVerse LIST statement question [not-secure]

2012-07-03 Thread Ed Clark
There have been more than a few times when I wished that MV query was a little more extensible. On a couple of occasions I have created throwaway connectives as a means to pass flags to an i-type or a B correlative, but it would be nice if there were a keyword that flagged to just ignore

[U2] UniVerse LIST statement question [not-secure]

2012-07-02 Thread Hennessey, Mark F.
I need to do a UniVerse LIST statement that would only populate a column if the contents met certain criteria. For example, suppose we have a file with details of telephone usage and that 3 associated mulitvalued fields contain date call was made, duration and if the call was a toll call. Is

Re: [U2] UniVerse LIST statement question [not-secure]

2012-07-02 Thread Brian Leach
Of Hennessey, Mark F. Sent: 02 July 2012 14:53 To: 'U2 Users List' Subject: [U2] UniVerse LIST statement question [not-secure] I need to do a UniVerse LIST statement that would only populate a column if the contents met certain criteria. For example, suppose we have a file with details of telephone

Re: [U2] UniVerse LIST statement question [not-secure]

2012-07-02 Thread George Gallen
-boun...@listserver.u2ug.org] On Behalf Of Hennessey, Mark F. [mark.hennes...@ct.gov] Sent: Monday, July 02, 2012 9:53 AM To: 'U2 Users List' Subject: [U2] UniVerse LIST statement question [not-secure] I need to do a UniVerse LIST statement that would only populate a column if the contents met

Re: [U2] UniVerse LIST statement question [not-secure]

2012-07-02 Thread Tony Gravagno
LIST CALLS '123456' EMP.NAME EMP.LOCATION DATE.CALL GE 2012-06-01 AND LE 2012-06-30 DURATION TOLL ? From mark.hennessey I need to do a UniVerse LIST statement that would only populate a column if the contents met certain criteria. For example, suppose we have a file with

Re: [U2] UniVerse LIST statement question [not-secure]

2012-07-02 Thread Richard Wilson
could you setup an index based on employee number.? then possibly use that index against employees active for June Rich Hennessey, Mark F. wrote: I need to do a UniVerse LIST statement that would only populate a column if the contents met certain criteria. For example, suppose we have a

Re: [U2] UniVerse LIST statement question [not-secure]

2012-07-02 Thread Ed Clark
I think the answer is to use an i-type dictionary. You can use WHEN instead of WITH on multivalued columns to limit printing to just the multi values you want, but then you wouldn't get an output line for the items where there were no calls in the range. You could do 2 separate reports, one

Re: [U2] UniVerse LIST statement question [not-secure]

2012-07-02 Thread Brian Leach
] On Behalf Of Tony Gravagno Sent: 02 July 2012 16:10 To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniVerse LIST statement question [not-secure] LIST CALLS '123456' EMP.NAME EMP.LOCATION DATE.CALL GE 2012-06-01 AND LE 2012-06-30 DURATION TOLL ? From mark.hennessey I need to do