Search found 4 matches

by Mohammad_Danish
Tue Sep 27, 2011 5:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Create a sequential file to be FTPed to Mainframe
Replies: 4
Views: 1680

Hi Ray, I have implemented using CFF stage by configuring it as follows: Column Datatype Length Scale OutDate Native Binary 99 InDate Native Binary 999 CompanyNo Varchar 2 OutletNo Native Binary 9 5 TransUnits Decimal 9 TransUnits2 Decimal 9 Sales Decimal 11 2 TrfUnits Decimal 9 Space Varchar 2 This...
by Mohammad_Danish
Tue Sep 27, 2011 4:02 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Create a sequential file to be FTPed to Mainframe
Replies: 4
Views: 1680

Create a sequential file to be FTPed to Mainframe

Hi, My objective is to create a sequential file with following columns in Cobol format, please tell what setting to use in Complex Flat File Stageto accomplish this task: Column Datatype Size OutDate Integer 99 InDate Integer 999 CompanyNo Alphanumeric XX OutletNo Numeric 9(5) TransUnits Packed deci...
by Mohammad_Danish
Thu Sep 22, 2011 7:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Creating flat file with packeddecimal columns
Replies: 1
Views: 1293

Creating flat file with packeddecimal columns

I am trying to convert columns with double as datatype into Packed Decimal. Please provide me any pointers on how to accomplish this task using a parallel job and what datatype to use for these type of columns so that it can be directly picked up be an FTP program and send to mainframe GDG file?
by Mohammad_Danish
Thu Sep 08, 2011 10:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Extracting a CLOB field (XML) from an Oracle database
Replies: 1
Views: 1198

Extracting a CLOB field (XML) from an Oracle database

I am trying to extract two columns from Oracle database, one of which is a CLOB field storing XMLs. The task I want to accomplish is to get those XMLs and then map the elements of the XML to columns of a dataset. Please guide me how to design the job to accomplish this. Thanks in advance. I am using...