All, anybody seen this before : (a friend has this problem). Any thoughts I can pass on? bst rgds Leslie We are running Version 7.1 of DB2 on AIX and I have installed Version 7 of stored procedure builder on a windows 2000 client I have a lot of pre-written SQL stored procedures already written I log on as user1 and the tables I have created are all qualified by the schema schema1 So far I have created a project using my user user1 in a database db1 I have changed the create procedure name form proc1 to schema1.proc1 and tried to build it and I get the following error message SCHEMA1. PROC1: 3: [IBM][CLI Driver][DB2/6000] SQL0455N In routine "PROC1", the schema name "USER1" provided for the SPECIFIC name does not match the schema name "SCHEMA1" of the routine. LINE NUMBER=3. SQLSTATE=42882 I have tried various other things but to no success. I don't understand the message when it refers to a SPECIFIC name and why that should matter ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. Sony cannot accept liability for statements made which are clearly the sender's own and not made on behalf of Sony. (03) ********************************************************************** ===== To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
