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

    Unanswered: DB2 store procedure on iseries navigator

    Hi Guys!!!

    I'm new to DB2/400 i have couple of questions please,

    1. can we create cluster index on db2/400

    2. i'm trying to create a procedure in which i have a select statement , i'm unable to create ... please see the code below i have written, here i dont want to use cursor ... i'm able to create if is use cursor...

    CREATE PROCEDURE TEST()
    LANGUAGE SQL
    BEGIN
    SELECT lname FROM employee WHERE empno = 10;
    END
    could some one please tell if i can create store procedures as in ORACLE or SYBASE... like
    create procedure proc_name
    @parameter//optional
    begin
    select * from emp;
    select * from dept;
    end;

    Thanks
    sam
    Last edited by asr2002; 12-20-02 at 20:48.

Posting Permissions

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