What is Locking in Sybase? What are its types?

dhampack

 Profile Answers by dhampack Questions by dhampack

• Nov 24th, 2008

Sybase does support locking at row level in version 12.5 onwards.Sybase use locking in below modes- Shared- Exclusive- UpdateFor APL(all page locking), sybase locks data as well index pageFor DOL(data only locks) either row level or data page level, sybase use not transactional locking(latches)

rahul.mra

 Profile Answers by rahul.mra Questions by rahul.mra

• Jul 2nd, 2008

Lock: controling access to page In sybase, locking is done at page level (whereas in Oracle, it is at row level).So, suppose if we have a lock (shared lock, write lock) on a page, than we can not access any rows in that page.

Answer Question  Select Best Answer

dhampack

 Profile Answers by dhampack Questions by dhampack

• Nov 24th, 2008

Rowid function is not supported in ASE, it's only supported in Sybase IQ

kay_kannan

 Profile Answers by kay_kannan Questions by kay_kannan

• Sep 3rd, 2008

Select distinct SHORT_NAME, row_id = identity(10) into #tmpPosCust from #tmpPosFinal

Answer Question  Select Best Answer

Copies definitions for specified views, rules, defaults, triggers, procedures, or reports from a database to an operating system file or from an operating system file to a database.

patelg1

 Profile Answers by patelg1 Questions by patelg1

• Oct 30th, 2008

Defncopy is a sybase tool that defines the objective statements such views, triggers, defaults,rules and so on

suji

 Profile Answers by suji Questions by suji

• Jan 8th, 2007

The defncopy utility cannot copy table definitions or reports created with Report Workbench.   Invoke the defncopy program directly from the operating system. defncopy provides a non-interac...

Answer Question  Select Best Answer

samala_naresh

 Profile Answers by samala_naresh Questions by samala_naresh

• Aug 13th, 2008

When you install Adaptive Server, it has single default data cache, with a 2K memory pool, one cache partition and a single spinlock. To improve performance you can add data caches and bind databases...

Answer Question  Select Best Answer

How to lock a table in sybase? give me its text command.

samala_naresh

 Profile Answers by samala_naresh Questions by samala_naresh

• Aug 7th, 2008

lock table table_name in {share | exclusive} mode [wait [no_of_seconds] | nowait]

Answer Question  Select Best Answer

lalifirst

 Profile Answers by lalifirst Questions by lalifirst

• May 13th, 2008

@@errorlog will display the path of log file

srihari

• Oct 23rd, 2007

Cd $SYBASE/$SYBASE_ASE/install

Answer Question  Select Best Answer

Explain What is Update Statistics?

Rashmi121

 Profile Answers by Rashmi121 Questions by Rashmi121

• May 9th, 2008

ASE uses two system tables for maintaining stats on tables for obtimized query and data retrival.systabstats is used on table level and is maintained dynamically while sysstatistics maintains informat...

wramakrishna

 Profile Answers by wramakrishna Questions by wramakrishna

• Mar 26th, 2008

The update statistics command helps the server make the best decisions about which indexes to use when it processes a query, by providing information about the distribution of the key values in the in...

Answer Question  Select Best Answer

amodsv

 Profile Answers by amodsv Questions by amodsv

• Mar 26th, 2008

The numeric and decimal typesare identical in all respects but one: Only numeric types with a scale of 0can be used for the IDENTITY column.

Answer Question  Select Best Answer

supari

 Profile Answers by supari Questions by supari

• Mar 19th, 2008

Shami,Can u elaborate more, in terms of 2 tables A and B if we do a right outer join, how can we use coalesce

shamimaziz

 Profile Answers by shamimaziz Questions by shamimaziz

• Jul 21st, 2007

Coalesce is also available in SybaseThis functions evaluates the listed expressions and returns the first non-null value. If all the expressions are null, coalesce returns nullUSAGE: coalesce(expressi...

Answer Question  Select Best Answer

kurar

 Profile Answers by kurar Questions by kurar

• Mar 9th, 2008

Procedure cache is the memory area where compiled query tree run e.g, procedure, batch query. Data Cache is the memory area where data that is required for the current querys running is bought from Disk on to memory for  building result sets.

Answer Question  Select Best Answer

ssukralia

 Profile Answers by ssukralia Questions by ssukralia

• Dec 3rd, 2007

Absolutely there are numerous features but most important are as follows1. Manages User Connection2. Enforces Business Rules3. Provide Recovery and BackUps4. Understand T-SQL5. Optimize Query Execution6. Maintain Databases with NO Redundancy7. Supports Data and Referential Integritymany more....

shamimaziz

 Profile Answers by shamimaziz Questions by shamimaziz

• Jul 21st, 2007

Sybase ASE 15.0.2:                              &n...

Answer Question  Select Best Answer

ssukralia

 Profile Answers by ssukralia Questions by ssukralia

• Dec 3rd, 2007

Shutdown with wait - wait from other processes to be completed and then shutdown happens.if "shutdown with nowait" - is used then SQL Server immediately shutdown and back to OS promptHope this will help

Shubh

• Oct 23rd, 2007

Ctrl+D works as well...

Answer Question  Select Best Answer

ssukralia

 Profile Answers by ssukralia Questions by ssukralia

• Dec 3rd, 2007

JDBC is a Application programming Interface which helps Java Developers to interact with Database like Sybase via DML Statements (Insert, Update, Delete and so on).

Answer Question  Select Best Answer

sukisudha

 Profile Answers by sukisudha Questions by sukisudha

• Nov 2nd, 2007

Using Open Server, customers can develop middle tier server applications that are transparent to the client, looking like Sybase Adaptive Server Enterprise, easing the complexities involved in develop...

Bessie

 Profile Answers by Bessie Questions by Bessie

• May 5th, 2007

In the context of Sybase open server a library is used for getting requests from client, handling the requests accepted from client and then returning the results back to client or user interface. Sim...

Answer Question  Select Best Answer

Arun

• Sep 8th, 2007

The data that are fetched by the SQL (select statement) is completely fetched from the index itself is called index covering.Example:-- TableA has 10 columns Col1, Col2, Col3, Col4, Col5...-- An index...

Jeevan

• Aug 22nd, 2007

If all the columns in table on which there is?an index are used in the join clause in the same order as it is in the index definition then it is called as index covered.It helps us to improve the per...

Answer Question  Select Best Answer

srihari

• Jul 28th, 2007

Adaptive Server Enterprise is the relational database management software manufactured and sold by Sybase.

Answer Question  Select Best Answer

shamimaziz

 Profile Answers by shamimaziz Questions by shamimaziz

• Jul 21st, 2007

Partition is a old technology helps to access data faster (not actually faster) in almost all the databases. Sybase ASE 15.0 opens up a new possiblity of this. Sybase ASE contains semantic Partioning ...

Answer Question  Select Best Answer

Gary C

• Jul 12th, 2007

In pre sybase 15 all database options will take effect after a use database and checkpoint command is run.For Sybase 15 the option take effect immediately since all sp_dboption commands have an automatic checkpoint.

Answer Question  Select Best Answer

Ganapathi Masilamani

• Jul 5th, 2007

Live table will be created using: 1. Create table ( column name datatype ) 2. Select * into from e-x: select * into new_emp from emp Temp Table will be created using: 1. Create table ...

Answer Question  Select Best Answer

Ganapathi M

• Jul 5th, 2007

1. Select * from .. 2. Use
go

Tanu

• Apr 15th, 2007

Use databasenamego will switch to database you have specified.

Answer Question  Select Best Answer