ISQL on a sybase SQLAnywhere db

[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.
erikleeAsked:
Who is Participating?
 
jbiswasConnect With a Mentor Commented:
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
 
erikleeAuthor Commented:
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
 
erikleeAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.