Search found 53125 matches

by ray.wurlod
Wed Mar 07, 2007 6:42 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: View Data against Universe table results with character: ü
Replies: 0
Views: 567

This character is how the particular browser represents a "value mark", one of the dynamic array delimiters used in UniVerse, particularly in multi-valued fields. Its appearance ought not to cause concern. When using a UniVerse stage, the user has the option to "normalize on" either a multi-valued f...
by ray.wurlod
Wed Mar 07, 2007 4:50 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Row Generator generated OSH script bug
Replies: 5
Views: 1142

Welcome aboard. :D

Choose the filepath column in the Columns grid. Right click on this row in the grid and choose Edit Row from the menu.

In the properties window, please advise what you have under the Generator property.
by ray.wurlod
Wed Mar 07, 2007 4:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Attach DSJ.JOBPID during job
Replies: 17
Views: 4219

You could employ the Transformer stage function GetEnvironment($$) when intializing a stage variable (for the Transformer stage's process ID) or GetEnvironment($PPID) for the job's process ID.
by ray.wurlod
Wed Mar 07, 2007 4:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: use column_gen stage to create current timestamp column
Replies: 3
Views: 1283

Is your problem with generating the current timestamp, or with using it in a job parameter? You can generate the value in a job sequence using an expression for the job parameter value. A suitable expression is: Oconv(@DATE,"D-YMD[4,2,2]") : " " : Oconv(@TIME,"MT...
by ray.wurlod
Wed Mar 07, 2007 4:25 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Lookup Failing when data should match
Replies: 8
Views: 1488

What ARE the data types?
Make sure to TRIM() any VarChar columns when populating the hashed file, and to apply TRIM() in the reference key expression when generating the lookup key, so that neither has unnecessary white space characters.
by ray.wurlod
Wed Mar 07, 2007 3:49 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Insert Long datatype from ORacle db to oracle db
Replies: 3
Views: 1913

Why involve DataStage if it's Oracle to Oracle? It would be faster to do it within Oracle.
by ray.wurlod
Wed Mar 07, 2007 3:48 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: call stored procedure repeatly
Replies: 11
Views: 2496

The ODBC stage has "call stored procedure" as one of its mechanisms.
by ray.wurlod
Wed Mar 07, 2007 3:47 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Delete on a Database
Replies: 6
Views: 982

Create a job that sends zero rows to the table, and set its rule to "truncate table then insert rows".
by ray.wurlod
Wed Mar 07, 2007 3:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Attach DSJ.JOBPID during job
Replies: 17
Views: 4219

Capture your PID using echo $$ within a before-job subroutine.
by ray.wurlod
Wed Mar 07, 2007 1:30 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: C++ routine
Replies: 12
Views: 3626

APT_COMPILER is installed with a default value. It may not be correct. Check whether your machine even has a compiler installed and, if so, where it actually is. If you're trying to compile from the command line, the compiler executable's directory pathname will need to be in your PATH and any libra...
by ray.wurlod
Wed Mar 07, 2007 1:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Director job monitoring warning message
Replies: 4
Views: 1410

Search the forum. It might be the case, for example, that the job monitor has run out of space for its log files.
by ray.wurlod
Wed Mar 07, 2007 1:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Max of date from Aggregator
Replies: 3
Views: 6716

All Aggregator stage calculation columns generate data type dfloat.

Try converting the date to Julian and getting the max of that, then converting back to any desired date format.
by ray.wurlod
Wed Mar 07, 2007 1:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: The number of external links does not match
Replies: 1
Views: 2084

Are the links in the job (one input to and one output from the shared container) named the same as the links from and to the Container Input and Container Output stages? If so, are they carrying the same metadata? Even if not, the Validate tool (drop down list should contain link names) can get them...
by ray.wurlod
Wed Mar 07, 2007 1:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Build op - Float comparison.
Replies: 6
Views: 1785

To what object does CHD_EXTERNAL_STATUS belong? Where have you declared this?