Search found 42189 matches

by chulett
Thu Jul 05, 2007 12:46 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: mkdbfile returnd error code 1
Replies: 8
Views: 1302

Post your complete syntax.
by chulett
Thu Jul 05, 2007 12:30 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error while importing a dsx file
Replies: 3
Views: 1020

You may be able to 'trick' it by editing the .dsx file and changing the version information in the file, but that really wouldn't be supported if it all went sideways. Anyone tried that? I don't have 8.x to play with, so can't. I don't even know if the .dsx format has undergone any 'improvements' sp...
by chulett
Thu Jul 05, 2007 12:24 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: mkdbfile returnd error code 1
Replies: 8
Views: 1302

I'd wager that's because you are not specifying a full path in your 'blabber', but are using a relative one instead.
by chulett
Thu Jul 05, 2007 12:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error while importing a dsx file
Replies: 3
Views: 1020

To a higher release, yes - but not to a lower release.
by chulett
Thu Jul 05, 2007 10:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Waiting for File
Replies: 6
Views: 2013

Ah... that would be true, waiting is waiting is a singleton process.

Wasn't aware a Sequence job generated OSH, however.
by chulett
Thu Jul 05, 2007 9:31 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error calling subroutine: DSR_SCHEDULE
Replies: 7
Views: 2310

The Director will only show a job as Scheduled if the currently logged in user is also the one that scheduled it. This because cron is user specific and each user can have their own crontab.

Your SA would need to manage the 'allow' files for you.
by chulett
Thu Jul 05, 2007 9:29 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: IsValid Function
Replies: 16
Views: 6086

Excellent!

More better is always gooder than less better. :D
by chulett
Thu Jul 05, 2007 8:54 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Date Validations in Datastage
Replies: 34
Views: 20353

Yes - they are already handled by the IConv function when handling dates, as is the year - just not with the restricted range you posted. Add another bit of logic to say that the date is invalid if the year portion of the date is outside that range as well as what you are already doing.
by chulett
Thu Jul 05, 2007 7:51 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Date Validations in Datastage
Replies: 34
Views: 20353

Not that I am aware of, feel free to write one. The only part you are missing is the year range restriction and that shouldn't be hard to add to your checks.
by chulett
Thu Jul 05, 2007 7:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Waiting for File
Replies: 6
Views: 2013

Describe the design of the Sequence job.
by chulett
Thu Jul 05, 2007 7:03 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to create Dynamic Server job
Replies: 3
Views: 1095

On a more serious note, how about you start by explaining what in the heck you mean by a 'Dynamic Server job'? :?
by chulett
Thu Jul 05, 2007 7:02 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to create Dynamic Server job
Replies: 3
Views: 1095

Just check the 'Dynamic' checkbox on the job's properties. And you'll probably need liberal use of the RMM stage.
by chulett
Thu Jul 05, 2007 7:00 am
Forum: General
Topic: Problem creating indexes!
Replies: 4
Views: 1313

Problem #2 is caused by problem #1. And for #1, the 'physical path name' must be the full path to the hashed file, including the hashed file name.

Post your syntax if you still can't get it to work.
by chulett
Thu Jul 05, 2007 6:57 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Is it possible to acess Oracle in Unix from DS in Windows
Replies: 4
Views: 901

Welcome aboard. :D

As noted, yes that is perfectly feasible. You can connect to any Oracle instance you have 'visibility' to from the DataStage server via your tnsnames setup.
by chulett
Thu Jul 05, 2007 6:55 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Date loading problems
Replies: 7
Views: 1700

And yet my reply is rated 'Off Topic / Superfluous'... interesting. Oh well.

Glad that "worked worked worked" for you. :D