Search found 15603 matches

by ArndW
Wed Feb 13, 2008 7:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Buffer out error
Replies: 6
Views: 1071

But the character that is causing the warning is not part of Shift-JIS (which is what JPN-SJIS stands for).
by ArndW
Wed Feb 13, 2008 7:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Data Retrieval from DataSet Stage
Replies: 7
Views: 1425

Making the name end in ".ds" doesn't create a dataset. Did you write this file with a sequential file stage or a Dataset stage?
by ArndW
Wed Feb 13, 2008 7:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Buffer out error
Replies: 6
Views: 1071

The character you are writing to the file is not contained in the Shift-JIS character set. Isn't this a warning message?
by ArndW
Wed Feb 13, 2008 7:06 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Rollback Option in DataStage
Replies: 10
Views: 7179

What do you mean by "not loaded properly"? The highest level of rollback is done by using the database commit functionality - i.e. if the commit size is 0 then if the job fails then no records are written. In your case this doesn't sound like what you are looking into doing. DataStage has so such in...
by ArndW
Wed Feb 13, 2008 7:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Buffer out error
Replies: 6
Views: 1071

This is not a buffer problem, but relates to NLS. If you posted your complete error message you might get additional assistance.
by ArndW
Wed Feb 13, 2008 6:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Data Retrieval from DataSet Stage
Replies: 7
Views: 1425

Data sets and Sequential files are different types. What you are trying is like attempting to read an Oracle table with a sequential file stage. You can only read Datasets with the Dataset stage.
by ArndW
Wed Feb 13, 2008 6:02 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Can we call a parallel job in a Batch server Job.
Replies: 13
Views: 3115

Vice-versa? You mean calling server jobs from job control in a Parallel job? The answer remains "yes"
by ArndW
Wed Feb 13, 2008 6:01 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Warning in transformer
Replies: 27
Views: 8375

One to one mapping with no conversions and no stage variables or constraints will not generate the message you are getting. Try making a copy of the job and remove output columns until the error goes away to narrow down the cause.
by ArndW
Wed Feb 13, 2008 4:42 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Warning in transformer
Replies: 27
Views: 8375

Reset your job in the Director and there should be a new log entry titled "From Previous Run..."; look at that entry to see the actual problem.
by ArndW
Wed Feb 13, 2008 4:39 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable to Save Jobs
Replies: 8
Views: 3131

The limit cannot be changed, unfortunately. I once wrote a little job while at a client site (they participate here, so may be willing to post the code but I no longer 'own' it so cannot post it even if I did have it available here) which went through the project directory and converted all RT_STATU...
by ArndW
Wed Feb 13, 2008 4:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Deleted Category
Replies: 6
Views: 1241

The deleted code is permanently gone, there is no undelete. Unless you have a DSExport or UNIX level backup you will need to re-write the jobs. You can go to the admin tool and issue the command "LIST DS_AUDIT WITH KEY LIKE ...{YourJobName}..." to get a list for a job which will tell you which useri...
by ArndW
Wed Feb 13, 2008 2:41 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable to Save Jobs
Replies: 8
Views: 3131

The same 32K inode entry for directories exists on AIX as well.
by ArndW
Tue Feb 12, 2008 12:46 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: date conversion
Replies: 17
Views: 3976

Iconv and Oconv have nothing to do with nullability. If your column contains nulls, add something like

Code: Select all

IF IsNull(DSLink44.BEGIN_DATE) THEN '01/01/2000' ELSE Oconv(Iconv(DSLink44.BEGIN_DATE , "D MDY"), "D4/MDY") 
by ArndW
Tue Feb 12, 2008 11:57 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error when compiling in Universe
Replies: 2
Views: 602

What file are you using for your BASIC? A sub-directory type 19 file or a hashed file? Can you try "CREATE.FILE MYBP 19", "ED MYBP TEST" and put in "PRINT 'Hello World'", file & "BASIC MYBP TEST"?
by ArndW
Tue Feb 12, 2008 11:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle_Enterprise_1,1: Unable to create FIFO with name
Replies: 7
Views: 3231

What happens when you try the command "mkfifo -m 00666 /scratch/ordb228195941463796c_.026"?