The ASE support team is looking for feedback on potential training on SAP ASE; things you would like to know more about that goes beyond a simple question and answer on SCN.If you've ever found yourself thinking all you needed to understand some ASE ...
A serious bug has been found in 15.7 SP133 and higher (currently SP134 is the only higher release).The problem is seen when (or after) loading a transaction log dump that contains log records for a reorg rebuild with online command. The known sympto...
ASE 15.7 SP133 was released last week, but included the wrong version (OCS SP132) of the OCS (Open Client) component subdirectory.SP133 has been removed from the download site and will be re-released as SP134 with the correct OCS component later this...
Hi Jose,No, usually dump and load is all you need.The issue being discussed occurs when the migration is between big-endian and little-endian systems.The byte order of various multi-byte datatypes (like smallint, int, timestamp) differ betweenthese s...
Yes, the output does look like you are logged into a SAP Sybase ASE server.It does not look like the CREATE DATABASE SampleDB was successful - but if any error was returned, it isn't shown in these screenshots. We can ignore that for the moment, how...
Hi harsha310890,A few reactions...First off, asking your client would seem to be the most direct way to get the best answer. For ASE, the most likely thing this .db file would be is a dump file, to be loaded using the LOAD DATABASE command. However...
Hi Jose,It doesn't appear to be necessary:1> create table fictionsales (store_id int not null, order_num int not null, date datetime not null)partition by range (date) (q1 values <= ("3/31/2004"), q2 values <= ("6/3...
Yes.
In a wider context, I would expect <session page> and <session row> to always refer to a BEGINXACT log record row, while <logpage> and <logrow> could be used to refer to other
types of log records as well depending on what we were looking at.
...
