Page 1 of 1

ON in ICETOOL's DISPLAY statement

PostPosted: Wed Nov 26, 2014 12:23 am
by Gallium
On page 150 of this

http://publibz.boulder.ibm.com/epubs/pdf/ice1cg60.pdf

Can anyone explain to me what ON(1,15,CH)ON...

means. I know CH, PD and ZD are data types but I am a little unclear as to the rest?

Re: ON in ICETOOL's DISPLAY statement

PostPosted: Wed Nov 26, 2014 3:53 am
by Terry Heinze
Page 151 seems to explain the ON operand. What have you tried so far and what were the results?

Re: ON in ICETOOL's DISPLAY statement

PostPosted: Wed Nov 26, 2014 4:37 am
by Gallium
Not fully though, it mentions p,m,f, formatting, VLEN and NUM but doesn't explain what they actually mean. If I knew what they meant I could try something.

Re: ON in ICETOOL's DISPLAY statement

PostPosted: Wed Nov 26, 2014 5:03 am
by BillyBoyo
The ON statements in DISPLAY are defining the fields you want listed in the report.

Re: ON in ICETOOL's DISPLAY statement

PostPosted: Wed Nov 26, 2014 5:32 am
by Gallium
BillyBoyo wrote:The ON statements in DISPLAY are defining the fields you want listed in the report.


so ON(1,15) means fields 1 and 15 in the original data set?

Re: ON in ICETOOL's DISPLAY statement

PostPosted: Wed Nov 26, 2014 1:05 pm
by BillyBoyo
No, SORT/ICETOOL does not know about any fields unless you define them. In DISPLAY, ON is how you define them.

it means the first field which will be printed is at position one in the input file and has a length of 15. ON(1,15) is invalid for DISPLAY. The field-type is mandatory. In the example, it is ON(1,15,CH) which means character data.

Re: ON in ICETOOL's DISPLAY statement

PostPosted: Wed Nov 26, 2014 8:24 pm
by Gallium
BillyBoyo wrote:No, SORT/ICETOOL does not know about any fields unless you define them. In DISPLAY, ON is how you define them.

it means the first field which will be printed is at position one in the input file and has a length of 15. ON(1,15) is invalid for DISPLAY. The field-type is mandatory. In the example, it is ON(1,15,CH) which means character data.


That's great thanks, makes you wonder why they couldn't just say that! I know you need CH etc. but I knew what they meant before. Although is there a URL that someone could point me to that?

Re: ON in ICETOOL's DISPLAY statement

PostPosted: Wed Nov 26, 2014 9:41 pm
by Gallium
Gallium wrote:
BillyBoyo wrote:No, SORT/ICETOOL does not know about any fields unless you define them. In DISPLAY, ON is how you define them.

it means the first field which will be printed is at position one in the input file and has a length of 15. ON(1,15) is invalid for DISPLAY. The field-type is mandatory. In the example, it is ON(1,15,CH) which means character data.


That's great thanks, makes you wonder why they couldn't just say that! I know you need CH etc. but I knew what they meant before. Although is there a URL that someone could point me to that?


that lists all the possible data types CH, ZD, PD etc.

Re: ON in ICETOOL's DISPLAY statement

PostPosted: Wed Nov 26, 2014 9:47 pm
by BillyBoyo
The Getting Started is a tutorial to get people going on using some of the power of SORT/ICETOOL.

ON(p,m,f)
Specifies the position, length, and format of a numeric or character field to be
used for this operation.


That's from the DFSORT Application Programming Guide. The PDFs I have are 224 pages vs 970 pages.

If you look at the "stickies" at the top of the DFSORT forum you'll find links to all the DFSORT publications.