469,303 Members | 2,042 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,303 developers. It's quick & easy.

reason code = "54"

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
1 3349
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.

Similar topics

1 post views Thread by Anand | last post: by
4 posts views Thread by jason.awlt | last post: by
reply views Thread by Dartmouth College LISTSERV Server (15.0) | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by harlem98 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.