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

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

i have configured the clinet using Client Configuration Assistant
(by selecting manual option)

vidya

Do you have partitioned database.

regards & thanks,

Mujeeb

yes we have partitioned db