Search found 4605 matches

by kduke
Fri Oct 22, 2004 8:09 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Set default Params
Replies: 2
Views: 687

One is the subvalued list of values when you have a list type.
by kduke
Fri Oct 22, 2004 8:07 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Set Job Parameters in Sequence without a batch job
Replies: 8
Views: 2491

If anyone wants Peter Lai's original routines to read a group of parameters from a sequential file then ask. I will ask Peter if it is ok to post it. He will be at ASCL world so ask him if you see him. He is a much nicer man than I am so treat him good. Go by and say hello to Dennis James. He owns t...
by kduke
Fri Oct 22, 2004 8:02 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Set Job Parameters in Sequence without a batch job
Replies: 8
Views: 2491

Tony

Sorry, I hope you don't mind me responding this way but I think I did a poor job of explaining this routine. I hope this is a better explaination.

See you guys at ASCL world.
by kduke
Fri Oct 22, 2004 8:02 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: job Parameters for Sequencer Jobs
Replies: 16
Views: 7594

For a more detailed explaination check out http://www.dsxchange.com/posting.php?mode=reply&t=89625.
by kduke
Fri Oct 22, 2004 7:56 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Set Job Parameters in Sequence without a batch job
Replies: 8
Views: 2491

Set Job Parameters in Sequence without a batch job

Tony asked this in a private message: Kim, When you have a minute I would appreciate a hand. If this private message isn't the proper way of asking this question, please let me know or just disregard it. I don't want to take up too much of your time. I'm trying to understand how to implement the rou...
by kduke
Fri Oct 22, 2004 9:34 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: remove blank lines from end of file
Replies: 9
Views: 3064

Craig is correct. It is a simple UNIX command. It is very fast. It has very ugly syntax. You suggested that you had many blank lines and this will solve that problem. I think this has been covered so I would do a search on here and maybe Google. You can ignore these errors in the sequential stage. Y...
by kduke
Fri Oct 22, 2004 5:58 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: JobReport fails
Replies: 5
Views: 799

They have 2 posted on ADN. Which one did you download?
by kduke
Thu Oct 21, 2004 11:48 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to Handle Changing Database Name?
Replies: 9
Views: 3491

Ray

I said most of the posters not all. I only started using Universe in 1986 and Pick before that. Still I think that is long enough to recognize a better way to do something.
by kduke
Thu Oct 21, 2004 8:30 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Multi instance job logs
Replies: 18
Views: 6920

I agree with Ken. This would not be a hard routine to code.

I think we may need a generic job to archive logs. If someone has done this then they should post their code or jobs. This question gets asked way too often.
by kduke
Thu Oct 21, 2004 8:26 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Publishing a job log in an html page
Replies: 2
Views: 565

If you want other options then VB would not be hard. It is fairly easy to connect to DataStage using VB. I have posted code snipets which show you how. The log files have good dictionary files to display the data. The log files have a field for instance id to separate mutiple instance logs. This is ...
by kduke
Thu Oct 21, 2004 8:19 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: remove blank lines from end of file
Replies: 9
Views: 3064

The sed command is very fast and can delete blank lines. I can't remember exactly the syntax but it something like

Code: Select all

sed '1,%g/^$/d'


This says delete all lines which have the begining of a line ^ next to the end of a line $ and nothing in between.
by kduke
Thu Oct 21, 2004 8:06 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to Handle Changing Database Name?
Replies: 9
Views: 3491

I think this is not a good idea. Sequencer code is very very ugly. To create this manual process to cut and paste this code into a batch job is a waste of time. I posted a routine the can be called from a routine activity which will set any job parameter in the current sequence. This is super clean....
by kduke
Thu Oct 21, 2004 7:51 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Publishing a job log in an html page
Replies: 2
Views: 565

Buy DsWebMon from me. It is a Web front end that does most of what the Director does. It is designed to run over a modem. No VPN required. It is real cheap. You would spend a lot more money building this than it would cost to buy it. If you need it then we could customize it or sell you source code....
by kduke
Thu Oct 21, 2004 12:21 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: RT_STATUS error
Replies: 4
Views: 855

At some point you have corrupted some of the DataStage files needed to run DataStage. You probably ran out of disk space or had a system crash of some sort. You need to call support.