DSXchange

This question demands an elaborate explanation which might not be possible here. In other words How do I design my ETL? A lot of factors to look at. The complexity of the rules, the data size, the activity load on the database server etc etc. Usually, a simple extract is done and all the transformat...

Go to the $DSHOME directory. Type dssh or uv. LOGTO your project. Then continue as you would from Administrator.

Try with two seperate stages. Maybe db2 stage is treating two seperate links of insert and update as 'insert or update single link'. Try with two and see what happens.

'DM_FCV_PROMEDIO..DB2_D_FCV_CONVERSION: This update action 'update or insert' is not compatible with parameter array binding. Array Size property will be set to 1.' Are you sure. Double check the update action for both your links. Your error message indicates that one of them is set to 'Update Or I...

You cannot have array size greater than 1 for either "Update then Insert" or "Insert then Update". The array size is set to 1 and you are warned about it.
Set the array size to 1 and the warning will go away.

.Type30 and not .Type.30

Sorry, its windows and not unix. Right click inside the folder and check the box "Hidden Files". You should see it then.

In the directory, do ls -ltr -a
Its hidden thats why you cannot see it with a simple ls.

Check Rob's last reply in this post.

How are you sending back four outputs? As far as I know, you can only return a single value. Are you concatenating the the four values together with a delimiter and then passing the entire output as a string?

Did'nt Nick already answer your post?
What have you tried so far?

How do you expect to send the input parameters to the routine in an after job subroutine? As a parameter maybe?
Never the less, you can create a wrapper before/after job subroutine that calls the UtilityHashLookup() and gets the information you need.

Look into Before job subroutine 'ExecDOS'. You can also call command line utilities using DSExecute(). At job sequence level, you can use 'Execute Command Stage'.

RowProcCompareWithPreviousValue() is only present in server jobs and not px jobs. So your only option is to use stage variables.

Try this: