[comp.databases] Informix SQL question, again...

lincoln@aut.UUCP (Philip Lincoln) (09/29/89)

Hallo world,
A week or so back I asked a question about the 
"- -" notation in a statement such as:
isql - - <<!

blah blah...

!

I understand that someone replied with a copy of a
manual page explaining this, but is not included in
the latest manuals. Unfortunately this got deleted
from our system before I had a chance to read it
(I got a reply to the reply though, thats how I
know it existed). Could the person who sent this
entry please re-send it so I can once again sleep
easy at night.

Thanks again,
	Philip.

davek@infmx.UUCP (David Kosenko) (10/10/89)

>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.


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...