Usage Note 15284: The error "SQL7008 Table in X not valid for operation" might occur when you attempt to create a DB2 table using SAS/ACCESS Interface to DB2
 |  |  |  |
The error can occur if the physical file on the server is not journaled.
To resolve this problem, modify the db2cli.ini file on the client. Create a section in the db2cli.ini that has the same name as the cataloged database. For example:[EDW] TxnIsolation =32
After adding the above two lines to the end of the file, perform a db2stop command and a db2start command.
Test without any isolation or commit modifiers on the libref assignment. For example:
libname db2lib db2 uid=DB2USR pwd=DB2PW datasrc=DB2WH
schema=DWH_TEST
READ_ISOLATION_LEVEL=UR
UPDATE_ISOLATION_LEVEL=CS; TxnIsolation CLI/ODBC configuration keyword
Keyword description:
Set the default isolation level.
db2cli.ini keyword syntax:
TxnIsolation = 1 | 2 | 4 | 8 | 32
Default setting:
Read Committed (Cursor Stability)
Only applicable when:
the default isolation level is used. This keyword will have no effect
if the application has specifically set the isolation level.
Equivalent statement attribute:
SQL_ATTR_TXN_ISOLATION
Usage notes:
Sets the isolation level to:
1 = SQL_TXN_READ_UNCOMMITTED - Read Uncommitted (Uncommitted read)
2 = SQL_TXN_READ_COMMITTED (default) - Read Committed (Cursor
stability)
4 = SQL_TXN_REPEATABLE_READ - Repeatable Read (Read Stability)
8 = SQL_TXN_SERIALIZABLE - Serializable (Repeatable read)
32 = SQL_TXN_NOCOMMIT - (No Commit, DB2 Universal Database for AS/400
only; this is similar to autocommit)The words in parentheses are IBM terminology for the equivalent SQL92 isolation levels. Note that no commit is not an SQL92 isolation level and is supported only on DB2 Universal Database for AS/400.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to DB2 | 64-bit Enabled HP-UX | 9.1 TS1M3 | |
| 64-bit Enabled Solaris | 9.1 TS1M3 | |||
| Linux | 9.1 TS1M3 | |||
| 64-bit Enabled AIX | 9.1 TS1M3 | |||
| Type: | Usage Note |
| Priority: | |
| Topic: | SAS Reference ==> Procedures ==> ACCESS |
| Date Modified: | 2012-12-10 14:46:07 |
| Date Created: | 2005-05-23 14:27:55 |