Re: Query: ANSI Connect Syntax

In article <5135_at_cvbnetPrime.COM> aperez_at_cvbnetPrime.COM (Arturo Perez x6739) writes:
>
>Could someone out there please tell me what the actual
>ANSI syntax is for connecting to different databases?
>
>The problem I have is I'm using embedded SQL on
>an IBM mainframe using SQL/DS and on other
>platforms I'm using Oracle.
>
>Oracle says
> EXEC SQL CONNECT :userid IDENTIFIED BY :userpw AT :serverName;
>and SQL/DS says
> EXEC SQL CONNECT :userid IDENTIFIED BY :userpw TO :serverName;
>
>So, what does ANSI say?

CONNECT TO <sql-server name> [ AS <connection name> ] [ USER <user name> ]

   or
CONNECT TO DEFAULT    The meaning of <sql-server name>, <connection name>, and    <user name> are essentially implementation defined.

-- 
Jeff Mischkinsky		internet: jeff_at_unify.com
Unify Corporation		          ...!{pyramid,csusac}!unify!jeff
3901 Lennane Drive		voice: (916) 928-6262 fax: (916) 928-6401
Sacramento, CA 95834		ICBMS: 38 38 40 N / 120 28 10 W