Search found 53125 matches

by ray.wurlod
Wed Jul 16, 2008 4:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: NullToEmpty - Exporting nullable field without null handling
Replies: 4
Views: 16813

Just to keep it happy set the Null Field Value property for this field to "" (indeed, having done so, you could remove the NullToEmpty transformation).
by ray.wurlod
Wed Jul 16, 2008 4:06 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Implicit conversion from source type "dfloat" to r
Replies: 3
Views: 2363

"double" stands for "double precision floating point number". Whoever authored the message abbreviated this to "dfloat".
by ray.wurlod
Wed Jul 16, 2008 4:04 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reading Multiformat Cobol File
Replies: 5
Views: 1382

In version 7.x, you can only use separate CFF stage for each table. In version 8.x one CFF stage can have different outputs for different tables.
by ray.wurlod
Wed Jul 16, 2008 4:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Modify stage:decimal to integer and numeric
Replies: 1
Views: 1611

Welcome aboard.

Can you show us what specifications you actually used?

VarChar does not exist for the Modify stage. It's called "string". For example string[max=32] to specify VarChar(32).
by ray.wurlod
Wed Jul 16, 2008 4:01 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error on Regen - UVCONFIG
Replies: 5
Views: 2895

Did you change the parameter immediately ahead of UVSPOOL ?

Does your uvconfig file's last line have a line terminator?
by ray.wurlod
Wed Jul 16, 2008 3:58 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Accessing Datastage Env variable value in Basic Rouitne
Replies: 6
Views: 2211

The test condition should have been

Code: Select all

UnAssigned(EnvVarName) Or IsNull(EnvVarName)
:oops:

I have edited the original post to show this.
by ray.wurlod
Wed Jul 16, 2008 5:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Lookup file-> how do arrive this answer
Replies: 1
Views: 902

The Lookup stage has a drop down list of reference inputs. You can choose one from which multiple row returns is permitted.
by ray.wurlod
Wed Jul 16, 2008 5:34 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Stage Routine in job sequencer
Replies: 3
Views: 1644

None of the above. A job sequence will always treat a non-zero return value from a routine as a "failure". To avoid this, you need to explicitly put in place a Failure trigger from the Routine activity. This can go to the same Sequencer as the OK trigger if you like. Bonne chance! Please format your...
by ray.wurlod
Wed Jul 16, 2008 4:22 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: NLS: junk character removal
Replies: 3
Views: 1631

The "?" is not necessarily a junk character; it is more likely to be a perfectly normal character but one that can not be mapped using the character map that you currently have specified. The solution to that is to determine how the characters in your data source are encoded, and to specify the appr...
by ray.wurlod
Wed Jul 16, 2008 3:33 am
Forum: General
Topic: How to read time datatype from sequential stage
Replies: 1
Views: 876

Read it as VarChar and convert it to Time downstream of the Sequential File stage, as discussed in this thread.
by ray.wurlod
Wed Jul 16, 2008 1:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: checking decimal in Isvalid
Replies: 1
Views: 2245

Clearly 501.42 is not a valid Decimal[7,5] so the result generated by the IsValid() function is correct. A general "is valid" test for decimal numbers, while not perfect (due, for example, to not handling scientific notation) is IsValid("int64",Field(InLink.TheDecimal,"."...
by ray.wurlod
Wed Jul 16, 2008 1:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reading delimited file where sometime delimiter is missing
Replies: 1
Views: 835

Capture them with a reject output link from your Sequential File stage and re-parse them downstream with a Transformer, Column Import or similar stage.
by ray.wurlod
Wed Jul 16, 2008 1:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Count records for column with table names in a table
Replies: 1
Views: 902

Do it with a server job. Use UtilityRunJob() function to run another server job that gets the row count and stores it in its user status area, and get that result back in the main job for update into your table. Or dump the list of table names into a file, read that file into a delimited string and ...
by ray.wurlod
Wed Jul 16, 2008 1:23 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how can i install missed plugin in unix
Replies: 3
Views: 1128

Package Installer on UNIX is an executable called DSPACKINST. Find it on your system. It asks the same questions as its Windows counterpart.
by ray.wurlod
Wed Jul 16, 2008 1:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Diffrence on Datastage MVS edition and Parallel extender
Replies: 2
Views: 2761

1. A definite maybe. Depends on configurations. 2. MVS. Fewer stages to know/learn. Less flexibility as a result. 3. Equal. "Will IBM continue to support MVS edition?" might be a pertinent question to ask. 4. Define "better". Either can be more expensive, depending on the configuration. 5. MVS, if y...