'WITH NO LOG'
Hi
Can anybody explain why the following error message is generated by
the code below ?? If I remove the 'with no log' option then everything
works fine. Is it me or is there a problem with the with no log
clause.
Configuration : Mip RC6280 & Informix Online & 4gl 4.0
{
SQL statement error number -206.
The specified table (tmp_table_2) is not in the database.
SYSTEM error number -111.
ISAM error: no record found.
}
-Cut here--Cut here--Cut here--Cut here--Cut here--Cut here--Cut here-
DATABASE cjh
MAIN
SELECT table_1.date_fld,
table_1.amount_a,
table_1.amount_b
FROM table_1
WHERE table_1.date_fld > TODAY
INTO TEMP tmp_table_2 WITH NO LOG
INSERT INTO tmp_table_2 ( amount_a, amount_b )
VALUES ( 1099.99, 234.81 )
END MAIN
-Cut here--Cut here--Cut here--Cut here--Cut here--Cut here--Cut here-
Regards Ken
+-------------------------------------------------------------------+
| Ken Woghiren (DBA - Charles Taylor & Co Ltd) |
| |
| Email: kenw@cix.compulink.co.uk |
| Snail: World Trade Centre, London E1 9UN ,ENGLAND |
| Voice: + 44 71 522 7466 |
+-------------------------------------------------------------------+