[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

ISQL on a sybase SQLAnywhere db

Posted on 1998-03-05
3
Medium Priority
?
573 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 120 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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
LinkedIn blogging is great for networking, building up an audience, and expanding your influence as well. However, if you want to achieve these results, you need to work really hard to make your post worth liking and sharing. Here are 4 tips that ca…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses
Course of the Month20 days, 2 hours left to enroll

872 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