Results 1 to 7 of 7

Thread: functions

  1. #1
    Join Date
    Dec 2007
    Posts
    30

    Unanswered: functions

    Hi All
    there is a function(user defined) by name mno.abc_def in syscat.functions in a production server. i want that function to be deployed in development server.
    i am using db2V8.2 fp5-solaris.
    can any plz tell me how to do that and what all things do i need to check during the deployment. any help would be appreciated.

    Thanks..

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    What is the language of the function?

    Andy

  3. #3
    Join Date
    Dec 2007
    Posts
    30

    functions

    the language is SQL

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Simple...

    1) connect to production DB
    2) SELECT text from syscat.routines where routineschema = 'MNO' and routinename = 'ABC_DEF'
    3) connect to development in command editor
    4) cut output from 2 into command editor and run

    Andy

  5. #5
    Join Date
    Dec 2007
    Posts
    30
    Thanks andy..

  6. #6
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Alternative: db2look -e -z mno
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  7. #7
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    The Developer Workbench can also be used.

    Andy

Posting Permissions

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