How to define previous day using system symbols in Symnames?



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

How to define previous day using system symbols in Symnames?

Postby skankatala » Fri Feb 03, 2012 1:00 pm

Hi......

When I am using //Symnames
I am able to define the Current day string using system symbols as CURRDATE,S'&LYR4..&LJDAY'

How to define previous day using the system symbols in the above format (i.e. YY.DDD) ?
skankatala
 
Posts: 42
Joined: Sun Dec 11, 2011 9:45 am
Location: Hyderabad
Has thanked: 0 time
Been thanked: 0 time

Re: How to define previous day using system symbols in Symna

Postby BillyBoyo » Fri Feb 03, 2012 2:36 pm

Which sort product are you using?
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: How to define previous day using system symbols in Symna

Postby NicC » Fri Feb 03, 2012 2:48 pm

Why not post in the appropriate section of the forum for your sort product? This is NOT a JCL question.
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: How to define previous day using system symbols in Symna

Postby skankatala » Fri Feb 03, 2012 9:06 pm

BillyBoyo wrote:Which sort product are you using?


I am using DFSORT.
skankatala
 
Posts: 42
Joined: Sun Dec 11, 2011 9:45 am
Location: Hyderabad
Has thanked: 0 time
Been thanked: 0 time

Re: How to define previous day using system symbols in Symna

Postby skankatala » Fri Feb 03, 2012 9:18 pm

skankatala wrote:Hi......

When I am using //Symnames in DFSORT
I am able to define the Current day string using system symbols as CURRDATE,S'&LYR4..&LJDAY'

How to define previous day using the system symbols in the above format (i.e. YY.DDD) ?


The format is YYYY.DDD.

Sorry for the wrong information...
skankatala
 
Posts: 42
Joined: Sun Dec 11, 2011 9:45 am
Location: Hyderabad
Has thanked: 0 time
Been thanked: 0 time

Re: How to define previous day using system symbols in Symna

Postby skankatala » Fri Feb 03, 2012 9:19 pm

NicC wrote:Why not post in the appropriate section of the forum for your sort product? This is NOT a JCL question.


I apoligize for that. I do not repeat it again in future...
skankatala
 
Posts: 42
Joined: Sun Dec 11, 2011 9:45 am
Location: Hyderabad
Has thanked: 0 time
Been thanked: 0 time

Re: How to define previous day using system symbols in Symna

Postby skolusu » Fri Feb 03, 2012 10:09 pm

if your intention is to get the current day-1 then you can use date3-1 which will give you the desired results.
//STEP0100 EXEC PGM=SORT         
//SYSOUT   DD SYSOUT=*           
//SORTIN   DD *                 
ABC                             
//SORTOUT  DD SYSOUT=*           
//SYSIN    DD *                 
  SORT FIELDS=COPY               
  INREC OVERLAY=(10:DATE3(.)-1) 
//*


the output of this is
----+----1----+----2
ABC      2012.033   
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
skolusu
 
Posts: 586
Joined: Wed Apr 02, 2008 10:38 pm
Has thanked: 0 time
Been thanked: 39 times

Re: How to define previous day using system symbols in Symna

Postby skankatala » Fri Feb 03, 2012 10:23 pm

skolusu wrote:if your intention is to get the current day-1 then you can use date3-1 which will give you the desired results.
//STEP0100 EXEC PGM=SORT         
//SYSOUT   DD SYSOUT=*           
//SORTIN   DD *                 
ABC                             
//SORTOUT  DD SYSOUT=*           
//SYSIN    DD *                 
  SORT FIELDS=COPY               
  INREC OVERLAY=(10:DATE3(.)-1) 
//*


the output of this is
----+----1----+----2
ABC      2012.033   


I did not expected this answer. But I modified my code and your answer helped me...
:D It worked... Thank you so much :)
skankatala
 
Posts: 42
Joined: Sun Dec 11, 2011 9:45 am
Location: Hyderabad
Has thanked: 0 time
Been thanked: 0 time


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post