Search found 25 matches
- Thu Dec 22, 2011 4:34 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error for DB2 job
- Replies: 11
- Views: 4211
Thanks for all the replies. I did notice in the job that the config file property was pointing to our UT environment even though the parameter had been set to PR and the job recompiled. I opted to import the job again and reset the config file property. That seemed to do the trick. Must have been a ...
- Mon Dec 19, 2011 1:04 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error for DB2 job
- Replies: 11
- Views: 4211
- Mon Dec 19, 2011 10:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error for DB2 job
- Replies: 11
- Views: 4211
- Mon Dec 19, 2011 10:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error for DB2 job
- Replies: 11
- Views: 4211
- Mon Dec 19, 2011 8:54 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error for DB2 job
- Replies: 11
- Views: 4211
Error for DB2 job
Hello I'm running into an error in my production environment that I'm not getting in any other environment. The job runs a couple of SQL statements using the DB2 API stage. The first stage gets the latest records from a table and the 2nd stage deletes from another table where the keys match. The err...
- Fri May 07, 2010 7:42 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Join Stage omitting data
- Replies: 4
- Views: 1896
Thanks guys, but the look ups should not be turning nulls. There are legit values in the fields for the key. I ended up having to split my data set into smaller data sets - one for each field (so structure was Key Column, Value Column). Bizarre. I tried playing with the parallel and sequential setti...
- Thu May 06, 2010 11:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Join Stage omitting data
- Replies: 4
- Views: 1896
Join Stage omitting data
I have a job that works in our UA environment but since we've moved to Prod it's causing us issues. I am using a Join stage to bring together data from several datasets. For the last column, despite doing a successful look-up, it's putting NULL (which we've replaced with asterisks). Has anyone seen ...
- Tue Sep 13, 2005 7:05 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Invalid object name 'MetaStage_Loc_Info'
- Replies: 5
- Views: 5328
- Mon Sep 12, 2005 12:56 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Invalid object name 'MetaStage_Loc_Info'
- Replies: 5
- Views: 5328
- Mon Sep 12, 2005 12:33 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Invalid object name 'MetaStage_Loc_Info'
- Replies: 5
- Views: 5328
Invalid object name 'MetaStage_Loc_Info'
There are a couple of topics that mention this error, but no one seems to answer the question, "Why does DataStage generate the following SQL Statement?". SELECT DISTINCT "Computer", "SoftwareProduct", "DataStore" FROM MetaStage_Loc_Info Server: Msg 208, Level...
- Fri Sep 09, 2005 12:10 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Referencing Environment Variables in Routine
- Replies: 5
- Views: 2023
- Wed Sep 07, 2005 7:10 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Date conversion from mm/dd/yy to CCYY-MM-DD
- Replies: 8
- Views: 4636
- Wed Sep 07, 2005 1:41 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Date conversion from mm/dd/yy to CCYY-MM-DD
- Replies: 8
- Views: 4636
- Wed Sep 07, 2005 12:00 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Referencing Environment Variables in Routine
- Replies: 5
- Views: 2023
Referencing Environment Variables in Routine
I apologize if I'm duplicating past posts, but I was not able to find the answer to my question in my searching... Is it possible to reference an Environment variable in a Routine without passing it as a parameter? Our objective is to reduce the number of parameters being passed to jobs thereby incr...
- Thu Aug 25, 2005 12:38 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: writing quote (") to a file in a routine
- Replies: 6
- Views: 3312