Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Location
    BRAZIL
    Posts
    10

    Question Unanswered: Function specific name

    I created a function named emdd.lpad and I noticed that its specific name was sql040205125700000.
    May I alter it to be the same as the function name?
    Silvana Meira

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

    Re: Function specific name

    AFAIK, there is no ALTER FUNCTION ...

    But when you create you can say SPECIFIC <specific name> ...
    The specific name can be anything, including the name of the function, but you can probably make it more descriptive ..
    say lpadv1_01 ie include the version info

    Cheers
    Sathyaram



    Originally posted by Silvana.meira
    I created a function named emdd.lpad and I noticed that its specific name was sql040205125700000.
    May I alter it to be the same as the function name?
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Jan 2004
    Location
    BRAZIL
    Posts
    10

    Thumbs up Re: Function specific name

    Originally posted by sathyaram_s
    AFAIK, there is no ALTER FUNCTION ...

    But when you create you can say SPECIFIC <specific name> ...
    The specific name can be anything, including the name of the function, but you can probably make it more descriptive ..
    say lpadv1_01 ie include the version info

    Cheers
    Sathyaram
    Thank you very much !!!!
    Silvana
    Silvana Meira

Posting Permissions

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