Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2006
    Posts
    7

    Unanswered: defncopy stored proc question

    hi junta,
    defncopy pulls just the stored procedure text. we have lot of procs that are using externally created hash tables [from parent proc or application ]. I am trying to build them with a different name [ say with a prefix ]. so defncopy does only part of the work, to build the proc, I need the hash table creation statement also in the front.

    Do you guys know how to handle this situation. Also wondering how Rapid-sql is able to pull the temp table creation statement also.

    Thanks in advance. Have a wonderful new year.

    Cheers,
    Prakash

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    If you want to change the text on the fly, only Power Designer is capable of doing it out of the box. Alternatively some smart perl'ing would do.

Posting Permissions

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