topic Re: Standard Program (SQ02) hangs @ delete statement in Application Development and Automation Discussions

Standard Program (SQ02) hangs @ delete statement

Former Member — Wed, 29 Jun 2005 08:49:35 GMT

Hi,

I have problem when i try to display a infoset @ SQ02, when i debug it, it hangs @ this statement.

delete from aqgdb where relid = 'AQ'

and srtfd like l_sukeylang.

Any idea what could be wrong? AQGDB is not a big table, and i try selecting from SE16 with the same select statement, it is fine.

Thanks,

Re: Standard Program (SQ02) hangs @ delete statement

Former Member — Wed, 29 Jun 2005 09:03:15 GMT

One explanation could be that srtfd is a 60Char field and a 'like' clause in the sql is going to take long (if it tries to match through the string for each record).

SE16 may be working because of its row-count limit (200/500 etc). You can probably remove this row-count to read all records (also specify a str value which is not normally to be found in aqgdb-srtfd, this will make it take longer).

cheers,

Re: Standard Program (SQ02) hangs @ delete statement

Former Member — Wed, 29 Jun 2005 09:20:09 GMT

But the this table in my system has only 63 records. It shouldn't take that long either, it juz seem to hang @ this statement.

Re: Standard Program (SQ02) hangs @ delete statement

Former Member — Wed, 29 Jun 2005 12:46:10 GMT

Hi,

Check with the delete satatement

DELETE FROM dbtab WHERE cond.

DELETE FROM (dbtabname) WHERE cond.

delete from aqgdb where relid = 'AQ'

and srtfd <b>like</b> l_sukeylang. Like is not recommended with in delete right?