Search found 5 matches

by taazeez
Tue Mar 13, 2007 9:00 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: USING XML_INPUT STAGE
Replies: 2
Views: 1466

USING XML_INPUT STAGE

am using XML_INPUT stage in Datastage for the first time to move data from XML file to oracle databse. I defined table definition for the xml file, after which I developed the etl job, but when I compiled the job, I keep on receiving error message as follows 'Plug-in stage does not have the required...
by taazeez
Tue Mar 13, 2007 8:49 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Plug-n stage does not have required stream inputs
Replies: 3
Views: 1685

Plug-n stage does not have required stream inputs

I am using XML_INPUT stage in Datastage for the first time to move data from XML file to oracle databse. I defined table definition for the xml file, after which I developed the etl job, but when I compiled the job, I keep on receiving error message as follows 'Plug-in stage does not have the requir...
by taazeez
Fri Jan 19, 2007 1:20 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Inserted value too large for column, row rejected.
Replies: 8
Views: 8625

I have tried to redirect the job to sequential file, all the records got loaded, but DataSage still gave a warning message on the particular record as follows:


nls_map_buffer_out() - NLS mapping error.

The size of the two fields causing the problem are 1024 xters, 255 xters.
by taazeez
Fri Jan 19, 2007 12:10 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Inserted value too large for column, row rejected.
Replies: 8
Views: 8625

I am extracting record from SQL Server and loading it into Oracle.
by taazeez
Fri Jan 19, 2007 11:06 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Inserted value too large for column, row rejected.
Replies: 8
Views: 8625

I tried to check the length of the field, and it is still within the normal length range for the field. The record could not pass through Datasatage transformer being used. I have tried to remove some of the characters in the field but I am still getting the same problem. The warning message is from...