Calling Stored Procedures in DB2 400 with WTX
Posted: Wed Oct 29, 2008 6:35 pm
This message goes to anyone who has had experience running stored procedures on iSeries AS400 systems running DB2.
I have tested the original SQL statement in WinSQL and it works as expected Example:
cAll CC5PTF.BCIF050P('BI5FILMM','BMIJOBD')
Now when I'm building this call to the proc in WTX it doesnt appear to execute at all.
In this instance I'm only triggering a single card map which runs in SINK and makes a DB2 call for the stored proc. Rule below. The Map accepts the value and runs to completion but it does not execute the store proc.
Am i missing Something?
Also the log doesnt even show the DB adapter doing anything.
EXMPLE RULE:=DBLOOKUP("call ?='CC5PTF.BCIF050P'('" + "BI5FILMM"+ "', '"
+ "BMIJOBD" + "',?)",
"-MDQ C:\Mercator65_testing\WTX8.1\Bizcaps\eair_bizcaps_price_verification.mdq -DBNAME BASIS")
I have tested the original SQL statement in WinSQL and it works as expected Example:
cAll CC5PTF.BCIF050P('BI5FILMM','BMIJOBD')
Now when I'm building this call to the proc in WTX it doesnt appear to execute at all.
In this instance I'm only triggering a single card map which runs in SINK and makes a DB2 call for the stored proc. Rule below. The Map accepts the value and runs to completion but it does not execute the store proc.
Am i missing Something?
Also the log doesnt even show the DB adapter doing anything.
EXMPLE RULE:=DBLOOKUP("call ?='CC5PTF.BCIF050P'('" + "BI5FILMM"+ "', '"
+ "BMIJOBD" + "',?)",
"-MDQ C:\Mercator65_testing\WTX8.1\Bizcaps\eair_bizcaps_price_verification.mdq -DBNAME BASIS")