Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    9

    Unanswered: anonymus SQL block in db2 udb v8

    Hi all,

    Is it possible to have an anonymus SQL block in DB2??

    Like in Oracle:

    DECLARE
    BEGIN
    END;

    How can I execute anonymus SQL block in db2?

    Thanks

    Vasja Chlen

  2. #2
    Join Date
    Dec 2003
    Posts
    9
    Hi All,

    I don't see any answers.
    Does it mean nobody performed migration from Oracle to Db2? :-)

    Thanks,

    Vasja Chlen

  3. #3
    Join Date
    Jan 2004
    Location
    Tallahassee, FL, USA
    Posts
    96
    yes I migrated DB from Oracle8i to DB2 UDBV8,

    you can

    use SQL block in db2 V8 as DB2 stored procedure


    from run , type db2dc , that will take you to development center , you build SQL stored procedures or JAVA, in DB2 UDB V8 , you can use even VB



    Let me know , if you need any syntax


    Lekharaju Ennam
    Certified Oracle8i & DB2 UDB DBA
    Florida A&M University

Posting Permissions

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