Search found 32 matches
- Fri Aug 17, 2012 1:18 am
- Forum: General
- Topic: Execute command activity and Exception Handler
- Replies: 2
- Views: 2603
Execute command activity and Exception Handler
In a sequence job, I have "Automatically handle activities that fail" enabled and a generic exception handler that calls a routine to log a message and generate an email. One of the steps is an Execute Command activity. This shell command returns 0 on success, 1 if it didn't find the file ...
- Thu Mar 15, 2012 7:45 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: reading thro seq file stage
- Replies: 7
- Views: 2813
- Thu Mar 15, 2012 5:39 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Extracting XML input with multiple repetative key elements
- Replies: 5
- Views: 3040
- Thu Mar 15, 2012 5:33 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: When deleting data set -previous delete attempt not complete
- Replies: 1
- Views: 1927
When deleting data set -previous delete attempt not complete
Yes, there are other threads on this, I have read most / all of them and didn't really come up with a conclusive answer. I am experiencing a different pattern to those other threads. Job A creates about 10 data sets that job B uses for further processing. A sequence has a loop to run A and B multipl...
- Mon Nov 28, 2011 8:08 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Frustrated by inconsistent approach in parallel stages
- Replies: 0
- Views: 3251
Frustrated by inconsistent approach in parallel stages
... or maybe just my lack of understanding. My frustration centres around the warning IIS-DSEE-TFIP-00063 "When checking operator: Dropping component "..." because of a prior component with same name." I first ran into grief with this on a DIFF stage. The diff stage requires colu...
- Wed Oct 26, 2011 8:10 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Avoid sending null elements in XML message
- Replies: 11
- Views: 17073
- Wed Oct 26, 2011 7:46 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How are empty fields better handled
- Replies: 2
- Views: 1851
Re: How are empty fields better handled
If the source is a database, then I'd make the input match the database specification which probably means varchar and nullable. The way I see it, you have 2 choices, but they relate to how you output the data. You sequential file stage has built in capability to handle nulls. You can use this. Alte...
- Wed Oct 26, 2011 7:38 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Avoid sending null elements in XML message
- Replies: 11
- Views: 17073
- Wed Oct 26, 2011 5:29 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Avoid sending null elements in XML message
- Replies: 11
- Views: 17073
- Tue Oct 25, 2011 8:18 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Avoid sending null elements in XML message
- Replies: 11
- Views: 17073
...it's the default behavior. If the field is null (using xmlOutput or 8.5 xml), the element simply does not appear.... you can optionally force it to blanks if you want, and can have blanks treat ... I would like this to be the case, but it is not my experience so far with the 8.5 XML stage. I hav...
- Fri Oct 07, 2011 9:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Warning in Director
- Replies: 6
- Views: 3317
Re: Warning in Director
Your input record is shorter than the definition of the record in your metadata.madhavamaganti wrote:Sequential_File_0,0: Input buffer overrun at field "Sale_Date", at offset: 0.
- Wed Oct 05, 2011 11:40 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Equalent to DATEADD in Datastage
- Replies: 3
- Views: 5110
Re: Equalent to DATEADD in Datastage
Have a look at TimestampOffsetByComponentsSURA wrote:DATEADD. This function will returns a new datetime value based on adding an interval to the specified date.
Is there is any function can we use in Datastage to achive the same task?
- Mon Sep 26, 2011 9:52 pm
- Forum: General
- Topic: Wait For File Activity generating incorrect code?
- Replies: 4
- Views: 6475
To check for file existence, set the timeout to zero. Yes, I was doing that, but a time out still causes a warning to be logged. No file is a perfectly acceptable result for me so I'd prefer not to have the warning. I'm now using a Unix if command and it is working fine. Still had to resort to a fu...
- Mon Sep 26, 2011 9:13 pm
- Forum: General
- Topic: Wait For File Activity generating incorrect code?
- Replies: 4
- Views: 6475
- Mon Sep 26, 2011 8:21 pm
- Forum: General
- Topic: Wait For File Activity generating incorrect code?
- Replies: 4
- Views: 6475
Wait For File Activity generating incorrect code?
I've been having problems with a Wait For File activity going to the exception handler rather than the links indicated by triggers. After playing around with different options and examining the generated code, it is my belief that a Wait For File Activity generates incorrect job control code if * yo...