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

What causes the SQL7008 error?

What causes the SQL7008 error?

When connecting via an ODBC data source to a non-IBM database such as SQLBASE, I can create an access query, and use the find/replace capabilities to find a text string within a field and replace it.

On the iSeries I can find, but I get an error when trying to replace:
[IBM][ISeries Access ODBC Driver] [DB2 UDB]sql7008-S.APMAST in SPFILES not valid for operation. (#-7008). Do you know why?


SQL7008 is most of the time caused by trying to update a file that is not journaled or you do not have authority to its journal.

Journal the file using command STRJRNPF (files on iSeries are not automatically journaled unless defined by using SQL).

More on this topic

Ask your systems management questions--or help out your peers by answering them--in our live discussion forums.

The Best Web Links: Tips, tutorials and more.

Check out this Search400.com Featured Topic: Networking and the iSeries

PC/Windows connectivity expert Shahar Mor is available to answer your toughest networking questions. Ask Shahar a question or read his previously answered questions here.

 


 

This was last published in April 2004

Dig Deeper on iSeries Access (Client Access)

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.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Close