Answer Posted / pavan

Hi, This answer is with respect Sybase ASE database

# temp-table

A temp table is created with a prefix of #. These are
session specific. That means if user-1 creates some temp
tables with #<some name> and logs out and then logs-in into
the database, he will not be able to see the #<table> which
he created.

Shareable temp-table

In turn, if the user creates tables in tempdb without
any "#" , then the table becomes shareable temp table.
These will remain in tempdb till the ASE is rebooted. If
the user logs-out and then logs-in , even in second
sessioin he can still access these table.

- Pavan

List the types of locking?

1004

---

How do I pipe the output of isql to a file in sybase?

890

---

Tempdb is full. How would you clear it?

889

---

Explanation about replication server software?

944

---

Can I use a named pipe to bcp/dump data out or in in sybase?

1008

---

How do I move tempdb off of the master device?

862

---

Must I use multiple devices to take advantage of partitions in sybase?

925

---

Explain about the features of sybase iq?

975

---

How do I find the oldest open transaction in sybase?

934

---

How would you improve throughput in sybase?

971

---

How to connect sybase database from python?

1047

---

How to view the log files in sybase?

936

---

How to restore sybase database in sap?

966

---

What are the different types of (all page) locks in sybase?

816

---

What is an advantage to using a stored procedure as opposed to passing an sql query from an application ?

926

---