DSXchange

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.

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...

The 5 levels are nested. How can we achieve this in new XML stage in 8.5.

We are not using Db2.

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...

Can some one please throw some light on this issue.

Thank you. We will have this set up and try running the job again.

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...

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...

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...

I am using Write Mode ------Insert, as i would like to insert my own insert statement, so cannot go with Bulk load.

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...

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...

Thanks for the reply. I will try this option.

Thanks for your reply.

If we use a server job to build this, i have below 2 questions

1.how can we see that it loads data into the master first and then the detail.

2. How do we do a single commit for all the tables once.