What do you mean by Stable Device in Sybase replication?
Latest Answer: I think the textbook term is 'stable queue' - the place on disk where transacitons/data is stored until it reaches its destination(s). Plays the role of a ledger file in JMS/Tibco. ...
What are the default size of master database in sybase ?
Latest Answer: The default size of a master database in sybase is 6MB for a 2K page size Adaptive server. ...
How will you purge data from audit database?
Latest Answer: To back up sysaudits_0n, set up a threshold which, when triggered, copies its contents into a permanent table and uses sp_configure to set the new active audit table to sysaudits_0(n+1). This will get the data into a more persistent location. From there ...
How is Workspace used in Sybase?
Latest Answer: I think it needs clarification. The only 'workspace' that comes to my mind here is a *.ws file from Sybase Power Designer. In that case a workspace serves as a container for physical, logical ERDs and reports, etc. ...
What is the use of 'with check' option in views?
Latest Answer: When you create a view using the with check option clause, each insert and update through the view, is validated against the view’s selection criteria. If the rows inserted or updated are out of criteria then it fails and gives error message. For ex, ...
How we can add a NotNull Column in a table by using alter command (without using default command)?
Latest Answer: First add the column as NULL. Then populate the column with non-null data. Then modify the column to NOT NULL. You may need to set dboption "select into" to True. ...
how to lock a table in sybase? give me its text command.
Latest Answer: lock table table_name in {share | exclusive} mode [wait [no_of_seconds] | nowait] ...
Latest Answer: declare @var intselect @var = 1update set @var = @var*< colname >select @var ...
What is Locking in Sybase? What are its types?
Latest Answer: 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 ...
Latest Answer: Rowid function is not supported in ASE, it's only supported in Sybase IQ ...
View page [1] 2 3 4 5 6 7 Next >>
Go Top
