Script file format ideas 
Author Message
 Script file format ideas

In ref to the recent posts about script file formats/techniques - some ideas
that have worked well for me:

        isql command line options -i -o

        Instead of using the shell redirects (<, >) you can use
        the isql command line options (-i input.sql -o output.out).
        This is nice because the "Password:" prompt shows up
        to receive user input.  

        By using the -Ppassword option anyone can run a "ps"
        and secure the password - when doing sa work, this could
        cause a real security risk.

        Another option which makes it easy to maintain many
        scripts:

        #!/bin/sh

        isql -Uuser -Sserver <<  EOT
        password

        use database
        go
        sp_help
        go
        quit
        EOT

        You can tweak that by using command line arguments:

        #!/bin/sh

        isql -Usa -Sserver << EOT
        $1

        use database, and so on....

        Note that the second example (using $1) would also reveal the
        password...

Just a couple of ideas...

Cheers,
Howie

---

#define OPINIONS "My own"   * Fannie Mae, Unix Technical Services   *
                            * 3900 Wisconsin Avenue NW              *
main(){for(;;);}            * Washington, DC, USA           20016   */



Wed, 09 Aug 1995 04:21:02 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Scripting File (is this a good idea?)

2. Mac File Format to PC File Format

3. File format: script options

4. PDOXWIN 5.0 Script file format - compatible with 4.5?

5. How to Call a SQL Script file from another SQL Script File

6. Format() on Date, any idea ...

7. Need FPW 2.6 Payroll Report format ideas

8. Backup Script Problems, any ideas welcome

9. Idea: Worthwhile creating a wrapper script to automate pg_hba.conf

10. Any idea where this script is running?

11. Stress script - any good ideas?

12. Save a file in TXT format/Sauver une fiche en format TXT


 
Powered by phpBB® Forum Software