SYMNAME symbol question



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

SYMNAME symbol question

Postby javivi » Fri Nov 29, 2013 3:31 pm

Hi

I have a SYMNAME file with the next records:

FINI,'2013-01-01'     
FFIN,'2013-11-28'     
INIM,'2013-11-01'     
INIS,'2013-11-21' 



I need to to use the symbol INIS in a sort but only the first four positions (the year).
I tried the nest:

64,4,CH,EQ,INIS,1,4,CH


the sort output say SYNTAX ERROR
(63,4,CH,EQ,C'2013-11-21',1,4,CH
                                         $
ICE007A 0 SYNTAX ERROR   


Any idea how I can do that?

Thanks.

Code'd
javivi
 
Posts: 47
Joined: Fri Jan 21, 2011 2:53 pm
Has thanked: 0 time
Been thanked: 0 time

Re: SYMNAME symbol question

Postby NicC » Fri Nov 29, 2013 4:19 pm

Your output does not match your input - your input begins 64 and your output (63. There is obviously soemthing wrong with the ( or something else in the the control card before what you show.

Why do you not just define another symname for the 4 digit year? And why not use the code tags?
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times

Re: SYMNAME symbol question

Postby javivi » Fri Nov 29, 2013 4:30 pm

Sorry for the mistake (copy and paste....) the right value is 63 not 64.

The symname file is generate by another job and i can't change it, I need to use that symname file.

What you mean with CODE TAGS?

Thanks
javivi
 
Posts: 47
Joined: Fri Jan 21, 2011 2:53 pm
Has thanked: 0 time
Been thanked: 0 time

Re: SYMNAME symbol question

Postby BillyBoyo » Fri Nov 29, 2013 4:56 pm

If you look at your question. it has been Code'd. If you click on the Quote button, you'll see how. Code'ing preserves formatting.

Unfortunately you can't do what you want. It would be useful to be able to, and I raised it with Kolusu a few months ago.

For your task, if you are unable to get the SYMNAMES-generator changed, I'd put in another small step which reads that SYMNAMES file, picks out the year, generates another name with the year. Creates a new file. You use that new file.

To get the year from INIS (remembering that around December/January you will have a mix of years) I'd use OUTFIL REMOVECC,TRAILER1=, where you can specify literals and also reference data from the final OUTFIL record, which is the INIS that you want the date from.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post