Search found 52 matches

by jojipjohn
Tue Aug 08, 2006 4:06 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Neeed help in converting Packed decimals
Replies: 7
Views: 1236

In the sequetial file stage I could not find the type defaults in the format tab.

Could you please explain this to me.
by jojipjohn
Tue Aug 08, 2006 3:20 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Neeed help in converting Packed decimals
Replies: 7
Views: 1236

We are not given the the cobol layout.. we asked for the copy book but we will not get this......

Could you please tell me how to create a cobol layout... I read through the pdf for CFF but could not get a head and tail how to make the layout....
by jojipjohn
Tue Aug 08, 2006 3:10 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Neeed help in converting Packed decimals
Replies: 7
Views: 1236

Neeed help in converting Packed decimals

In my projects I am getting source files from Mainframe system in packed format. I am converting this using the tranformation "DataTypePicComp3()",but we are not getting correct values after conversion. Could anyone help me in this. Is there any other transformation for this. Thanks for an...
by jojipjohn
Thu Jul 27, 2006 1:33 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Help for datastage certification
Replies: 1
Views: 775

Help for datastage certification

Can someone help me in getting any study materials fordatastage certification.

Thanks a lot for any help
by jojipjohn
Wed Jul 26, 2006 3:09 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Does Datastage Px and server edition come in a single packag
Replies: 5
Views: 1146

Can I unpack the packed decimals and fixed binary decimals in the source file. If yes how is this done.
by jojipjohn
Wed Jul 26, 2006 2:39 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Does Datastage Px and server edition come in a single packag
Replies: 5
Views: 1146

Does Datastage Px and server edition come in a single packag

I am having datastage 7.5 installed and when I open a new desingner window i get a list to choose from. I have parallel jobs also in this list. Is this parallel job same as Datastage PX.
by jojipjohn
Thu Jul 06, 2006 11:51 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to use CFF to unpack the packed data from Mainframe sys
Replies: 2
Views: 1123

How to use CFF to unpack the packed data from Mainframe sys

Hi,

I tried using CFF to convert a packed data type, but could not find a place to specify this. The pdf file in docs does not say any thing about this.
Can someone please help me in this.
by jojipjohn
Wed Jul 05, 2006 11:56 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Extracting Packed decimal data type from A flat file
Replies: 21
Views: 7930

The pdf doesnot says anything about unpacking the packed columns. Can some one please tell me where in CFF can I specify this.
by jojipjohn
Wed Jul 05, 2006 10:59 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Extracting Packed decimal data type from A flat file
Replies: 21
Views: 7930

In our project we dont have access to the mainframe system. Where can I get the Cobal copy book (.cfd file)
by jojipjohn
Wed Jul 05, 2006 12:41 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Extracting Packed decimal data type from A flat file
Replies: 21
Views: 7930

I will be thankful if you could send that to jojipjohn@yahoo.com.
by jojipjohn
Tue Jul 04, 2006 10:32 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Extracting Packed decimal data type from A flat file
Replies: 21
Views: 7930

I tried usig a CFF but I getting all the columns as null when I view the data. Can someone please detail on how to use a CFF.
by jojipjohn
Tue Jul 04, 2006 9:55 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Extracting Packed decimal data type from A flat file
Replies: 21
Views: 7930

Should I use mainfraem jobs to convert this or can I do this usnig the server jobs.
by jojipjohn
Fri Jun 30, 2006 5:11 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Extracting Packed decimal data type from A flat file
Replies: 21
Views: 7930

I think my packed fields has characters also... I am getting thid error when I used the routine "Error, unable to convert ' Z ' into number".
Could you please tell me how to convert this.
by jojipjohn
Wed Jun 28, 2006 11:10 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Extracting Packed decimal data type from A flat file
Replies: 21
Views: 7930

How to define the source stage

How will I define the packed decimal in the source sequencial file stage. Is there any other stages to handle this data type. My source file is of the following structure: Source Location NUM Transaction Code CHAR Blanket Order Number CHAR Blanket Order Release Number CHAR P.O. Item Sequence Number ...