DSXchange

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...

Sorry... double posting

Hi Zet,

Have a look at this post:
viewtopic.php?t=89810

Regards,

Mat

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 ...

Hi all, We encountered the same problem recently after upgrading from v7.5A to 7.5.2 on AIX. It seems that even if you have set the property "First Line is Column Names" to "True" you will receive a warning for the first line if you are using the file with a lookup stage and ther...

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...

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_...

No, I have only this one stage variable and no other derivation uses this field.

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...

Hi Rasi,

Condition X using other fields that are not nullable (specifically, a change_code from a change capture stage).

Regards,

Mat

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...

Thank you for your help.

NLS is not installed on our server

Regards,

Mat

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

Hi Samba,

I don't know how you extract your data, but if your goal is to load only new records, you could use a change capture stage with your new data as the after dataset and the target table as the before dataset and retain only the new records (inserts is change_code = 1).

Regards,

Mat

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...