MVSFORUMS.com

[Siddheart22]

Hi,

I have file say ABC.CONTROL.FILE which contains one record with the timestamp in YYYYMMDDHHMMSS format as its first field. The record in all is 28 bytes long.
The layout of this file is:

01 Abc-Control-File.
05 Timestamp PIC X(14).
05 Filler PIC X(14).

Problem Statement:
Using this file I need to build a FTP control card which contains 7 records. Here is a sample FTP control card:

Record1 contains IP Address : 11.22.33.44
Record2 contains user Id : used_Id
Record3 contains Passcode : Pass_Code_abc
Record4 contains Format : ASCII
Record5 contains FTP statement : PUT 'ABC.CONTROL.FILE' em_Timestamp.dat
Record6 contains FTP command : CLOSE
Record7 contains FTP command : QUIT

Now, in the Record 5 of the control card, the timestamp field from the ABC.CONTROL.FILE is to be populated to build the name of the destination file [basically, its the name of ABC.CONTROL.FILE on the server with IP mentioned in the control card]. ONLY the timestamp field needs to be changed, all the other fields in the FTP card remain as they are.

ABC.CONTROL.FILE is created once everyday. Therefore the Control card all needs to be created everyday (with the new destination file name, from the timestamp field in the control file).

Could you please help me achieve this using SYNCSORT?

Thanks for your time.

[superk]

Would this work for you?

[Siddheart22]

Thanks Superk.

It did work!
Regards,

[heman]

Hi Superk,

In the solution given by you above, where are we updating the existing control card. Please consider that the control card will be a member in a PDS.

Thanks,
Heman.

[kolusu]