Path: utzoo!attcan!utgpu!jarvis.csri.toronto.edu!mailrus!uwm.edu!uakari.primate.wisc.edu!ames!amdahl!nsc!pyramid!infmx!davek
From: davek@infmx.UUCP (David Kosenko)
Newsgroups: comp.databases
Subject: Re: An Informix-SQL Question...
Keywords: informix, sql
Message-ID: <2343@infmx.UUCP>
Date: 14 Sep 89 10:38:33 GMT
References: <732@aut.UUCP>
Reply-To: davek@infmx.UUCP (David Kosenko)
Organization: Informix, Menlo Park, Ca. U.S.A.
Lines: 78

>The Informix-SQL demo script contains something like:
>
>isql - - <<!
>.
>-- SQL statements --
>.
>.
>
>!
>
>We can't find this "- -" parameter notation documented anywhere.
>Is it documented anywhere?, and what does it actually mean?? 
>Naturally we've already figured out that it probably tells
>Informix that the input comes from standard input, but perhaps
>there is something more to it than that.
>
>Any answers gratefully accepted.
>
>Thanks,
>	Philip.

	See the INFORMIX-SQL Reference manual, Appendix M -
Accessing Programs from the Operating System, page M-4.
A facsimile is reproduced here:

RDSQL

The operating system command line syntax for running RDSQL
statements is


-------------------------------------------------------------

ISQL { database-name | - } { -r | command-file | - }

-------------------------------------------------------------


ISQL		is the program call for INFORMIX-SQL

database-name	is the name of the database in your current
		directory or a directory cited in your DBPATH
		environment variable.  You may replace
		database-name with a dash, if either the
		CREATE DATABASE or DATABASE
		statement follows.

-r		calls the RDSQL Menu.  When you exit the
		RDSQL Menu, you return to the operating
		system command line.

command-file	is the name of a command file containing one
		or more RDSQL statements.  Do not include the
		.sql extension (filename.sql) on the command
		line.

		You may replace command-file with a dash and 
		enter RDSQL statements from the standard
		input (UNIX systems only).  Indicate the end 
		of a statement with a semicolon.

Enter the RDSQL statements at the > prompt.  You can enter
a single statement or an entire series of statements.  You
remain in RDSQL until you type CTRL-D at the prompt.




M-4  Program Command Line Syntax


---
Dave
-- 
Disclaimer:  The opinions expressed herein | ..and the best thing you've ever
are by no means those of Informix Software | done for me is to help me take my
(though they make you wonder about the     | life less seriously - it's only
 strange people they hire).                | life, after all...