Database Server - SQL Access
Description: Database Server - SQL access - 100
Database Server – SQL access – 200 (for V4R1 and above)
This server function is used when certain SQL requests are received for the data base server.
The QIBM_QZDA_SQL2 exit point takes precedence over the QIBM_QZDA_SQL1 exit point. If a program is registered for the SQL2 exit point, it will be a called, and a program for the SQL1 point will not be called.
Where used: | iSeries Access for Windows |
| ||
| - | Access to System i5 database through ODBC interface | ||
| - | File transfers |
| |
| Called by these functions: |
| ||
| ALTER TABLE | DROP PACKAGE | ||
| CALL |
| DROP TABLE | |
| COMMENT ON | DROP VIEW | ||
| COMMIT |
| GRANT | |
| CREATE COLLECTION | INSERT | ||
| CREATE DATABASE | LABEL ON | ||
| CREATE INDEX | LOCK TABLE | ||
| CREATE TABLE | REVOKE | ||
| CREATE VIEW | ROLLBACK | ||
| DELETE |
| SELECT | |
| DROP COLLECTION | SET TRANSACTION | ||
| DROP DATABASE | UPDATE | ||
| DROP INDEX |
| ||
Server Identifier: | *SQLSRV |
|
| |
Format Name: | ZDAQ0100 |
|
| |
| ZDAQ0200 |
|
| |
Levels Supported: | Basic |
| (Levels 1,2) |
|
| Intermediate | (Level 3) |
| |
| Advanced | (Level 4) |
| |
Limitations: | Does not check binary field or DBPKG/DBDLIB fields. | |||
Recommended |
|
|
|
|
Setting: | Level 4, Log All |
|
| |
| SafeNet/400 Reference Guide | |
12.24 | ♥ Copyright 2008 MP Associates of Westchester, Inc. | |
V8.50 - May 2008 | ||
|
