Search found 11 matches
- Thu Nov 15, 2007 4:15 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to compare two files in windows through datastage
- Replies: 3
- Views: 2920
How to compare two files in windows through datastage
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...
- Mon Oct 08, 2007 10:03 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to read the file from the end
- Replies: 2
- Views: 2651
How to read the file from the end
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...
- Thu Jun 14, 2007 8:56 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Not able to re-run Wrapper job
- Replies: 1
- Views: 1177
Not able to re-run Wrapper job
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...
- Wed Apr 25, 2007 12:25 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to capture remote server response during FTP
- Replies: 2
- Views: 1371
- Wed Apr 25, 2007 11:31 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to capture remote server response during FTP
- Replies: 2
- Views: 1371
How to capture remote server response during FTP
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:...
- Mon Apr 16, 2007 1:19 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to round column values in Data Stage?
- Replies: 4
- Views: 2073
How to round column values in Data Stage?
Can any one tell me how to round column values through data stage?
e.g 2.333 = 2.34 (Round to two decimals)
Thanks
e.g 2.333 = 2.34 (Round to two decimals)
Thanks
- Thu Apr 12, 2007 5:05 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to Split Row into columns through Data Stage?
- Replies: 6
- Views: 5717
How to Split Row into columns through Data Stage?
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
E.g
Row:
Column1 Column2 Column3
100 200 300
Into Columns:
Column1 Column2
100 200
Column1 Column3
100 300
Thanks
- Wed Mar 28, 2007 12:49 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Multi instance Job log gets truncated
- Replies: 3
- Views: 1613
- Tue Mar 27, 2007 2:53 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Multi instance Job log gets truncated
- Replies: 3
- Views: 1613
Multi instance Job log gets truncated
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...
- Fri Mar 16, 2007 9:29 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Multi instance Job gets Deadlocked on windows platform
- Replies: 4
- Views: 2984
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...
- Fri Mar 16, 2007 8:58 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Multi instance Job gets Deadlocked on windows platform
- Replies: 4
- Views: 2984
Multi instance Job gets Deadlocked on windows platform
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...