reason code = "54"

Oliver Stratmann

Hello All,

could anyone give me a clou about the above reason code?
(Database Version 7.2 UDB on a Windows 2000 Machine)

This is what i did:

<Begin-Quote>
db2 => insert into e_deka_einzel select * from e_deka_einzel_vw

DB21034E The command was processed as an SQL statement because it was not a

valid Command Line Processor command. During SQL processing it returned:

SQL0902C A system error (reason code = "54") occurred. Subsequent SQL

statements cannot be processed. SQLSTATE=58005

db2 =>

<End-Quote>

This error occurs even if I only SELECT the view e_deka_einzel_vw.

Thanks for Your help in advance!

Bye!
Oli

Nov 12 '05 #1

Martin Neumann

Hi Oliver,

you should check the db2diag.log file in your instance directory for
entries.

If that does not yield any results, check the definition for your view.
(use: SELECT text FROM Syscat.Views WHERE Viewname='E_DEKA_EINZEL_VW')

Gruesse,

Martin Neumann
Marvin Consult

Oliver Stratmann wrote:

db2 => insert into e_deka_einzel select * from e_deka_einzel_vw

DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0902C A system error (reason code = "54") occurred. Subsequent SQL
statements cannot be processed. SQLSTATE=58005

Nov 12 '05 #2