Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Posts
    60

    Unanswered: problem creating SP

    I am trying to create a SP using db2 -td@ -v -f test1.sql ...but its giving me following error. Also where can i find the specified log file in error message?

    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL7032N SQL procedure "BOSP_DEL_TEST" not created. Diagnostic file is
    "P3851580.log". SQLSTATE=42904

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1

    Re: problem creating SP

    Originally posted by jfkuser
    Also where can i find the specified log file in error message?

    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL7032N SQL procedure "BOSP_DEL_TEST" not created. Diagnostic file is
    "P3851580.log". SQLSTATE=42904
    I guess any OS would have some way to find a file. In Windows that would be "Start Menu -> Search -> Files or Folders"; in unix, "find / -name..."

    For example, on my Windows machine the procedure mentioned above brings the following result: C:\SQLLIB\function\routine\sqlproc\<database_name> \<user_name>\tmp
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

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