In db2cmd, put
db2 ? sql0717
C:\Documents and Settings\durgeshm>db2 ? sql0717
SQL10007N Message "717" could not be retrieved. Reason code: "4".
C:\Documents and Settings\durgeshm>db2 ? sql0727
SQL0727N An error occurred during implicit system action type
"<action-type>". Information returned for the error
includes SQLCODE "<sqlcode>", SQLSTATE "<sqlstate>"
and message tokens "<token-list>".
Explanation:
The processing of a statement or command has caused the database
manager to implicitly perform additional processing. During this
processing an error was encountered. The action attempted is
shown by the "<action-type>":
1 implicit rebind of a package
2 implicit prepare of a cached dynamic SQL statement
3 implicit regeneration of a view
4 This return code is reserved for use by DB2.
5 incremental bind of a static SQL statement, not bound during
package bind time
6 implicit prepare of a reoptimizable statement containing
host-variables, special registers, or parameter markers
The sqlcode, sqlstate and message token list (each token is
separated by the vertical bar character) are provided. The
message tokens may be truncated. See the corresponding message
for the "<sqlcode>" for further explanation of the error.
The original SQL statement or command that caused the
"<action-type>" cannot be processed and the implicit system
action was not successful.
Federated system users: You may have received this message
because you dynamically prepared an SQL statement in a
pass-through session and then tried to execute the statement
after the session was closed.
User Response:
Check the message associated with the SQLCODE of the SQL
statement that failed. Follow the action suggested by that
message.
For an invalid package, the REBIND command can be used to
recreate the error or to explicitly validate the package once the
cause of the error has been resolved.
For a failure while regenerating a view, the name of the view
that failed is recorded in the administration notification log.
The failing view can be dropped or a change made to the statement
or command that caused the view regeneration.
Federated system users: If the statement that failed was
dynamically prepared in a pass-through session, open another
pass-through session, write and prepare the statement again, and
execute it while the session is still open.
sqlcode : -727
sqlstate : 56098
-----Original Message-----
From: Rahul Yadav
[mailto:db2udbdba-ezmlmshield-x54912797.[Email address protected]
Sent: Tuesday, June 27, 2006 3:13 PM
To: LazyDBA Discussion
Subject: implicit rebind or prepare
SQL Error: -727 SQLState:56098
"An error occurred during implicit rebind or prepare"
when do we see such error???
Best Regards,
Rahul Yadav
Software Engineer
Daffodil Software Ltd.
2nd Floor,Vipul Orchid Plaza,
Sun City,Sector 54,
Gurgaon,India.
Mobile:+91 9868679702
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
DISCLAIMER:
This message contains privileged and confidential information and is intended only for the individual named.If you are not the intended recipient you should not disseminate,distribute,store,print, copy or deliver this message.Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system.E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted,corrupted,lost,destroyed,arrive late or incomplete or contain viruses.The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard-copy version.
DB2 & UDB email list listserv db2-l LazyDBA home page