DBA Tip of the Month

From: <campbell_white_at_my-deja.com>
Date: 1999/10/06
Message-ID: <7tfe0o$krh$1@nnrp1.deja.com>#1/1

RevealNet Tip of the Month

FIPS SQL Flagger

The Federal Information Processing Standard for SQL (FIPS 127-2) requires a way to identify SQL statements that use vendor-supplied extensions. Oracle provides a FIPS flagger through interactive SQL to help you write portable applications. Server Manager requires that you use the ALTER SESSION command to enable and disable flagging.

Interactive SQL tools (such as SQL*Plus) check current SQL statements; the precompilers check embedded SQL constructs. Once flagging has been set in a session, subsequent executions of the ALTER SESSION SET FLAGGER command cause the ORA-00097 error to be returned because ALTER SESSION is not part of the ANSI standard. However, the ALTER SESSION SET FLAGGER command executes regardless of the returned error. This allows flagging to be turned on and off without disconnecting.

NEWS FROM REVEALNET

Knowledge Bases Integrated with Quest Software's SQL Navigator
PCWEEK LABS Gives PL/Generator Excellent Marks
DB2 Author Craig Mullins Signs with RevealNet

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Oct 06 1999 - 00:00:00 CDT