Search found 42189 matches

by chulett
Tue Oct 06, 2009 7:28 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Status in Mail Notification Activity
Replies: 2
Views: 1825

So... what was the resolution?
by chulett
Tue Oct 06, 2009 7:27 am
Forum: General
Topic: Batch script for exporting shared container in datastage ?
Replies: 10
Views: 13927

Hmmm... if you have 8.1 and have updated it to include the istool function, that may change this. Not sure. :?
by chulett
Tue Oct 06, 2009 7:25 am
Forum: General
Topic: Batch script for exporting shared container in datastage ?
Replies: 10
Views: 13927

You have two choices: A) jobs only via dsexport. B) The entire project via dscmdexport. Some folks do the project and then hack it up using the 'DSX Cutter' script posted here.
by chulett
Mon Oct 05, 2009 11:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Transformer Compile Error
Replies: 18
Views: 4340

Compiling a PX job with a Transformer requires a supported C++ compiler be installed and configured properly... have you done both?
by chulett
Mon Oct 05, 2009 10:16 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Export job with NO "include dependent items"
Replies: 6
Views: 4261

... and pretty much everywhere else for that matter.
by chulett
Mon Oct 05, 2009 9:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Cursor logic in Datastage
Replies: 1
Views: 1231

No 'cursor' or 'loop' needed, just looks like an aggregation to me.
by chulett
Mon Oct 05, 2009 9:09 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Server Jobs appear to be dropping quotes from code
Replies: 2
Views: 2165

Re: Server Jobs appear to be dropping quotes from code

We have been having continued issues with -14 errors (resource time-outs) and a change was suggested by our admins to fix this. The change was implemented and now every job that has the audit code above fails. Am I missing something or do you not mention what the 'fix' was that was suggested and im...
by chulett
Mon Oct 05, 2009 1:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Date Calculations
Replies: 5
Views: 1618

Okay... what's stopping you from storing it somewhere, even if that somewhere is only a flat file, you could use it to do a lookup against. And a job would build the list one time, rather than having to do it 'on the fly' each time. Just curious...
by chulett
Mon Oct 05, 2009 12:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Date Calculations
Replies: 5
Views: 1618

This 'month number' reference, where is it stored - in a database table? And the 'create month' is a string field? And are you saying there's more to this than just a lookup, that you have a starting month/number and you need to compute the result somehow? Or just convert '2009/10/05' to 'October-20...
by chulett
Mon Oct 05, 2009 10:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: IS Client installation error
Replies: 9
Views: 2816

OK, and I see from your initial post that you have admin rights. Just to be completely anal, have you verified that the SYSTEM32 directory is in your PATH?
by chulett
Mon Oct 05, 2009 10:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: IS Client installation error
Replies: 9
Views: 2816

Right, from Ray's reply I assumed we were talking installing the Server, not the Client and so updated my post before I saw your reply.
by chulett
Mon Oct 05, 2009 9:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: IS Client installation error
Replies: 9
Views: 2816

XP is not supported for the Server, period. And as noted, neither it nor the client will even attempt to install on XP Home. You should, however, be able to install the client on XP Pro without issue. :?

Not sure what's going on with your issue, do you have admin rights on the machine?
by chulett
Mon Oct 05, 2009 8:20 am
Forum: General
Topic: Syntax for calling execsqlproc from before sub routine
Replies: 5
Views: 1577

ps. You will need commas between the argument values, assuming multiple 'Args' are defined in the routine. Otherwise, some kind of delimited string?
by chulett
Mon Oct 05, 2009 8:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job aborted without error
Replies: 4
Views: 1722

If you Reset the aborted job, does it add a 'From previous run...' message to the log? If so, please post it.