DSXchange

I want to compare two txt files through datastage server edition on windows, Can I know how can I do that? I tried to use following code - cmd = "FC E:\DataStageQa\ndw\work\stagingx\25\DEPLETF E:\DataStageQa\ndw\work\stagingx\25\DEPLETF" CALL DSExecute("NT", cmd, ScreenOutput, Sy...

I am writing FTP log to a file every day(same file), I need to read this file every day and send an e-mail when there are error message. I am planning to read from the end-of file until the begining of that day's log so that I will be reading only that day's log, planning to send an e-mail when I en...

I have a wrapper job, which hung while doing FTP. I tried to stop the job but I couldn't then I changed the job status. Now if I re-run the wrapper job it fails while doing FTP. Hera are the log details - Log - VIP_Wrapper.60.JobControl (Info): **** ITEM PROCESSING IS COMPLETE **** VIP_Wrapper.60.Jo...

Yes and nothing is there in ScreenOutput Variable - cmd = "ftp -i -d -s:U:\DataStageProd\ndw\jobcontrol\batchscripts\VIP_Ftp.parm >> U:\DataStageProd\ndw\work\staging\VIP_Log\VIPLOG" *---------------------------------------------------------- CALL DSExecute("NT", cmd, ScreenOutpu...

I am FTPing files by invoking batch script through Data Stage, I am able to capture all the commands that i have placed in the batch script but not able to get the remote server response like "226 Transfer complete" . Any idea how to capture it through data stage. cmd = "ftp -i -d -s:...

Can any one tell me how to round column values through data stage?

e.g 2.333 = 2.34 (Round to two decimals)

Thanks

Can any one suggest me how to split row in to columns through data stage?

E.g
Row:
Column1 Column2 Column3
100 200 300

Into Columns:

Column1 Column2
100 200

Column1 Column3
100 300


Thanks

I tried to override the project level purge option in two ways - 1.Under "Immediate purge" I tried to set "Before date:" option which I was not able to set beyound today date. 2.Under "Enabled for this job" I tried to set number of days but I couldn't. for some reason t...

One of our multi instance job log gets truncated every day. The project level purge option is set to 2 days, I tried to change the purge option through Director-Clear log. For some reason the changes that I made under immediate purge/Auto purge does not stay. For e.g I set the before date option und...

Hmmm, I don't quite see why a lock occurs. However, multi-instance jobs means each job establishes its own connection to the database. The reason running multiple queries from the same connection ma ... Ken, Even I don't see a reason why this query gets deadlocked, this is a simple Select query, we...

We have a Multi instance Multi invocation ID Server job wich runs on SQL server 2005, most of the time following SQL gets dead locked. This is a select statement with a LOCK. I have included the SQL server trace. if I execute couple of following SQL select statement through SQL server Managment Stud...