> Please bear with me if this is not a very intelligent question!!
>
[quoted text clipped - 21 lines]
>
> Thanks in advance for your time!
Us eteh PUT_ROUTINE procedure. Note "special register flag"
http://publib.boulder.ibm.com/infocenter/db2help/topic/com.ibm.db2.udb.doc/admin
/r0004230.htm?resultof=%22%50%55%54%22%20%22%70%75%74%22%20
Cheers
Serge

Signature
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Raj - 31 May 2005 17:06 GMT
Thanks.
But when I tried that I got the following message.
Command:
put routine from xyz.sar OWNER Administrator USE REGISTERS
Error Message:
"SQL0443N Routine "SYSFUN.PUT_ROUTINE_SAR" (specific name "PUT_SAR")
has
returned an error SQLSTATE with diagnostic text "-20135, 55046, 1".
SQLSTATE=38000"
When I looked up sqlcode: -20135 and sqlstate: 55046 it says
1. The operating system of the target environment is not the same as
the operating system on which the SQL archive was created.
2. The database type and level of the target environment is not the
same as the database type and level on which the SQL archive was
created.
1) I am not sure which one has caused the problem. Is there anyway to
narrow down to the exact problem?
2) Is there any other way to manually run those procedures? reading the
SPs in the SAR file and manually running against the DB
Thanks!
Serge Rielau - 31 May 2005 18:29 GMT
> Thanks.
>
[quoted text clipped - 23 lines]
>
> Thanks!
Which fixpack level are you on both systems and what are the systems?
GET and PUT ROUTIEN are meant to deploy from a development machine to a
production machine without a C-Compiler.
In DB2 V8.2 the only remaining reason to use GET and PUT is obfuscation
of the text.
Does anyting speak against just getting the text from SYSCAT.ROUTINES.TEXT ?
Cheers
Serge

Signature
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab