Results 1 to 2 of 2

Thread: running scripts

  1. #1
    Join Date
    Sep 2006
    Posts
    5

    Question Unanswered: running scripts

    i have applicationtables.sql
    its contents are
    connect to ridb user nikhincm using nikhincm
    @sli.sql
    @rumt.sql
    @rdt.sql ..etc..

    when i am running db2cmd->db2 -tvf applicationtables.sql

    its giving error as @ is not defined others also scripts file,i want to run these scripts file while running applicationtables.sql ..anybody please replay to me urgent.

  2. #2
    Join Date
    Mar 2004
    Posts
    46
    It seems you are trying to run "scripts" within a script file - probably trying out the Oracle SQL*Plus approach. This does not work in DB2's command line processor.

    Would recommend creating a shell script or Windows batch file that has the following formats -
    db2 connect to <dbname> user <username> using <password>
    db2 -tvf file1.sql
    db2 -tvf file2.sql
    ......

Posting Permissions

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