Hi All,
When i am running bewlo 2 queries in sql assistant i am getting
error 3932:Only an ET or null statement is legal after a DDL Statement.
REPLACE VIEW A
AS
LOCKING ROW FOR ACCESS
SELECT x,y,z
FROM B where cast(y as date format 'yyyy-mm-dd') = (select cast(max(Y) as date format 'yyyy-mm-dd')
from C) ;
REPLACE VIEW D
AS
LOCKING ROW FOR ACCESS
SELECT
a,b,c
FROM E
where cast(b as date format 'yyyy-mm-dd') = (select cast(max(B) as date format 'yyyy-mm-dd')
from F);
But when i am running it without where clause of first statement it is running fine:
REPLACE VIEW A
AS
LOCKING ROW FOR ACCESS
SELECT x,y,z
FROM B /*where cast(y as date format 'yyyy-mm-dd') = (select cast(max(Y) as date format 'yyyy-mm-dd')
from C) */;
REPLACE VIEW D
AS
LOCKING ROW FOR ACCESS
SELECT
a,b,c
FROM E
where cast(b as date format 'yyyy-mm-dd') = (select cast(max(B) as date format 'yyyy-mm-dd')
from F);
Please help me out as what may be the problem....
As in sql assistant it is an auto commit after each statement..a virtual BT; STATEMENT ; ET;
Urge Forum Gurus to throw some light on same.