Does anybody know where the text for the CREATE OR REPLACE PACKAGE and PACKAGE BODY sentences go when compiling PL/SQL in DB2 9.7.4 ?
Thanks in advance
This topic has been locked.
1 reply Latest Post - 2011-10-24T11:13:57Z by SystemAdmin
Pinned topic Where is the TEXT for PL/SQL packages and package bodies
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2011-10-24T11:13:57Z at 2011-10-24T11:13:57Z by SystemAdmin
SystemAdmin 110000D4XK708 PostsACCEPTED ANSWER
Re: Where is the TEXT for PL/SQL packages and package bodies2011-10-24T11:13:57Z in response to SystemAdminOK I got it: It's in system view DBA_SOURCE:
db2 describe select '*' from DBA_SOURCE
Long. Esq. tipo Long. Nombre tipo Long.
Tipo SQL Long. tipo Nombre columna nombre Long. Lob datos esq. datos nombre
448 VARCHAR 128 OWNER 5 0 SYSIBM 6 VARCHAR 7
448 VARCHAR 128 SCHEMA 6 0 SYSIBM 6 VARCHAR 7
448 VARCHAR 128 NAME 4 0 SYSIBM 6 VARCHAR 7
449 VARCHAR 128 SPECIFICNAME 12 0 SYSIBM 6 VARCHAR 7
449 VARCHAR 12 TYPE 4 0 SYSIBM 6 VARCHAR 7
409 CLOB 0 TEXT 4 2097152 SYSIBM 6 CLOB 4
It might be the case that TOAD for DB2 (c) show data incorrectly due to CLOB field.