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
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
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
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
Mark
Took me a couple of times reading through the post to understand the issue
..
I think you're going to have to call a subroutine rather than use a LIST.
Brian
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of
How about LIST CALLS EAMP.NAME EMP.LOCATION WHEN DATE.CALL GE 2012-06-01 AND
DATE.CALL LE 2012-06-30 DURATION TOLL WITH @ID EQ '123456'
In order for the When to work, it must be declared as Multivalued in the DICT
of DATE.CALL, DURATION and TOLL and most likely, need to
have the same associated
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
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
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
] 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
10 matches
Mail list logo