Solved

ISQL on a sybase SQLAnywhere db

Posted on 1998-03-05
3
539 Views
Last Modified: 2008-03-10
[1] sometimes the following don't work
.............load table xyz from 'c:\data\xyz.dat'
i have to use
.............load table "DBA.xyz"  from 'c:\data\xyz.dat'

[2] can u throw some light on connecting to Server/engine and database and/or datafiles. Sometimes i get the following on ISQL "connect using "uid=xxx;pwd=yyy;DBN=aaa;ENG=bbb"
i thought i 'd already connected using one of the connect profiles.
0
Comment
Question by:eriklee
  • 2
3 Comments
 
LVL 2

Accepted Solution

by:
jbiswas earned 40 total points
ID: 1098353
Answer1. If you login through Sybase Central using a dba userid , you do not have to mention the "dba"."table_name". For any other userid you have to use the dba in front of the tablename.

Answer2. I have seen this too and my analysis of this has been:
Either I have disconnected from the database by mistake or the connection has timed out(configurable parameter) or I have multiple databases open in Sybase Central. If multiple databases are open I think isql gets confused, not knowing which session to open(I mean connect to which database).
0
 

Author Comment

by:eriklee
ID: 1098354
added some points.  Sorry Biswas, i just verified your answer as i was away on holiday. Thanks for answering.

The "DBA"."table" stuff just don't seem to be logical. I am logged on as 'dba'. And 'dba' created all the tables i.e if u look at the properties of the table -- it says creator = 'dba'.
Yet only one of the table won't work with the SELECT statement
( i have to use SELECT * from "DBA"."schedule" to run. Yep, only this one table..)


0
 

Author Comment

by:eriklee
ID: 1098355
sorry biswas - i just realised this question was ungraded but happy to give u the points as u are the reliable sybase gooroo.

The reason I was having the above problem is - one of the table name 'schedule' is actually a RESERVED word. I think sybase sqlanywhere should have given warnings.

Thanks.
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In previous parts of this Nano Server deployment series, we learned how to create, deploy and configure Nano Server as a Hyper-V host. In this part, we will look for a clustering option. We will create a Hyper-V cluster of 3 Nano Server host nodes w…
The Windows functions GetTickCount and timeGetTime retrieve the number of milliseconds since the system was started. However, the value is stored in a DWORD, which means that it wraps around to zero every 49.7 days. This article shows how to solve t…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

680 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question