In the cobol file definition provided one of the columns provided is PIC-9.9.
But the complex flat file stage was not able to import this column.
Can some one please let me know how this column can be imported.
I am getting the below error
'PIC' PICTURE character string format is invalid.
Search found 204 matches
- Wed Nov 13, 2013 10:42 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to read PIC -9.9 in complex flat file
- Replies: 5
- Views: 3752
- Fri Apr 26, 2013 2:21 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Order of columns in sequential file getting overwritten
- Replies: 0
- Views: 1572
Order of columns in sequential file getting overwritten
Hi, I have a simple job design shown below OracleConnector----------->Transformer--------->sequential file I am reading 15 columns from the source and formatting the columns in transformer and write them to sequential file I want to write columns a, b which are in Col 12 and Col 13 in Oracle as Colu...
- Thu May 17, 2012 3:38 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parse xml which has hierarchical data
- Replies: 8
- Views: 9989
- Thu May 17, 2012 2:36 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parse xml which has hierarchical data
- Replies: 8
- Views: 9989
- Thu May 17, 2012 12:35 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parse xml which has hierarchical data
- Replies: 8
- Views: 9989
I tried elsont's suggestion to set last level column as key. I tried that using 3 levels(in xsd) of hierararchy, by setting one of the columns(Col1) in level 3 hierarchy as key . I see that in the Mapping section Col1 is mapped to some other column in level2 when i click auto map.So I am trying to m...
- Tue May 15, 2012 4:11 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parse xml which has hierarchical data
- Replies: 8
- Views: 9989
- Mon Apr 23, 2012 10:02 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DTS stage error
- Replies: 5
- Views: 4146
- Sun Apr 22, 2012 4:21 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DTS stage error
- Replies: 5
- Views: 4146
We have used data stage and MQ combination by reading messages from queue and directly loading them into Oracle by using oracle entrprise stage. And that job is running fine with out issues. But i saw that DTS is the way to go when we are reading from MQ,so i am trying to use DTS stage. I am using t...
- Fri Apr 20, 2012 2:33 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DTS stage error
- Replies: 5
- Views: 4146
DTS stage error
Hi, I am trying to use DTS stage to load data into oracle table while reading messages through MQ Connector stage. Below is my job design MQ Connector---->XML Stage---->DTS stage In DTS stage i am using oracle connector and specified a work queue , In MQ I am using MQ read mode as 'Move to work queu...
- Mon Jan 30, 2012 1:26 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parse xml which has hierarchical data
- Replies: 8
- Views: 9989
Parse xml which has hierarchical data
Hi, I have xsd which has 5 levels of hierarchy in that, in 8.1 i have used 5 xml input stages one after another to parse this XML. I have been trying to use the new XML stage in datastage 8.5 to parse the same XML. Do i have to use 5 XML parser steps in the new XML stage. I am not able to figure out...
- Mon Jul 18, 2011 2:02 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle connector
- Replies: 4
- Views: 5245
- Mon Jul 18, 2011 12:49 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle connector
- Replies: 4
- Views: 5245
Oracle connector
I am reading from a flat file and loading data into a oracle table.below is my job design in datastage 8.5 Sequential File----->Transformer----------->Oracle Connector I am trying to commit all the rows at once in oracle connector stage. In order to do that I have set up the below properties in conn...
- Thu Dec 09, 2010 8:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Distributed Transaction stage
- Replies: 7
- Views: 5971
That option is working but the job is slow,any suggestions to improve the performance would be great. As Craig has suggested it is a server job a seq file---->Transformer------->Oracle Oci stage From transformer i have 4 different links going into Oracle stage and I am inserting data using custom sq...
- Wed Dec 08, 2010 11:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Distributed Transaction stage
- Replies: 7
- Views: 5971
- Wed Dec 08, 2010 9:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Distributed Transaction stage
- Replies: 7
- Views: 5971