Search found 6 matches
- Tue Jan 11, 2005 7:10 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to call DB2 stored procedure using ODBC stage
- Replies: 3
- Views: 2969
How to call DB2 stored procedure using ODBC stage
Hi acool, I have successfully called a DB2 stored procedure using a ODBC stage using 'user defined SQL query' option and writing: call procedurename(argument list); in the 'enter sql' tab Can anybody tell me how to call a db2 stored procedure using 'stored procedure' option in outputs page of a ODBC...
- Tue Jan 11, 2005 6:58 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Mapping a Decimal to a Char
- Replies: 4
- Views: 2107
- Tue Jan 11, 2005 6:56 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Scheduling/Running a job from a web portal
- Replies: 3
- Views: 1577
- Tue Jan 11, 2005 6:50 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: can not call a Stored Procedure using odbc stage
- Replies: 9
- Views: 4452
- Tue Jan 11, 2005 6:47 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: can not call a Stored Procedure using odbc stage
- Replies: 9
- Views: 4452
Hi acool, I have successfully called a DB2 stored procedure using a ODBC stage using 'user defined SQL query' option and writing: call procedurename(argument list); in the 'enter sql' tab but was unsuccessful using 'stored procedure' option due to: 1.) it required that i import that s proc defn befo...
- Tue Jan 11, 2005 5:41 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Description of DataStage Errors
- Replies: 7
- Views: 3173