Search found 15603 matches

by ArndW
Mon Mar 17, 2008 2:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Date Warning from DB2 Extract,Load to Cobol file (complex)
Replies: 5
Views: 1030

I'm not sure if the "field 15" is conted starting at 1 or 0 - are both of those columns dates, and if so could you check the range? I still don't understand how or where the Julian Date figures into this.
by ArndW
Mon Mar 17, 2008 2:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Missing resource bundle and Too many files on child node
Replies: 8
Views: 5461

Have you used $APT_DUMP_SCORE to see how many PIDs you are firing off at the same time? If this number is in the thousands and the requirement remains that all the jobs need to run at the same time: (a) optimize the jobs to use less processes (b) use less nodes in your APT_CONFIG_FILE (c) What hardw...
by ArndW
Mon Mar 17, 2008 2:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: concatenate two fields (dont use a transformer)
Replies: 10
Views: 5294

Akumar - I just wrote two small test programs to see what the differences are. In a 1-node configuration my transform stage was 20% faster than a column import stage.
by ArndW
Mon Mar 17, 2008 1:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to remove double quotes with in the value
Replies: 11
Views: 1866

The error message comes from the file read stage, so before any replace functions could be used. Could you post the line of source data causing the error?
by ArndW
Mon Mar 17, 2008 1:56 am
Forum: General
Topic: Help regarding Datastage ORacle stage
Replies: 9
Views: 5161

That is quite odd - this only happens when you insert a null value? In that case, I would guess that you specified a "null length" in the column attributes.
by ArndW
Mon Mar 17, 2008 1:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Fatal: Parallel job reports failure (code 139)
Replies: 1
Views: 1256

A segmentation fault is an operating system error caused by a program accessing a memory address that isn't allocated. It would be more helpful if you could post the complete error message. Actually in this case, posting all the error messages would be helpful.
by ArndW
Sun Mar 16, 2008 10:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Date Warning from DB2 Extract,Load to Cobol file (complex)
Replies: 5
Views: 1030

What type is the column defined as in DB2? I wonder where you are doing the Julian date conversion.
by ArndW
Sun Mar 16, 2008 9:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Building User Defined Stages
Replies: 10
Views: 2559

It's been stated already that the only documents available are those you already have access to.

If you could be explicit and explain what you tried and how it failed then you will get answers - but I don't have any examples that I am free to give out.
by ArndW
Fri Mar 14, 2008 12:08 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Handling Multi Byte Character Dataset
Replies: 2
Views: 788

UTF-8 is a good basis but it does not handle "all" characters. No mapping does. It will most likely cover any characters you are going to use. If you could explain
...facing issues in oracle enterprise stage because of this...
in more detail someone could perhaps comment.
by ArndW
Fri Mar 14, 2008 11:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DS Export
Replies: 14
Views: 5533

That was a legitimate business writeoff, they were learning about DS :D

(Yes, your honour, I am guilty of thread drift and will do DSXchange community service in pennance)
by ArndW
Fri Mar 14, 2008 11:50 am
Forum: General
Topic: Cannot edit the Target or Source Stages
Replies: 3
Views: 1059

did you also manually clear out the "\\HKEY_LOCAL_MACHINE\SOFTWARE\Ascential Software" tree from your PC's registry with regedit?
by ArndW
Fri Mar 14, 2008 11:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Fixed width columns
Replies: 2
Views: 677

You shouldn't need the field width attribute if you have specified a bounded string with a maximum length. Have you tested this?
by ArndW
Fri Mar 14, 2008 11:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Design Help - Reverse Pivot vs Running Sequential Mode
Replies: 4
Views: 1066

A "deadlock" occurs when one process waits for a lock that another never releases. This won't happen when each write/update is a transaction. It might not be the most efficient of methods, but you won't be getting a record level deadlock.
by ArndW
Fri Mar 14, 2008 11:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DS Export
Replies: 14
Views: 5533

chulett wrote:{or boats, Arnd thinks about boats too}


How about both women and boats?
by ArndW
Fri Mar 14, 2008 10:45 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DS Export
Replies: 14
Views: 5533

{I have lots of thoughts, some of them are daydreams, many of them about women and food. Occasionally one might be about DS. I have always disliked that question} Have you been doing DS updates sometime on that box or is the current version the first one that was installed. What was the last compile...