Posted: Tue May 31, 2005 6:09 pm Post subject: Copying KSDS and RRDS in to a Sequential Dataset
Hi,
I have three VSAM files A, B and C. Out of which A and B are KSDS and C is a RRDS. I want to copy all these three files in to a sequential file and ftp it to a server, from which I will load it in to a Oracle database. The combiantion of A, B and C is like a multi dimensional database. A will have a key with which we can go to B and fetch the data. For some data in B we will have values in C. The file C will have the values in bit format. But my output sequential files should be a coma(,) separated one. I knew that we can use REPRO, but in order to get coma(,) separated Iam not sure. Also I'm not sure how the RRDS will work for REPRO. Please come up with some ideas.
Device type: 3390
Organization: KSDS EXTENDED
KSDS key length: 8
KSDS key location: 0
Average record size: 100
Maximum record size: 32000
For B:
Device type: 3390
Organization: KSDS EXTENDED
KSDS key length: 7
KSDS key location: 0
Average record size: 100
Maximum record size: 12500
C is
Device type: 3390
Organization: RRDS
KSDS key length: 0
KSDS key location: 0
Average record size: 1016
Maximum record size: 1016
So I need all these three files to be copied in to three Sequential files from which I need to upload to a Oracal Database.
I'm unable to give you sample input and output. But I Can say I need to copy all these 3 VSAMS in to a sequential file and need not be a comma separated one.
I have already done this, thanks for your help. whats the best way to read this data from Unix and laod it in to Oracle, whats the best readable format to do this. My ultimate goal is to ftp these file son to UNIX and then write some procedures to load it in to a Oracle. Please share some ideas on this. I think there are some common utilities on the mainframe side to compress this and send it to UNix and then uncompress it over there......any help on this??????
Kolusu,
My Vsams are not in readable format. If we open the VSAM file through file aid we may not be able to read the data. Even coma separated cannot be done. Is there any way to convert these file sin to binary format(compressing) and uncompressing at the server side, some utilities on both server side and mainframe side.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum