Search found 53125 matches

by ray.wurlod
Thu Jun 26, 2008 1:13 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Loopup Using Lookup file set
Replies: 4
Views: 1623

If it's a Lookup File Set servicing the reference input, then the lookup key column on the stream link must have the same name as the key column defined for the Lookup File Set. You can cheaply achieve a column name change using a Copy stage on the stream input.
by ray.wurlod
Thu Jun 26, 2008 1:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Character-Mismatch while migrating from Non-NLS no NLS
Replies: 1
Views: 2098

Perhaps all you need is to change the Character Set property in the export file header.
by ray.wurlod
Thu Jun 26, 2008 1:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Conductor node, Section leader and player help
Replies: 6
Views: 2336

I believe all you need to do is to drag them into place. There is one conductor process, one section leader per processing node, and one player process per operator on each processing node. The number of operators is determined from the score, which is composed at run time using generated osh and th...
by ray.wurlod
Thu Jun 26, 2008 1:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: unexpected fatal while calling Store proc
Replies: 6
Views: 1584

Somewhere - maybe in DataStage, maybe in the database server, maybe in the middleware - a segmentation violation has occurred. There are many possible causes; a search of DSXchange will help you to find the more common ones.
by ray.wurlod
Thu Jun 26, 2008 1:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datstage Environment variable value
Replies: 14
Views: 4775

I am unable to reproduce this symptom. Can you describe precisely how you got them out of sync in the first place?
by ray.wurlod
Thu Jun 26, 2008 12:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Timestamp value in Stage Variable
Replies: 1
Views: 842

Welcome aboard.

You often get a quicker answer using Search - as it happens this very question is the topic of a current thread. Please track it down. If you then have further questions, you can add them right here.
by ray.wurlod
Thu Jun 26, 2008 12:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Null handling
Replies: 2
Views: 1054

1. Specify how null is (or is to be) represented in the sequential file. If the format is fixed width, the null field value must have the same number of characters as the field's width. 2. Data that do not match the record schema can be captured on a reject link, or the row simply dropped, or the jo...
by ray.wurlod
Thu Jun 26, 2008 12:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datstage Environment variable value
Replies: 14
Views: 4775

Yes, a non-administrator can use the Administrator client to view, and in limited cases change, global project properties (including environment variable values, provided write permission to DSParams exists).

Other tasks, such as Permissions, will be disabled to non-administrators.
by ray.wurlod
Wed Jun 25, 2008 9:14 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: For Loop in sequence
Replies: 3
Views: 1299

Do you have a link from your EndLoop activity back to your StartLoop activity? This will be painted with a dot-and-dash line.
by ray.wurlod
Wed Jun 25, 2008 9:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Collecting Column Name which rejects record.
Replies: 5
Views: 1102

You have to design that in. The output link can receive columns whose values are column names (as constant strings) from the input link.
by ray.wurlod
Wed Jun 25, 2008 4:18 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: segmentation fault
Replies: 6
Views: 1523

There's no workaround. You need to have NLS_LANG set if you're going to communicate Unicode data to/from the database server. End of story.
by ray.wurlod
Wed Jun 25, 2008 4:16 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Compilation Warning
Replies: 4
Views: 1027

Information Server Web Console > Session Management

disconnect errant process
by ray.wurlod
Wed Jun 25, 2008 4:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Not extracting data when the job is running
Replies: 5
Views: 2090

You probably need more memory in your machine.
by ray.wurlod
Wed Jun 25, 2008 4:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Obtaining Last Non-Null Value Per Column
Replies: 6
Views: 1836

In parallel jobs the Remove Duplicates stage has a First or Last option, and does not "break parallelism".
by ray.wurlod
Wed Jun 25, 2008 4:08 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ORCHESTRATE step execution terminating due to SIGINT
Replies: 4
Views: 2080

Premium membership costs less than US$0.30 (less than 1 ringgit) per day, and would allow you to read the entirety of premium posts. Corporate discounts for multiple memberships are available - see link on DSXchange home page.