I have corrected it Naveen. Thanks. But as I mentioned, My problem still continues with the rows for the column whose datatype is number. Is there a way out for that. I seem to miss it. I am still waiting....
Kris
Search found 1099 matches
- Wed Feb 22, 2006 2:58 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Empty spaces in OCI Target table
- Replies: 10
- Views: 2421
- Wed Feb 22, 2006 1:02 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Find out which User has run the job
- Replies: 6
- Views: 1515
- Wed Feb 22, 2006 12:38 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Empty spaces in OCI Target table
- Replies: 10
- Views: 2421
Hi Naveen, Thanks for that. It worked fine for columns whose datatype is varchar2 but didnt work for column whose datatype is number. Am I missing something out over here. please let me know. And as Kumar mentioned..NULL is different from empty string. But I need NULL at my ouput..so I used 'NULL' i...
- Wed Feb 22, 2006 11:23 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Empty spaces in OCI Target table
- Replies: 10
- Views: 2421
Empty spaces in OCI Target table
Hi all, I have created a simple job that reads data from the source table through ODBC stage and writes it to an Oracle target table( I am using a OCI stage) through a transformer. The only transformation I do in the transformer is to find out if there are any empty spaces in the source table and wr...