Am I right that this will also eliminate the problem that "select count(*) from <Table>" queries on a table that contains a LONG column currently fail?
Regards,
Robert
Zabach, Elke wrote:
Oops, this is a bug, the check for LONG-columns is too restrictive. Will be fixed with the next version (PTS 1123716). Thank you for reporting.
There is no chance to do it within one statement. DECLARE c CURSOR FOR SELECT id FROM test WHERE id IS NOT NULL + select distinct id from c should do (written in pure SQL, with some clients the naming of the first resultset looks different, of course)
Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
