DSXchange

Thanks chulett.

The file 'dssendmail_template.txt' is missing in my project.

Hi, I am getting the below error when i use Notification Activity. Untitled1..JobControl (DSSendMail): Cannot read template file 'dssendmail_template.txt' Untitled1..JobControl (@Notification_Activity_0): Routine DSSendMail did not finish OK, return code = '-17' i simply tested the job only with one...

Thanks a lot guys...

The solution given by DSguru2B and ZDC works...

How to change the extended properties of the field? I am new to DataStage PX. I tried the following, but got some error. StringToDate(Convert('-','',Date_Column),"%yyyy%mm%dd") Error: Failure during execution of operator logic Conversion error calling conversion routine date_from_string da...

I want the output to be in Date with length 8.

Please provide a solution....

Will this give the output as date dataype with length 8?

Hi,

My source is a Date datatype in YYYY-MM-DD format.
How can i convert it to Date(8) in YYYYMMDD format?

That line is not my last line.

but i tried running that job after removing that line. then it gave the same error in someother column.

I am running with some 100 records now.

i have to check whether it is running fine.

Hi,

Can you give a unix command to delete a particular row from a file.

I will delete this row and try running. so that i can confirm whether problem lies only in this record or i am missing something else.

Hi, I am having 2 jobs. In one job i am extracting data from a sequential file, after doing some transformations i am loading that into a named pipe. In the next job i am reading the data from the named pipe and loading it into a table after some transformations. I am running both the jobs in parall...

constraints are not that much complex. We will be passing the first month value and will compare this with the date value in the source file and will find the month difference. Based on this month difference we are splitting this 24 months data into 2 files of 12 months data. we have nearly 100 mill...

We already have a job for this with transformer constraints. Since the data volume is high it is taking more time. So we are trying for some methods to improve the performance. Is there anyother way to achive this other than transformer constraints?(which will reduce the time taken). thanks in advan...

My source file contains 24 months data. I have to extract first 12 months data from that file using filter command in sequential file. Which command i have to use to achive this requirement.

The result is coming in 561 chars in which i need the last 13 chars so i am giving the following

Ans=EReplace(OsOutput[552,13],@FM,"")

Hi, i am calling a routine in a routineactivity in a sequence. When i checked the routine seperatly it is returning a correct value. but in sequence it is giving an error as Routine DSU.GetSrtdtCount did not finish OK , return code = '2004-09-01/24' The expected result is 2004-09-01 and it is coming...