Search found 4605 matches

by kduke
Wed May 31, 2006 4:20 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Ds repository tables in Basic routines
Replies: 8
Views: 2050

I would bet money this command works in the next release. I doubt if the next release changes that much. I think a lot of these types of hacks are the only way you can get this information. If the information is valuable then get it and use it. Hack the new later. Using the macros are better when th...
by kduke
Wed May 31, 2006 6:14 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: forwarding invocationid's to lower level-jobs
Replies: 5
Views: 1084

I hope someone corrects all my old posts. Thanks.
by kduke
Tue May 30, 2006 11:17 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DS_METADATA
Replies: 8
Views: 3153

Ray is correct. I modified Ray's routine to create DDL and get row length from knowing how DS_METADATA works. He hacked this one, not me.
by kduke
Tue May 30, 2006 6:18 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DS_METADATA
Replies: 8
Views: 3153

Ray wrote a routine to export these records to a XML file. The key to this hashed file look like ODBC\DSN\TABLENAME. I am not certain how the OCI keys look but you can import them to any key you want.
by kduke
Sun May 28, 2006 3:04 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage administartion
Replies: 9
Views: 3391

Why would I want to?
by kduke
Sat May 27, 2006 10:19 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage administartion
Replies: 9
Views: 3391

Never mind.
by kduke
Sat May 27, 2006 7:16 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage administartion
Replies: 9
Views: 3391

Can I get a mention? :)
by kduke
Fri May 26, 2006 9:43 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage administartion
Replies: 9
Views: 3391

Wow, Ray is quoting me now. :shock:
by kduke
Fri May 26, 2006 3:48 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Getting DataStage Job Names and Category
Replies: 4
Views: 4050

select NAME, CATEGORY from DS_JOBS;
by kduke
Fri May 26, 2006 3:45 pm
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

Your .profile is not executed when a job runs. PATH should be set in dsenv but it is always useful to source it in your .profile.
by kduke
Fri May 26, 2006 3:42 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: protecting the selected category of jobs inside the project
Replies: 8
Views: 2475

Thanks again, Kumar. I think there are some more directories like catdir which need 777 permissions. I am not sure without the script. I will look it up.
by kduke
Fri May 26, 2006 3:38 pm
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

Sorry, I misread. I thought you wanted a filename in a sequential file stage. You are going to have to hack a solution. Like the one I have for sequential file stages.
by kduke
Fri May 26, 2006 3:36 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Can anyone give an example to send a mail with an attachment
Replies: 7
Views: 2184

What version are you using? I have workarounds for both UNIX and DOS.
by kduke
Fri May 26, 2006 6:35 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Can anyone give an example to send a mail with an attachment
Replies: 7
Views: 2184

Attachments did not work till either Ds7.5 or Ds7.5.1.