Search found 53125 matches

by ray.wurlod
Thu May 06, 2010 2:33 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Row-Delimiter & column Delimiter in Datastage
Replies: 1
Views: 2705

I don't believe the server Sequential File stage can handle this (the parallel one can). In a server job, given that your file does have operating system line terminators, why not run a Filter command (for example sed or awk) to strip out the {LR} characters? Similarly for the multi-character field ...
by ray.wurlod
Thu May 06, 2010 2:29 am
Forum: General
Topic: libvmdsapi.so: open failed Error
Replies: 4
Views: 3744

Does dsadm change LD_LIBRARY_PATH in, say, .profile? "No such file" is usually either a search path issue, but possibly permissions to a parent directory. I suspect the former in your case, but it's going to require some detective work to find it. For a start, try manually adding $DSHOME/l...
by ray.wurlod
Wed May 05, 2010 7:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Custom Stage Type BuildOp Help
Replies: 9
Views: 3805

This isn't really server job question, is it?
by ray.wurlod
Wed May 05, 2010 7:04 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: 2 GB limit on Oracle Bulk load Stage ?
Replies: 6
Views: 2033

Moderator: please move to Server forum
by ray.wurlod
Wed May 05, 2010 7:04 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Converting from Windows to Linux
Replies: 4
Views: 1627

Moderator: please move to Server forum
by ray.wurlod
Wed May 05, 2010 7:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Load Parent child records
Replies: 10
Views: 2841

Moderator: please move to Server forum

The obvious suggestion is multiple jobs.
by ray.wurlod
Wed May 05, 2010 7:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Warning - Import error
Replies: 1
Views: 1060

Get your metadata to match your data.

Add a Rejects link to capture the rejected records, and try from those to see where the issue is.

There's not enough information in your report to provide any more help.
by ray.wurlod
Wed May 05, 2010 4:51 pm
Forum: General
Topic: Is there any priority in trigger conditions
Replies: 14
Views: 4061

I believe they execute in the order they are specified in the grid on the Triggers tab. That said, they are independent; that one trigger has fired does not affect whether or not other, later, triggers may fire.

Inspect the generated job control routine to get a better idea of what is happening.
by ray.wurlod
Wed May 05, 2010 4:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: 2 GB limit on Oracle Bulk load Stage ?
Replies: 6
Views: 2033

Since file size is unlimited (check that this is the case for the executing user), you need to check further afield. For example is the /data/etldata/Control_Data_Files/DW_Files/ file system filling?
by ray.wurlod
Wed May 05, 2010 4:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Failed to authenticate the current user against the selected
Replies: 3
Views: 2025

WAS = WebSphere Application Server, the mechanism that exposes the common services used by products in the Information Server suite, including the login/security service and the directory service which are used during the login/authentication process. If WAS had been shut down temporarily, perhaps f...
by ray.wurlod
Wed May 05, 2010 4:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Converting from Windows to Linux
Replies: 4
Views: 1627

Beware of any job or routine that invokes a BAT file - you will need to convert these to shell scripts.
by ray.wurlod
Wed May 05, 2010 4:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to convert 26-FEB-10 into 26/02/2010
Replies: 4
Views: 1647

Use StringToDate() to convert to binary date format, and DateToString() to convert back to desired format. Use appropriate date format strings for each function.
by ray.wurlod
Wed May 05, 2010 4:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to Copy, Save or Compile any jobs in a Project
Replies: 5
Views: 1973

No project wide variables were altered. Could someone have changed the status of the project to Protected (which does not require variables)? Check using the Administrator client, project properties. If the project is protected, the command button on the General tab will be captioned "Unprotec...
by ray.wurlod
Wed May 05, 2010 4:39 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Custom Stage Type BuildOp Help
Replies: 9
Views: 3805

The API is documented in the Parallel Job Advanced Developer's Guide.

But why are you reinventing the wheel? The inbuilt Index() function can perform the task you describe.
by ray.wurlod
Wed May 05, 2010 4:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Repeated Warning in a job
Replies: 6
Views: 3525

True, but the original question posited a Transformer stage.