Results 1 to 1 of 1
  1. #1
    Join Date
    Nov 2002
    Posts
    1

    Unanswered: call SQL-Procedure

    Hi,

    i have created a SQL-Procedure. But i can´t call the Procedure.

    Operation Systemolaris
    DB2 V7.1

    -----------------------------------------
    bash-2.03$ db2 -td$ -vf test3
    drop table zwip
    DB20000I The SQL command completed successfully.

    create table zwip (tier1 varchar(20), tier2 varchar(20))
    DB20000I The SQL command completed successfully.

    drop table tiere
    DB20000I The SQL command completed successfully.

    create table tiere (tier varchar (20))
    DB20000I The SQL command completed successfully.

    insert into tiere values('lowe')
    DB20000I The SQL command completed successfully.

    DROP PROCEDURE try
    DB20000I The SQL command completed successfully.

    CREATE PROCEDURE try()
    LANGUAGE SQL
    BEGIN
    DECLARE sum varchar(20);
    FOR vl AS
    SELECT Tier FROM tiere
    DO
    SET sum = tier;
    INSERT INTO zwip VALUES (sum,sum);

    END FOR;
    END

    DB20000I The SQL command completed successfully.

    call tiere.try()
    SQL10013N The specified library "/export/home/borchert/sqllib/function/routine/sqlproc/TIERE/BORCHERT/P" could not be loaded.

    !!!!!!! I have no idea whats wrong!!!!!!!

    ----------------------------------------------

    In the Directory are the following Files:

    bash-2.03$ pwd
    /export/home/borchert/sqllib/function/routine/sqlproc/TIERE/BORCHERT
    bash-2.03$ ls
    P4028170 P4028170.c P4028170.log P4028170.sqc tmp

    I send the File P4028170.log as Attachment

    ----------------------------------------------

    Please help me
    Attached Files Attached Files

Posting Permissions

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