Search found 53125 matches

by ray.wurlod
Tue Mar 10, 2009 3:57 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to process a large sequential file?
Replies: 2
Views: 901

Welcome aboard.

You may find it preferable to use the Slowly Changing Dimension stage.

Or you may like to investigate any of the three change detection stages (Difference, Compare, Change Capture).
by ray.wurlod
Tue Mar 10, 2009 3:57 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to start ORCHESTRATE process on node node4
Replies: 2
Views: 1153

Is rsh properly configured between all nodes mentioned in the configuration file?
by ray.wurlod
Tue Mar 10, 2009 3:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to process a large sequential file?
Replies: 2
Views: 901

Welcome aboard.

You may find it preferable to use the Slowly Changing Dimension stage.

Or you may like to investigate any of the three change detection stages (Difference, Compare, Change Capture).
by ray.wurlod
Tue Mar 10, 2009 3:54 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Conversion from string to decimal
Replies: 2
Views: 1893

It's an alert, not a warning. When converting from string to decimal rounding may occur. Therefore "rounding errors" may occur. No records will be dropped, but some may incur these rounding issues. Then again, none may - depends on your data. But DataStage always generates the "precis...
by ray.wurlod
Tue Mar 10, 2009 3:51 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Get DS jobs list
Replies: 1
Views: 1593

Not with a single function call. You need to get the entire job list then iterate through it calling DSGetJobInfo() to determine the status of each, building your new list as you go.
by ray.wurlod
Tue Mar 10, 2009 3:45 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Reject handling in web service transformer stage
Replies: 4
Views: 2876

"Some error"?!!! Get serious. We charge a lot extra to read your mind.

WHAT error?
by ray.wurlod
Tue Mar 10, 2009 2:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: problem executing dsjob -run -jobstatus
Replies: 2
Views: 1614

It's -jobinfo that you need to run before -run, not -jobstatus. The -jobstatus option is a sub-option of -run.

Search DSXchange for error code -14, and then reduce the total load on your server.
by ray.wurlod
Tue Mar 10, 2009 2:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: need help in understanding the seq file pattern reading
Replies: 2
Views: 1094

The regular expression is evaluated when the stage opens. The new file will be ignored - not discarded (it will still be there), just ignored - until next time you run the job.
by ray.wurlod
Tue Mar 10, 2009 2:14 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error Catalog
Replies: 5
Views: 1396

First you need to be a forum moderator. Are you?

Otherwise just post a message on this thread indicating that it's closed, and open a new thread in the correct forum.
by ray.wurlod
Mon Mar 09, 2009 11:41 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Logically concatenate sequential files
Replies: 5
Views: 2193

Use IPC stages to separate the Link Collector from other active stages.
by ray.wurlod
Mon Mar 09, 2009 10:48 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Logically concatenate sequential files
Replies: 5
Views: 2193

There's no such thing as "the first row in a table".

As noted, there are solutions available in parallel jobs, and your site does have Enterprise Edition. Perhaps you could investigate.
by ray.wurlod
Mon Mar 09, 2009 10:46 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error Catalog
Replies: 5
Views: 1396

Not while the post is on the Server forum.
by ray.wurlod
Mon Mar 09, 2009 10:45 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: While loop in Datastage
Replies: 17
Views: 14888

Shreya wrote:This code was working fine from last 0ne year,
its giving me problem when we moved this job to new server.
What's different on the new server? ("Nothing" is not the correct answer.)
by ray.wurlod
Mon Mar 09, 2009 10:45 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: While loop in Datastage
Replies: 17
Views: 14888

Shoar. Try this site for examples.
by ray.wurlod
Mon Mar 09, 2009 10:40 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Can a local container be used as a reference input?
Replies: 16
Views: 7011

Thanks Ray and Craig. I hit the doc, saw "localuv", success. Question: can I specify where the hashed file gets written? We like to keep all our hashed files in one spot for file system cleanup, etc. I tried #$HashFileLocation#/#DSJobname#_#DSStageName# for the table name, but no joy: Sco...