Search found 53125 matches

by ray.wurlod
Tue Jun 03, 2008 9:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Possible to export DS log?
Replies: 6
Views: 2257

Open the Project menu in Director and choose the Print option. When the Print dialog opens, check the "Print to file" check box as well as options that determine how much of the log is to be dumped. Click OK and the common dialog for choosing a file name opens, in which you specify the name of the f...
by ray.wurlod
Tue Jun 03, 2008 9:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: rejecting rows while updating in oracle
Replies: 17
Views: 4532

Auto commit. Transaction size = 1.
by ray.wurlod
Tue Jun 03, 2008 7:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: File splitting based on row count
Replies: 1
Views: 955

Just use the UNIX split -l 3000000 filenamecommand. Execute man split to get detailed syntax for your particular UNIX and to learn how the names of the output files are generated.
by ray.wurlod
Tue Jun 03, 2008 7:21 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Writing into a text file
Replies: 7
Views: 2558

In a Routine. Probably in a before/after or job control routine. DataStage BASIC Notes 1. Lines do not require a ";" terminator. 2. "Then" or "Else" on the end of a line open a block of statements that must be terminated by an "End" statement. Tip Track down the OpenSequentialFile() function (search...
by ray.wurlod
Tue Jun 03, 2008 6:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Header files to use in .c file (LINUX)
Replies: 2
Views: 1054

dsapi.h (find it in the dsdk directory)

You'll also need to include the dsapi libraries.
by ray.wurlod
Tue Jun 03, 2008 5:06 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Oracle Oci Stage Before and After Options
Replies: 2
Views: 1002

Try it and let us know.

The only way we could answer would be to try it, so why should we do your work for you?

As well, you probably already have your Oracle-sourced metadata in place.
by ray.wurlod
Tue Jun 03, 2008 5:04 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hi Gurus
Replies: 4
Views: 1315

Please use meaningful subject lines
by ray.wurlod
Tue Jun 03, 2008 4:08 pm
Forum: IBM QualityStage
Topic: processing large resultsets
Replies: 5
Views: 1787

If the system is not running out of resources, use a configuration file with more nodes.

It might be possible to write a more efficient rule set, but the benefit is probably not worth the cost.
by ray.wurlod
Tue Jun 03, 2008 4:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Empty string Handling in Datastage
Replies: 2
Views: 7065

Read as Char or VarChar. In the Transformer stage test for an all-blank value and replace that with null.

Code: Select all

If InLink.TheNumber = "   " Then SetNull() Else InLink.TheNumber
by ray.wurlod
Tue Jun 03, 2008 4:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to audit for a single job
Replies: 2
Views: 889

Please mark thread as Resolved.
by ray.wurlod
Tue Jun 03, 2008 4:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error During View Data in DB2_UDB_ENTERPRISE Stage
Replies: 10
Views: 3271

What do you understand from the words in the error messages?
by ray.wurlod
Tue Jun 03, 2008 4:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Fileset
Replies: 1
Views: 728

Try it. Let us know.
by ray.wurlod
Tue Jun 03, 2008 3:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: rejecting rows while updating in oracle
Replies: 17
Views: 4532

Since it's an update, you only need to send those values which you have.

This may involve designing the job to take different paths for different combinations of changed columns.