Category : Databases and related files
Archive   : SSQL31A.ZIP
Filename : READ.ME
Output of file : READ.ME contained in archive : SSQL31A.ZIP
* FOR INSTALLATION DETAILS TYPE INSTALL *
*****************************************
*** QUICK START (DETAILS IN DOCUMENTATION)
SSQL
(TYPE A COMMAND, SUCH AS)
SELECT *
FROM BRANCH;
(NOW PROCESS THE COMMAND BY PRESSING)
F4
(The response will be in the text box on the right. To close it press Alt-F3)
A fast way to erase the current query
(assuming the cursor is at the end of the query)
Shift-PgUp
Del
*** Output limit under SQL
The output of the select command is brought into an editing window. There
is a 65,000 character limit to the editing window. Anything above that will
get a "memory error". Since the output is put in a file called QUERY.TXT, you
can idit it with any text editor/word processor that can handle large files.
If you use SSQLENG directly the limit to the output is about 320,000 characters.
However, the size of the input tables remains UNLIMITED.
Work-around for file-save bug
When you create a new file, there is a bug if you press ALT-F3 to close the
window AND answer YES to saving an untitled file. It will probably lock-up.
Instead of pressing ALT-F3 to cloze a NEW file you want to save, press
ALT-F, A (Save As) to save the file, then close it.
Possible bug with mouse in VGA mode
If the mouse only goes down 25 lines when you are in VGA mode, do the following:
ALT-F, D (to shell to DOS)
exit (to get back to the program)
That should clear it unless you have a very old mouse driver.
Time-consuming queries
If your query takes a relatively long time (over 1000 tests), the word WORKING,
followed by a dot '.' for every thousand tests, will appear to let you know
that the computer has not locked up, it is just taking a while to evaluate
the query.
****** IF YOU HAVE A PC XT COMPATIBLE AND/OR NO HARD DISK *****
You may find SSQL a bit slow since every time you process a command, it has
to start SSQLENG. You can use SSQLENG directly which will greatly speed
processing on slow machines. See page INTRO-4 for a brief description of
SSQLENG, page WORD-1 and SCRIPT-1 for some hints to make working with
SSQLENG easier.
Very nice! Thank you for this wonderful archive. I wonder why I found it only now. Long live the BBS file archives!
This is so awesome! 😀 I’d be cool if you could download an entire archive of this at once, though.
But one thing that puzzles me is the “mtswslnkmcjklsdlsbdmMICROSOFT” string. There is an article about it here. It is definitely worth a read: http://www.os2museum.com/wp/mtswslnk/