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")
Calling Stored Procedures in DB2 400 with WTX
Formally known as "Mercator Inside Integrator 6.7", DataStage TX enables high-volume, complex transactions without the need for additional coding.
-
- Participant
- Posts: 5
- Joined: Mon Oct 27, 2008 5:57 pm
Return to “IBM<sup>®</sup> DataStage TX”
Jump to
- Moderators' Choice
- ↳ Editor's BLOG Corner
- ↳ Ask the Experts! - Dads and Grads
- ↳ DSXchange Testimonials
- ↳ Cognos (IBM BI)
- FAQs
- ↳ FAQs
- ↳ FAQ Discussion
- DataStage
- ↳ General
- ↳ IBM<sup>®</sup> Infosphere DataStage Server Edition
- ↳ IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- ↳ Archive of DataStage Users@Oliver.com
- IBM<sup>®</sup>Infosphere Products<sup></sup>
- ↳ Business Glossary
- Suggestions
- ↳ Site/Forum
- ↳ Enhancement Wish List
- Consulting
- ↳ Talent
- ↳ Looking for Talent
- Support
- ↳ Parameter Manager
- ↳ Compile All Plus
- Usergroup Forums
- ↳ Usergroup Central Forum
- ↳ Heartland Usergroup Forum
- The Written Word
- ↳ Articles, White Papers and Tips and Tricks
- ↳ Product Documentation
- Third Party Applications
- ↳ Third Party Applications
- Product Derivatives
- ↳ Functions
- ↳ Routines
- ↳ Jobs
- ↳ Logs
- Tools
- ↳ Tools Forum
- Category
- ↳ Infosphere Master Data Management
- ↳ Data Quality Best Practices
- ↳ IBM QualityStage
- ↳ Information Analyzer (formerly ProfileStage)
- ↳ IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
- ↳ IBM<sup>®</sup> DataStage TX
- ↳ BI
- ↳ Data Integration