Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Posts
    14

    Unanswered: how to create db2 stored procedures through script file

    Posted: Mon Nov 03, 2003 11:13 am Post subject: how to create db2 stored procedures through script file

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

    Hi,

    i would like to know how to create Db2 stored procedures through script(command line) in Linux.

    I have taken the sample script from the db2 help and tried to execute in linux using

    db2 connect to sample (it was connected successfully) then

    db2 -td@ -vf netcase.db2

    the system has thrown the error stating " reached end of file"

    So, can anyone tell me how to execute this script in Linux version.

    I have Db2 v8.1 and red hat linux 8.1

    Also can anyone tell me how to create stored procedures when there are many say like 200-300.

    Is it possible to execute all the scripts at a time through a single script file,also are there any options if i want to create all the scripts in a new database server from existing database server.

    Any help is appreciated.

    Sri
    Attached Files Attached Files

  2. #2
    Join Date
    Jul 2003
    Location
    Austin, TX, USA
    Posts
    278

    Redbook for Stored Procedures.

    Hi Sri,

    You can download the below Redbooks from www.redbooks.ibm.com

    Cross-Platform DB2 Stored Procedures: Building and Debugging SG24-5485-01

    Setup of the DB2 Application Development Environment for Stored Procedures, REDP-0183-00

    Up and Running with DB2 for Linux, SG24-6899-00

    I don't know much about DB2 application development however I am sure these would help you in your quest.

    Regards

    Nitin.

  3. #3
    Join Date
    Aug 2003
    Posts
    14

    Re: Redbook for Stored Procedures.

    Hi nitin,

    I have taken the example from the db2 help only, still it is throwing errors when i run it.

    Also, i am looking for something where i can execute all the procedures at a time in a single script.

    Any ideas..



    Originally posted by nitingm
    Hi Sri,

    You can download the below Redbooks from www.redbooks.ibm.com

    Cross-Platform DB2 Stored Procedures: Building and Debugging SG24-5485-01

    Setup of the DB2 Application Development Environment for Stored Procedures, REDP-0183-00

    Up and Running with DB2 for Linux, SG24-6899-00

    I don't know much about DB2 application development however I am sure these would help you in your quest.

    Regards

    Nitin.

Posting Permissions

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