If I pipe the same file into dbaccess I do not have this problem.
Did you see this in the docs for DBD::Informix or Informix?
Thank you,
Korey
-----Original Message-----
From: Wilson, Doug [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 06, 2001 11:46 AM
To: 'Korey Klier'; [EMAIL PROTECTED]
Subject: RE: Problem creating opaque types
> From: Korey Klier [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 06, 2001 6:43 AM
> To: [EMAIL PROTECTED]
> Subject: Problem creating opaque types
>
>
> I am having a problem with the following SQL
> in a single statement:
>
> my $sql = qq|create opaque type mytype (
> internallength=variable, MAXLEN=512
> );
>
> GRANT usage on type mytype to user;
> |;
>
> my $dbh =
> DBI->connect("dbi:Informix:$database_name","database_user","da
> tabase_passwor
> d");
>
> ERROR: -9628 'SQL: -9628: Type (mytype) not found.
> If I split the sql into two statements
> I do not have a problem.
The docs on Informix say that when executing a multiple
statement sql statement, you should not depend on them
being executed sequentially, that they may be executed
in parallel. So you can't GRANT permission
on something that hasn't necessarily been created yet.
-Douglas Wilson
