[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

ISQL on a sybase SQLAnywhere db

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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

An overview of cyber security, cyber crime, and personal protection against hackers. Includes a brief summary of the Equifax breach and why everyone should be aware of it. Other subjects include: how cyber security has failed to advance with technol…
If something goes wrong with Exchange, your IT resources are in trouble.All Exchange server migration processes are not designed to be identical and though migrating email from on-premises Exchange mailbox to Cloud’s Office 365 is relatively simple…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

649 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