View previous topic :: View next topic |
Author |
Message |
sharada Beginner
Joined: 24 Aug 2005 Posts: 32 Topics: 14 Location: Hyderabad
|
Posted: Mon Sep 19, 2005 10:49 pm Post subject: what is &DATE1 |
|
|
Hi,
Previously I have posted a question as,
how to compare a date field with current
date in JCL SORT and I got reply to use
&DATE1. I have used it and its working
fantastic.
My question now is what is &DATE1 is it
a register having current date value, or
a function which returns current date.
Please explain,
I will be very thankful if any one of you can
provide a document for that.
Thanks,
Sharada. |
|
Back to top |
|
|
Phantom Data Mgmt Moderator
Joined: 07 Jan 2003 Posts: 1056 Topics: 91 Location: The Blue Planet
|
Posted: Tue Sep 20, 2005 12:43 am Post subject: |
|
|
Sharada,
&DATEx, &DATExC, &DATExP (x = 1, 2 & 3) are all date constants (symbolic constants) which reperesent current date in various formats (numeric, text & Packed Decimal).
Quote: |
I will be very thankful if any one of you can
provide a document for that.
|
Sure, but first, I need to know what Sort product you use (Syncsort / DFSORT).
Thanks,
Phantom |
|
Back to top |
|
|
sharada Beginner
Joined: 24 Aug 2005 Posts: 32 Topics: 14 Location: Hyderabad
|
Posted: Tue Sep 20, 2005 12:47 am Post subject: |
|
|
Hi Phantom,
I am using SYNCSORT _________________ Regards,
Sharada.
Always perform your duty efficiently and without any selfish attachment to the results,
because by doing work without attachment one attains Supreme. |
|
Back to top |
|
|
Phantom Data Mgmt Moderator
Joined: 07 Jan 2003 Posts: 1056 Topics: 91 Location: The Blue Planet
|
Posted: Tue Sep 20, 2005 12:51 am Post subject: |
|
|
Sharada,
Syncsort manuals are copyrighted and are not available on the net for distribution. If your shop has a valid licence, talk to your Sys. Programmers to find the syncsort manual.
Thanks,
Phantom |
|
Back to top |
|
|
sharada Beginner
Joined: 24 Aug 2005 Posts: 32 Topics: 14 Location: Hyderabad
|
Posted: Tue Sep 20, 2005 12:53 am Post subject: |
|
|
THANK YOU _________________ Regards,
Sharada.
Always perform your duty efficiently and without any selfish attachment to the results,
because by doing work without attachment one attains Supreme. |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12375 Topics: 75 Location: San Jose
|
Posted: Tue Sep 20, 2005 6:45 am Post subject: |
|
|
Sharada,
The following are the various formats of current date.
Code: |
CURRENT-DATE FORMAT
============ ====================
&DATE1 C'YYYYMMDD'
&DATE1(C) C'YYYYCMMCDD'
&DATE1P +YYYYMMDD
&DATE2 C'YYYYMM'
&DATE2(C) C'YYYYCMM'
&DATE2P +YYYYMM
&DATE3 C'YYYYDDD'
&DATE3(C) C'YYYYCDDD'
&DATE3P +YYYYDDD
&DATE4 C'YYYY-MM-DD-HH.MM.SS'
Y'DATE1' Y'YYMMDD'
Y'DATE2' Y'YYMM'
Y'DATE3' Y'YYDDD'
|
&DATEx and &DATEx(c) represent the current date as a character string (C'string')
&DATExP represents the current date as a decimal number (+n)
However some of them are dependent on the version of sort you have.
Hope this helps...
Cheers
Kolusu _________________ Kolusu
www.linkedin.com/in/kolusu |
|
Back to top |
|
|
|
|