Search found 53125 matches

by ray.wurlod
Wed Jun 06, 2007 10:57 pm
Forum: Site/Forum
Topic: update stratagies
Replies: 4
Views: 2903

Eek! Not only do you hijack a thread, but you hijack a thread that's in the wrong forum in the first place! There must be some kind of award for that! Meanwhile please open a new thread in the appropriate forum (server or parallel) so that you can get an answer relevant to your platform. Wannabexpe...
by ray.wurlod
Wed Jun 06, 2007 9:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Fatal Error: APT_SYSselect returned error status -1
Replies: 11
Views: 2748

This may not be related, but why hash on acctnum only to repartition using DB2 after the Funnel stage?
by ray.wurlod
Wed Jun 06, 2007 9:18 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Copying set of tables in to different tables
Replies: 12
Views: 1970

Stored Procedure stage sounds like a potential candidate.
by ray.wurlod
Wed Jun 06, 2007 9:16 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: problem adding jobs to schedule
Replies: 15
Views: 14366

Welcome aboard. :D

Which AT command is it finding?
Will moving System32 to the front of PATH solve the "garbage after the time specification" issue, or is this a bug in DataStage?
by ray.wurlod
Wed Jun 06, 2007 9:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: why to use copy stage .....
Replies: 7
Views: 2541

A Copy stage that does nothing will be optimized out of the design when the score is composed.

While the Copy stage is not permitted to change or add data, it can do any or all of the following:
- re-order columns
- drop columns
- rename columns
by ray.wurlod
Wed Jun 06, 2007 9:08 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Libraries
Replies: 3
Views: 1080

If you are asking about connecting from a DataStage client, they should be set up in the dsenv script in the DSEngine directory.

If you are asking about connecting via telnet, you can execute the dsenv script, perhaps from your .profile file.
by ray.wurlod
Wed Jun 06, 2007 9:06 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: C code execution on AIX
Replies: 4
Views: 1243

Check the four environment variables in the Compiler group.
by ray.wurlod
Wed Jun 06, 2007 9:03 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: To speed up the aggregator
Replies: 15
Views: 5784

You might also investigate option #6 on the DS.TOOLS menu, where you can modify the reporting intervals and memory allocation model.
by ray.wurlod
Wed Jun 06, 2007 9:01 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable to copy files to different domains
Replies: 4
Views: 2133

On the server machine map a shared folder from \\pubnt33 (using a different user ID) so that you can set up authentication. Or execute the DOS command NET USE to set up the authentication.
by ray.wurlod
Wed Jun 06, 2007 8:52 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DRS Stage Hangs
Replies: 9
Views: 2648

Is your client running Windows XP sp2? If so, do you have the DataStage patch installed?
by ray.wurlod
Wed Jun 06, 2007 8:50 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Dependencies page in batch job.
Replies: 6
Views: 1624

The Dependencies tab exists only to provide a checklist for promotion. You should record any routines that a job invokes, or any routines that a routine invokes. Then, when it comes time to promote from development into test or production, you have a checklist of other components that need to exist ...
by ray.wurlod
Wed Jun 06, 2007 8:47 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Delete
Replies: 17
Views: 4636

Array Size governs transmission of data between DataStage and the database server.
by ray.wurlod
Wed Jun 06, 2007 8:45 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: writing batch control for ftp files in unix
Replies: 3
Views: 1254

Eschew DataStage. Just write shell scripts. There's nothing useful that DataStage can add to your requirement; you're simply moving files.
by ray.wurlod
Wed Jun 06, 2007 8:43 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: sql from file in DB2/UDB API
Replies: 10
Views: 5078

What, getting data out of a DB2 table using OCI stage?? I'd like to see that! :twisted:

I need to do some research before providing a more serious response to the original question.
by ray.wurlod
Wed Jun 06, 2007 8:39 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Read log files and write custom messages in Exception file.
Replies: 4
Views: 1316

Use DSGetLogSummary() to determine whether there were any warnings. Presumably, if there were none, you don't want to write to the exceptions file. You can obtain the row counts from "active stage finishing" messages in the log. Statements OpenSeq, WeofSeq or Seek, WriteSeq and CloseSeq will allow y...