Search found 4605 matches

by kduke
Fri May 26, 2006 6:32 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage administartion
Replies: 9
Views: 3391

I posted scripts to back these up. Use those before editting any of these. Some of these can shutdown the engine completely. Some break ODBC connections. Not as important.
by kduke
Fri May 26, 2006 6:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to get the folder name used in the folder stage into the
Replies: 3
Views: 906

The safest way is to make it a parameter. Otherwise the SQL to find these filenames has been posted. It should have CSeqInput and CSeqOutput so search for that.
by kduke
Fri May 26, 2006 6:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: where is the PATH variable value will be set in DataStage
Replies: 10
Views: 4288

I think it should work in dsenv but never tried it.
by kduke
Fri May 26, 2006 6:24 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: protecting the selected category of jobs inside the project
Replies: 8
Views: 2475

I posted some shell scripts to do this in UNIX with separate projects. You will need to change permissions on some of files in the DSEngine directory. The default setuo is for the same group as dsadm to be used by all developers. It is not complicated but DS_LICENSE and some other directories need c...
by kduke
Thu May 25, 2006 7:48 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Windows XP as DataStage Server
Replies: 17
Views: 8246

Yea, Ray can he hijack his own thread?
:wink:

Is it bad etiquette to be rude to yourself? What kind of term would Craig have for that?
:lol:
by kduke
Thu May 25, 2006 7:46 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Deleting records based on User Entered Date
Replies: 12
Views: 2832

I got it the first time. Me not stoopid.
by kduke
Thu May 25, 2006 4:41 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Is there any benefit to use Unix shell script to control job
Replies: 6
Views: 1700

Scripts suck. GUI is better. Old school is for music not IT.
by kduke
Thu May 25, 2006 4:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: efforts estimation in datastage
Replies: 10
Views: 2686

I had a topic in one of the old newsletters about estimating.
by kduke
Thu May 25, 2006 4:32 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Version Control comments
Replies: 7
Views: 1367

I would expect they are stored in one of the APM hashed files. It might easier to put them back before initializing in VC. I posted a routine or job named KgdFixLongDesc. It will show you how to update this field.
by kduke
Thu May 25, 2006 4:28 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Version Control comments
Replies: 7
Views: 1367

I delete those lines. I think they are annoying. They should be at the bottom of the long description.
by kduke
Thu May 25, 2006 4:25 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: I need help to create a sequential file with metadata
Replies: 9
Views: 4008

Greetings dhelsley. Old Pick programmers are always welcomed.

Ray's routine will extract the routines to XML. Why not export your routines as XML and hack that.
by kduke
Thu May 25, 2006 4:20 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Number of projects on a single server.
Replies: 3
Views: 1007

My rule of thumb is create a new project if none of the new jobs need to be run by the existing jobs. It almost always means this is a totally unrelated subject area.

Remind me not to work on this project. 9000 jobs has to be brutal in the Director.
by kduke
Thu May 25, 2006 4:15 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Deleting records based on User Entered Date
Replies: 12
Views: 2832

Stoopie? :lol: What is dumb is I agree.
by kduke
Tue May 23, 2006 7:09 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Universe - Impact of adding additional columns to table
Replies: 5
Views: 1420

Ray

Will a UV stage work if the column name is not in the dictionary of the hashed file?