Search found 53125 matches

by ray.wurlod
Mon Feb 08, 2016 11:39 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Compare previous rows and with another column
Replies: 4
Views: 1800

Majority rules? Whatever the rule is, you need to document it!

You may need to count the A values and the R values in each group to make your final decision.
by ray.wurlod
Mon Feb 08, 2016 8:58 pm
Forum: General
Topic: sequence job failure
Replies: 16
Views: 5427

FYI the checkpoint mechanism does work within loops.
by ray.wurlod
Mon Feb 08, 2016 4:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Compare previous rows and with another column
Replies: 4
Views: 1800

Probably easiest to use stage variables (a) to determine that you're in a new group, and (b) to determine whether status A has been seen. Use the LastRowInGroup() function to restrict output to those rows.
by ray.wurlod
Mon Feb 08, 2016 4:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Webservices Client - Error
Replies: 19
Views: 3689

The issue is NOT resolved. It is buried under the carpet.
by ray.wurlod
Mon Feb 08, 2016 4:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Is it possible to generate the schema file using ds job
Replies: 10
Views: 19303

I mean the table definition in the Repository, not in a job.
by ray.wurlod
Mon Feb 08, 2016 4:39 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Null handling for CHAR + nullable field
Replies: 8
Views: 3711

What is the value of the Null Field Value property?
by ray.wurlod
Mon Feb 08, 2016 4:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequential file NLS issue in parallel job
Replies: 0
Views: 1361

How are you specifying the separator character? Try specifying it using the Unicode hex value of its codepoint.
by ray.wurlod
Sun Feb 07, 2016 11:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Varchar to timestamp
Replies: 10
Views: 4506

Re: Varchar to timestamp

anudeepdasari001 wrote:...help me out
Groucho Marx wrote:I'd love to help you out. Which way did you come in?
:lol:
by ray.wurlod
Sun Feb 07, 2016 11:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Varchar to timestamp
Replies: 10
Views: 4506

Welcome aboard.
What do the two source numbers represent?
What (precisely) are you trying to achieve? (Hint: "16:11:4730" is not a timestamp.)

We could guess your requirement, but that would waste everyone's time were the guess incorrect.
by ray.wurlod
Sat Feb 06, 2016 3:33 pm
Forum: General
Topic: sequence job failure
Replies: 16
Views: 5427

Kim, how does the "touch file" approach work if the job activity failure is at, say, the fourth iteration of a loop?
by ray.wurlod
Thu Feb 04, 2016 9:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Webservices Client - Error
Replies: 19
Views: 3689

Port number is the port number on which the web service is listening.

If you haven't got this right, then you can't get any response. Which you are interpreting as a null response.
by ray.wurlod
Thu Feb 04, 2016 5:57 pm
Forum:
Topic: Workbench metadata export from Oracle
Replies: 8
Views: 5504

Can you import using DataStage Designer and the Connector Import Wizard, specifying your MDM Connector when doing so?
by ray.wurlod
Thu Feb 04, 2016 3:49 pm
Forum: General
Topic: DSODB queries
Replies: 8
Views: 7674

qt_ky wrote:I think newer versions store the data in XMETA instead of a separate DSODB.
It's always been possible to install DSODB as a separate schema within the XMETA database. Or you can install it in any other ODBC-accessible database.
by ray.wurlod
Thu Feb 04, 2016 3:47 pm
Forum:
Topic: Workbench metadata export from Oracle
Replies: 8
Views: 5504

Can you import the Oracle metadata using one of the other tools, such as DataStage or Information Analyzer?
by ray.wurlod
Wed Feb 03, 2016 7:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Webservices Client - Error
Replies: 19
Views: 3689

Can you invoke the same web service through some other client, such as SoapUI ?