DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
pradkumar


since November 2006

Group memberships:
Premium Members

Joined: 18 Oct 2006
Posts: 393

Points: 4233

Post Posted: Mon Mar 10, 2008 12:11 pm Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Server
OS: Windows
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 of the input file: EBCDIC or ASCII, or NLS. If NLS is enabled, the Data Format is set to NLS and is not editable. (NLS maps support EBCDIC data.)

why i could not find the EBCDIC or ASCII in data format. It is showing only NLS as an option. How to enable the data format to EBCDIC OR ASCII?

Could any one help me regarding this issue.

Thanks


Last edited by pradkumar on Tue Jul 08, 2008 1:47 pm; edited 1 time in total
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 43085
Location: Denver, CO
Points: 222463

Post Posted: Mon Mar 10, 2008 12:19 pm Reply with quote    Back to top    

pradkumar wrote:
If NLS is enabled, the Data Format is set to NLS and is not editable. (NLS maps support EBCDIC data.)

Sounds like you have NLS enabled.

_________________
-craig

"You can never have too many knives" -- Logan Nine Fingers
Rate this response:  
Not yet rated
pradkumar


since November 2006

Group memberships:
Premium Members

Joined: 18 Oct 2006
Posts: 393

Points: 4233

Post Posted: Mon Mar 10, 2008 12:34 pm Reply with quote    Back to top    

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 VSAM file.
so could you please let me know how to do the conversion .

Do i need to ask to convert the VSAM file in to sequential file in binary mode or in which format? and also regarding fixed width columns?

Really i would appreciate your help,

Thanks
Rate this response:  
Not yet rated
flashgordon



Group memberships:
Premium Members

Joined: 17 Aug 2004
Posts: 99
Location: Boulder, Colorado
Points: 1188

Post Posted: Mon Mar 10, 2008 6:08 pm Reply with quote    Back to top    

Hi,

Tell the mainframe person to convert the vsam file to sequential. If everything in the file converts cleanly to a number or a letter you have the option of having your file transmission mechanism convert the file to ascii. If you are reading this file with cff stage you specify ascii. You can still use the cobol copybook to read an ascii file.

If the file has "packed" numbers in it you have to read it in cff stage as ebcdic and you have to have it transmitted from the mainframe as binary. You won't be able to open this file with notepad or otherwise read it from the operating system unless you read hex well and understand the ebcdic character set.

You want your mainframe guys to give you the "cobol copybook" they wrote the output file with. This is what you import to cff stage to read the ebcdic file.

... Flash

_________________
Flash Gordon
Hyperborean Software Solution
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
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



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours