Solved

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

Posted on 2009-05-13
1
1,122 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 34

Accepted Solution

by:
Gary Patterson earned 500 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Microsoft Dynamics Roles question 4 82
Batch convert .doc to .docx 13 165
Office 365 and use on Terminal Server - Licenses 2 52
Windows doesn't download updates 26 91
Many people tend to confuse the function of a virus with the one of adware, this misunderstanding of the basic of what each software is and how it operates causes users and organizations to take the wrong security measures that would protect them ag…
I don't know if many of you have made the great mistake of using the Cisco Thin Client model with the management software VXC. If you have then you are probably more then familiar with the incredibly clunky interface, the numerous work arounds, and …
Viewers will learn the different options available in the Backstage view in Excel 2013.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

932 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now