Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002
    Location
    chennai
    Posts
    30

    Exclamation Unanswered: Running a ddl file and sql file

    Hi all,

    This may be a silly question, but any way. Can any one tell me how to run a ddl file or sql file in CLP and command center.

    Thanks in advance,
    sekhar

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Running a ddl file and sql file

    I'm not too sure from a CLP, I doubt you can ...

    From command window(invoked using a db2cmd command), if you meant this one, the most common is

    db2 -tvf <scriptname>

    t - default delimiter ;
    v - verbose
    f - input file

    More options are detailed in the comman reference manual.

    From Command Centre, go the the Scripts tab ... If you have a file , you can import it into the comman centre , or you can create a new one and run it using the 'gear-wheel' icon or script->execute menu option.

    If you do not intend to edit the scitpt, I recommend using Script Centre, which allows you to see and manage multiple scripts, both db2 and os commands ...

    My choice is using the command window (I hate db2's gui tools ... they eat up your system memory and response time is high ) ...

    HTH

    Cheers

    Sathyaram


    Originally posted by k_sekhar_rao
    Hi all,

    This may be a silly question, but any way. Can any one tell me how to run a ddl file or sql file in CLP and command center.

    Thanks in advance,
    sekhar

Posting Permissions

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