Does UniAccess ODBC allow the customer to execute (CREATE) PROCEDURE, (CREATE) FUNCTION,GET PARAMETERS commands via UNIACCESS ODBC?
There are two parts to our response. The first part addresses the UniAccess ODBC driver, and the second part addresses the UARS transaction. First, no the UniAccess ODBC driver does not parse the “[CREATE] Procedure” command. There are currently no plans to add the ability to parse this command to the UniAccess ODBC driver. (The “[CREATE] PROCEDURE” command is not part of the ODBC SQL grammar, nor SQL-92.) If a parsing error is detected using the SQLExecDirect interface, the original statement will be passed to RDMS for processing. The modifications to the SQL statements discussed in the UniAccess for OS 2200 Client Guide will not be applied to SQL statement. Handling SQLExecDirect parsing errors in this manner allows RDMS syntax to be passed by UADriver to RDMS. If a parsing error is detected using the SQLPrepare interface, the client application is notified by the return code of SQL_ERROR. After failing the SQLPrepare, this statement is not eligible for execution through the SQLExecu
Related Questions
- The function module works fine with my parameters when I execute it in transaction SE37. Why do I get errors when sending the same data via RfcAdapter?
- How can I create custom activities for accessing a SQL database, selecting a procedure and adding SQL parameters to activities?
- Does UniAccess ODBC allow the customer to execute (CREATE) PROCEDURE, (CREATE) FUNCTION,GET PARAMETERS commands via UNIACCESS ODBC?
