We help IT Professionals succeed at work.

stored procedures

taylor020697
taylor020697 asked
on
Medium Priority
289 Views
Last Modified: 2013-12-26
How do I execute a stored procedure on a Unix platform with DB2600 from a visual basic 4.0 app using ODBCAPI's. Having a great deal of difficulty with this, and any help would be great.
thanks..bt
Comment
Watch Question

Commented:
When you want to call stored procedure in ODBC you
have to use SQL syntax:
"{ call procName param1 param2 ...}"
"{ .. }" - is important, this couse driver will not try to
look into the sql statement.

So written SQL statement you can use in SQLPrepare - SQLExecute
(for SELECT type procedure) or in SQLExecDirect (INSERT, UPDATE
DELETE or other with no resulset procedure).

I do not know DB2 but this work for other SQL DBs. If in DB2
is some other sysntax for stored procedures (but I don't think so) use this syntax with "{ .. }".

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.