RE: [U2] UD: Calling Stored Procedures

2006-01-05 Thread u2ug
REPOSTED FOR NON MEMBER Vinson Lee [EMAIL PROTECTED] We're currently running Unidata 6.0 and I have been trying unsuccessfully to call a Unidata subroutine (Stored procedure) via SQL. There isn't a whole lot of documentation on how to call a stored procedure. I'm using the following syntax:

Re: [U2] [UD] Calling Stored Procedures

2006-01-05 Thread Geoffrey Mitchell
I have successfully used a stored procedure on UniVerse (not UD). I have only called the procedure from a JDBC connection. When I try using the same statement at the console, I get 'Illegal verb CALL.' It works fine from JDBC, though. *shrug* You might try using a parameter marker (?)

[U2] [UD] Calling Stored Procedures

2006-01-04 Thread Vinson Lee
We're currently running Unidata 6.0 and I have been trying unsuccessfully to call a Unidata subroutine (Stored procedure) via SQL. There isn't a whole lot of documentation on how to call a stored procedure. I'm using the following syntax: {CALL ROUTINE_NAME('','1234567')} The name lookup