DSXchange

DataStage server is on AIX.

I am seeing a weird issue with mail functionality on 7.5.1. Mails are not getting sent when I use notification activity stage. I am able to send the mails successfully from the shell using mailx command and also using DSSendMailTester routine. Initially I noted that %server% tag was not there in the...

I have a requirement to send notification if the record counts in target table is different from the source table, after the load is completed. I am accomplishing this using a server routine. I am returning 0 if counts match and -1 if counts do not match. In the routine activity in sequence job, I a...

I am calling DSSendMail from routine to send mail. I see that the reply from DSSendMail is 0, but for some reason the mail is not getting sent. I have not tried sending the mail using Notification activity. Can anyone tell me the snippet to execute a mailx -s "Subject" "Recipient Addr...

Thanks for the reply. All I am doing in the subroutine is reading 2 files and comparing them. If I assign ErrorCode to any desired value within the routine and provide the same in the After-job routine section of the job properties, will it work? I tried with value as 1 and 0, but I still get the sa...

I have created a routine to compare data in 2 sequential files and take action on sync/non-sync scenarios. The arguments for the routine are the file path and I see ErrorCode is automatically added when I select the Type as 'Before/After subroutine'. In this case how should deal with the ErrorCode. ...

Thanks for the replies. Escaping the script in After-job subroutine did not help. I executed the script successfully from command line as below. #!/usr/bin/ksh diff file1 file2 if \[ $? == 0 \]; then echo "Counts in sync" else exit -1 fi But, when I run the script as After-job subroutine, ...

I am trying to a count check between records fetched from source table and records loaded to target table for an audit purpose. What I am trying to do is writing the record count from source and target to sequential files and run a diff command in the After-Job subroutine using ExecSH. But, I get an...

I had to make some changes in the code to make sure that derivation for stage variable does not result in a null value. I see a problem now. When I compare the data loaded in the table by the server job (via division logic in the server routine called in BASIC transformer stage) and the data loaded ...

I need to calculate the value for a nullable column by doing some division and the derivation uses stage variables. The target column in the oracle table is of Varchar(25) though. The input for calculation is read from a fixed width file. If stgVar1 = 1 Then DecimalToDecimal(inputcol[1,15] / 1000000...

Sorry for not being clear!. The locks were in Datastage. When the job failed there were few mutex errors too.

Thanks for the inputs. Our DataStage Admin could find a huge number of locks on the job which seemed to have caused the job to fail. When the locks were cleared, job ran fine. The issue did not happen thereafter. This left me recheck the job design again. All that he job does is read a file, do look...

Thanks for the inputs. The issue is now happening consistently with strangely different errors. Sometimes the job fails at either or both BASIC transformer stages with error Unable to run job - -2. In other cases it fails at either BASIC Transformsr stages with error Non-Integer value returned for f...

Thanks for the reply.

The column is non-nullable. I believe the problem happens when the value of the job parameter is assigned to the column using the column derivation. Are there any known issues in BASIC transformer stage in such cases?

I am using a BASIC transformer stage in a parallel job. There is a column which is defined as Integer and the value for this column is mapped from the job parameter. The column is not nullable and there will be always an integer value passed to it. I am seeing intermittent failures with this job and...