×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

SQLBase SYSADM password

SQLBase SYSADM password

SQLBase SYSADM password

(OP)
A little background on the issue at hand: We have a really old version of ADP running on SQLBase version 7.5.1. I would like to shut down this server, but need the data off. I can login through SQLTalk via the SYSSQL user, but someone has changed the SYSADM password and no one here knows what it might be. I saw one thread where someone said you can dump a single table out using the SYSSQL user but all I have been able to get is the structure.

What options do I have to get this data into a usable format given the predicament that I am in?

Thanks for the help!
James

RE: SQLBase SYSADM password

James
As SYSSQL you can still unload data and/or Schema. Here is the syntax followed by EXAMPLES:



Examples:

Unload the EMP and DEPT (data only) tables in SQL format.
UNLOAD DATA SQL personnel.sql EMP DEPT;
Unload the EMP table (data only) in ASCII format.
UNLOAD ASCII emp.asc EMP;
Unload the EMP table in DIF format. Table and data are unloaded:
UNLOAD DIF table.unl EMP;
Unload all tables and indexes belonging to the user who issues the command:
UNLOAD ALL mytables.uld;
Unload the entire EMPLOYEE database:
UNLOAD DATABASE emp.uld;
UNLOAD COMPRESS DATA SQL db.unl ALL ON SERVER LOG db.log;
UNLOAD SQL table.unl OVERWRITE t1 t2;
UNLOAD COMPRESS DATABASE db.unl ON SERVER; UNLOAD DIF table.unl;
Unload the entire database at the server using a control file located also at the server:
UNLOAD DATABASE CONTROL contrl1.fil ON SERVER;

GuptaSteveL

See us for all Gupta / Centura SQLWindows / SQLBase help at: https://www.banksidesystems.com/

RE: SQLBase SYSADM password

(OP)
Thanks for the reply!

My process is as follows:
I start SQLTalk and click on Session then Connect. I enter the DB, username and password, and then connect. Going back to the main window I am typing in the commands listed. I first tried UNLOAD DATABASE pay4win.uld and got an error saying only SYSADM can do that. So then I tried UNLOAD ALL mytables.uld and it was successful. Looking at the file all I see is ALTER TABLE statements to add primary/foreign keys, no create table statements. I have then tried multiple variations of the first 3 commands to try to dump out 1 table at a time. I get an error saying the table is inaccessible. Am I missing a step in here somewhere? It feels like the SYSSQL user maybe has less access than the default SYSSQL user?

Thanks!
James

RE: SQLBase SYSADM password

James

If you are seeing :

01436 DLU SEC Cannot unload inaccessible table

Reason: Attempt to unload a table without proper privileges.

Remedy: Obtain the required privileges from the table owner(s).


afraid it looks like either DBA auth has been removed from SYSSQL ( some do this for security ) , or
who ever owns the Table/s , has not granted rights to SYSSQL or Public .
Without the owners password in this case , I dont know how you get access to it . sad

Greetings from New Zealand !
GuptaSteveL

See us for all Gupta / Centura SQLWindows / SQLBase help at: https://www.banksidesystems.com/

RE: SQLBase SYSADM password

(OP)
Hi,

Thanks for your help here! I guess we will have to go a different route to get this data.

Thanks!
James

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close