Results 1 to 7 of 7
  1. #1
    Join Date
    Feb 2004
    Posts
    79

    Unanswered: running all scripts in 1 one script file

    I TRIED DOING AS FOLLOWSsorry for the caps)Gives me error

    set echo on
    spool allmyScripts.txt

    /* create the tables f */
    @@cre.tab
    /* create indexes */
    @@cre.ind



    any sample available?Thanks

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: running all scripts in 1 one script file

    It should work, though it needs a SPOOL OFF at the end.

    My crystal ball isn't working today - what error does it give?

  3. #3
    Join Date
    Sep 2003
    Posts
    156

    Re: running all scripts in 1 one script file

    Originally posted by andrewst
    It should work, though it needs a SPOOL OFF at the end.

    My crystal ball isn't working today - what error does it give?
    Did your crystal ball not give you an error code?

    ;)
    rgs,

    Ghostman

  4. #4
    Join Date
    Jul 2003
    Posts
    2,296
    I've found that it will never go further down the file directory
    without explicitly calling the exact filepath.

    for one you do not specify the file-path for cre.tab.
    I am assuming cre.tab calls other files which create the tables.

    Perhaps we could see what is in this file to help you out.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  5. #5
    Join Date
    Feb 2004
    Posts
    79
    cre.tab has table creation syntax
    create table myTable(name varchar(10), age number(2));

  6. #6
    Join Date
    Jul 2003
    Posts
    2,296
    how about specifying where the file resides?

    ie: @c:\mydirectory\cre.tab
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  7. #7
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    Originally posted by The_Duck
    how about specifying where the file resides?

    ie: @c:\mydirectory\cre.tab
    The @@ syntax is to prevent you from needing to specify where the file resides - it means: same location as the calling script. This is useful when creating a lot of scripts called by other scripts, if you believe the path may change in the future.

Posting Permissions

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