Search found 6 matches

by peppy_perky
Wed Jul 26, 2006 5:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: executing cobal programs from DS
Replies: 2
Views: 1901

executing cobal programs from DS

Hi All,

I got a new requirement in my project that i need to call the cobal programs from DS. Does anyone have any idea on how to call cobal programs from DS environment?

Appreciate your help/advise on this.

Regards
peppy
by peppy_perky
Fri Jun 02, 2006 6:21 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Capturing DBMSCode
Replies: 3
Views: 1435

Hi Chulett,

There is no difference in the new job. I have just created a new job from the scratch with the same functionality of my previous job(one among the old jobs).

But it is tedious to recreate all the jobs.


I would like to hear your advice.

Thanks a ton,
by peppy_perky
Fri Jun 02, 2006 4:54 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Capturing DBMSCode
Replies: 3
Views: 1435

Capturing DBMSCode

Hi all, I have around 20 to 25 server jobs . In that source is Oracle (OCI) and target is Oracle (OCI) . Just a xfm for doing the transformations and a hash file to capture the application and db errors. xfm and hashfile I have put into a shared container. Problem starts here. I have to capture the ...
by peppy_perky
Fri Apr 07, 2006 3:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem while extracting from Oracle using oracleenterprise
Replies: 1
Views: 1219

Problem while extracting from Oracle using oracleenterprise

Hi All, I have a job design where i'm trying to extract some 26 million records from oracle using oracle enterprise stage and the job is getting aborted with the following error. main_program: Internal Error: (colDesc):orautils.C: 1623: getColDesc failed. Traceback: Could not obtain stack trace; che...
by peppy_perky
Thu Apr 06, 2006 9:12 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Loading 50million records from Oracle9i to Oracle9i
Replies: 7
Views: 3667

loading 50millions rows

Hey Ken This was your reply to a previous question. Could you please look into this and explain a bit more about the 3rd option and insert into target (select * from source) ? Thanks kcbland wrote: Well, DataStage Server jobs are single-threaded. This means that the SELECT query is prepared however ...
by peppy_perky
Thu Apr 06, 2006 8:58 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Loading 50million records from Oracle9i to Oracle9i
Replies: 7
Views: 3667

Loading 50million records from Oracle9i to Oracle9i

Hi all, I have a record of about 50million in the source database in the same server where datastage is residing and migrating to a target db in a different server. I would like to find out the fastest way to migrate this data. We are currently using Oracle OCI which is VERY slow. There is a similar...