Results 1 to 5 of 5

Thread: Sp Comilation

  1. #1
    Join Date
    Aug 2004
    Posts
    15

    Unanswered: Sp Comilation

    hi,

    We are using DB2 V7.2 on AIX


    and we remotely connect to AIX box from our system which has windows XP and db2 V72 for windows installed.

    while buildig a SP on aix server from client error:

    [IBM][CLI Driver][DB2/6000] SQL0901N The SQL statement failed because of a non-severe system error. Subsequent SQL statements can be processed. (Reason "CREATE PROCEDURE with LANGUAGE SQL only allowed at catalog node".) SQLSTATE=58004


    what can be the reason?

    pl. help

  2. #2
    Join Date
    Feb 2003
    Location
    San Francisco,US
    Posts
    15
    How did u create the client.
    did u catalog the AIX server node at the client..

    catalog tcpip node node1 remote [hostname|ip-address] server [svcname|portnumber]
    catalog db dbname as dbalias at node node1
    Ashutosh Mishra
    Accenture India,Chennai
    call on - +91-9884118430

  3. #3
    Join Date
    Aug 2004
    Posts
    15
    i have configured the clinet using Client Configuration Assistant
    (by selecting manual option)

    vidya

  4. #4
    Join Date
    Mar 2004
    Posts
    448
    Do you have partitioned database.

    regards & thanks,

    Mujeeb

  5. #5
    Join Date
    Aug 2004
    Posts
    15
    yes we have partitioned db

Posting Permissions

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