Search found 6 matches

by madhavgp
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...
by madhavgp
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

What is HTH?
by madhavgp
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

hi pal,
can u explain with a diagram as 2 what is refreshing what ? i couldnt get ur explanation correctly...could u explain better.

thanks,
Madhav
by madhavgp
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

Hi,
Can anybody tell me how to call a db2 stored procedure using 'stored procedure' option in outputs page of a ODBC stage...

Thanks,
Madhav
by madhavgp
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...
by madhavgp
Tue Jan 11, 2005 5:41 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Description of DataStage Errors
Replies: 7
Views: 3173

Hello Ray,
Where does this sys.message table exist. Where do you enter this select statement.

Thanks and regards,
Madhav