-
What is defncopy and it's usage.
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
- Oct 30th, 2008
Defncopy is a sybase tool that defines the objective statements such views, triggers, defaults,rules and so on
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...
-
-
Why can a user create 249 non clustered indexes over a given table as against only one clustered index over a table?
rachitkhanna1981
- Sep 1st, 2009
When 1 clustered index is being formed on a table then the values when entered into the table have to be in the same form or there would be an error message whereas nothing of this sort is being used in non clustered index therefore more then 1 could be created.
harish_varghese
- Jun 11th, 2007
With a clustered index, Adaptive Server sorts rows on an ongoing basis so that their physical order is the same as their logical (indexed) order. Since we can maintain data in any one order only, there can be only one clustered index per table as against 249 non-clustered indexes.
-
What is a Coalesce? What is the equivalent of Oracle/Db2 Coalesce Function in Sybase
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
- 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...
-
How to check the long running transaction ?
mikeob
- Jun 17th, 2009
In addition to syslogshold one can look at master.sysprocess and the physical_io. If this is large (several hundred thousand) you are probably looking at a query doing a table scan. syslogshold tends to only store teh *longest*.
srihari
- Jul 8th, 2007
Select * from syslogshold
-
How to view the log files in sybase
srihari
- Oct 23rd, 2007
Cd $SYBASE/$SYBASE_ASE/install
-
Update Statistics
Explain What is Update Statistics?
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
- 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...
-
Locking in Sybase
What is Locking in Sybase? What are its types?
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
- 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.
-
Db Space
How do you check db space and what are the measures available to increase the db space?
subind123
- Mar 4th, 2011
Measure available to increase the DB space:1) Drop objects which are no longer used.2) Run alter database command to increase database size.
nagaraju_p
- Sep 9th, 2009
Sp_helpdb gives information about memory used and available.sp_spaceused - gives space used..
-
Sybase ASE server Display the number value in Words
I need to convert a "check amount" to a "written out amount in english", for check printing.
Ex) $ 582.71 ---> Five hundred eighty two and 71 cents
-
What are the mandatory options required for BCP command utility?
srihari
- Jun 25th, 2007
usage: dataserver valid options are: -a caps_file - path to CAPs directive file -b [size_spec] - master device size specifier -c config_file - config file for server -D [size_spec] - default dat...
keerthv
- Jun 14th, 2007
Hi,Thanks, Where can i see this format file?What are 2 typesof bcp? When can i use them?Regards,keerthv
-
Views 'with check' Option
What is the use of 'with check' option in views?
Tejas More
- Jul 7th, 2011
The with check option flag prevents insertion or updating of rows that will not meet the view criteria. e.g.: create view cal_publishers_chk as ...
dhampack
- Nov 24th, 2008
When you create a view using the with check option clause, each insert and update through the view, is validated against the views selection criteria. If the rows inserted or updated are out of cri...
-
What is Sybase SQL Server?
neo.sql
- Sep 10th, 2011
Sybase SQL Server is the RDBMS developed by Sybase Inc (now an SAP company) which is now called as Sybase Adaptive Server Enterprise is the enterprise version and a flagship product of Sybase. Another...
luisgranados
- May 20th, 2011
Is the original name for the product we know today as Adaptive Server Enterprise.Sybase SQL Server name was changed since version 11.5 because they wanted to differentiate the product from Microsoft.
-
What is Open Server in Sybase?
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
- 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...
-
What is the major differences between Oracle & Sybase
chrisjej
- Jun 23rd, 2010
I would point out that the above answers are point in time - and any answer should mention the versions involved. Sybase is a company - not a database server, by the way. The question should be asking...
tuliothx
- Jul 5th, 2008
Let me clarify that while Sybase does not have "Object Tables" it can hold BLOBS in columns in tables. These can be of datatype TEXT or IMAGE.Sybase has the concept of Temporary tables in the form of ...
-
How to clear the logsegment when the Secondary truncation point is on ?
luisgranados
- May 20th, 2011
I suppose you want to do that because you refresh the database to a development/QA environment and you no longer need the replication to be working.So you just need to disable the secondary truncation...
dhampack
- Nov 24th, 2008
There are only two options to clear the log1) Kill the tran which is filling up the log2) Extend the transaction log to complete the transaction.don't use 'dump with truncate_only' if you ...
-
How can you change to get the decimal separator as comma instead of the decimal point (.)?
protech
- Jul 15th, 2010
declare @mod_string varchar(20)select @mod_string = str_replace("1234.567",".",",")select @mod_string
debadritab
- Jun 24th, 2008
declare @source varchar(30)
select @source = "10.236.155.17"
while charindex(".",@source) > 0
begin
select @source = stuff(@source,charindex(".",@source),1,",")
end
select @source -
How to find out the maximum sales of an item for each sales man.The table consists sales_man, item, sales columns, each sales man will have the different sales values for different items.here I have to find out for every sales man, which item he sold maximum
nagaraju_p
- Sep 9th, 2009
Select a.sales_person, a.item, a.TotalQuantityFROM (select b.sales_person,b.item,SUM(b.InvAmount ) as TotalQuantity from sales_data bGroup by b.sales_person,b.item)as aGROUP BY a.sales_personHAVING a.TotalQuantity = MAX(a.TotalQuantity )
swadheengupta
- Sep 8th, 2008
Assuming that both the items are required to be shown if two or more items are sold of same quantity. The query is :-select sales_man,item,sales from table where (sales_man,sales) in? (select sales_man,max(sales) from table group by sales_man);
-
How to clear tempdb when the tempdb gets filled?
dychandran
- Oct 6th, 2010
We may need to identify the Culprit Spid Which is casuing the Tempdb to filled up and confirm about the is that ok to kill it and clear the log.use dbcc log - Commad to identify the Cuprit Spid.dbcc logPurpose: displays transaction log records.
jaya
- Nov 24th, 2007
Dump tran with truncate_only if it is not cleared the go for select lct_admin("abort", {process_id [, database_id]})
-
How to find row id in sybase
kay_kannan
- Sep 3rd, 2008
Select distinct SHORT_NAME, row_id = identity(10) into #tmpPosCust from #tmpPosFinal
Sybase Interview Questions
Ans