#1097 DB2: don't display UDF source : SQL0206N "SCHEMA" is not valid in the context where it is used.

snapshot
open
nobody
5
2013-09-20
2013-09-20
Georg Hartmann
No

Hello,
since version 3.5 Squirrel doesn't show source code of DB2 UDF.
Version 3.4 shows it.
pls. see attached screens.
I've checked it on 2 machines and with db2 app driver and db2 net driver.

Win7 prof. 64bit:
C:\DEV>java -version
java version "1.7.0_40"
Java(TM) SE Runtime Environment (build 1.7.0_40-b43)
Java HotSpot(TM) 64-Bit Server VM (build 24.0-b56, mixed mode)

RHEL6.4 64bit:
java version "1.7.0"
Java(TM) SE Runtime Environment (build pxa6470sr4fp2-20130426_01(SR4 FP2))
IBM J9 VM (build 2.6, JRE 1.7.0 Linux amd64-64 Compressed References 20130422_146026 (JIT enabled, AOT enabled)
J9VM - R26_Java726_SR4_FP2_20130422_1320_B146026
JIT - r11.b03_20130131_32403ifx4
GC - R26_Java726_SR4_FP2_20130422_1320_B146026_CMPRSS
J9CL - 20130422_146026)
JCL - 20130425_01 based on Oracle 7u21-b09

Tried also different DBs (V9.7.7 / 9.7.8) on AIX and Windows.

In case you need more information:
I'm on vacation the next both weeks :)

kind regards Georg

3 Attachments

Discussion