IC5Notice: We have upgraded developerWorks Community to the latest version of IBM Connections. For more information, read our upgrade FAQ.
Topic
  • 1 reply
  • Latest Post - ‏2011-10-24T11:13:57Z by SystemAdmin
SystemAdmin
SystemAdmin
708 Posts

Pinned topic Where is the TEXT for PL/SQL packages and package bodies

‏2011-10-20T18:23:19Z |
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

Raul
Updated on 2011-10-24T11:13:57Z at 2011-10-24T11:13:57Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    708 Posts

    Re: Where is the TEXT for PL/SQL packages and package bodies

    ‏2011-10-24T11:13:57Z  
    OK 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.