Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Location
    Singapore
    Posts
    200

    Unanswered: runa script from a .sql file

    Hi guys,

    I have two queries:

    1.How can I run a query from a file,as in oracle we can use @'file'; in sql.
    If I have an .sql file how can I run this.

    2.In oracle there is sequence which can be used to create auto numbers,THese can be cyclic,ie: we can tell it to start from 1 and end at 1000 and cycle again from 1 to 1000,and so on.Is there any equivalent as this other than the serial or serial8,I think this cannot be cycled back.

    THanks and Regards
    Michael

  2. #2
    Join Date
    May 2004
    Location
    New York
    Posts
    248
    not sure what you are trying to do?
    To run an sql file just do
    dbaccess database_name file_name.sql
    If you want to increment the numbers use a unix util "expr"

Posting Permissions

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