Reg: Problem while reading COBOL file

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
sudarsan
Participant
Posts: 31
Joined: Fri Nov 17, 2006 4:14 am

Reg: Problem while reading COBOL file

Post by sudarsan »

Hi All,

I am trying to read a COBOL file using Complex flat file stage and write it into a flat file.(Complex FF - Tfm - Seq File)

Note: In CFF stage, DataFormat mentioned it as EBCIDIC and Record style as Binary. Source file I have FTPed from Mainframe server in Binary mode.

All columns are populating properly except Packed decimal columns.

Simply Packed decimal columns are coming with some unknown characters.

I searched in forum and unfortuanetly I didn't find any solution for this.

Can any one please help me on this.
Thank You,
Sudarsan AVS
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Can you post the hex values in the source for one of those packed decimal columns as well as the PIC clause for that column?
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

Also the PIC clause used in the CFF stage.
sudarsan
Participant
Posts: 31
Joined: Fri Nov 17, 2006 4:14 am

Post by sudarsan »

Hi,

Thanks for Quick reply.

PIC clause for the column is: PIC S9(13)V9(5) COMP-3.
PIC clause used in the CFF stage:PIC S9(13)V9(5) COMP-3.

Sorry, I am unable to provide the Hex values for that columns because I don't have a access to the mainframe system. Mainframe wiil FTP the source file and provide to us.
Thank You,
Sudarsan AVS
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

But in your first post you mentioned that you had a binary local copy - that is the one where I'd like to see what the binary values are and if they are actually a COMP-3 representation.
sudarsan
Participant
Posts: 31
Joined: Fri Nov 17, 2006 4:14 am

Post by sudarsan »

Hi ArndW,

I tried to view that file in notepad, but all fileds are showing as some unknown characters.

That's Why I am unable to send you..sorry for not able to provide you the enough information.
Thank You,
Sudarsan AVS
sudarsan
Participant
Posts: 31
Joined: Fri Nov 17, 2006 4:14 am

Post by sudarsan »

But I am able to view the content of that file through complex flat file stage except packed decimal columns
Thank You,
Sudarsan AVS
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Use notepad++ or some other tool that will let you see the true binary contents. Using the CFF stage is "too late" to find errors in this case.
Post Reply