Search found 53125 matches

by ray.wurlod
Tue Jan 22, 2008 1:26 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error while running Dsjobs
Replies: 12
Views: 4280

Is the file system on which your project directory exists full? Do you have write permission to your project directory? These are the two most common reasons for "unable to create RT_CONFIGnnn" messages.
by ray.wurlod
Mon Jan 21, 2008 8:16 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Remove dulpicate
Replies: 7
Views: 1481

Whether I recommend it or not is irrelevant. It's what you have to do.
by ray.wurlod
Mon Jan 21, 2008 8:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to change NLS settings at runtime
Replies: 9
Views: 5532

I assume that, by "NLS Setting", you mean "character map". Surely there can't be that many different character maps? After all, there's only one for Arabic. Can you not create "clone" jobs with different NLS settings for the few different character sets that you will be processing and, in a job sequ...
by ray.wurlod
Mon Jan 21, 2008 8:06 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Values are read during compilation or during runtime?
Replies: 3
Views: 742

Not during compilation. Why do you ask?
by ray.wurlod
Mon Jan 21, 2008 8:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: What is the difference b/w Parameters and the Properties
Replies: 6
Views: 1397

Not all properties are parameters, however. For example, the short description and before-job subroutine are properties, but can not be parameters. Job parameters are properties of their job, one of many different kinds of property. Therefore, as Ken said, there is no difference. The question is aki...
by ray.wurlod
Mon Jan 21, 2008 7:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: error while viewing the Oracle Enterprise stage
Replies: 8
Views: 2062

what else? For example what Read Method are you using? Do you have the correct column definitions for this table loaded?
by ray.wurlod
Mon Jan 21, 2008 7:52 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need to load the file name(source) to the table
Replies: 3
Views: 896

There is not.

I take it your intention is to use Field() and Count() functions?
by ray.wurlod
Mon Jan 21, 2008 7:46 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error in calling user defind PL/SQL
Replies: 36
Views: 5449

Even if Craig re-posts the answer it will still be a premium post. Premium memberships are one of the ways that the hosting and bandwidth costs incurred by DSXchange are met. Corporate discounts for multiple memberships are available (see DSXchange home page).
by ray.wurlod
Mon Jan 21, 2008 7:41 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Large numbers hanging BASIC routine
Replies: 8
Views: 2692

Put the following declaration at the top of your code: PRECISION 14 Let us know if that improves things. Otherwise, since you've marked the job type as parallel (even though it's posted in the server forum), you could write the routine in C++ and take advantage of double or even quad precision float...
by ray.wurlod
Mon Jan 21, 2008 7:31 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Changing every nth place in a string
Replies: 2
Views: 1112

Server job or parallel job?

You marked the job type as parallel yet you posted in the server job forum.
by ray.wurlod
Mon Jan 21, 2008 7:28 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Using an array as a job handler
Replies: 30
Views: 11129

A dimensioned array or a dynamic array? And what is "a lot" here?
by ray.wurlod
Mon Jan 21, 2008 7:26 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Comparing numbers with leading 0's
Replies: 3
Views: 1301

It always puzzles me that programmers constuct expressions of the form If test_expression Then @TRUE Else @FALSE It suffices to let the logical expression's result (which is always true/false anyway) stand for itself. In the example in this thread, for example, a sufficient constraint expression wou...
by ray.wurlod
Mon Jan 21, 2008 7:21 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Server to Parallel Transition lab classes.
Replies: 6
Views: 1184

Contact Dennis James (editor@dsxchange.com) who is in charge of this.
by ray.wurlod
Mon Jan 21, 2008 7:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need to load the file name(source) to the table
Replies: 3
Views: 896

Welcome aboard.

The Sequential File stage has a "File Name Column" property which captures the file name into the named column.

It also has a "Row Number Column" property, which is sometimes useful.
by ray.wurlod
Mon Jan 21, 2008 7:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: error while viewing the Oracle Enterprise stage
Replies: 8
Views: 2062

Did this occur during a job run or while using View Data?

Does it happen every time, intermittently, or was it just the once?