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


        isql -Uuser -Sserver <<  EOT

        use database

        You can tweak that by using command line arguments:


        isql -Usa -Sserver << EOT

        use database, and so on....

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

Just a couple of ideas...



#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