By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,756 Members | 1,749 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,756 IT Pros & Developers. It's quick & easy.

reason code = "54"

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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

This discussion thread is closed

Replies have been disabled for this discussion.