Search found 20 matches

by holgi02
Thu Apr 29, 2004 6:32 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Processing large numbers of input files
Replies: 9
Views: 8000

Why not have a look at using the folder stage and use before/after subroutines to do the call the decode software. This way around you have DS in control and calling your decode software instead of attempting to call DS from a C++ environment. If you want to automate the whole thing even further try...
by holgi02
Thu Feb 26, 2004 10:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequencer job OK Link
Replies: 18
Views: 7261

What I meant by "less visible" is that the custom trigger has 2 conditions under which the link fires and to get at the exact condition you would have to crack open the stage and view the condition code. Using the "Out of the box" triggers, 2 of them, gives you visibility on the ...
by holgi02
Thu Feb 26, 2004 10:14 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequencer job OK Link
Replies: 18
Views: 7261

The only downside for me of the custom trigger is it is a little less "visible" on the canvas. I guess there are loads of ways to solve this issue - whatever works for you.

Gil.
by holgi02
Thu Feb 26, 2004 9:31 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequencer job OK Link
Replies: 18
Views: 7261

My mistake... I forgot to mention that little piece of info... very useful the sequencer stage :wink:

Cheers,

Gil.
by holgi02
Thu Feb 26, 2004 9:17 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequencer job OK Link
Replies: 18
Views: 7261

Put in a Seqencer stage between the two job activity stages. Have 2 links from the 1st job activity to the sequencer stage, 1 for OK, 1 for warnings and have the output trigger from the sequencer stage set to ANY to fire the 2nd job. This way it will execute the 2nd job if the 1st job finishes with ...
by holgi02
Thu Feb 26, 2004 8:49 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequencer job OK Link
Replies: 18
Views: 7261

Hi, No it will not continue if your only trigger is "OK" from a job activity - that denotes that the job activity completed without warnings. If you want your downstream link to fire if the job activity completes "OK" or "with warnings" then have 2 triggers from the job...
by holgi02
Wed Feb 25, 2004 10:44 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Entry DB2 table is empty. How can i finish normal my job?
Replies: 2
Views: 2367

Why not use a COBOL program to execute a SQL count on the table and call this from an external routine with the count returned as an output parameter to the DS job. In the DS job use this returned count value as a constraint on the output link of a transform.

IHTH

Gil.
by holgi02
Wed Feb 25, 2004 10:28 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Combine source rows into single target row?
Replies: 14
Views: 7208

Yeah,

I was refering to the directory structure on the "Install CD" if it is available. Check this out first and if the files are missing from here then you must have a bad one - talk to Ascential and get a new "Install CD"

IHTH

Gil.
by holgi02
Wed Feb 25, 2004 9:56 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Combine source rows into single target row?
Replies: 14
Views: 7208

Sounds like the client side install did not install everything. If you have access to the Ascential DataStage install CD there is a whole load of stuff on there under \packages\doc\enu
by holgi02
Wed Feb 25, 2004 7:05 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to submit a Datastage Job from UNIX command line
Replies: 8
Views: 5081

Further information about job exit status codes and meanings found as follows on a Windows install taking ALL the defaults at C:\Ascential\DataStage\Dsdk\include\dsapi.h /* 'jobStatus' values... */ #define DSJS_RUNNING 0 /* Job running */ #define DSJS_RUNOK 1 /* Job finished a normal run with no war...
by holgi02
Tue Feb 24, 2004 1:50 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem starting DS clients
Replies: 7
Views: 3797

uninstalled/reinstalled DS Thanks for the tip Roy but I've been there, done that, have the T-shirt etc. etc. still no joy. I even thought it might be a virus that is giving me a denial of service or some such - updated all my Anti-Virus stuff - still not playing ball. I will become angry soon as th...
by holgi02
Tue Feb 24, 2004 1:54 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem starting DS clients
Replies: 7
Views: 3797

Hmmm.. the reboot made no difference. I am still getting the same error. :?
by holgi02
Mon Feb 23, 2004 7:12 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem starting DS clients
Replies: 7
Views: 3797

Problem starting DS clients

Having just installed DS version 6.0.1 on Windows 2000 I have a problem starting DS clients. I get the message "Failed to connect to host: localhost, project: UV (The connection was refused or the RPC daemon is not running (81016))" When I look in the event log I see the following error:- ...
by holgi02
Mon Feb 23, 2004 6:44 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to submit a Datastage Job from UNIX command line
Replies: 8
Views: 5081

I never thought to look in the header files - silly me :oops:

Perhaps those good people at Ascential could get it into a .pdf manual somewhere. :wink:

Thanks chaps.

Gil.
by holgi02
Mon Feb 23, 2004 6:12 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to submit a Datastage Job from UNIX command line
Replies: 8
Views: 5081

On a related subject - is there a definitive list in the documentation of the exit codes and meanings from dsjob? I have looked but failed to find them anywhere.

Tx.

Gil. :(