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 [
On 03/07/12 21:19, Ed Clark wrote:
> Hmm, I never knew that EVAL needed to write to the dict on universe. Is that
> try on unidata as well?
It was certainly the case on Prime.
I always thought it was security more than anything else. Not
particularly effective necessarily, but if you've locked
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 everyth
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 parameters
There are 3 ways I can think of offhand to tell the subroutine what date range
to use. I like #3 the best:
1: use common variables, which is what the example function MARKH does. The
downside is that you have to assign the common variables before you run the
query.
2: You could use @SENTENCE i
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
g.org] 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 TOL
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 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 file
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 wi
ers-boun...@listserver.u2ug.org
[u2-users-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 wou
lf 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 detai
ssage-
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 6:53 AM
To: 'U2 Users List'
Subject: [U2] UniVerse LIST statement question [not-secure]
I need to do a UniVerse LIST statement
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 it
14 matches
Mail list logo