timestamp conflict

[Michael Schmid]

Hallo,

I've written a C++ program which collects data from a DB2-Database via
embedded sql.
The program is working, but sometimes I get the following message:

--- error report ---
ERROR occurred : SQL Error....
SQLCODE : -818
SQL0818N A timestamp conflict occurred. SQLSTATE=51003
--- end error report ---

The db2-server is located on a PC with NT, while my client is running on
an AIX-workstation.

I changed the time on the Server, but it didn't make a difference.

There are timestamp values in my table, but I don't select them.

The access to the database is read-only, via cursors.

There isn't any error when I access the database via the
db2-command-line.

Any help would be appreciated
Michael

[Mitch]

An 818 is caused when the timestamp generated at precompile time by the
precompiler is not the same as the timestamp stored with the package at
bind time.

This sounds to me like your package/plan and executable were not
created at the same time.

Rebind your program.

Richard “Mitch” Mitchell
Senior Database Administrator
IBM Certified Solutions Expert - DB2 UDB v6.1 Database Administration
for UNIX, Windows and OS/2

Fracta Networks

In article <3A01830F...@daimlerchrysler.com>,

--
- Mitch

Sent via Deja.com http://www.deja.com/
Before you buy.