Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2002
    Posts
    5

    Red face Unanswered: Passing Sql Errors to Unix ksh Script

    Can someone tell me how to pass the db2 sql errors out to
    a ksh script? I'm new to db2 and we have several scripts that
    run at night - and where the unix script processes ok we are
    getting some sql errors that we'd like to trap for -

    Thanks

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Passing Sql Errors to Unix ksh Script

    I have made a copy of this thread to 'Unix Shell Scripts' forum ... So, please check that forum also for answers ...

    Cheers

    Sathyaram


    Originally posted by manialg
    Can someone tell me how to pass the db2 sql errors out to
    a ksh script? I'm new to db2 and we have several scripts that
    run at night - and where the unix script processes ok we are
    getting some sql errors that we'd like to trap for -

    Thanks

  3. #3
    Join Date
    Apr 2002
    Posts
    188

    Re: Passing Sql Errors to Unix ksh Script

    Originally posted by manialg
    Can someone tell me how to pass the db2 sql errors out to
    a ksh script? I'm new to db2 and we have several scripts that
    run at night - and where the unix script processes ok we are
    getting some sql errors that we'd like to trap for -

    Thanks
    I do not think you can do that, I tried different ways to get them and at the end I created a table on the database that keeps track of them.
    then I have a little cron job that gets them and write them out to a file

    hope it helps

    marcos oliva

Posting Permissions

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