tsql _SYSTEM password

Post Reply
resume.robot
Posts: 68
Joined: Sat Jan 13, 2001 1:23 am

tsql _SYSTEM password

Post by resume.robot »

Attempting to add a user in a db created with gw. No users have ever been added.

/tsql "select * from SYSUSERS";
Texis Version 03.01.962147411(20000627) Copyright (c) 1988-2000 Thunderstone EPI

U_NAME U_UID U_GID U_PASSWD
------------+------------+------------+------------+
_SYSTEM 0 0
PUBLIC 9999 9999


Texis manual on tsql says

the _SYSTEM password (empty string by default).


Entering an empty string for password produced the following error:



/tsql -a A nuts
Texis Version 03.01.962147411(20000627) Copyright (c) 1988-2000 Thunderstone EPI

_SYSTEM Password:
000 Could not open SYSTABLES in the function ddopen
002 Could not open database . in the function administer
nuts:/export/usr/rr>/tsql "select * from SYSUSERS";
Texis Version 03.01.962147411(20000627) Copyright (c) 1988-2000 Thunderstone EPI

000 Could not open SYSTABLES in the function ddopen
000 Couldn't connect to . in the function SQLConnect


Is this a bad password or a bad statement?
User avatar
mark
Site Admin
Posts: 5519
Joined: Tue Apr 25, 2000 6:56 pm

tsql _SYSTEM password

Post by mark »

Since your first and last tsql SQL statements are the same and the first worked and the last didn't I must surmise that you were not in the correct directory except the first time. Make sure you are in the database directory or supply the -d option with the path to the database.
resume.robot
Posts: 68
Joined: Sat Jan 13, 2001 1:23 am

tsql _SYSTEM password

Post by resume.robot »

Thanks, it worked -- I thought I was in the correct directory the first time but I guess not.

Is there a list of tsql commands or a specific tutorial? Or, which sql program is most similar?

For example, "show" and "describe" (mysql) do not seem to work.
Post Reply