tsql [-a command] [-c [-w width]] [-l rows] [-hqm?] [-d database]
[-u username] [-p password] [-i file] ["SQL statement"]
Tsql is the main program provided for interactive use of a Texis database. You should either be in the database directory, or else specify it on the command line as the -d <database> option.
If a query is present on the command line than tsql will execute that statement, and display the results on stdout (the screen). If no query is present then queries will be accepted on stdin (the keyboard). Queries on stdin must be terminated by a semicolon. To exit from tsql you should produce EOF on it's stdin. On Unix systems this is usually done with Control-D, and on Windows with Control-Z.
Tsql also provides facilities for doing many administrative tasks.
To aid in the use of tsql from scripts or as parts of a chain of commands there are many options available. The options are
There are three administration commands, add, change and delete. Add is used to add a user. You will need to run this as an operating system user with write permissions to SYSUSERS. The user-id and group-id should be numbers in the range 1-9998. User-id 0 is reserved for _SYSTEM, who has full access to the database. User-id 9999 is reserved for PUBLIC. Any permissions granted to PUBLIC will also be granted to all users on the system.
To Delete a user you need to supply the users name and the _SYSTEM password (empty string by default). The current version of delete will not remove the users tables of permissions, so if you create a new user with the same user-id they will inherit the old users permissions.
Change is used to change a password. You will be prompted for the new password. You must supply either your old password, or the _SYSTEM password. This allows the DBA to change passwords if needed.
If you are planning on using the Texis permission scheme then you should change the _SYSTEM and PUBLIC passwords as one of the first tasks after creating the database.