Problem solve Get help with specific problems with your technologies, process and projects.

Why am I receiving the error SQL7008?

This user is receiving the error SQL7008 message. Site expert Kent Milligan offers some advice.

I am trying to run the following SQL statement and I'm getting an error message. Do you have any suggestions? The file was not created with a DDS. The file was created using SQL via .NET.


This is what the source member looks like:



SQL7008  30       1  Position 1 SIEBIND in ICKIPRDEXT not valid for operation. 
SQL7961   0          Rollback completed.                    

SQL7008 is usually a journaling issue. Meaning you're using a commitment control level other than *NONE on the RUNSQLSTM command and then changing DB2 tables or physical files that are not journaled.

If that's not the case, we would need a little more information to be able to determine the cause of the problem in your particular case. Run the SQL statement again and find the SQL7008 message in your joblog. Press F1 to display the message help text. Look for the reason code generated for the error. All the reason codes and suggested solutions are listed in the message help text. This should give you a little more insight as to what the problem is and how to solve it.

More on this topic

Visit the ITKnowledge Exchange and get answers to your DB2 questions fast.

Check out this Search400.com Featured Topic: Expert advice on DB2 

Search400.com's targeted search engine: Get relevant information on DB2/400. 

The Best Web Links: Tips, tutorials and more.


Dig Deeper on Debugging