[sqr-users] PSoft Fin 7.5SP1, SQR 4.3.4.1,& DB2 OS/390 TEMP Database

["Judy Dreska" <A20JKD1@wpo.cso.niu.edu>]

We are running PeopleSoft Financials 7.5 SP1 with SQR version 4.3.4.1 on
DB2 OS/390 version 7.1.  We could not run any SQRs until we defined a
TEMP database.  We are not Declaring any temporary tables and we are not
using scrollable cursors, so we don't understand why we need the TEMP
database.  We are now getting this error on certain programs:  SQL
Status =  -497, SQL Error  = [IBM][CLI Driver][DB2] SQL0969N  There is
no message text corresponding to SQL error "-497" in the message file on
this workstation.  The error was returned from module "DSNXISCR" with
original tokens "TEMP ".  SQLSTATE=54041 

For some reason, it seems that an object is being created in the TEMP
database each time the select statement is called.  SQL State 54041
states that "Only 32767 OBIDs are allowed".  In other words, it sounds
like we're reaching the physical limit for OBIDs.

Does anyone know why we had to create a TEMP database?  Also is there a
way for us to change our setup so no TEMP database is needed?  Any help
will be appreciated.

We specifically put together a very simple SQR trying to determine what
is causing the problem.  The code is listed below.

Begin-Report
  #debugh show 'Begin-Report'
    do StdAPI-Init
    do Process-Main 
  do StdAPI-Term 
End-Report

Begin-Procedure Process-Main 
  #debugh show 'Process-Main'
  let #cnt = 1
  while #cnt <= 40000
     display '#cnt = ' noline
     display #cnt
     do Get-Dept
     let #cnt = #cnt + 1
  end-while
End-Procedure Process-Main

begin-procedure Get-Dept
  #debugh show 'Get-Dept'
  let $sql-statement = 'Get-Dept'
BEGIN-Select ON-ERROR=SQL-ERROR
descr
from PS_DEPARTMENT_TBL
WHERE DEPTID = 'OP58049'
AND SETID = 'NIUDK'
END-Select
End-Procedure Get-Dept

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