If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Db2 Static Bind Errors

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 08-23-11, 18:24
connect2srinath connect2srinath is offline
Registered User
 
Join Date: Aug 2011
Posts: 1
Db2 Static Bind Errors

Hi,

I am receiving static bind errors in DB2 and i tried clearing all the packages before i ran static bind.

But, still i am receiving the below errors and need a help on this

SQL Code: -144, SQLSTATE: 58003
Message: INVALID SECTION NUMBER 1. SQLCODE=-144, SQLSTATE=58003, DRIVER=3.61.107
SQL statement: SELECT BUSN_TASK_DEST_CD FROM WORK_DIST_METHD WHERE WORK_DIST_METHD_ID=?
SQL locator: retrieveDistributionType(int)

SQL Code: -144, SQLSTATE: 58003
Message: INVALID SECTION NUMBER 11. SQLCODE=-144, SQLSTATE=58003, DRIVER=3.61.107
SQL statement: UPDATE BUSN_TASK SET BUSN_TASK_PRMRY_STTS_CD = ?, BUSN_TASK_SCDY_STTS_CD = ?, LAST_MOD_USER_PRFL_ID = ?, BUSN_TASK_ACTN_RESN_CD= ? WHERE BUSN_TASK_COMN_ID = ? AND BUSN_TASK_NUM = ? AND BUSN_TASK_SCDY_STTS_CD = ? AND RESPB_USER_PRFL_ID = ?
SQL locator: updateStatusesReasonCodeByIdandSecondaryStatus(sho rt, Short, int, char, long, short, short, int)

SQL Code: -144, SQLSTATE: 58003
Message: INVALID SECTION NUMBER 34. SQLCODE=-144, SQLSTATE=58003, DRIVER=3.61.107
SQL statement: UPDATE BUSN_TASK SET WORK_DIST_METHD_ID = ? , BUSN_TASK_ACTN_RESN_CD = ? , LAST_MOD_USER_PRFL_ID = ? , RESPB_USER_PRFL_ID = NULL, BUSN_TASK_SCDY_STTS_CD = 1,BUSN_TASK_PRMRY_STTS_CD = 1 WHERE BUSN_TASK_COMN_ID = ? AND BUSN_TASK_NUM = ?
SQL locator: reassignIntrayTasksToDistribution(java.util.List<s f.pc_apps.service.bsntsksvc.to.ReassignSingleTaskT O>)
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On