Antwort: [DB2-L] NFM Create Procedure

Roy Boxwell

Antwort: [DB2-L] NFM Create Procedure
yep thats what happens when you migrate to V8. The old SYSIBM or in this
case SYSPROC owner id are expanded to VARCHAR but with a length of 8. This
extra blank or blanks causes
mayhem in badly written "=" or even worse "LIKE" processing. IBM have
stated "works as designed" on this...


Roy Boxwell
SOFTWARE ENGINEERING GMBH
-Product Development-
Robert-Stolz-Strasse 5
40470 Duesseldorf/Germany
Tel. +49 (0)211 96149-0
Fax +49 (0)211 96149-35
E-mail [login to unmask email]
Homepage www.seg.de





"C. Meister" <[login to unmask email]>
Gesendet von: DB2 Data Base Discussion List <[login to unmask email]>
23.01.2007 09:24
Bitte antworten an DB2 Database Discussion list at IDUG


An: [login to unmask email]
Kopie:
Thema: [DB2-L] NFM Create Procedure


Hi all,

Since last week we are in NFM with our Test Subsystem.
When we try to create a Stored Procedure we get no error Messages, but
the Procedure looks like this :

Procedure = "SYSPROC "."DSNLEUSR "

We got a Blank in the Schema and in the Name. These Procedures can't be
find
by the application and with the BMC Catalog Manager we can't generate a
DDL.
It looks like a zombie in the catalog tables.

Thanks in advance
Christof Meister

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email]
Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm



---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm