Re: Table Names Query
Toby Denbow (tdenbow@mathworks.com) wrote:
> In article <35nhpl$kqa@telerama.lm.com> , barry@telerama.lm.com writes:
> > $CREATE TABLE alpha ( .... ) LOCK MODE ROW;
> You must specify table ownership when using CREATE TABLE.
> Example CREATE TABLE "Informix".alpha (...) LOCK MODE ROW;
> Should give you what you want. By not specifying ownership, it defaults to
> the current user.
It turns out that tables in ANSI database must include owner name. If
explicit owner isn't specified when table is created or referenced,
current user ID is used. So creating alpha was equivalent to creating
barry.alpha. The problem was that dbaccess just showed me alpha, not
barry.alpha. I finally did
$CREATE TABLE OWNER.alpha ...;
$CREATE SYNONYM alpha for OWNER.alpha;
where OWNER is ESQL/C pre-processor variable.
Barry