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: {CALL ROUTINE_NAME('','1234567')}
The name lookup subroutine's first parameter is an output field of a
person's name and the second parameter accepts the key value for a person. I
have also tried defining the subroutine using VSG although the VSG
documentation says this isn't necessary.
I've tried from the sql> prompt (nothing happens) and the colon prompt
(syntax error). If I try using Microsoft Access to call the stored
procedure, I get the following message - "ODBC call failed [Ardent][Unidata
ODBC Driver] Statement violates access rule:Connection is READ ONLY. (#0)"
Has anyone successfully called stored procedures using SQL and what syntax
should be used?
Thanks.
Vinson Lee
San Diego Community College District
[EMAIL PROTECTED]
619-388-1143
--
- Charles Barouch, Moderator
U2-Users
U2-Community
RBSolutions
SBSolutions
Visit http://listserver.u2ug.org,
enter your e-mail address,
and 'browse all' lists to maintain your access.
For non-U2UG e-mail: [EMAIL PROTECTED]
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
