basic questions
On Mon, 18 Aug 2003 16:57:12 -0400, Jack A wrote:
DATABASE databasename; -- Semi-colon is end of statement.
or you can use the connect statement:
CONNECT TO 'databasename@servername';
Method 2:
select * from databasename:tablename;
Actually the full syntax is:
SELECT "owner".<table_or_alias>.<column>
FROM "owner".<database>@server:"owner".<table> ...;
Art S. Kagel
> How do i specify the database name in a sql script ? For example, are
> there equivalents of the following ...
>
> use databasename
> go ------- > Means end of batch select * from tablename go
>
>
> Method 2: Here I do not say which databse to use but put it in the Sql
> statement
>
> select * from databasename..tablename
How do i specify the database name in a sql script ? For example, are
there equivalents of the following ...
use databasename
go ------- > Means end of batch
select * from tablenamego
Method 2: Here I do not say which databse to use but put it in the Sql
statement
select * from databasename..tablename
dbaccess <database> <script.sql>
or
-------------------
database XXXX;
select * from table;-------------------
or
-------------------
select * from <database>@<server>.table
-------------------
"Jack A" <InformixMail@yahoo.com> wrote in message
news:ce0e3c22.0308181257.3a4004db@posting.google.com...
> How do i specify the database name in a sql script ? For example, are
> there equivalents of the following ...
>
> use databasename
> go ------- > Means end of batch
> select * from tablename> go
>
>
> Method 2: Here I do not say which databse to use but put it in the Sql
> statement
>
> select * from databasename..tablename