Search found 3 matches
- Tue Nov 20, 2007 11:58 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Isnull problem
- Replies: 4
- Views: 3688
I have experienced a similar error. In my case I think the problem is due to the combination of a failed outer join from the Join Stage and the IsNull function being performed on a timestamp data type. Is the data type you are checking a timestamp or date? When I changed the IsNull function to look ...
- Tue Jun 05, 2007 8:16 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Escape Character in ExecSH Routine Activity Sequence Job
- Replies: 2
- Views: 2090
Escape Character in ExecSH Routine Activity Sequence Job
I am trying to run the following unix command in a Routine Activity of a Seqence 'echo "EXEC DBMS_STATS.gather_table_stats(' : DEST_US : ',' : DEST_TBL : ')" | sqlplus ' : DEST_US : '/' : DEST_PW : '@' :DEST_DB DEST_TBL, DEST_US, DEST_PW and DEST_DB are job parameters. the single quotes ar...
- Thu Jul 13, 2006 3:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parallel job reports failure (code 138)
- Replies: 2
- Views: 2149
Parallel job reports failure (code 138)
I couldn't find any info on this fatal error, so when I resolved it I thought it would be useful to post the solution. Hope it helps. The problem stemmed from trying to extract data from Oracle 10g using the Oracle Enterprise stage. The failure was caused by the view I was using in Oracle. One of th...