Search found 53125 matches

by ray.wurlod
Tue Jan 20, 2009 3:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: capture multiple occurances
Replies: 1
Views: 736

Did you Search DSXchange for your answer? Your question has been asked and answered before. Essentially it involves splitting your data stream into two, running one through an Aggregator stage to count (grouped by ID_B) then joining the two streams. Downstream of that, filter those rows having a cou...
by ray.wurlod
Tue Jan 20, 2009 3:41 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage 7.5.1.A server - automate environment variables
Replies: 3
Views: 1885

DSXchange is an all-volunteer forum, in which members post as and when they can. We resent "asap" and "urgent". If you need urgent assistance, sign up with your official support provider for premium services, and learn just how much "urgent" is worth. What, precisely, ...
by ray.wurlod
Tue Jan 20, 2009 3:40 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage 7.5.1.A server edition - automate job parameters
Replies: 1
Views: 1120

DSXchange is an all-volunteer forum, in which members post as and when they can. We resent "asap" and "urgent". If you need urgent assistance, sign up with your official support provider for premium services, and learn just how much "urgent" is worth. Again, Search DSX...
by ray.wurlod
Tue Jan 20, 2009 3:37 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage 7.5.1.A server edition - job locks
Replies: 1
Views: 972

Welcome aboard.

You can often get your answers faster using a Search of DSXchange. This question has been asked, and answered, before.

Use Cleanup Resources from the Director client.
by ray.wurlod
Tue Jan 20, 2009 3:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem with Teradata Connector
Replies: 3
Views: 2877

Check your shared library search list contains the library's directory.

Check that the executing user has execute permission to the library.
by ray.wurlod
Tue Jan 20, 2009 3:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Jobs do not appear in the DS Designer
Replies: 6
Views: 3246

The only cause I can imagine for the "XPTO " folder name (with space character) is between the keyboard and the chair.
by ray.wurlod
Tue Jan 20, 2009 3:29 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: JobAuditReport..BeforeJob (DSAttachJob): Job control error (
Replies: 8
Views: 4142

Are you providing an invocation ID in DSAttachJob?
by ray.wurlod
Tue Jan 20, 2009 3:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: capturing reject records with DRS stage
Replies: 1
Views: 754

Create an extra output link from the stage then, using the right mouse button, click on that link and select "Convert to Reject" from the menu.
by ray.wurlod
Tue Jan 20, 2009 3:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: dssh commands
Replies: 3
Views: 3038

There are literally hundreds of them. Most of them you never need.
Almost all are documented in the UniVerse manuals on the IBM website.
by ray.wurlod
Tue Jan 20, 2009 3:23 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: New Logic
Replies: 4
Views: 1083

Sorry. "I understand that..." can get you deep in the brown stuff as an ETL developer. Get confirmation of the precise requirement/specification from whoever did the analysis and created the source-to-target mappings, and get them to sign off on it. That way, when you deliver what you can ...
by ray.wurlod
Tue Jan 20, 2009 3:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SCD stage issue
Replies: 1
Views: 734

According to IBM sales people, DB2 is the only database you'll ever need.
:wink:

Try closing the job, re-opening it, and seeing if this behaviour persists.
by ray.wurlod
Tue Jan 20, 2009 3:19 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error compiling job - Input string too long, limit 8192
Replies: 6
Views: 3825

Please post the contents of the file RT_BP1145/JOB.1546223192.DT.1499637778.TRANS1 (encased in Code tags).
by ray.wurlod
Tue Jan 20, 2009 3:17 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Reading error in sequentail stage
Replies: 16
Views: 4394

Please strive for a professional standard of written English on DSXchange. Not everyone here has English as a first language, and SMS-style abbreviations make it more difficult for such people to comprehend.
Keep your SMS for your mobile telephone only.
by ray.wurlod
Tue Jan 20, 2009 3:15 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DS Routine to delete data
Replies: 6
Views: 2476

The clause "doesn't work" conveys no useful information. What do you mean? Please share the routine code (encased in Code tags), that we might assess why the problem you are getting is occurring.
by ray.wurlod
Tue Jan 20, 2009 3:13 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: sorted
Replies: 3
Views: 1351

This is still not the parallel forum.

Moderator: please move to parallel forum