Search found 7 matches

by swamiar
Mon Jul 31, 2006 10:59 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Subroutines
Replies: 1
Views: 982

Subroutines

Hi,

When any before/after job subroutine fails, there is only a warning in the director. Is there any settings that can be made to abort the job when a subroutine fails?

Aravind.
by swamiar
Mon Jul 17, 2006 1:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ORCHESTRATE Exception
Replies: 9
Views: 11051

ORCHESTRATE Exception

Hi, I get the following error when i run the jobs in datastage. "main_program: Fatal Error: Caught ORCHESTRATE exception in main program: APT_Archive::BadData: From: Loading memory archive." All these jobs were running fine till recently. what could be the possible reason for this? I have ...
by swamiar
Fri Jun 16, 2006 10:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem using sequence in oracle stage.
Replies: 7
Views: 3082

It is an integer field of length 10.

Regards,

Aravind
by swamiar
Fri Jun 16, 2006 10:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem using sequence in oracle stage.
Replies: 7
Views: 3082

I have two jobs to insert records into the same table and the sequence field being a key field can not have duplicate values. This is the reason i use the sequence and not the surrogate key of datastage. There is a possibility of the jobs running parallel as well.

Regards,

Aravind.
by swamiar
Fri Jun 16, 2006 10:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem using sequence in oracle stage.
Replies: 7
Views: 3082

Hi,
But this happens only when i use datastage.

Regards,

Aravind
by swamiar
Fri Jun 16, 2006 9:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem using sequence in oracle stage.
Replies: 7
Views: 3082

Problem using sequence in oracle stage.

Hi, I have two jobs that insert data into the same table in oracle database. We have a field in this table that gets its value from a sequence created in Oracle. I first run one job to insert into the table and next the other. But the sequence number does not continue from the last value that was pr...
by swamiar
Mon Feb 20, 2006 5:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: formatting to XML
Replies: 4
Views: 2074

formatting to XML

Hi,

I want to develop a job that reads data from a sequential file and formats it into XML. This XML has to be messaged using the MQseries. can anyone give the guidelines towards developing this?

Aravind.