Results 1 to 9 of 9
  1. #1
    Join Date
    Feb 2006
    Posts
    7

    Question Unanswered: Need to find Sp parameters

    Can any one tell me how to find sp parameters and its details like datatype , length , flowdirection using system tables in DB2..

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    SYSCAT.ROUTINEPARMS

    Quote Originally Posted by jimmy_a
    Can any one tell me how to find sp parameters and its details like datatype , length , flowdirection using system tables in DB2..
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Feb 2006
    Posts
    7
    Thnks sathaya ..

    using this SYSCAT.ROUTINEPARMS i can get a param name and its length..

    Including this i need to find its UDD's and flowdir and Precision for the given..

    Any idea from which table i can these details...

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    http://publib.boulder.ibm.com/infoce...n/r0001044.htm

    If you are unable to find the information, please give an example ... What does UDD mean ?

    Quote Originally Posted by jimmy_a
    Thnks sathaya ..

    using this SYSCAT.ROUTINEPARMS i can get a param name and its length..

    Including this i need to find its UDD's and flowdir and Precision for the given..

    Any idea from which table i can these details...
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  5. #5
    Join Date
    Feb 2006
    Posts
    7
    UDD means User Defined Datatype ...

  6. #6
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    They are generally know as UDT - User Defined type

    Quote Originally Posted by jimmy_a
    UDD means User Defined Datatype ...
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  7. #7
    Join Date
    Feb 2006
    Posts
    7
    Fine satya... I dont have much idea abt DB2 ..thats y i said UDD...

    is there any way to find that UDT for a procedures

  8. #8
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    I would recommend that start here
    http://publib.boulder.ibm.com/infoce...n/r0011297.htm

    SYSCAT.DATATYPES gives you information on the base datatypes for a given datatype.

    Generally speaking, it is always useful to give example on what you want - rather than a one-liner saying UDD, flow dierection etc. Helps to get a response that will help you.

    Cheers

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  9. #9
    Join Date
    Feb 2006
    Posts
    7
    No satya.... I didnt mean the data type... let me exlpain u wht im expecting...

    I defined one UDD called UDD_Name which is of data type char(10)..

    In SP , the parameters which are all having the data type char(10) i can use this UDD_Name commonly... any one can use this udd in that DB...

    Now i want to fetch the SP Name and the UDD Name and its corresponding data type and Length...

    I can get all these details in SQL using information Schema.... Like wise i need to fetch in DB2...


    I hope Im clear ......

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •