Contents Index Tables related by key constraint must both be permanent or both be temporary created with ON COMMIT PRESERVE ROWS The aggregate expression '%1' must appear in either the select list or a HAVING clause subquery

ASA Error Messages
  Database Error Messages
    Alphabetic list of error messages

Terminated by user -- transaction rolled back

Item Value
SQLCODE -302
Constant SQLE_TERMINATED_BY_USER
SQLSTATE 40W02
Sybase error code 3618
ODBC 2 State ERROR
ODBC 3 State ERROR
Probable cause 

You canceled a statement while the database was executing. A ROLLBACK WORK statement has been automatically executed.

Contents Index Tables related by key constraint must both be permanent or both be temporary created with ON COMMIT PRESERVE ROWS The aggregate expression '%1' must appear in either the select list or a HAVING clause subquery