Search found 2288 matches

by roy
Tue Jul 12, 2005 5:34 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Select value into Job Parametr
Replies: 9
Views: 2408

Hi,
Just wanted to state that if you use the option of the routine givven to run DS jobs verify no passwords will be written to the logs.

IHTH,
by roy
Tue Jul 12, 2005 2:24 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Filtering top and bottom records from sequential file.
Replies: 5
Views: 1210

Hi,
You could also use the filter command to be a sequential file's input and use a head and tail combination to do the same.

IHTH,
by roy
Tue Jul 12, 2005 2:18 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DS Basic routine from shell script
Replies: 10
Views: 2410

Hi, The logic I ment was having an Exception Handler stage that will intercept the job abort and do the logic! Check the Automatically handle activities that fail Make sure your routine returns zero on success and try this flow EH ----->Collect log Errors RA ----->Collect log Success In case you nee...
by roy
Mon Jul 11, 2005 7:39 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DS Basic routine from shell script
Replies: 10
Views: 2410

Hi, In a sequence job you should be able to capture even failed activities, therefor you can upon activity failiour invoke you routine in a routine activity stage. bare in mind that this way you put a routine activity for bot hsuccess and failiour of the flow. In case your routine is not generic/dyn...
by roy
Mon Jul 11, 2005 7:07 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DS Basic routine from shell script
Replies: 10
Views: 2410

Hi,
What exactly do you mean by calling it?
Do you mean use it like a routine in the script?
Do you mean invoke it?
by roy
Mon Jul 11, 2005 7:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ODBC on AS400 - the query gets stuck(?)
Replies: 6
Views: 1829

Hi (my welcome aboard was sent via private message ), For other people lets make it clear your talking about the DS_CONNECT command. Try having your DB2 poeple debug the connection and perhaps enable server side trace in the DS side. Your first objective is to figure out what is blocking the flow? I...
by roy
Mon Jul 11, 2005 5:48 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: getting DSlinkinfo for a datastage job in shell script
Replies: 6
Views: 2992

Invoking a routine is also a posibility but depending on where you invoke it and what you want to do with the result will effect the implementation.

( Arnd - happens to all of us :wink: )
by roy
Mon Jul 11, 2005 5:25 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Retrieving Files from Back up
Replies: 3
Views: 891

Hi, you never backed this info to begin with. this info does not nesceserily resides inside your project directories. As for the files: 1. sequential files of value should have been backedup as well. 2. data sets and file sets might have required recreation in the new version regardless of backups. ...
by roy
Mon Jul 11, 2005 5:16 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: getting DSlinkinfo for a datastage job in shell script
Replies: 6
Views: 2992

Hi,
If your invoking an after job script in any shell you can only use the dsjob command line utility to get that info.

that utility has been covered to "death" one might say in this forum, search for it or in the docs.

IHTH,
by roy
Mon Jul 11, 2005 5:13 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Does datastage supports JDBC connection
Replies: 2
Views: 1707

Hi,
I Guess it does if you buy and install the java pack.
But not nesceserily the way you think (external source).
Or If you build your own stage it might.

IHTH,
by roy
Mon Jul 11, 2005 3:26 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Routine Activity of Job Sequence
Replies: 4
Views: 1252

Hi, This routine requires a Job Handle in order to write the message to that job's log. In short it depends what you want to do? 1. write to the job sequence's log? - Use DLogInfo or use DSJ.ME as the job handle. 2. write the info to anoter job's log? - wrap the mentioned routine in your own code to...
by roy
Mon Jul 11, 2005 2:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job Scheduling through Director
Replies: 2
Views: 872

Hi,
The most common way to run DS jobs in intervals unavailable via the director client is using external schedualers such as the OS schedualing mechanism.
this involves usage of the dsjob command line interface.
A search in the forum (this and Server) should find you all you need to know.

IHTH,
by roy
Sun Jul 10, 2005 8:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: multiple text files as input
Replies: 9
Views: 3215

Ok I have more to say regarding Craig's note. In some cases you have multiple files of the same scheme so my idea should work for that. In case you have also multiple schemes for the files you have 2 options: 1. export/import stages and further along split acording to type aproach. 2. good naming co...
by roy
Sun Jul 10, 2005 8:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: multiple text files as input
Replies: 9
Views: 3215

Hi,
performing a type #PATH1#\*.* > #PATH2#\Myfile
will be far slower (the more data the slower it will be)
then simply read the files and process the read buffer!

That is my humble opinion and probably all I have to say for this post :)

Good Luck,
by roy
Sun Jul 10, 2005 7:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: multiple text files as input
Replies: 9
Views: 3215

Hi,
if you specify in your sequential file stage your read method as file pattern and use wild cards in your file path (i.e: #path#/*) you will read all files in the specified path.

IHTH,