View previous topic :: View next topic
|
Author |
Message |
sharad_shanu
New User
Joined: 03 Oct 2006 Posts: 40
|
|
|
|
Hi,
We are transmitting a file thry XMIT to some users. The name of the report we are sending is 'XYZ.csv".
We would like to put date at the end of reprt name to make it like "XYZ_mmddyyyy.csv".
We have a date in file1 and rest of transmit command in file2. We want to put date from file1 to be added in filename which is present in file2.
The data in file1 is
10022010
The data in file2 is:
-------------------------------
-------------------------------
SUBJECT: report XYZ
-------------------------------
-------------------------------
filename: "XYZ.csv"
We have shown two rows from file2 where we need to add date. Is there any way to perform this through sort? I would be thankful for the help.
Regards,
Sharad |
|
Back to top |
|
|
sqlcode1
Active Member
Joined: 08 Apr 2010 Posts: 577 Location: USA
|
|
|
|
sharad_shanu,
What is the expected output for this sample that you have shown? What is the lrecl and recfm for the input and output files?
Thanks, |
|
Back to top |
|
|
|