Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2013
    Posts
    2

    Post Unanswered: DB2 insertion exception problem

    Hi Everybody,

    If we have any exception during insertion of data in DB2 we are getting only sql error code. Is their any possibility to get table and column name where it has failed?

    Thanks in advance

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    as language/platform is not indicated
    get diagnostics could help
    displaying sqlca and the message field should contain this info..
    details as always, available in infocenter
    please read fix entry in forum : read before asking a question.. supply ALL info, otherwise we have to guess
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •