Search found 53125 matches

by ray.wurlod
Tue May 22, 2007 3:57 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Before job Routine!
Replies: 2
Views: 1031

And to abort the job simply set ErrorCode to a non-zero value. The log functions still work; ErrorCode does not do anything until the routine executes its RETURN statement.
by ray.wurlod
Tue May 22, 2007 3:55 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: 2 datastage servers
Replies: 5
Views: 1358

Yes, though at least one will need to be an -itag installation.
by ray.wurlod
Tue May 22, 2007 3:53 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: commands to delete and create DBF,MDX files
Replies: 5
Views: 3865

Premium membership is one means by which the bandwidth charges of DSXchange are met. Please do not ask us to bypass it. It's only a few cents per day.
by ray.wurlod
Tue May 22, 2007 3:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Compilation Error
Replies: 9
Views: 4665

Compiler first. The DataStage server install process checks that it's there.
by ray.wurlod
Tue May 22, 2007 3:45 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Failed to open RT_CONFIGXXXXX, RT_LOGXXXXetc.............
Replies: 7
Views: 2566

What is the value of T30FILE ?

What is the workaround?
by ray.wurlod
Tue May 22, 2007 3:43 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Execute MS Access Query containing VBA function
Replies: 1
Views: 715

If you can publish the VBA function in an OLE server, you can import it as an "external function" into DataStage.
by ray.wurlod
Tue May 22, 2007 3:36 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Executing multiple TCL Commands using Command Stage
Replies: 4
Views: 1631

You need a paragraph. Either store the two commands under a single name (from the Administrator client) or construct a string with a field mark (@FM) between the two queries. Each query requires a terminating semi-colon.
by ray.wurlod
Tue May 22, 2007 3:34 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Abort of Job sequence
Replies: 3
Views: 4801

Your point 2 is not correct. You can call ANY compiled job from a job sequence, whether or not the job has stages. For example, the job might contain only job control code.
by ray.wurlod
Tue May 22, 2007 3:28 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Using lookups
Replies: 13
Views: 3163

I think you need to attend some entry-level DataStage training.
by ray.wurlod
Tue May 22, 2007 3:18 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error in opening DS Administration
Replies: 4
Views: 1484

Failed to enumerate local groups may mean that you're logged in as a domain user who is not a local administrator.

Failed to enumerate domain groups may mean that you're logged in as a local user who is not a domain administrator.
by ray.wurlod
Tue May 22, 2007 3:15 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Abort of Job sequence
Replies: 0
Views: 495

You have marked this thread as resolved.
Please advise what the resolution is.
by ray.wurlod
Tue May 22, 2007 3:14 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Poor performance of Hash file?
Replies: 8
Views: 1365

There is a field in each Hsahed File stage in which caching can be enabled or disabled, if the stage's output is connected to a reference link.
Size of the hashed file cache for the project is set in the Administrator client on the Performance tab.
by ray.wurlod
Tue May 22, 2007 3:10 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error Code and Error Handling
Replies: 3
Views: 1139

Code: Select all

dsjob -run -jobstatus ...
exitstatus=$?
if [ $exitstatus -eq 0 ] then
   exit 20
fi
by ray.wurlod
Tue May 22, 2007 3:05 pm
Forum: General
Topic: DSSendmail subroutine to send notifications
Replies: 11
Views: 6252

You actually have to call DSSendMail after determining the status.

Please delete your other post which covers identical ground.
by ray.wurlod
Tue May 22, 2007 3:00 pm
Forum: General
Topic: SAP BW with datastage
Replies: 6
Views: 2116

Further, PACK is an ITLA (incremented three latter acronym)
:lol: