Re: DBA Tip of the Month

Would it be true to say that "ANSI SQL" and portability is a bit of a joke anyway, given that different database vendors use different means of achieving the same thing:

For example, Oracle uses the "pipe (|)" symbol for concatenation, but other vendors use other symbols - I think Sybase uses +.

Thus, achieving portability isn't that simple anyway.

Regards
Coakleyj

In article <7tfe0o$krh$1_at_nnrp1.deja.com>,   campbell_white_at_my-deja.com wrote:
> 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.
>

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