Results 1 to 4 of 4
  1. #1
    Join Date
    May 2002
    Posts
    2

    Arrow Unanswered: create function in db2

    create function rtrims(x varchar(1000))
    returns varchar(1000)
    NO EXTERNAL ACTION
    DETERMINISTIC
    LANGUAGE SQL
    CONTAINS SQL
    NULL CALL
    return case when (x is null) then
    'null'
    else
    ''''||rtrim(x)||''''
    end

    i cannt add it in db2 v7.1,what's the matter

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

    Re: create function in db2

    can you post the error message you get ...

    Cheers

    Sathyaram

    Originally posted by jjdf
    create function rtrims(x varchar(1000))
    returns varchar(1000)
    NO EXTERNAL ACTION
    DETERMINISTIC
    LANGUAGE SQL
    CONTAINS SQL
    NULL CALL
    return case when (x is null) then
    'null'
    else
    ''''||rtrim(x)||''''
    end

    i cannt add it in db2 v7.1,what's the matter

  3. #3
    Join Date
    May 2002
    Posts
    2
    [IBM][CLI Driver][DB2/NT] SQL0628N Multiple or conflicting keywords
    involving the "LANGUAGE SQL" clause are present SQLSTATE=42613

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    This is a known bug first fixed in FP4 ...

    Check

    http://www-1.ibm.com/support/manager...SW&doc=1045001

    and

    http://www-3.ibm.com/cgi-bin/db2www/...aparno=JR15961

    Cheers

    Sathyaram

    Originally posted by jjdf
    [IBM][CLI Driver][DB2/NT] SQL0628N Multiple or conflicting keywords
    involving the "LANGUAGE SQL" clause are present SQLSTATE=42613

Posting Permissions

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