Sybase数据库技术，数据库恢复专家

For EXECUTE IMMEDIATE, the new syntax is:

EXECUTE營MMEDIATE燵爀xecute-option燷爏tring-expression

execute-option:

牋WITH燪UOTES燵燨N爘燨FF燷

|燱ITH燛SCAPES爗燨N爘燨FF爙

| WITH RESULT SET { ON | OFF }

Now, if an EXECUTE IMMEDIATE statement is intended to be used to return a result set, it must be specified as follows:

EXECUTE IMMEDIATE WITH RESULT SET ON string-expression

If the "WITH RESULT SET ON" clause is included, the containing procedure is marked as returning a result set. Failure to include this clause will result in an error being reported when the procedure is called if the statement does produce a result set.

阅读全文...

1 - Connected to a database,

2 - Disconnected from the database,

3 - Connected to a different database

From then on, attempting to display the source to any stored procedure usually displayed source for a different procedure. This problem is now fixed.

- at least 2 MobiLink users were defined, say U1 and U2

- at least 2 publications are defined, say P1 and P2

- there existed some operation O, that affected both P1 and P2

- only U1 had a subscription to P1

- only U2 had a subscription to P2

Under these circumstances, if the subscription U1/P1 was synchronized, followed by the subscription U2/P2, then O may have been uploaded for U1/P1 but not U2/P2. This problem is now fixed and did not occur if the -u switch was used to specify the MobiLink user on the dbmlsync command-line.

阅读全文...

阅读全文...

阅读全文...

running an SQL query is killed.

To reproduce:

1) create a new XML model

2) create a new element (element_1)

3) add three new elements to element(element_1)

(The three new elements branch off the sequence)

4) add several attributes to element_2

NOTE: element_2 now overlaps the other elements

Neither collapsing the sequence, auto-layout, nor redisplay corrects the issue.

The only workaround is to change the orientation from horizontal to vertical

阅读全文...

with 11" in the module 'des_rekeep' together with a stack trace

which includes the modules 'proc__linktopss' and 'lwp_proc_setup'

may be reported in the error log when a client application is

executing a query using "dynamic sql" and the system is configured

with a low value for the configuration parameter "number of

open objects" according to its workload.

and a temporary table has at least one BIT column.

allocation at the same time. The deadlock information will consistently show the deadlock

ccurring on rowid 0 for both spids.

A high value for 揵y Log markers� indicates that Adaptive Server is flushing the ULCs because of

permanent log marker scans (a permanent log marker scan indicate that syslogs includes the log

record). Adaptive Server uses the log records for operations like executing triggers, rollbacks,

aborts, and so on. When Adaptive Server needs a permanent log marker but does not have one, it

flushes the ULC to create a new log marker. When 揵y Log markers� displays a large percentage of ULC

flushes, you may need to reduce the number of unnecessary or redundant triggers, rollbacks, or aborts.

阅读全文...

not be used in a SELECT which is not part of the declaration of a cursor or which is not inside

a stored procedure"

on the same column can choose deferred update mode, when direct update mode is possible.

As a result performance of the UPDATE query can be negatively impacted.

An example query is:

update t1 set c2 = 3 from t1, t2 where t1.c1 in (1,2,3,4,5,6,7,8,9) and t1.c2 = t2.d2

where table t1 is being updated and the query joins tables t1 and t2 and there is a IN-list

on column c1 of table t1.

阅读全文...

Project execution might become unresponsive when database runs out of space.

Resolution:

When a database involved in a data transfer runs out of space, the execution of a project might stop responding. This is because the database driver does not return with an error message but waits until space is available to continue. Please ensure that sufficient space is available before running a project or job.

the engine-wide semaphore is not released, causing all the other kerberos logins on that engine to block.

or earlier, causing ASE crash or blocking all Kerberos logins when there are concurrent Kerberos

authentication attempts.

ASE now supports concurrent Kerberos authentication requests by default.

Trace flag 7844 is no longer needed and can be used if concurrent Kerberos authentications is not required.

阅读全文...