|
|
| Author |
Message |
iknow
Senior Member
Joined: 22 Aug 2005
Posts: 582
Location: Colarado, US
|
|
|
|
Hi All
Could anyone tell me like how to convert a VSAM file to flat file?If possible explain with an example. |
|
| Back to top |
|
 |
References
|
|
 |
Rupesh.Kothari
Member of the Month
Joined: 27 Apr 2005
Posts: 486
|
|
|
|
Hi
| Quote: |
| Could anyone tell me like how to convert a VSAM file to flat file?If possible explain with an example. |
To copy from VSAM to Flat file we can use IDCAM utility.
| Code: |
//STEP04 EXEC PGM=IDCAMS
//INPUT1 DD DSN=Input File VSAM name ,DISP=SHR
//OUTPUT1 DD DSN=Out Put Flat file name ,
Give other parameter like Disp, Space and other.
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SYSIN DD *
REPRO INFILE(INPUT1) OUTFILE(OUTPUT1)
/* |
Hope this helps
Regards
Rupesh |
|
| Back to top |
|
|
Kevin
Active User
Joined: 25 Aug 2005
Posts: 254
|
|
|
|
iknow, could you please define what you mean by a "flat file"?
By definition, that's either a simple database, any file that is not a database, or a non-delimited file in an ASCII environment. |
|
| Back to top |
|
|
priyesh.agrawal
Global Moderator
Joined: 28 Mar 2005
Posts: 1509
Location: Chicago, IL
|
|
|
|
Thats right Kevin....There have been continuous speculation over term "FLAT"....
I hope iknow meant for a Physical Sequential Dataset.
Regards,
Priyesh. |
|
| Back to top |
|
|
vijayamadhuri
Active User
Joined: 06 Apr 2005
Posts: 185
|
|
|
|
| a flat file is generally a sequential dataset |
|
| Back to top |
|
|
iknow
Senior Member
Joined: 22 Aug 2005
Posts: 582
Location: Colarado, US
|
|
|
|
Hi All
I meant only physical sequential dataset. If that's the case how can I do it. |
|
| Back to top |
|
|
|
|
