Search found 53125 matches

by ray.wurlod
Thu Jun 26, 2008 11:10 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Reg NLS settings
Replies: 4
Views: 1075

Welcome aboard. Any standard number beginning with ISO is issued by the International Standards Organization; you can consult their website for more information. ISO8859 (parts 1 through 12) covers ways of encoding characters encountered in commercial business data processing in "European" language ...
by ray.wurlod
Thu Jun 26, 2008 11:07 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: compilation error
Replies: 7
Views: 1604

It's not actually relevant. Your disk was full, and that's why DataStage could not create a new file/table.
by ray.wurlod
Thu Jun 26, 2008 8:16 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ODBC Stage Error - SQLConnect failed
Replies: 6
Views: 7733

You are getting intermittent network errors. Check for faulty network card and/or check with your network administrator whether any strange things are occurring on your network.
by ray.wurlod
Thu Jun 26, 2008 6:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to check if the job is still running
Replies: 3
Views: 1166

Use Monitor to determine what the status of each stage is. Also, is the row count continuing to increase? (Yes would indicate that the job is still running.)
by ray.wurlod
Thu Jun 26, 2008 4:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: NULL value in DECIMAL fields
Replies: 6
Views: 2632

U has not logged in for some time.

The second person personal pronoun in English is spelled "you".
by ray.wurlod
Thu Jun 26, 2008 4:50 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to parse Configuration file
Replies: 6
Views: 8366

Switch back temporarily to a hard-coded pathname as the value of $APT_CONFIG_FILE. When you're done testing reinstate $PROJDEF as the default value.
by ray.wurlod
Thu Jun 26, 2008 4:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: handle_null to return empty string
Replies: 1
Views: 1119

Try using double-quote characters instead of single-quote. The target field must be of type VarChar (that is, string[max=N]).
by ray.wurlod
Thu Jun 26, 2008 4:39 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Conductor node, Section leader and player help
Replies: 6
Views: 2336

Re: Conductor node, Section leader and player help

sreddy wrote:There is generally a player for each operator on each node.
There is ALWAYS a player for each operator (each operator mentioned in the score) on each node.
by ray.wurlod
Thu Jun 26, 2008 4:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Lookup Fileset
Replies: 5
Views: 1777

Try to stay with the convention of ".fs" suffix for File Sets and Lookup File Sets (even though the latter is not a true file set) so that you don't confuse your support provider.
by ray.wurlod
Thu Jun 26, 2008 4:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datstage Environment variable value
Replies: 14
Views: 4775

They are stored in DSParams. But you may need to re-open the client to have it re-read the file.
by ray.wurlod
Thu Jun 26, 2008 4:13 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: compilation error
Replies: 7
Views: 1604

Or the disk where your project is installed has become full.
by ray.wurlod
Thu Jun 26, 2008 4:12 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Copy log to a txt file ERROR
Replies: 16
Views: 6813

Just leave out (omit) the -type option to get all types.
by ray.wurlod
Thu Jun 26, 2008 4:11 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Merge stage mismatched data types
Replies: 1
Views: 828

ODBC driver for text files can do this. It's a great solution if you're being paid by the hour! :wink:
by ray.wurlod
Thu Jun 26, 2008 4:09 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ds_uvopen()-unable to read file header
Replies: 2
Views: 1144

It suggests to me that you're trying to read a sequential file with a hashed file stage. The ds_uvopen() function relates only to a Hashed File stage. If you had been using a Sequential File stage the function would have been DSD.SeqOpen().
by ray.wurlod
Thu Jun 26, 2008 4:03 pm
Forum: General
Topic: Delete of not-used hash-files
Replies: 7
Views: 2085

Define "not used". This may be trickier than you imagine. For example you may have one or two hashed files used only in end of year processing. Once you have identified them, deleting them is straightforward, but you must use the correct method depending on how they were created. If they were create...