Re: �Q� create database in shell script
Posted in 1995
In article <dberg.789000530@cheetah> dberg@informix.com (David I. Berg) writes:
>greg@orgchem.weizmann.ac.il (Gregory Karpinsky) writes:
>
>>Hi,
>>I'm using Informix On-Line 5.01 as a database server. The only thing
>>I use Informix directly is: run SQL in dbaccess "create database XXX
>>with log ansi". All the rest is done through the client program.
>>Is there a way to do this in a shell script, w/o dbaccess?
>
>You could, of course, use ESQL or 4GL, but why not a script which:
>
> echo "create database $1 with log ansi" | dbaccess - -
Or
dbaccess - <<!
create database $1 with log ansi;
!
This is also very useful if you have more than one statement to execute.
June
---- June Tong Informix Software ----
---- junet@informix.com On-Site Regency Support at SAP ----
---- Informix: (415)926-6140 SAP: (415)286-6808 ----