View previous topic :: View next topic
|
Author |
Message |
sandhya89
New User
Joined: 12 May 2011 Posts: 1 Location: chennai
|
|
|
|
Write a sort for the below requirement:
a) To get the current system date in the output file
b) To get the records which have “Y” in the 7th position of the input file
need a help regarding this |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
And you haven't given us the standard details.
Input and output files DSORG, RECFM, LRECL
Sort product and release level that you have installed. |
|
Back to top |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007 Posts: 2455 Location: Hampshire, UK
|
|
|
|
Get the system date in the output file - as a record? or as part of the dataset name?
For the other point - read the manual particularly about COPY and the INCLUDE keyword |
|
Back to top |
|
|
sqlcode1
Active Member
Joined: 08 Apr 2010 Posts: 577 Location: USA
|
|
|
|
sandhya89
Quote: |
a) To get the current system date in the output file
b) To get the records which have “Y” in the 7th position of the input file |
Where/which position do you want system date? Did you mean header or trailer records or populate system date at certain position for all records?
Please provide RECFM and LRECL for input/output files. Also,if possible provide a sample input and expected output.
Thanks, |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
narmadha,
You haven't given enough details for anyone to help you.
Please show an example of the records in your input file (relevant fields only) and what you expect for output. Explain the "rules" for getting from input to output. Give the starting position, length and format of each relevant field. Give the RECFM and LRECL of the input file. |
|
Back to top |
|
|
|