Search found 42189 matches

by chulett
Wed Apr 08, 2009 8:02 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Read only access in Datastage Server edition
Replies: 3
Views: 1333

The 'official' answer would be to make the project a Protected project via the Administrator. Another answer is to use Version Control to promote everything into it as it can set each individual component to 'read only' during the process.
by chulett
Wed Apr 08, 2009 8:00 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Parameters in Command Stage
Replies: 22
Views: 6918

Windows is not case-sensitive so that's not an issue here. One thing confusing me - you've now sometimes said you are using the "Execute Command" stage and here the "Command Activity" stage. Can you verify exactly which one we're talking about? Not sure it is an issue here, just ...
by chulett
Wed Apr 08, 2009 7:55 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: comparing with null values
Replies: 5
Views: 1241

And welcome to E.F. Codd's world of three-valued logic: True, False and Who the Heck Knows. :wink:
by chulett
Wed Apr 08, 2009 7:44 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Controller Problem
Replies: 4
Views: 1579

Or "[Timed out while waiting for an event]" is another good search candidate. As noted, discussed here many many times.
by chulett
Wed Apr 08, 2009 7:42 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Parameters in Command Stage
Replies: 22
Views: 6918

Probably not going to make any difference since the parameters as passed are getting resolved. Are you certain there are "*.csv" files in that location and which are accessable to the DataStage job? The first (not totally conclusive) test to run is to start a "cmd" window so you ...
by chulett
Wed Apr 08, 2009 7:33 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ExecuteCommand stage not accepting semicolon
Replies: 3
Views: 1285

I second the use of "&&" as the command separator rather than a semi-colon. As noted, it requires the preceding step to complete successfully before allowing the next to execute, compare that to the semi-colon which blissfully passes execution down the line regardless of the mayhem...
by chulett
Wed Apr 08, 2009 7:29 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Calling Datastage job in a UNIX script
Replies: 2
Views: 1306

$DS_LOGIN is a filename containing credentials: server, userid, password. And $DS_SERVER tells it which record in the file to use, looked up by matching server name. As noted, you may be able to leave them out but if not and you remove the "-file ${DS_LOGIN} ${DS_SERVER}" bit you'll need t...
by chulett
Wed Apr 08, 2009 7:24 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Parameters in Command Stage
Replies: 22
Views: 6918

Possibly the 'Windows only' Command stage which I've never seen. Can you post the log message that shows the actual command that was executed after the parameters were resolved? I assume this logs one like the Execute Command stage does. For Windows without any MKS Toolkit like functionality, rather...
by chulett
Tue Apr 07, 2009 10:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job Not progressing with Shared Containers
Replies: 3
Views: 1501

Do we have to guess what's in the container? :?
by chulett
Tue Apr 07, 2009 9:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to write substring option in transformar with if conditi
Replies: 5
Views: 1489

Ah... didn't notice you had the arguments 'backwards'. :wink:
by chulett
Tue Apr 07, 2009 9:42 pm
Forum: General
Topic: How to detect end of file
Replies: 2
Views: 1033

Short answer? Nope. :( Sometimes you can 'pre-count' the data and pass the number in as a parameter for use in a constraint or derivation. Some people will cat a known 'end of file' record onto the source or into the stream so you can tell when you've hit the end. Another thought relates to 'group c...
by chulett
Tue Apr 07, 2009 3:08 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to write substring option in transformar with if conditi
Replies: 5
Views: 1489

Now, that depends on how you read the 'IN' statement in the OP. As written, it is syntactically equivalent to if OKCSCD = 'DE' but if you read it as if OKCSCD like '*DE*' or that the field contains the substring 'DE' then the Index() is appropriate.
by chulett
Tue Apr 07, 2009 3:03 pm
Forum: General
Topic: Routine to zip a file
Replies: 6
Views: 2661

Post the unedited log message (copy/paste) that shows the 'executed command'. And answer the question about 'fil1'.
by chulett
Tue Apr 07, 2009 12:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Can we use XML stages in Parallel jobs
Replies: 3
Views: 1023

Yes. That guide was written pre-PX from what I recall.
by chulett
Tue Apr 07, 2009 12:10 pm
Forum: General
Topic: Routine to zip a file
Replies: 6
Views: 2661

You get this error when - compile time, run time, what? Also, is "fil1" a local variable you've built as well?