Search found 53125 matches

by ray.wurlod
Thu Aug 28, 2008 3:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage Director
Replies: 10
Views: 2888

If use the job sequence with no dependencies between jobs, how would we error handle. i.e if a job aborts then it will cause the sequnce to abort which inturn aborts the rest of the jobs. Use an Exception Handler. This has activity variables that will tell you which activity failed. Once you restar...
by ray.wurlod
Thu Aug 28, 2008 3:29 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Multiple Instances of data file
Replies: 1
Views: 1118

Are the file names exactly the same? What are the "date/time accessed" values on the files? What does the Data Set Management utility show you when in the Segments grid when you select Node 0 in the nodes grid?
by ray.wurlod
Thu Aug 28, 2008 3:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Deploy
Replies: 6
Views: 2006

Use Administrator to create new project.

Use export to capture the old project, and import to move those objects into the new project.
by ray.wurlod
Thu Aug 28, 2008 3:24 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequence fails to compile ... but no error message
Replies: 3
Views: 1128

Do you have write permission on the client machine? Precompiling a job sequence needs to write to the client machine.
by ray.wurlod
Thu Aug 28, 2008 3:22 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to capture Rejected ODBC records
Replies: 5
Views: 1541

On the Rejects link you can also capture the SQL State, DBMS code and last error message returned from the "regular" output link when a row is rejected.
by ray.wurlod
Thu Aug 28, 2008 3:20 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Enterprise databse stages are disabled
Replies: 1
Views: 822

Read the help for this particular check box. Then don't check it unless you're running DataStage on USS.

For more information read the DataStage Parallel Job Developer's Guide Chapter 56.
by ray.wurlod
Thu Aug 28, 2008 3:10 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: missing nutccg folder in MKSToolKit directory
Replies: 1
Views: 768

It should be at X:\MKS Toolkit\etc\nutccg

However, DataStage requires the Visual Studio .NET C++ compiler - it's that that you have to install. You can download the Express version (use the 2005 version) for free from Microsoft and will also need the Platform SDK for 32-bit applications.
by ray.wurlod
Thu Aug 28, 2008 7:34 am
Forum: General
Topic: Unable to open Designer/Director/Administrator
Replies: 3
Views: 1589

Has the ASB Agent stopped?
by ray.wurlod
Thu Aug 28, 2008 5:13 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Using Job Parameter in Column Generator stage
Replies: 8
Views: 3580

The Modify stage does not accept job parameters (I wonder whether Jasti has tested the suggestions made?). This is the fundamental flaw in your "simple logic".
by ray.wurlod
Thu Aug 28, 2008 5:11 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: VOC :: Pointer creation limit
Replies: 2
Views: 1592

There IS a limit, which is when the VOC file reaches 2GB. Given that the typical VOC is about 100KB and the average file pointer not more than 200 bytes, you have some time before this will be a problem. BUT... is there any reason for keeping the old VOC pointers (and indeed the old hashed files) on...
by ray.wurlod
Thu Aug 28, 2008 4:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Running Commands in DS Administrator
Replies: 1
Views: 1047

Code: Select all

SELECT NAME FMT '32L', CATEGORY FMT '32L' FROM DS_JOBS
WHERE JOBNO IN
(SELECT OBJIDNO FROM DS_JOBOBJECTS
 WHERE EVAL "@RECORD" LIKE '%EMP_NO%');
by ray.wurlod
Thu Aug 28, 2008 4:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Using Job Parameter in Column Generator stage
Replies: 8
Views: 3580

Use a Transformer. There's no reason any more not to.

Unless, of course, you don't have a C++ compiler.
by ray.wurlod
Thu Aug 28, 2008 4:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: PX_Debug variable - Help required
Replies: 8
Views: 3583

Nice Catch Ray, I had created a dummy job for the IBM guys, So that they'll get the necessay info. And that job still exist in the project. This job has PX_Debug variable as a job parameter. If I delete this job from the project, Will this issue be resolved? Clearly and definitely "maybe". Is $PX_D...
by ray.wurlod
Thu Aug 28, 2008 4:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DSU_BP sub directory
Replies: 2
Views: 1970

The same as that of any line of code. When $INCLUDE is executed at compile time, lines from the header file are inserted at that point into the main code stream.
by ray.wurlod
Thu Aug 28, 2008 4:29 am
Forum: General
Topic: HashFileLookup
Replies: 1
Views: 1004

Not possible using a Hashed File stage or UtilityHashLookup(). These only do exact match, employing the hashing algorithm to do so in the most speedy fashion available. What you seek to do is possible, but slow, using a UniVerse stage or BCI code (with no licensing issues) to refer to the hashed fil...