Printer FriendlyEmail Article Link

How do I run SQL’s from the UNIX command prompt?

Answer

dbaccess <<!
database <DATABASE>;
<SQL>!

Example below:

dbaccess <<!
database pmint;
SELECT * 
from circuit,access_point,network_entity,fpm_log 
where access_point.tid_id=network_entity.tid_id and 
access_point.ckt_id=circuit.ckt_id and 
circuit.ckt_id=fpm_log.ckt_id and 
fpm_retrieve_date = “10/26/2007” and
time > “08:00:00.000” and time < “09:00:00.000” and
ckt_num=”23/HCGS/003466/^^^/CD^^/^^^”
!


Product : UNIX,Informix