?
Solved

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

Posted on 2009-05-13
1
Medium Priority
?
1,244 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 35

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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
In this article we will discuss all things related to StageFright bug, the most vulnerable bug of android devices.
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

765 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