Re: Can't drop table - "Prepare statement failed or was not executed"
Hi,
Here are my SQL scripts to create those few tables that I can't
drop/insert. Could it be something to do with my foreign key defination
in the REFERENCE clause in "sia_article" table?
CREATE TABLE sia_category (
categoryID SERIAL PRIMARY KEY,
category VARCHAR(20) NOT NULL,
order SMALLINT
);
CREATE TABLE sia_article (
articleID SERIAL PRIMARY KEY,
categoryID INT NOT NULL REFERENCES sia_category(categoryID),
title VARCHAR(100),
description VARCHAR(255),
header VARCHAR(255),
body LVARCHAR,
hidden BOOLEAN DEFAULT 0 NOT NULL,
date_created DATE DEFAULT TODAY NOT NULL,
date_modified DATE,
image1_path VARCHAR(100),
image1_alttext VARCHAR(100),
image1_caption VARCHAR(255),
image1_width SMALLINT,
image1_height SMALLINT,
image2_path VARCHAR(100),
image2_alttext VARCHAR(100),
image2_caption VARCHAR(255),
image2_width SMALLINT,
image2_height SMALLINT
);
Thanks, tata.
"Lee Haw, Ong" wrote:
> Hi guys,
>
> Solaris 2.6 on Sun Enterprise 450 box
> IUS 9.14 UC3
> Web Integration Option 1.2
>
> I have a funny problem where after I created a table, I can't insert
> anything or drop it. Using dbaccess to drop it, it gave "410: Prepare
> statement failed or was not executed". Using SQL Edit to drop it, it
> gave "404: The cursor or statement is not available".
>
> I tried recycle the IUS database engine, I even tried rebooting the
> whole box. Neither help. I'm lost... the last thing I wanna do is
> "oninit -i" to reinitialize the IUS instance. Appreciate any advice.
>
> Our Informix support only services us from 9 to 5...
>
> Thanks, tata.