Search found 100 matches
- Wed Jul 20, 2005 1:32 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Job Aborts with improper data type
- Replies: 2
- Views: 1293
Job Aborts with improper data type
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 ...
- Tue Jun 28, 2005 9:56 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Mail Notification
- Replies: 3
- Views: 1365
Mail Notification
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...
- Mon Jun 27, 2005 10:31 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Subtract Year
- Replies: 10
- Views: 2800
- Mon Jun 27, 2005 10:11 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Subtract Year
- Replies: 10
- Views: 2800
Subtract Year
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 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
- Sun Jun 26, 2005 12:42 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Subtract Week From Date
- Replies: 3
- Views: 1946
- Sat Jun 25, 2005 10:29 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Subtract Week From Date
- Replies: 3
- Views: 1946
Subtract Week From Date
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....
- Mon Jun 20, 2005 10:14 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Need Help In Resolving Lookup
- Replies: 10
- Views: 4968
Need Help In Resolving Lookup
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...
- Sat Jun 18, 2005 4:40 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Data Validation
- Replies: 5
- Views: 1544
- Thu Jun 16, 2005 5:59 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Data Validation
- Replies: 5
- Views: 1544
Data Validation
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 *,/....
- Thu Jan 20, 2005 12:27 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Error in Aggregator Stage
- Replies: 4
- Views: 2468
Error in Aggregator Stage
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...
- Tue Jan 18, 2005 1:05 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DS Error
- Replies: 2
- Views: 1645
DS Error
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...
- Wed Sep 22, 2004 5:10 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Sequencer Restartability
- Replies: 2
- Views: 1288
Sequencer Restartability
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...
- Tue Sep 30, 2003 4:45 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Datastage and Stored Procedure
- Replies: 8
- Views: 1478
- Fri Sep 05, 2003 12:37 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Current timestamp
- Replies: 10
- Views: 3283
- Tue Aug 26, 2003 2:01 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Execute script from DS
- Replies: 2
- Views: 958
Execute script from DS
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...