Search found 387 matches

by pradkumar
Tue Mar 11, 2008 11:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to extract data from VSAM file using CFF stage
Replies: 9
Views: 3949

How to extract data from VSAM file using CFF stage

Hi Everyone, I converted a VSAM file to a Seq file and FTP the Sequential VSAM file to the DataStage server in binary format . Iam using Complex Flat File Stage to extract (import) this Sequential file in my DataStage job. If i view the data in CFF stage iam seeing wierd characters for all the colum...
by pradkumar
Mon Mar 10, 2008 12:34 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataFormat in Complex Flat File Stage
Replies: 3
Views: 3752

Hi Craig, Thanks for your reply, I need to extract the data from VSAM file. Could you please suggest me what to ask the mainframe person regarding the VSAM file. I searched the forum and i have got some information. But iam not in clear manner to explain to the mainframe person in converting the VSA...
by pradkumar
Mon Mar 10, 2008 12:11 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataFormat in Complex Flat File Stage
Replies: 3
Views: 3752

DataFormat in Complex Flat File Stage

Hi , I need to extract data from VSAM file on mainframe . I am using CFF stage in my server job. If open outputs tab on the stage properties i could only see NLS as Dataformat and Record style as Binary or CR/LF. But in the manual about the CFF Stage in server it has given as Data Format: The format...
by pradkumar
Fri Mar 07, 2008 11:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Can we extract VSAM file on Mainframe through datastage
Replies: 2
Views: 1479

Ok Thanks a lot.

Sree
by pradkumar
Fri Mar 07, 2008 10:20 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Can we extract VSAM file on Mainframe through datastage
Replies: 2
Views: 1479

Can we extract VSAM file on Mainframe through datastage

Hi Everyone,

Iam using server job. Can we extract VSAM file on mainframe through CFF stage in server job? Thanks a lot

Sree
by pradkumar
Wed Mar 05, 2008 5:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to extract data from VSAM Files
Replies: 21
Views: 19290

Hi Aruna,

Did you check the CFF stage in server and please let me know how to work out this issue.

Many Thanks

Sreekanth
by pradkumar
Wed Mar 05, 2008 5:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to extract data from VSAM Files
Replies: 21
Views: 19290

Hi Aruna,

Did you check the CFF stage in server and please let me know how to work out this issue.

Many Thanks

Sreekanth
by pradkumar
Wed Mar 05, 2008 5:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to extract data from VSAM Files
Replies: 21
Views: 19290

Hi Aruna,

Did you check the CFF stage in server and please let me know how to work out this issue.

Many Thanks

Sreekanth
by pradkumar
Tue Mar 04, 2008 6:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to extract data from VSAM Files
Replies: 21
Views: 19290

Hi Aruna,

Did you check the CFF stage in server and please let me know how to work out this issue.

Many Thanks

Sreekanth
by pradkumar
Tue Mar 04, 2008 3:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to extract data from VSAM Files
Replies: 21
Views: 19290

Hi , First of all thanks for your quick reply. My job is server job.I could only see Data format as NLS and Record style as Binary and CR/LF , Record Length , a check box for verify sign value for decimal comp-3 and a check box for preserve NULL in General tab of CFF stage of the server job. The mai...
by pradkumar
Tue Mar 04, 2008 2:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to extract data from VSAM Files
Replies: 21
Views: 19290

Hi Aruna, Iam working on version 8.0.1 on windows server. So in CFF stage i could only see Dataformat : as NLS Record Style as : Binary or CR/LF. what do i need to tell to mainframe person to convert VSAM file in to ???I( which format ) Is it fine if the mainframe person converts VSAM file to text f...
by pradkumar
Thu Feb 28, 2008 11:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to extract data from VSAM Files
Replies: 21
Views: 19290

Thanks a lot Aruna,iam working on that .If i have any more questions i will be in contact with you.
by pradkumar
Wed Feb 27, 2008 3:54 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to extract data from VSAM Files
Replies: 21
Views: 19290

Hi Aruna, Iam also facing the same problem of extracting the data from VSAM files.Iam new to datastage and working on version 8 windows. Could you help me how to extract the vsam files .Do i need to convert the VSAM files to sequential file and then ftp to datastage server . or can i directly ftp th...
by pradkumar
Wed Feb 27, 2008 3:53 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to extract data from VSAM Files
Replies: 21
Views: 19290

Hi Aruna, Iam also facing the same problem of extracting the data from VSAM files.Iam new to datastage and working on version 8 windows. Could you help me how to extract the vsam files .Do i need to convert the VSAM files to sequential file and then ftp to datastage server . or can i directly ftp th...
by pradkumar
Wed Feb 27, 2008 1:13 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to extract VSAM files on Mainframe
Replies: 1
Views: 1128

How to extract VSAM files on Mainframe

Hello, Iam new to datastage .Could any one help me on how to extract data from a VSAM file.I searched the forum and i couldnt get exact information. Is anyone out there extracting data from MainFrame VSAM files ? If so, could they please let me know how it is being done. I asked mainframe people to ...