Search found 53125 matches
- 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
- 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
- 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
- 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
- Wed Jul 16, 2008 4:01 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Error on Regen - UVCONFIG
- Replies: 5
- Views: 2895
- 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
I have edited the original post to show this.
Code: Select all
UnAssigned(EnvVarName) Or IsNull(EnvVarName)I have edited the original post to show this.
- 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
- 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...
- 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...
- 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.
- 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
- 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
- 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 ...
- 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
- 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...