read a pds file and create varibles in rexx
Posted: Wed Jul 08, 2009 8:33 pmI have a pds file and want to read it and break data up into variables using rexx any one have ideas or atleast send me in the right direction.
IBM Mainframe Forum
Mainframe Technical Support Forums
https://www.ibmmainframeforum.com/
read a pds file and create varibles in rexx
Page 1 of 1
Posted: Wed Jul 08, 2009 8:33 pmRe: read a pds file and create varibles in rexx
Posted: Wed Jul 08, 2009 9:38 pmSee this previous topic.
Re: read a pds file and create varibles in rexx
Posted: Thu Jul 09, 2009 12:44 amok was reading up on that maybe im just confused.
what i want to do is read in a pds that has lines of data and each observation or line has 20 colums i want to be able to tell rexx that the first colum in the first line should have this in this format and so fourth all the way down the line then put that data on another line in another data set. also there are mutiple lines of data which has the same exact data in some colums. example
SYS TYPE REPORT ACCT TRAN 200905 200906 200907
I.D. TASK CLASS WORKLOAD APPL ID CODE PREF ####.# ####.# ####.#
---- ---- -------- -------- -------- ---- ---- ------ ------ ------
xxxx JOB BATCH xxxx_B RODE_PC 035 0.0 0.0 3.0
xxxx JOB BATCH xxxx_B RODE_PC 035 0.0 0.0 10.0
xxxx JOB BATCH xxxx_B RODE_PC 035 0.0 0.0 3.0
xxxx JOB BATCH xxxx_B xxxxx_PC 035 100.0 0.0 3.0
what i want to do is read in a pds that has lines of data and each observation or line has 20 colums i want to be able to tell rexx that the first colum in the first line should have this in this format and so fourth all the way down the line then put that data on another line in another data set. also there are mutiple lines of data which has the same exact data in some colums. example
SYS TYPE REPORT ACCT TRAN 200905 200906 200907
I.D. TASK CLASS WORKLOAD APPL ID CODE PREF ####.# ####.# ####.#
---- ---- -------- -------- -------- ---- ---- ------ ------ ------
xxxx JOB BATCH xxxx_B RODE_PC 035 0.0 0.0 3.0
xxxx JOB BATCH xxxx_B RODE_PC 035 0.0 0.0 10.0
xxxx JOB BATCH xxxx_B RODE_PC 035 0.0 0.0 3.0
xxxx JOB BATCH xxxx_B xxxxx_PC 035 100.0 0.0 3.0
Re: read a pds file and create varibles in rexx
Posted: Thu Jul 09, 2009 1:36 amHello,
So, this really has nothing specific to do with a pds? This could just as well be a simple sequential file?
Keep in mind that what you "have" and what want to do is completely clear to you, but may not be to others.
If that is the input, what should be the output?
What are the "rules" for getting from the input to the output?
So, this really has nothing specific to do with a pds? This could just as well be a simple sequential file?
What does this mean?i want to be able to tell rexx that the first colum in the first line should have this in this format
Keep in mind that what you "have" and what want to do is completely clear to you, but may not be to others.
If that is the input, what should be the output?
What are the "rules" for getting from the input to the output?
Re: read a pds file and create varibles in rexx
Posted: Thu Jul 09, 2009 2:28 amok i have a supec rexx program that compares the changes from two files and then i want to be able to add the changes to the original file so if someone changes info on any given line or colum or delets a line i want to be able to add those changes to the original file.
and the next step is to have error checking code that checks for errors for each colum. thats what i meant about the format.
like in line one first varible should have a format standard of AB12345 meaning 1st two are charaters and the last 5 will be numeric.
and the next step is to have error checking code that checks for errors for each colum. thats what i meant about the format.
like in line one first varible should have a format standard of AB12345 meaning 1st two are charaters and the last 5 will be numeric.