Filter
Top Products
12.24
SafeNet/400 Reference Guide
Copyright 2008 MP Associates of Westchester, Inc.
V8.50 - May 2008
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