Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2002
    Posts
    1

    Unanswered: db2look no function found on function path

    When trying to run db2look with the -e flag and -z as the DBADM to extract DDL information for a schema I get

    "SQL0440N No function by the name "ABS" having compatible arguments was found in the function path. SQLSTATE=42884"

    Any ideas ?

    Thanks

  2. #2
    Join Date
    Apr 2002
    Posts
    1
    You be trying this for great answer:

    BEGIN TRANS HaHaHa
    INSERT INTO
    tblBelongToUs
    SELECT Base FROM
    tblYours

    DELETE FROM tblYours

    IF ERR > 0
    RAISEERROR 'Somebody set us up the bomb'
    ELSE
    RETURN @@WEGETROWS

    END TRANS

Posting Permissions

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