SAP ASE 16.0 SP03 PL02Please see the simple select statement that uses "rows limit"
1> select id from sysobjects order by 1 desc rows limit 102> go id ----------- 2146103655 2085579437 1954102971 1909578810 ...
sp-sysmon-with-cpu-full.txt
Hi,
I am looking at the sp_sysmon log from one of my customer who is running SAP BW on SAP ASE.
SAP ASE 15.7 SP133Windows 2008 R2
The ASE and NetWeaver 7.3 are running on a virtual Windows environment.N...
Hello,
SAP ASE 16.0 SP03 PL02
1> declare @t table (a int)2> insert into @t values (10)3> select * from (select * from @t) t4> go(1 row affected)Msg 225, Level 16, State 1:Server 'ASE1603', Line 3:Cannot run query--referenced object (name NAME ...
Hello,
Running "insert into @table_variable select * from @table_variable" causes CPU 100% and heavy writes to tempdb.It does not return response for a few minutes and finally ends up with tempdb log full.
ASE 16.0 SP03 PL02
...
Hello,
Does global temporary table support "default" and constraint?
I defined default value on a column in global temporary table on ASE 16.0 SP03 PL02, but it does not work.I added check constraint on another column, but the constraint is ignor...
Hi Ryan,
I reported it to SAP Support and they confirmed the behavior reproduces.
They registered this as KBA 2484644 - SQLDriverConnectW() may fail to connect ASE due to a 10351 error - SAP SDK
CR 808692 was made but it still seems to be o...
I answer to my own question.
I found similar topic at KBA:2150485 - Empty string and a space character are treated as equal - SAP IQ
In SAP IQ, empty string and blank are treated as equal.
Suppose you have a table containing both empty string a...