Search found 50 matches
- Mon Mar 10, 2008 1:16 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Using a DB2 Enterprise and a Xfm in the same Job.
- Replies: 4
- Views: 2504
Hi guys, After months of searching someone here found the solution to this problem. If you are on a MPP system you need to set the following env variable to true. $APT_COPY_TRANSFORM_OPERATOR = TRUE To quote the manual: Transform Library If you are working on a non-NFS MPP system you need to set the...
- Mon Mar 10, 2008 1:14 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Using a DB2 Enterprise and a Xfm in the same Job.
- Replies: 4
- Views: 2504
- Thu Dec 13, 2007 10:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to unlock a job accessed by another user
- Replies: 8
- Views: 4533
- Thu Dec 13, 2007 9:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 sparse lookup column length problem
- Replies: 1
- Views: 2425
DB2 sparse lookup column length problem
Hi All, I just ran into a problem that seems to be a bug. I think I found the source but I'll share this so I might save you some research time or you might have a different view on the issue. While doing a sparse lookup in DB2 , I got the following error: Additional info after successful execution ...
- Thu Apr 26, 2007 12:29 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: reject at 0 record
- Replies: 11
- Views: 5155
- Fri Mar 03, 2006 2:04 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parameter Value not being Passed correctly
- Replies: 3
- Views: 1988
DataStage does not cache parameter values from last runs (unless you have a restartable sequencer in which case, it will notify you of any changes on a restart but the value will be changed anyway for this run) Is the value Y your default value for this parameter in the job? If so, maybe you did not...
- Fri Mar 03, 2006 8:45 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Null date in transformer
- Replies: 14
- Views: 8846
Hi Kumar, Are you checking any value or assiginging a value of 2 to out_diff_mc.change_code in the stage variable svFermSpec? No, this is only the lazy way of writing: If out_diff_mc.change_code = 2 Then @true Else @false What is the value of e30_dat_fin_mens. Is your output field nullable? e30_dat_...
- Thu Mar 02, 2006 8:45 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Null date in transformer
- Replies: 14
- Views: 8846
- Thu Mar 02, 2006 8:29 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Null date in transformer
- Replies: 14
- Views: 8846
Sure, Here is the derivation for the Stage Variable svFermSpec: out_diff_mc.change_code = 2 And the derivation for the field itself (date 10 nullable): If IsNull(out_diff_mc.DAT_FERM_MACR) Then (If svFermSpec Then e30_dat_fin_mens Else SetNull()) Else out_diff_mc.DAT_FERM_MACR The error I get is: AP...
- Thu Mar 02, 2006 6:37 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Null date in transformer
- Replies: 14
- Views: 8846
- Thu Mar 02, 2006 6:11 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Null date in transformer
- Replies: 14
- Views: 8846
Ray, This test If IsNull(<Date Field>) Then SetNull() Else <Date Field> was only done to verify the functionality of the IsNull() function on my nullable date field. The real derivation That I would like to implement is: If IsNull(<Date Field>) Then If Condition X Then #DefaultDate# Else SetNull() E...
- Thu Mar 02, 2006 5:10 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Null date in transformer
- Replies: 14
- Views: 8846
- Thu Mar 02, 2006 2:10 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Insert and update the records to sqlserver
- Replies: 17
- Views: 8122
If your update and insert volumes are both very large, try to split your updates and your inserts in two separate datasets (change capture will tell you which is which or any timestamp you put in the source data). This way, you can update and insert separately (reduces DataBase operations). HTH, Mat
- Thu Mar 02, 2006 1:18 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Insert and update the records to sqlserver
- Replies: 17
- Views: 8122
- Thu Mar 02, 2006 12:26 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Null date in transformer
- Replies: 14
- Views: 8846
Null date in transformer
Hi all, I have an issue with a date field that may contain null values. The logic to apply is: if condition X and the date field is null then put a defined date (job parameter) Else if Not condition X and the date field is null then put null Else put the date field This logic always result in the tr...