IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

how to read qsam file into vsam without comma(,)


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
ravi_asgm
Warnings : 2

New User


Joined: 07 Jun 2007
Posts: 5
Location: ap

PostPosted: Mon Jul 23, 2007 1:32 pm
Reply with quote

hi sir

i am having a file qsam EMP
records are stored in form like

ENO1,ENAME1,ESAL1,ENO2,ENAME2,ESAL2,ENO3,ENAME3,.........

HOW we can read this records with out comma(,) into vsam file

plz reply sir
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ

PostPosted: Mon Jul 23, 2007 1:37 pm
Reply with quote

Another interview question?
Quote:
records are stored in form like
ENO1,ENAME1,ESAL1,ENO2,ENAME2,ESAL2,ENO3,ENAME3,.........
Records are not "stored" in that form.....
Quote:
HOW we can read this records with out comma(,) into vsam file
Are you trying to transfer from QSAM to VSAM?
And what does the comma have to do with anything?
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales

PostPosted: Mon Jul 23, 2007 1:56 pm
Reply with quote

Would this be a CSV file ?
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA

PostPosted: Mon Jul 23, 2007 8:48 pm
Reply with quote

ravi,

I suspect you can use DFSORT's PARSE feature to do what you want, but it's not clear exactly what you want to do.

For more information on DFSORT's PARSE function, see:

Use [URL] BBCode for External Links

If you want more specific help, show an example with more than one input record, and what you expect for output. Give the RECFM and LRECL of the input file.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts FTP VB File from Mainframe retaining ... JCL & VSAM 4
No new posts Extract the file name from another fi... DFSORT/ICETOOL 6
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Error to read log with rexx CLIST & REXX 11
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
Search our Forums:

Back to Top