Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2014
    Posts
    294

    Unanswered: SQL7032 ERROR on Db2/400 procedures

    HI,

    I am connecting to the Iseries machine through IBM data studio & trying to create a db2/400 stored procedure. Till yesterday the procedure is working absolutely
    fine, today I m getting the below error. As I havn't changed anything.

    Error:

    [SQL7032] SQL procedure, function, or trigger TYU.TYUI_98 in TYU not created.
    TYU.TYUI_98 - Deploy failed.
    TYU.TYUI_98 - Roll back completed successfully.

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    SQL7032 ? not found
    TYU.TYUI_98 in TYU not created. - maybe todo with library ....
    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

  3. #3
    Join Date
    Jul 2014
    Posts
    294
    Library is there. Does it mean any space issue with the library ?

  4. #4
    Join Date
    Dec 2007
    Location
    Richmond, VA
    Posts
    1,328
    Provided Answers: 5
    If nothing is changed, why are you deploying??? You stated your problem as if the procedure has been in your subsystem and was being executed. However, the error message you show has nothing to do with executing a procedure where nothing has changed, you provide partial error message for deploying a changed procedure.
    Dave

  5. #5
    Join Date
    Jul 2014
    Posts
    294
    Even I m thinking the same. I tried to deploy again, its stating the same error. The error which I posted is not partial, that is the only which I can see.

Tags for this Thread

Posting Permissions

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