DSXchange

Hi All I am trying to call the below mentioned function in transformer and when I start the job it aborts with reason "Improper data type".When I tested this code in routine it satisfies all the conditions and gives proper results.I understand its very lengthy code and take lot of time to ...

Hi , I am trying to implement mail notification from a batch.I want to send an email if any job in the batch fails which will include the reason for failure.I know to implement it via graphical sequencer but not sure how to include in a batch code. I am attaching the batch code below, please guide m...

Hi Sainath

I tried doing that but my comparison logic is not working properly.

I have to compare the output with another date of same format but for some reasons it is not giving correct results.Please advice.

Hi

I am trying to subtract year from a given date format but not able to succeed.The input format is 01/15/2005 and my output should be something like 01/15/2002.Please help me in acheiving this.

Thanks

I am sorry ,I did try it and there was small syntax error which I was not able to locate.I found out that now and it works fine,
Oconv((Iconv(Arg1,"D-YMD")-7),"D-YMD").

Thanks for your help.

Hi All I have a requirement where i need to subtract 7 days from the date.The source date has date format of yyyy-mm-dd. For a sample date of 2003-01-10,the output should be 2003-01-03 and for 2003-01-03 the output should be 2002-12-27 I tried using Oconv and Iconv but could not get to the solution....

Hi All , I have a situation where i need to check the incoming date from source with a table which has upper and lower limits specified for the source columns.Inturn the incoming column values should fall between the upper limit and lower limit.Problem is the user table which has the limits is a sta...

Thanks for all your responses.
I am going with Ray's advice as it is much simple to implement.

Thanks once again to everyone.

Hi we have a situation where we need to validate the identification number we are getting from the source.The number is 17 characters in length and may contain alphanumeric characters.Now the number can have alphabets A-Z and 0-9 excluding I,O,Q.It should not contain any special characters like *,/....

Hi I have a job in which I am using aggregator stage.Hash file is the input for aggregator and I group by two columns and take min of the third column.I have 2.5 million records in hash file and the job gets aborted at 1.51M every time i run.It aborts at the same row num and the log does not have an...

Hi all, I have a Exec TCL command in the before job routine in job properties which clears the hash file.But for some reasons I am getting the DSU.ExecTCL is not cataloged error and job is getting aborted. This job was working fine in other environments but for some strange reson started giving prob...

I have designed a sequencer with two jobs and they have routine activity stages before and after the job.For restartability purpose I have checked the two check boxes in sequencer properties.The two jobs have execution action as RUN.I use a utility written in DSBasic to read and pass params to the j...

As far as my knowledge goes DS does'nt support out parameters.

Regards

Shiv

"DateCurrentDateTime" can be used in the transformer to insert timestamp for each row processed.

Shiv

Hi I have to run a SQL script from the command line through EXECUTE COMMAND activity of the sequencer.Now I can give the command as db2 -tf and the parameter as the file name.Now my question is where should I place the script file?Should it be placed in any specific folder?I am working on AIX. Regar...