Search found 53125 matches

by ray.wurlod
Wed Dec 12, 2007 7:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Calling routine inside a rotuine
Replies: 7
Views: 3032

That's because DEFFUN applies only to server routines. How you refer to the other function from within a C function depends on how that other function was created, bound and/or linked. Can you provide that information?
by ray.wurlod
Wed Dec 12, 2007 7:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: TeraUtils:Fetch failed: Error Code = 227 [terautils.C:2863]
Replies: 4
Views: 3753

What's different between production and QA environments? ("Nothing" is demonstrably not the correct answer.)
by ray.wurlod
Wed Dec 12, 2007 7:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Query About join stage in PX
Replies: 8
Views: 2622

A join condition failing would result in zero rows. This is not a failure of the job (or whatever else might generate the SQL).
by ray.wurlod
Wed Dec 12, 2007 7:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Dataset's data file on database node
Replies: 4
Views: 1425

Do you constrain the Data Set stage to execute in the db2 node pool?
by ray.wurlod
Wed Dec 12, 2007 7:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Appending CRLF to data being read from a sequential file
Replies: 6
Views: 1317

Or, somewhat more simply:

Code: Select all

gunzip filename ; cat - ; echo \r\n

You may even not need the second command here!
by ray.wurlod
Wed Dec 12, 2007 7:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to use the switch stage
Replies: 2
Views: 1588

For each source column value that you specify you also need to specify to which output link that row will go. Output links are numbered beginning from zero.
by ray.wurlod
Wed Dec 12, 2007 7:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: main_program: Internal Error: (nP==nC)
Replies: 2
Views: 1236

If it's urgent, tell your support provider who might ask you to sign up for premium service. We don't do "urgent" here; it's an all-volunteer site on which people post as and when they can.
by ray.wurlod
Wed Dec 12, 2007 7:20 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: OCI has fetched truncated data
Replies: 10
Views: 3554

It means that the default date format is the one you would get by executing the following query.

Code: Select all

SELECT CURRENT_DATE CONV 'D' FMT '20L' FROM VOC FIRST 1;
by ray.wurlod
Wed Dec 12, 2007 7:16 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: CREATE.FILE usage for 64 bit hashed files
Replies: 30
Views: 7576

To do the CREATE TABLE method, you would use a UV stage and edit the DDL that it creates.

To delete a hashed file (not a table) created in a directory you have to remove not only the data portion but also the dictionary portion.

Code: Select all

rm -rf hashedfilename ; rm -f D_hashedfilename
by ray.wurlod
Wed Dec 12, 2007 7:13 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Handling different metadata in runtime for the same table in
Replies: 8
Views: 2007

In particular, how do you learn the format of the source stream, from which you hope to be able to create the target table? And what database is this? There may be a bulk loader solution possible. At the same time that you create the table you create the bulk loader control file based on the same me...
by ray.wurlod
Wed Dec 12, 2007 1:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Selective reading Metadata versus using a copy stage/Modify
Replies: 3
Views: 1587

"you", not "u".
"are", not "r".
"because", not "becoze"
"definition", not "defination"
by ray.wurlod
Wed Dec 12, 2007 1:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to Re-INDEXED the Project
Replies: 2
Views: 1277

Have you searched the forum?
by ray.wurlod
Wed Dec 12, 2007 1:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error Meaning
Replies: 3
Views: 1534

Search for "already bound". This question has been answered before.
by ray.wurlod
Wed Dec 12, 2007 1:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Routine
Replies: 3
Views: 1133

Have you tried it?