Q

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.

RUNSQLSTM SRCFILE(DRISCOLL/QSQLSRC) SRCMBR(UUPDSIEBIN)

This is what the source member looks like:

SRCMBR(UUPDSIEBIN):

INSERT INTO ICKIPRDEXT/SIEBIND (SIEBIND) VALUES (1);

 
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.

 

This was first published in August 2005

Dig deeper on Debugging

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchEnterpriseLinux

SearchDataCenter

Close