Search found 97 matches

by verify
Thu Apr 03, 2008 11:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Regarding oracle error with indexes enabled
Replies: 8
Views: 6409

Regarding oracle error with indexes enabled

Hi All, I am using datastage 8.0.1 ( IBM Informaation Server ) .I have job design as below SEQ ----->>>> TRANSFORMER ---->>>> ORACLE ENTERPRISE STAGE We are getting the below Error Message on DS Log and Jobs are getting aborted. i know that its coming because indexes are enabled on the table .Also p...
by verify
Wed Apr 02, 2008 6:08 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: invoking ETL job from Java program
Replies: 2
Views: 943

invoking ETL job from Java program

Is there a way to invoke DS jobs from a java program?. I want to get rid of the existing unix scripts with java programs as java offers more error handling features than a shell script.
by verify
Mon Mar 31, 2008 9:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: sqlldr error
Replies: 4
Views: 3653

Thank you very much... I will look at the docs and let you know status.
by verify
Mon Mar 31, 2008 7:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: sqlldr error
Replies: 4
Views: 3653

You would need to post the details in the sqlldr log as noted. That or take that to your DBA: "please see the loader logfile: /apps/opt/IBM/InformationServer/Server/Scratch/ora.2430.764692.6.log for details" Edited to add - I see there's more to this than that. Following related messages ...
by verify
Mon Mar 31, 2008 5:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sqlldr error when we use oracle enterprise stage with load
Replies: 3
Views: 2443

sorry by mistake i raised in datastage server edition forum
by verify
Mon Mar 31, 2008 5:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: sqlldr error
Replies: 4
Views: 3653

sqlldr error

Dear All, Thanks for supporting so far all my ds issues We are trying to insert records from flat file to oracle table using oracle enterprise stage with load option. Basically when we use load option it calls sqlldr, for some reason it was not working and throwing following error. Please advice us ...
by verify
Mon Mar 31, 2008 4:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sqlldr error when we use oracle enterprise stage with load
Replies: 3
Views: 2443

Sqlldr error when we use oracle enterprise stage with load

Dear All, Thanks for supporting so far all my ds issues We are trying to insert records from flat file to oracle table using oracle enterprise stage with load option. Basically when we use load option it calls sqlldr, for some reason it was not working and throwing following error. Please advice us ...