[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

[sqr-users] SQR error - possibly related to the Count () function??

I am running a SQR through SQRW and I get the error below.  It looks
possibly like a problem 
with the count() function???  When I run the SQL through TELNET in DB2 the
SQL works okay.  
Is there any limitations/buffers when using the Count() function??  Any help
would be 
appreciated and Thanks in advance!!

                                               SQR CODE
                                              ==========

216     begin-procedure Count-Temp                         
217     #debug do debug-msg('Count-Temp') 
218
219     begin-select
220
221     count(*) &temp.count
222     from ps_sss_RES_temp temp
223
224     end-select
225
226     End-Procedure !Count-Temp
227 

=========================================================================
                                                         SQR.log
                                           =======

SQRW: Structured Query Report Writer V3.0.12.4
Copyright (C) MITI, 1994, 1995.  All Worldwide Rights Reserved.

(SQR 5528) ODBC SQL dbftch error -911 in cursor 3:
   [IBM][CLI Driver][DB2/6000] SQL0911N  The current transaction has been
rolled back because 
of a deadlock or timeout.  Reason code "68".  SQLSTATE=40001



Error on line 219:
   (SQR 3725) Bad return fetching row from database.

SQRW: Program Aborting.

============================================================================
=====

                       SQL run in DB2
                       ==============


/home/dbaprd $ db2 "select count(*) \
> from ps_sss_RES_temp"

1
-----------
       3346

  1 record(s) selected.

/home/dbaprd $



 
Thanks Ken

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users