Search found 53125 matches

by ray.wurlod
Tue Jun 14, 2011 3:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Use of Vertical Pivot Stage
Replies: 2
Views: 1578

Have you actually read the manual or help for this stage type?
by ray.wurlod
Tue Jun 14, 2011 3:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: want to pass unique and dup record seperately
Replies: 3
Views: 1528

Use a fork join design and a downstream filter on the count. The solution has been posted previously on DSXchange.
by ray.wurlod
Tue Jun 14, 2011 2:59 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Not able to read special charactes in the source CFF
Replies: 1
Views: 1304

I personally refuse to try to diagnose any message from APT_CombinedOperatorController.

Disable operator combination to learn which actual operator (stage) is throwing the error.
by ray.wurlod
Tue Jun 14, 2011 2:55 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Enabling RCP. Effect on previous and new jobs
Replies: 1
Views: 1095

1) Yes.
2) Yes (provided that the job already exists and has been compiled successfully).
by ray.wurlod
Tue Jun 14, 2011 2:53 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SQLConnect error: Status = -1 SQLState = IM976 Natcode
Replies: 8
Views: 8855

Try using DS.CONNECT rather than CONNECT. Also try using localuv in lower case. Make sure that you have executed the dsenv script before invoking dssh. Make sure that the DSN is recorded in uvodbc.config.
by ray.wurlod
Tue Jun 14, 2011 2:50 pm
Forum: General
Topic: Stages, field names and job parameters
Replies: 5
Views: 1984

Modify stage.
by ray.wurlod
Tue Jun 14, 2011 1:52 am
Forum: General
Topic: RT_Config File Query
Replies: 2
Views: 1741

Use Administrator client command window on the project.

Code: Select all

SELECT NAME FROM DS_JOBS WHERE JOBNO = '<<Job Number>>';
where Job Number is obtained from the RT_CONFIG file name.
by ray.wurlod
Tue Jun 14, 2011 1:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Null display in datastage
Replies: 6
Views: 3125

Since you're running version 8.1 or higher, you can compare the jobs between projects. In DEV right click on the job in the Repository toolbar and choose, from the context menu, Cross Project Compare... From the dialog that opens connect to the TEST project and identify the job that you want to comp...
by ray.wurlod
Mon Jun 13, 2011 3:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Query on Hash Partitioning
Replies: 7
Views: 2201

Consider how modulus works. Hash works exactly the same way, except that the dividend is created from the codepoint values of the characters in the key. Key-based partitioning algorithms guarantee that, for any given value of the key, all rows with that value will be placed in the same partition.
by ray.wurlod
Mon Jun 13, 2011 5:13 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Pivoting 1 or more groups in a singel stage
Replies: 1
Views: 2349

Is this a WebSphere Transformation Extender (WTX, formerly known as DataStage TX) question?

If not, please post your question in the correct forum.
by ray.wurlod
Mon Jun 13, 2011 5:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Multi language traslation in Datastage
Replies: 1
Views: 1271

Before we get into that, which calendar are you using for the Arabic data? The Hijri calendar has twelve months, but alternating 30 and 29 days, for a shorter year than the Gregorian calendar. Your choices for the month lookup (if that's how you're going to proceed) are using a general character map...
by ray.wurlod
Mon Jun 13, 2011 5:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: convert single row data into multiple rows
Replies: 6
Views: 4026

It is probably easier to use the Field() function in a Transformer stage to isolate the elements from the delimited list, or you could use a Column Import stage to parse them. That having been done, use a Pivot stage to convert the rows to columns. Or, if you're using a Transformer stage anyway, you...
by ray.wurlod
Sat Jun 11, 2011 11:34 pm
Forum: Site/Forum
Topic: about premium membership
Replies: 1
Views: 1781

Premium membership gives discounted prices and other special deals on video training and other materials from the commercial website associated with DSXchange.
by ray.wurlod
Sat Jun 11, 2011 4:29 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: NEED URGENT HELP!!!!
Replies: 3
Views: 1810

Urgent? On a weekend? I don't think so. At DSXchange we don't "do" urgent. DSXchange is an all-volunteer site whose members post if and when they can contribute something. If you need urgent help, sign up with your official support provider for priority service and learn just how much &quo...
by ray.wurlod
Sat Jun 11, 2011 4:27 pm
Forum: General
Topic: logsum,lognewest and logdetail
Replies: 3
Views: 1302

Review the documentation to learn how to filter these functions by log entry type and by date.