Search found 53125 matches

by ray.wurlod
Mon Jun 16, 2008 1:12 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Check file format for sequencial file (Unix/DOS) in routine
Replies: 1
Views: 925

You can't use ReadSeq to read to end of line unless the line terminator is appropriate for the operating system. You can read with ReadBlk, a character at a time, until you come to a Char(13) or a Char(10), and check the next character just in case. Don't forget to CloseSeq, to release the lock on t...
by ray.wurlod
Mon Jun 16, 2008 12:49 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: TimeStamp Variable.
Replies: 6
Views: 1452

System variables give the job start, which timestamp can also be had via the DSJobStartTimestamp macro. If you need the timestamp "now", prefer Date() and Time() functions. Oconv(Date(), "D-YMD[4,2,2]") : " " : Oconv(Time(), "MTS:")
by ray.wurlod
Sun Jun 15, 2008 11:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataStage Environment Variable
Replies: 2
Views: 1106

This is not a DataStage question. In a shell script a reference to an environment variable begins with $, for example $PROJDATADIR is a reference to (the value of) the environment variable called PROJDATADIR.

I wonder whether you asked the right question?
by ray.wurlod
Sun Jun 15, 2008 10:59 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: OBJ files
Replies: 4
Views: 1270

Cud is what ruminants chew. I have no idea of your context for the question about an OBJ file.
by ray.wurlod
Sun Jun 15, 2008 6:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Filter Option in Sequential File
Replies: 4
Views: 2500

Your head -1 command needs to be followed by the file name. The Sequential File stage reads stdout of the command rather than reading the file and applying the filter command to it.
by ray.wurlod
Sun Jun 15, 2008 3:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Mapping Network Drives
Replies: 6
Views: 1599

At the very least you need ALLOWNFS to be set to 1. However DataStage can be very particular with mapped drives; you may have more success using UNC pathnames to refer to files on the remote machines. Usual Windows security considerations still apply; DataStage can not bypass these.
by ray.wurlod
Sun Jun 15, 2008 3:05 am
Forum: General
Topic: Datastage Installation in laptop
Replies: 15
Views: 5968

Are the DataStage services started?
by ray.wurlod
Sat Jun 14, 2008 4:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Passing Env variables through dsjob
Replies: 23
Views: 6134

:oops:

My bad. As usual on a Friday night I was in an airport lounge, and it was very stormy weather, I was probably not fully focussed on DSXchange!
by ray.wurlod
Sat Jun 14, 2008 4:23 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Map Name to be given in type conversion
Replies: 10
Views: 5373

Map name is an optional property. The "warning" is actually an alert, informing you that you are changing from ustring to string (in case you weren't aware of it). Are you saying that the "implicit conversion" message persists even when you specify an explicit conversion, or that you haven't tried i...
by ray.wurlod
Sat Jun 14, 2008 4:12 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Row Splitter vs Transformer with FIELD function
Replies: 7
Views: 2386

When it's only one (which was not the original question, by the way), there will not be much to choose from in terms of number of stages in the job. My personal preference is guided by the relative newness of the Row Splitter stage; the Transformer has been around a lot longer and has had a better c...
by ray.wurlod
Sat Jun 14, 2008 4:10 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Fault type is 11
Replies: 5
Views: 2038

I suspect that 0xde is the address, the "." is punctuation indicating the end of that sentence in the error message and the final "0" is spurious.

Therefore a VLIST of the generated Transformer code would reveal what instruction occurs at addres 0xde and the corresponding source statement.
by ray.wurlod
Sat Jun 14, 2008 4:07 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error writing to ROOT
Replies: 5
Views: 2611

ROOT refers to a record in DS_JOBOBJECTS table in the local (project) repository and in the equivalent table (whatever it's called) in the XMETA common metadata database.
by ray.wurlod
Sat Jun 14, 2008 4:06 pm
Forum: General
Topic: How to run the job as parameter driven
Replies: 6
Views: 1452

... except in file/table names. Only in expressions.
by ray.wurlod
Sat Jun 14, 2008 1:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Add block to queue failed - issue
Replies: 3
Views: 6525

Tip: with these large configuration files it's not a bad idea to add a comment beside each node name indicating its node number. /* Four node configuration beatles.apt */ { node "john" /* node #0 */ { definition } node "paul" /* node #1 */ { definition } ...
by ray.wurlod
Sat Jun 14, 2008 1:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Passing Env variables through dsjob
Replies: 23
Views: 6134

The special tokens $PROJDEF, $ENV and $UNSET are only ever used in the job parameter definition grid in a job design. They are never mentioned in the Administrator client.
Does that help clarify your question?