DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: delete command to remove sql file??

  1. #1
    Join Date
    Oct 2000
    Posts
    144
    Hi everyone,

    I create a script in NT that has SPOOL (filename).sql. At the end of the script, I want to set
    a command to remove (filename).sql. I know that you can use "rm" command in Unix, but I don't
    know What command do I use in NT? Please give me some advise. I really appreciate it.

    Thanks,

    Trina

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    del filename.sql
    Jeff Hunter

  3. #3
    Join Date
    Oct 2000
    Posts
    144
    Hi Jeff,
    I try your method, but it gives me an error message:
    SP2-0224: invalid starting line number

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    from sqlplus,
    host del filename.sql
    Jeff Hunter

  5. #5
    Join Date
    Oct 2000
    Posts
    144
    Thanks Jeff, it works.

Posting Permissions

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


Click Here to Expand Forum to Full Width