[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SQL0913 - Row or object CCMPBDIH in COMPANYDAT10 type *FILE in use

Posted on 2009-05-13
1
Medium Priority
?
1,297 Views
Last Modified: 2013-12-06
I am getting this error when I am trying to add a record to a table thru Microsoft Query to iSeries.
Insert into COMPANYDAT10.CCMPBDIH (CHCMPN, CHCMPS, CHCO, CHSLWH, CHBTCN, CHRSCD, CHACDT, CHPON, CHSON) Values ('AD-0036-2008','A','572','81919','819839','MM','20090513','3432','234532')

Open in new window

0
Comment
Question by:muralibmk
1 Comment
 
LVL 36

Accepted Solution

by:
Gary Patterson earned 1500 total points
ID: 24381842
A good place to start is always the extended message description.  On the AS/400, use the DSPMSGD command (SQL messages are stored in message file QSQLMSG).

                         Display Formatted Message Text                        
                                                                 
 Message ID . . . . . . . . . :   SQL0913                                      
 Message file . . . . . . . . :   QSQLMSG                                      
   Library  . . . . . . . . . :     QSYS                                      
                                                                               
 Message . . . . :   Row or object &1 in &2 type *&3 in use.
                   
 Cause . . . . . :   The requested object &1 in &2 type *&3 is either in use by
   another application process or a row in the object is in use by either      
   another application process or another cursor in this application process.  

 Recovery  . . . :   Look at the previously listed messages in the job log    
   (DSPJOBLOG command) or from interactive SQL press F10 (Display messages in  
   job log) on this display to determine if this is an object or record lock  
   wait time out.                                                              
     Do one of the following:                                                  
     -- If the object is locked by another application process, try the        
   Structured Query Language (SQL) statement again when the object is not in  
   use. Use the Work with Object Locks (WRKOBJLCK) command to determine who is
   currently using the object.                                                
     -- If the object is a schema and an attempt was made to create a table,  
   view, or index into this schema under commitment control, a                
   save-while-active operation may be in progress on the same schema by another
   job in the system. Try the request again when the save-while-active        
   processing is complete.                                                    
     -- If a record is locked by another application process, try the SQL      
   statement again when the record is not in use.  The Display Record Locks    
   (DSPRCDLCK) command will determine who is currently using the record.      
     -- If this is a record lock held by another cursor in the same application
   process, you must issue a COMMIT, ROLLBACK, or another FETCH statement on  
   the cursor that is holding the lock before issuing this SQL statement.      
     If this error occurs frequently, use the Change Physical File (CHGPF),    
   Change Logical File (CHGLF), or Override Data Base File (OVRDBF) command to
   change the object or record wait time out.

- Gary Patterson
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windows 7 does not have the best desktop search built in. This is something Windows 7 users have struggled with. You type something in, and your search results don’t always match what you are looking for, or it doesn’t actually work at all. There ar…
The article covers five tools all IT professionals should know about, as they up productivity by a great deal!
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question