Solved

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

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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
Viewers will learn the different options available in the Backstage view in Excel 2013.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…

773 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