Search found 53125 matches

by ray.wurlod
Tue Jan 27, 2009 3:21 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Read operation failure. >
Replies: 23
Views: 6772

What happened to Sunoj? Now need to think about this, meanwhile what does your official support provider have to say?
by ray.wurlod
Tue Jan 27, 2009 3:19 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Lookup not matching
Replies: 15
Views: 4729

Yeah. I understood that and provided the solution.

Code: Select all

If RefLink.NOTFOUND Then InputLink.TheValue Else RefLink.TheValue
by ray.wurlod
Tue Jan 27, 2009 3:15 am
Forum: General
Topic: Best practice to convert decimal numbers to their hex value?
Replies: 3
Views: 977

That number is an integer (int32). Your original question was about decimal. Which is it? It then occurred to me that you may mean "base 10" when you use the term "decimal", as opposed to "hexadecimal". There is no built in function in parallel jobs, as far as I am awar...
by ray.wurlod
Tue Jan 27, 2009 3:14 am
Forum: IBM QualityStage
Topic: Standardize data output
Replies: 6
Views: 5036

Please get more information from them, including an eCase number. If they know it's a bug, then there's an eCase number, because the bug will have been reported.
by ray.wurlod
Tue Jan 27, 2009 3:13 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: Cross Table Analysis based on Key columns
Replies: 1
Views: 1680

Candidate keys have already identified. You choose the ones you want investigated for foreign key/primary key relationships from the list presented to you. The remainder of cross table analysis verifies (or not) whether the suggested keys are valid to identify such a relationship.
by ray.wurlod
Mon Jan 26, 2009 1:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: custom operator
Replies: 8
Views: 1634

Welcome aboard. The answer is no, unless the custom operator is one that you wrote in-house.
by ray.wurlod
Mon Jan 26, 2009 1:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: convert strings
Replies: 6
Views: 1298

In your specific example you need two of them.
by ray.wurlod
Mon Jan 26, 2009 1:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: sort key problem
Replies: 4
Views: 1615

In the Sort stage mark the sort mode for Col1 "don't sort, already sorted" and sort normally by Col2, Col3 and Col4.
by ray.wurlod
Mon Jan 26, 2009 1:30 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Lookup not matching
Replies: 15
Views: 4729

Do the lookup. If it is not found, make no change. If it is found, make the change.
by ray.wurlod
Mon Jan 26, 2009 1:27 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Importing Sequential Data Structure
Replies: 10
Views: 2339

If you still have the COBOL FD you can import that directly. There is no other way to import table definitions from table definitions. (You could consider converting the metadata that you have into an Orchestrate record schema and import that but that would be time consuming, at least the first time.)
by ray.wurlod
Mon Jan 26, 2009 4:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: clean up memory for datasets which is deleted manually
Replies: 12
Views: 10581

... apart from restoring the *.ds file from backup, of course.
by ray.wurlod
Sun Jan 25, 2009 1:35 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Read operation failure. >
Replies: 23
Views: 6772

Code: Select all

SELECT &SAVEDLISTS& WITH @ID LIKE "&&..."
DELETE &SAVEDLISTS&
The second command will prompt you to delete with active Select List. Answer "Yes" to this question.
by ray.wurlod
Sun Jan 25, 2009 6:24 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Read operation failure. >
Replies: 23
Views: 6772

It's frustrating how slowly we're progressing, I know, but we have to eliminate the impossible (Sherlock Holmes). The only other local "file" that gets read when an account is accessed is &SAVEDLISTS&. Even so, please check the permissions on VOCLIB, D_VOC, D_VOCLIB, D_&SAVEDLI...
by ray.wurlod
Sat Jan 24, 2009 1:58 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Read operation failure. >
Replies: 23
Views: 6772

OK, it's something only in the EDWPROD project that's triggering the read operation failure. Can you please try these variants of commands from the LOGIN paragraph, again posting the result?

Code: Select all

IF @TTY NE 'phantom' THEN DISPLAY Interactive
NOTIFY ON
by ray.wurlod
Sat Jan 24, 2009 1:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Information Analyser Vs Quality Stage
Replies: 1
Views: 3486

A good idea would be to search for the marketing material concerning each product from the IBM website (or get your vendor to provide you with the same). In the meantime, I shall outline my understanding. Profiling data is inspecting those data, column by column and table by table, to determine what...