Hi,
1) I am having problem trying to import Informix Stored Procedure
definition into DataStage:
DSR.MetaGeta(GET.PROC.COLUMNS)
(SQLPrepare("{CALL "findcdrpackage04" (NULL,NULL,NULL)}")): BCI Error: SQLSTATE=51,CODE=-201,[Ardent][SQL Client][ODBC] [INTERSOLV][ODBC 20101 driver][20101]A syntax error has occurred.
Environment is: DataStage 3.6.3r2 on Tru64 4.0F, IDS 7.31FCx
Ive tried on a different environment with similar error message:
DSR.MetaGeta(GET.PROC.COLUMNS)(SQLPrepare("{CALL "return_call_type"
(NULL,NULL)}")): BCI Error: SQLSTATE=37000,CODE=-11060,[Ardent][SQL Client][ODBC][Informix][Informix
ODBC Driver]General error.Syntax error
Environment was: DataStage 4.01 on NT, IDS 9.20.TC1
2) Has anyone successfully used Informix Stored Procedure as a look up
function in Transformer stage ? My test procedure would have a single input
parameter and return a single value. And I would like the input rows of the
transformer stage to be passed as the stored procedures input parameter.
Is it achievable in DataStage ?
William Lam email: wlam@informix.com
Senior Consultant tel: (852)2824-0981
I.Intelligence fax: (852)2824-1863
Informix Software HK Ltd
Using Stored Procedure in DataStage ?
Archive of postings to DataStageUsers@Oliver.com. This forum intended only as a reference and cannot be posted to.
Return to “Archive of DataStage Users@Oliver.com”
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