IBM Mainframe Forum

by **Ramsee** » Wed Dec 04, 2013 6:02 pm

Hi All,

I have a typical requirement that my INPUT1 is a FILE which contains list of DSN names to verify the matching key.
INPUT2 is another file it will contain KEY.

Now i need to validate the first DSN present in the INPUT1 file and match with the INPUT2 Key, if KEY is found OUTPUT1 will write the DSN Name and KEY FOUND,Else DSN NAME KEY NOT FOUND like this i need to read all the DSN listed in INPUT1 file and need to match with the INPUT2 and write the OUTPUT1.

I dont know how to read the INPUT FILE Interenally.

Please suggest me how to read the DSN from INPUT1 internally.

Thanks,
Ramsee

by **BillyBoyo** » Wed Dec 04, 2013 8:05 pm

Are you trying to read the content of the DSN?

by **Ramsee** » Wed Dec 04, 2013 8:12 pm

Yes i am trying to read the content of the Listed DSN in the INPUT1 File.

Regards,
Ramsee

by **dick scherrer** » Wed Dec 04, 2013 8:14 pm

Hello,

Suggest you post a bit of sample input from both files and show what you want as output from this sample data when your process is run.

Cover anything the "real" data may contain.

Show the "rules" for processing the data.

by **Akatsukami** » Wed Dec 04, 2013 8:43 pm

Ramsee wrote:Yes i am trying to read the content of the Listed DSN in the INPUT1 File.

Then you will surely want to dynamically allocate those data sets. If Easytrieve does not have a native capacity to do this, I expect that you can invoke BPXWDYN.

by **Ramsee** » Wed Dec 04, 2013 8:47 pm

Please find the below requirement for the same

INPUT1 : List of DSN in the File

Select all

USER.TEST.DSN1
USER.TEST.DSN2
USER.TEST.DSN3
USER.TEST.DSN4
USER.TEST.DSN5
USER.TEST.DSN6
USER.TEST.DSN7
USER.TEST.DSN8
USER.TEST.DSN9

INPUT2 : KEy to be verified from the INPUT1 list of DSN

Select all

123456789

KEY
Data in DSN1..DSN9 is present in the POSITION 40.

Select all

------+----1----+----2----+----3----+----4----+----5---
ASDASDASDASDASDSADSADASDSADA 123456789 --> Date in USER.TEST.DSN1
ASDASDASDASDASDSADSADASDSADA 123456781 --> Date in USER.TEST.DSN2
ASDASDASDASDASDSADSADASDSADA 123456783 --> Date in USER.TEST.DSN3
ASDASDASDASDASDSADSADASDSADA 123456789 --> Date in USER.TEST.DSN4
ASDASDASDASDASDSADSADASDSADA 123456781 --> Date in USER.TEST.DSN5
ASDASDASDASDASDSADSADASDSADA 123456789 --> Date in USER.TEST.DSN6
ASDASDASDASDASDSADSADASDSADA 123456789 --> Date in USER.TEST.DSN7
ASDASDASDASDASDSADSADASDSADA 123456789 --> Date in USER.TEST.DSN8
ASDASDASDASDASDSADSADASDSADA 123456789 --> Date in USER.TEST.DSN9

OUTPUT1

Select all

USER.TEST.DSN1 KEY FOUND
USER.TEST.DSN2 KEY NOT FOUND
USER.TEST.DSN3 KEY NOT FOUND
USER.TEST.DSN4 KEY FOUND
USER.TEST.DSN5 KEY NOT FOUND
USER.TEST.DSN6 KEY FOUND
USER.TEST.DSN7 KEY FOUND
USER.TEST.DSN8 KEY FOUND
USER.TEST.DSN9 KEY FOUND

Please let me know in case of any further information is required.

Regards,
Seetharaman

by **dick scherrer** » Thu Dec 05, 2013 12:47 am

Hello,

One way to get what you want is to read the "key" file and get the search value. Then read the DSN file and generate SORT steps to read each file looking for the "key". When the key is found generate the "found" message. When not found, generate the not found message.

Write the found/not found info to a file that each step MODs onto.

IBM Mainframe Forum

EZT Pgm for INPUT Validation

EZT Pgm for INPUT Validation

Re: EZT Pgm for INPUT Validation

Re: EZT Pgm for INPUT Validation

Re: EZT Pgm for INPUT Validation

Re: EZT Pgm for INPUT Validation

Re: EZT Pgm for INPUT Validation

Re: EZT Pgm for INPUT Validation