Total members 11894 |It is currently Sat Nov 23, 2024 1:39 pm Login / Join Codemiles

Java

C/C++

PHP

C#

HTML

CSS

ASP

Javascript

JQuery

AJAX

XSD

Python

Matlab

R Scripts

Weka
Switch to mobile style




This is a DB2error :Fix of reason code “7″ SQLCODE=-668 SQLSTATE=57016 , happens when access to a table is restricted. You face while you are running SQL query like :
Code:

ALTER TABLE DROP COLUMN


To fix this issue you can run the following command to remove the restriction :

Code:

 REORG TABLE [TABLE_NAME]
 


For more information about REORG command please see the link below :
Code:

http://publib.boulder.ibm.com/infocenter/db2e/v9r1/index.jsp?topic=%2Fcom.ibm.db2e.doc%2Fsqlreorgt.html




_________________
M. S. Rakha, Ph.D.
Queen's University
Canada

Author: DrRakha
Mastermind
User avatar Posts: 2715
Have thanks: 74 time
Post new topic Reply to topic  Page 1 of 1
  [ 1 post ] 

  Related Posts  to : Fix of reason code “7″ SQLCODE=-668 SQLSTATE=57016
 The reason of using DOCTYPE     -  
 i want code for connecting mobile and pc can u send me code     -  
 Freeman chain code algorithm code     -  
 asking for code     -  
 code     -  
 XML Paging Code     -  
 Code of stack     -  
 US Zip Code Validation     -  
 polyalphabetic J# Code     -  
 I need help with a html code     -  



Switch to mobile style




Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
All copyrights reserved to codemiles.com 2007-2011
mileX v1.0 designed by codemiles team
Codemiles.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com