Malformed query detection

We keep getting SQL statements running through the database server jobs that have cross joins (Cartesian products), i.e. tables with no join specification. These jobs consume enormous amounts of temporary storage building their result sets before we detect them and end the jobs. I know they're doing cross joins because I retrieve the SQL statements via iSeries Navigator and examine them.

Is there a way to configure one of the database server exit points, e.g. QIBM_QZDA_SQL1 or _SQL2, to do some kind of quick analysis of the SQL statement looking for cross joined tables, and reject the statement if found?
.

Relevant Pages

  • Re: Malformed query detection
    ... These jobs consume enormous amounts of temporary ... I know they're doing cross joins because I retrieve the SQL ... Is there a way to configure one of the database server exit points, ... Some client interfaces may provide a setting to enable it versus from an exit program [by CHGQRYA]. ...
    (comp.sys.ibm.as400.misc)
  • Re: SQL performance - multiple rows for SELECT (SQL0811)
    ... sysibm/sysdummy1 is a 1 record table that comes in handy. ... some high-volume batch jobs that have lots of embedded ... SQL statements in question to try to eliminate the ... letting the messages accumulate in the log. ...
    (comp.sys.ibm.as400.misc)
  • Re: DataTable - SQL delete command
    ... I would hope this functionality is implemented in a ... There's no reason to involve a database server for my ... you cannot issue SQL statements against a DataTable. ...
    (microsoft.public.dotnet.framework.aspnet)
  • DTS packages no longer running after upgrade
    ... Jobs that run SQL statements or execute Operating System ... process is started by user SQLADMIN - who also owns all ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL REPLACE STATEMENT - CONSOLIDATION
    ... > Can these lines of sql statements be consolidated into one sql statement ... You're going to kill your database server, ... Write a PHP function to cleanup text ...
    (comp.lang.php)