?
Solved

ISQL on a sybase SQLAnywhere db

Posted on 1998-03-05
3
Medium Priority
?
556 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

Question has a verified solution.

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

The Summer 2017 Scholarship Winners have been announced!
In this modest contribution, I want to share with the IT community (especially system administrators, IT Support Engineers and IT Help Desks) about Windows crashes/hangs and how to deal with these particular problems.
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

771 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