Search found 53125 matches

by ray.wurlod
Thu Oct 11, 2007 2:37 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Comparing columns in the same table to dictate processing
Replies: 3
Views: 895

Yes. You need to get the two values into the job sequence - typically via a job that selects them and loads them into its user status area or writes them into a file. Having retrieved them, you would use a Nested Condition activity with a custom trigger expression to make the decision.
by ray.wurlod
Thu Oct 11, 2007 2:35 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: is there a unix datastage uninstall?
Replies: 2
Views: 1061

Take a look at the shell script Craig mentioned. It's complex only because it must take into account that there may be other instances of DataStage server installed on the same machine. With only one, it suffices to remove all the DataStage objects - the install directory, the hidden files in the ro...
by ray.wurlod
Thu Oct 11, 2007 2:32 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error while reading a csv file
Replies: 1
Views: 655

Code: Select all

If Trim(Rec) <= " " Then Continue
by ray.wurlod
Thu Oct 11, 2007 2:30 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable to view the input tab for any file stage
Replies: 3
Views: 1204

Try reinstalling the DataStage client. The SAP client installation may have added/moved some critical DLLs, possibly the Microsoft Foundation Class.
by ray.wurlod
Thu Oct 11, 2007 2:29 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error calling DSRunJob -99
Replies: 11
Views: 5174

Did you regenerate and restart DataStage after changing T30FILE? Execute the command analyze.shm -t | grep T30FILE to find out whether T30FILE has indeed been increased.
by ray.wurlod
Thu Oct 11, 2007 2:24 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ORAOCI stage : Transaction isolation options
Replies: 5
Views: 1651

Most (if not all) stage types have a Help button. You could have clicked this and gotten the answer sooner.
by ray.wurlod
Thu Oct 11, 2007 2:23 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ORAOCI stage : Transaction isolation options
Replies: 5
Views: 1651

Most (if not all) stage types have a Help button. You could have clicked this and gotten the answer sooner.
by ray.wurlod
Thu Oct 11, 2007 2:22 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unexpect network error and Socket closed
Replies: 1
Views: 2782

There was an unexpected network error.

This is not a DataStage issue, nor is it an ODBC driver issue.

Get your network administrator onto it.
by ray.wurlod
Thu Oct 11, 2007 2:20 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sort String
Replies: 18
Views: 3792

I assume that the statements that idiot-proof the arguments are OK. The main logic converts the delimited string to a dynamic array (which in one sense is just a delimited string with a different delimiter, but one for which there are some useful tools). The delimiter I used is a field mark, which m...
by ray.wurlod
Thu Oct 11, 2007 2:11 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Cannot import the SQL server 2000 Stored Procedure...
Replies: 5
Views: 1077

In your version of DataStage the only type of stored procedure that is supported is one that returns a SmallInt (SQL type 5). Apparently your stored procedure does not fit that model.
by ray.wurlod
Thu Oct 11, 2007 2:07 pm
Forum: General
Topic: MQ Stage/Destructive Read/Commit at end of job
Replies: 2
Views: 1656

Apparently you can browse the MQ Series queue rather than destructively reading it.
by ray.wurlod
Thu Oct 11, 2007 1:59 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Deleting Information Analyzer DataStage Jobs
Replies: 0
Views: 1816

Deleting Information Analyzer DataStage Jobs

Information Analyzer uses osh scripts to do its work; they run in a dedicated DataStage project called ANALYZERPROJECT. The DataStage jobs that it runs can be viewed using DataStage Director. However, it is not possible to delete these jobs using DataStage Director: the following message is displaye...
by ray.wurlod
Thu Oct 11, 2007 1:42 am
Forum: General
Topic: DSD.Browse Error
Replies: 7
Views: 3297

DataStage is a 32-bit application. It must find the 32-bit client libraries. If both 32-bit and 64-bit client libraries must be in the shared library search list, for DataStage the 32-bit libraries must appear earlier.
by ray.wurlod
Thu Oct 11, 2007 1:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Timestamp value automatically getting formatted
Replies: 4
Views: 1270

Eschew the OCI stage if this is critical - the OCI stage doesn't do microseconds properly. Prefer Oracle Enterprise stage.
by ray.wurlod
Thu Oct 11, 2007 1:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SQLSTATE=IM003 error after doing all
Replies: 4
Views: 2272

For DataStage it definitely does. DataStage is a 32-bit application and must find the 32-bit libraries (and must find them before the 64-bit libraries if both are in the shared library search list).