Search found 15603 matches

by ArndW
Fri Dec 14, 2007 11:11 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Duplicate job after importing
Replies: 8
Views: 1867

What kind of messages does your REINDEX show? It is likely that the indices or files are corrupted beyond easy repair.
by ArndW
Fri Dec 14, 2007 7:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: APT_CombinedOperatorController(4),0: Operator terminated abn
Replies: 5
Views: 3861

That is very strange behaviour - does the error come back when you put in that condition on the lookup?
by ArndW
Fri Dec 14, 2007 4:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: APT_CombinedOperatorController(4),0: Operator terminated abn
Replies: 5
Views: 3861

Does this error happen on every run, or is it sporadic? You should set "APT_DISABLE_COMBINATION" to "true" and see which stage is generating the error.
by ArndW
Thu Dec 13, 2007 10:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Implicit conversion,modify stage
Replies: 8
Views: 1914

Is your ROW_ID declared as a bigint?
by ArndW
Thu Dec 13, 2007 8:08 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job running status
Replies: 1
Views: 890

The dsjob command has numerous options that you can use to get this information. One would be "dsjob -jobinfo <YourProject> <YourJob>"
by ArndW
Thu Dec 13, 2007 7:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Dataset Problem
Replies: 7
Views: 2085

I would guess that the NULL condition hasn't been handled the way you think it has. Can you write a simple job to read your dataset and find out which row has a NULL value for the field X and then check your source data for that row to see what the values actually are?
by ArndW
Thu Dec 13, 2007 4:44 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error Occuring while using DB2 UDB Bulk Load .
Replies: 6
Views: 3234

But in that field it only wants a directory to create the working files; try that without the file name, please.
by ArndW
Thu Dec 13, 2007 3:59 am
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

The whole purpose of using a gZipped file in this case is to save disk space (actually, there is not enough disk space for this file when expanded); so using an interim file is not possible.
by ArndW
Thu Dec 13, 2007 3:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Dataset Problem
Replies: 7
Views: 2085

In your director in the toolbar under "Tools" there will be an entry for Dataset Management which will let you examine the schema of your dataset.
by ArndW
Thu Dec 13, 2007 3:44 am
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

Well, it seems that there were a couple of solutions to the question I asked, but it turns out that it didn't resolve my issue. I have a fixed length file with CRLF separators, but the final one is missing. I would like to read this using multiple readers but DS complains that the file length is not...
by ArndW
Thu Dec 13, 2007 3:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Calling routine inside a rotuine
Replies: 7
Views: 3032

You are not calling a function so the DEFFUN is not the correct call to use (you would have saved a lot of time and effort if you had stated that).

Your code should read

Code: Select all

IN_RTN_1 = 'DSU.IN_RTN_1' 
Call @IN_RTN_1('a')
by ArndW
Thu Dec 13, 2007 3:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: unable to comiple job with transformer stage
Replies: 3
Views: 2574

This is probably happening because the c++ compiler is not installed or is the incorrect one. Also, is suSe-Linux a supported platform?
by ArndW
Thu Dec 13, 2007 3:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reading complex flat file in sequential mode
Replies: 5
Views: 1661

Since you have found the tab in the stage where you can see (and change) in which mode that stage operates I am not sure what you are asking.
by ArndW
Thu Dec 13, 2007 3:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error Occuring while using DB2 UDB Bulk Load .
Replies: 6
Views: 3234

Re: Error Occuring while using DB2 UDB Bulk Load .

dsouza.adithfrancis wrote:...Directory for data and command files : #I have mentioned Directory path with the source file Name#...


What exactly did you enter here; since the error message refers to this value this is where we should be looking.
by ArndW
Thu Dec 13, 2007 3:00 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequencer Compilation error
Replies: 3
Views: 1108

Re: Sequencer Compilation error

dj wrote:...and tried to rename copy seq to A....

Does that mean you got an error when trying to rename this? If so, what was that error?