Search found 4 matches
- 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...
- 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...
- 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?
- 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...