远程Sybase数据库技术支持,联系手机:13811580958,QQ:289965371!

 

随着Sybase被完全整合到SAP下,Sybase原来的支持网站被SAP Support Portal取代。
只有购买了SAP服务的用户才能使用账号登录SAP Support Portal进行介质下载、补丁升级、报Incident等。
考虑到Sybase数据库的初学者或者没有购买原厂服务的Sybase客户情况,现提供SAP ASE/IQ/RS/SDK/SQL Anywhere/PB等产品的BUG信息。
在SAP Support Portal网站或者google上搜索Targeted CR List for ASE,可以看到针对不同版本的CR(CR表示Change Request)简单描述信息列表。
需要注意的是:Targeted CR List for ASE列出的CR虽然绝大多数是BUG,但有一些是更改需求。
以下提供SAP ASE/IQ/RS/SDK/SQL Anywhere/PB等产品的BUG信息!

如有问题,请联系我!

QQ :289965371 点击这里给我发消息
Email:
不仅仅包括BUG的详细描述信息,还包括首次报告BUG的平台、数据库版本以及BUG修复历史过程;有些BUG还提供了Workaround来临时解决该BUG带来问题。

 

CR:307981
CR Number:   307981
Product Name:   OpenSwitch
Product Component:   RCM
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Jun 2003 Fixed
Description
RCM should allow for different primary and standby database names



CR:308149
CR Number:   308149
Product Name:   Open ClientCONNECT for CICS
Product Component:   Open ClientCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5 12 Mar 2003 Fixed
Description
TDS Version hardcoded in TDINIT affecting Mixed Mode Program connecting to ASE 12.5.

ASE 12.5 cannot handle a 4.6 tds stream in a mixed mode program the ctx handle from OSC is used and the TDS version is hardcoded to version 4.6.



CR:308202
CR Number:   308202
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Mar 2004 Presently Not Targeted For Any Future Release Of This Product
09 Sep 2010 Duplicate
Description
Customer wants to redirect output from within ISQL
Review Status
 Reviewed Aug 2003. This CR is currently not targeted for a fix.
Workaround Description
 Use redirection or -o option.



CR:308409
CR Number:   308409
Product Name:   Open ServerCONNECT for CICS
Product Component:   tcp/ip
Status:   Closed
OS:   MVS
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Aug 2003 Fixed
Description
12.5.1 Context handler ASRA, when the region is put under Load.



CR:308438
CR Number:   308438
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   HP-UX
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 May 2003 Fixed
Description
OpenSwitch crashes after failing to close a connection with errors:

thrd__ct_close: Connection busy, ct_close(CS_UNUSED) failed

thrd__ct_con_drop: ct_con_drop() failed



CR:308533
CR Number:   308533
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Generic
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5 07 Feb 2003 Fixed
Description
If CONNECT_TIMEOUT is not explicitly set, CS_TIMEOUT will be set to 60 seconds. It should be left unset so that we can default to the OpenServer default, which is infinity.



CR:308551
CR Number:   308551
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.2 19 Feb 2003 Fixed
5.5 19 Feb 2003 Fixed
Description
jConnect now properly reads data from the server when the server sends back interspersed Exceptions and Warnings. Previously, jConnect could misread this kind of data, resulting in JZ0EM (end-of-data) exceptions being erroneously thrown.



This issue would show up when a client used a command such as 'set statistics io, time on', which results in query-processing statistics being sent to the client as SQLWarning messages.



CR:308868
CR Number:   308868
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.2 19 Feb 2003 Fixed
5.5 19 Feb 2003 Fixed
5.5 19 Feb 2003 Fixed
Description
jConnect now properly processes groups of Warnings and results when they come back as part of a cursor fetch. Previouly, jConnect was in certain cases prematurely reporting the end of a ResultSet when a Warning came back as part of a cursor fetch.



CR:309380
CR Number:   309380
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Open
OS:   Microsoft Windows
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Sep 2012 EOL'd version. Not to be Fixed.
Description
BCP IN to UTF-8 server fails to convert SJIS Roman numerals properly.



CR:309514
CR Number:   309514
Product Name:   Open ServerCONNECT for CICS
Product Component:   tcp/ip
Status:   Closed
OS:   MVS
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Mar 2003 Fixed
Description
CICSPING returning the wrong Version String for the EBF10522



CR:309542
CR Number:   309542
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Feb 2004 Fixed
30 Jun 2003 Fixed
26 Aug 2003 Fixed
21 Aug 2003 Fixed
28 Oct 2003 Presently Not Targeted For Any Future Release Of This Product
Description
CPRE: An ESQL/C application continuously creating new threads to connect and disconnect to ASE may show an increase in using memory. 'EXEC SQL THREAD_EXIT' can be used before the end of a thread to help to reduce the memory consumption.



CR:309605
CR Number:   309605
Product Name:   ESQL
Product Component:   Cobol
Status:   Open
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Feb 2004 EOL'd version. Not to be Fixed.
Description
64 bit ESQL Cobol does not work on Solaris 2.8. It fails

with error code: 114, pc=0, call=1, seg=0

114 Attempt to access item beyond bounds of memory (Signal 10)
Target Version
 To Be Determined
Review Status
 Reviewed Aug 2003. No plans yet to release a 64 bit version of ESQL/COBOL.



CR:309691
CR Number:   309691
Product Name:   Open ServerCONNECT for CICS
Product Component:   tcp/ip
Status:   Closed
OS:   MVS
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Aug 2003 Fixed
Description
OSC when Starting Transactions uses the Default Prefix of "DF", for TSQ



CR:309809
CR Number:   309809
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   AIX
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Feb 2003 Duplicate
Description
AIX client, either isql, isql_r or user written program gets a segv after using SSL connectivity when the program exits (returns to the OS command prompt). The same program not using SSL (omit the SSL from the interfaces entry for the client and server) will run successfully.



CR:309971
CR Number:   309971
Product Name:   Open ClientCONNECT for CICS
Product Component:   Open ClientCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   4.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Oct 2012 EOL'd version. Not to be Fixed.
Description
Customer is asking for a way to track the users using there OCC applications. So we need to add logging and/or tracking of some sort in to OCC. Need to get more details from the customer on what they need.



CR:309975
CR Number:   309975
Product Name:   Open ClientCONNECT for CICS
Product Component:   Open ClientCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   4.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Mar 2008 Insufficient priority to fix
Description
Customer would like an API interface added to OCC/OSC so that they call the API VIA NATURAL which uses the CICS TWA an PPT not the REGister 1 calling convention.



CR:310107
CR Number:   310107
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   NA
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Mar 2003 Fixed
24 Mar 2003 Fixed
18 Apr 2003 Fixed
Description
SRVLIB: Open Server crashes with Signal BUS after repeated cursor errors are processed.



CR:310691
CR Number:   310691
Product Name:   OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5 01 Apr 2003 Fixed
Description
OLEDB: Using Multiple Recordsets with ADO and Sybase ASE OLE DB Provider generates:

'The Instruction at "0x100403de" feferenced memory at "0x000001ec". The memory could not be "read".' This has been fixed in version 02.70.0016



CR:310716
CR Number:   310716
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   NA
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Mar 2003 Duplicate
Description
CTLIB: ct_results may hang if ct_cancel(CS_CANCEL_ATTN) is called before any pending result is retrieved.
Workaround Description
 Return CS_FAIL from the message callback.



CR:310901
CR Number:   310901
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Mar 2005 Fixed
Description
jConnect: Request to have support for ASE password encryption.



CR:310972
CR Number:   310972
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Generic
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Jul 2003 Fixed
12 Aug 2003 Fixed
25 Jul 2003 Fixed
Description
If a non-zero value is passed as a second parameter to 'rp_dump', rp_dump not only does not channel the dump output to the log file as documented, but also cause 'NULL SRVPROC' error messages to be printed in the error log.



CR:311265
CR Number:   311265
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Apr 2003 Fixed
07 Apr 2003 Duplicate
Description
OpenSwitch does not return the correct TDS status for failed commands.

It returned CS_CMD_SUCCEED when it should have returned CS_CMD_FAILED.



CR:311302
CR Number:   311302
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   NA
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
XAER_RMERR returned during ASE crash test in client app using SybXAResource class. For dead connection RM is unavailable and XAER_RMFAIL would be more suitable for this condition. Please investigate if this could be changed.



CR:311671
CR Number:   311671
Product Name:   Open Client
Product Component:   blklib
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Mar 2003 Fixed
12 Mar 2003 Fixed
Description
BLKLIB: blk_init() failed when using CS_DEFER_IO or CS_ASYNC_IO



CR:311844
CR Number:   311844
Product Name:   Open ClientCONNECT for CICS
Product Component:   Open ClientCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Aug 2003 Fixed
Description
Incorrect padding on array Receive when using Numeric to Packed decimal conversion.



CR:312022
CR Number:   312022
Product Name:   Open Client
Product Component:   blklib
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Apr 2003 Fixed
07 May 2003 Fixed
16 Jun 2003 Fixed
Description
BCP: bcp sends unnecessary attentions while retrieving the table format which, very occasionally, may cause hangs with some versions of ASE.
Workaround Description
 N/A



CR:312057
CR Number:   312057
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Mar 2003 Fixed
31 Mar 2003 Fixed
Description
SRVLIB: In the reentrant libraries, open server raised error 16331 whenever a site handler connection completes.



CR:312953
CR Number:   312953
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Apr 2003 Fixed
Description
ODBC: Numeric parameters preceded by char parameters would display as char datatypes when the metadata information for the parameters was not provided in an ADO application. What happened was the ODBC Driver would call SQLProcedureColumns to gather datatype information, but the driver was not indicating NUMERIC for the NUMERIC datatypes. It would indicate their types as CHAR.



CR:313052
CR Number:   313052
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Mar 2003 Fixed
28 Jul 2003 Presently Not Targeted For Any Future Release Of This Product
Description
CTLIB: ct_cancel can cause a stack trace when called after ct_fetch returns value != CS_SUCCEED.
Workaround Description
 Use 12.0 client libraries, use -Vc option instead of the "message integrity" options.



CR:313067
CR Number:   313067
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Mar 2003 Fixed
02 Apr 2003 Presently Not Targeted For Any Future Release Of This Product
02 Apr 2003 Fixed
Description
CTBCP: bcp does not allow batch size of 1 (-b1), it changes it to 10.
Workaround Description
 Revert to bcp from ESD#3.



CR:313316
CR Number:   313316
Product Name:   Open Client
Product Component:   dblib
Status:   Closed
OS:   AIX
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Feb 2004 EOL'd version. Not to be Fixed.
Description
DBLIB: Make file in the db-lib sample directory doesn't contain support for 64 bit AIX



CR:313490
CR Number:   313490
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 May 2003 Fixed
Description
Need documentation about temporary tables and connection caching



CR:313493
CR Number:   313493
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 May 2003 Fixed
Description
Need to document required patches for HPUX: PHNE_28089

for HPUX 11.11 and PHNE_28538 for 11.00.



CR:313533
CR Number:   313533
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 May 2003 Fixed
Description
Connection cache fails to accept command for second connection



CR:313620
CR Number:   313620
Product Name:   OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jun 2003 Fixed
Description
OLEDB: Command Timeout (oCmd.Properties.Item("Command Time Out").Value) gives twice the expected delay.
Workaround Description
 Use half values expected.



CR:313737
CR Number:   313737
Product Name:   jConnect
Product Component:   jtds
Status:   Closed
OS:   NA
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Apr 2003 Fixed
14 Apr 2003 Fixed
Description
The jTDS open server now can send and receive the new date and time datatypes.



CR:313841
CR Number:   313841
Product Name:   ESQL
Product Component:   C
Status:   Closed
OS:   SunOS
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Apr 2003 Fixed
06 Nov 2003 Fixed
Description
ESQL: cpre might generate core dumps when compiling source code using "typedef" structures.
Workaround Description
 Break the functions out of a single .cp file and

place them each in their own .cp file.



CR:314008
CR Number:   314008
Product Name:   OpenSwitch
Product Component:   RCM
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Oct 2003 Presently Not Targeted For Any Future Release Of This Product
Description
Incorrect installation instructions in Bulletin Replication Coordination Module



CR:314062
CR Number:   314062
Product Name:   OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Jun 2003 Fixed
Description
OLEDB: Query with Outer Joins produces error in OLEDB Provider:

Syntax error at token 'ON', line 1 offset 46.
Workaround Description
 Use ODBC Driver instead.



CR:314065
CR Number:   314065
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Apr 2003 Fixed
Description
ODBC: Using the "execute" keyword to execute stored procedures in ADO or ODBC applications causes the CommandTimeout to fail. Instead of timing out the driver will cause an infinite loop based on the timeout value.



CR:314085
CR Number:   314085
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Apr 2005 Fixed
04 Aug 2003 Fixed
Description
Make CMON_USER/CMON_PASSWORD configurable at SERVER and CONFIG levels.



CR:314352
CR Number:   314352
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 May 2003 Duplicate
Description
OpenSwitch 12.5 installer should define SYBASE_OCS in SYBASE.csh



CR:314354
CR Number:   314354
Product Name:   ESQL
Product Component:   C
Status:   Closed
OS:   AIX
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Apr 2003 Duplicate
Description
CPRE: -KSYMANTIC check might generate core dumps.



CR:314688
CR Number:   314688
Product Name:   ESQL
Product Component:   C
Status:   Closed
OS:   AIX
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Apr 2003 Duplicate
Description
CPRE: cpre might generate incorrect codes when host variables are in a structure.
Workaround Description
 There is no real workaround as the customer has other problems that are only fixed on later versions.



CR:314694
CR Number:   314694
Product Name:   ESQL
Product Component:   C
Status:   Closed
OS:   AIX
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Apr 2003 Duplicate
Description
ESQL/C: cpre might generate error "M_INTERNAL_ERROR" when the soure code uses typedef structure in the include files.
Workaround Description
 Could use GA if this was the only problem. Unfortunately, too many other problems needing higher rev. level.



CR:314700
CR Number:   314700
Product Name:   Open ServerCONNECT for CICS
Product Component:   tcp/ip
Status:   Closed
OS:   MVS
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5 11 Aug 2003 Fixed
Description
Context handler needs to handle transactions that are disabled



CR:314704
CR Number:   314704
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Oct 2004 Fixed
Description
jConnect: The getImportedKeys, getExportedKeys and getCrossReference methods return results in an order not consistent with the JDBC specification.
Workaround Description
 As a workaround the cusotmer can make the changes to sp_jdbc_fkeys:



Change the ordering (commented out lines ar ethe original line) - like this - there are 3 places near the end of the script to make this change:



/* order by fktable_name,fktable_own



CR:314726
CR Number:   314726
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jun 2003 Fixed
Description
ODBC: Output parameter not displayed when raiserror is involved in a stored procedure.
Workaround Description
 There is none with the current ODBC drivers



CR:314780
CR Number:   314780
Product Name:   Open Client
Product Component:   blklib
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Mar 2004 EOL'd version. Not to be Fixed.
24 Dec 2004 Presently Not Targeted For Any Future Release Of This Product
Description
BCP: Does not validate input data file for correct number of data fields.
Review Status
 Reviewed Aug 2003. No fix targeted at this time.
Workaround Description
 Write own validation code with BLK-Lib or UNIX scripts.



CR:314811
CR Number:   314811
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Aug 2013 Duplicate
Description
Request for bcp like utility based on JDBC API
Target Version
 To Be Determined
Review Status
 Reviewed Aug 2003. Fix to CR may be considered for a future release, but is currently not targeted for an upcoming release.



CR:314836
CR Number:   314836
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.2 14 Apr 2003 Fixed
5.5 14 Apr 2003 Fixed
Description
jConnect now caches the results of calls to ResultSetMetaData.getColumnTypeName(int). This caching can lead to significant performance improvements for applications which call the getColumnTypeName method frequently.



CR:314909
CR Number:   314909
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.2 14 Apr 2003 Fixed
5.5 14 Apr 2003 Fixed
Description
jConnect now uses the canonical charset name when doing byte-to-character and character-to-byte conversion. This change will give jConnect users a significant performance benefit, particularly users who execute lots of queries, or who do a large amount of String processing from the database (i.e. calling the ResultSet.getString method).



This fix is a workaround for a java bug described in the following location:



http://developer.java.sun.com/developer/bugParade/bugs/4623303.html



For more information on canonical charset names, see this document:



http://java.sun.com/products/jdk/1.2/docs/guide/internat/encoding.doc.html



CR:314990
CR Number:   314990
Product Name:   jConnect
Product Component:   jtds
Status:   Closed
OS:   NA
Original Version:   4.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Apr 2003 Fixed
14 Apr 2003 Fixed
Description
The jTDS openserver now properly sends pass-thru widetable results to clients that don't support widetable. In these cases, jTDS will convert the results to a format that can be understood by older clients that don't support widetable functionality.



CR:315029
CR Number:   315029
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   AIX
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jun 2003 Duplicate
Description
On 12.0 openserver threaded libraries, signal handling in the openserver appears to be broken on AIX. After installing a signal for sigalrm, a call to alarm() out of his handler and the process is then blocked. No logins are permitted once the signal handler is called.
Workaround Description
 No workaround if 12.0 and threaded are required as is the case with this customer. He is not doing the desired alarm handling in his application til the problem is fixed.



CR:315086
CR Number:   315086
Product Name:   OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jun 2003 Fixed
Description
OLEDB: OLE-DB fails to return EED errors from stored procedures unless there is at least one result set. Instead the application gets "One of more errors occurred while processing the command"
Workaround Description
 Ensure sproc returns at least 1 resultSet.



CR:315113
CR Number:   315113
Product Name:   OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jun 2003 Fixed
Description
OLEDB: INTEGER output parameter is always zero if Parameter object Size = -1 in CreateParameter.



CR:315391
CR Number:   315391
Product Name:   OpenSwitch
Product Component:   RCM
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5 23 Jun 2003 Fixed
Description
Sample rcm_oswitch.cfg file needs COORD_MODE set to ALWAYS
Workaround Description
 CHANGE COORD_MODE=ALWAYS



CR:315393
CR Number:   315393
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 May 2003 Fixed
Description
Need to add all new configurable options like CMON_USER to OpenSwitch.cfg file
Workaround Description
 Add these values manually.



CR:315394
CR Number:   315394
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 May 2003 Fixed
Description
The automatic configuration option during install should prompt for CMON values
Workaround Description
 Add these values manually after the installation.



CR:315558
CR Number:   315558
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   HP-UX
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Oct 2003 Not reproducible with latest version of the product available as of Resolution Date
Description
Client threads hang in OpenSwitch during failover



CR:315615
CR Number:   315615
Product Name:   OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
OLEDB: Request new features in UDL Interface
Review Status
 Reviewed Aug 2003. Not to be fixed by Sybase, as this is a Microsoft Datalink issue.



CR:315668
CR Number:   315668
Product Name:   Open ClientCONNECT for IMS and MVS
Product Component:   MVS
Status:   Closed
OS:   MVS
Original Version:   4.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Aug 2003 Fixed
Description
SYISQL abends when accessing a Datetime column.



CR:315674
CR Number:   315674
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 May 2003 Fixed
Description
rp_switch command fails to switch users to next server
Workaround Description
 Use the pool name with the rp_switch command.

You still get an error but it switches the spid.



CR:315678
CR Number:   315678
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 May 2003 Fixed
Description
OpenSwitch crashes in strcmp due to CMON changes



CR:315704
CR Number:   315704
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Apr 2003 Fixed
5.2 15 Apr 2003 Fixed
5.2 15 Apr 2003 Fixed
5.5 15 Apr 2003 Fixed
5.2 15 Apr 2003 Fixed
5.2 15 Apr 2003 Fixed
Description
jConnect has optimized its performance when reading rows from the server. In some cases, users can expect to see a 10 percent performance improvement. Clients who use the widetable feature in ASE 12.5+ could see improvement of up to 25 percent. In all cases, clients will see performance improvement during selects.



CR:315862
CR Number:   315862
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Jun 2003 Fixed
03 Jun 2003 Fixed
25 Jul 2003 Duplicate
Description
CTLIB: Read from unallocated memory causes crash in ct_get_data().



CR:315971
CR Number:   315971
Product Name:   Open Client
Product Component:   dblib
Status:   Closed
OS:   AIX
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Apr 2003 Fixed
28 Apr 2003 Fixed
Description
DBLIB: No longer setting SO_REUSEADDR on client sockets.



CR:316031
CR Number:   316031
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.2 15 Apr 2003 Fixed
5.5 15 Apr 2003 Fixed
Description
jConnect no longer throws the JZ0TS SQLException at Connect time in the following case:



1. Client has not set the HOSTNAME connection property and the host computer's name (retrieved through java.net.InetAddress.getLocalHost().getHostName()) is longer than 30 bytes. jConnect will now truncate any hostname longer than 30 bytes to a max of 30 bytes.
Workaround Description
 Currently customer is using the HOSTNAME connection property and setting this to a name less than 30 bytes. This enables them to avoid the IOException



CR:316159
CR Number:   316159
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 May 2004 Not a Bug
Description
ODBC: Raiserror, in a stored proc, detected on different API call when executed as an RPC event as opposed to the LANGUAGE event. In this case it returns on SQLMoreResults() on the RPC call (it returns SQL_ERROR) and as a LANGUAGE event it returns SQL_ERROR on SQLFetch() after all rows are fetched on the result set preceding the raiserror.
Review Status
 Reviewed Aug 2003. Not to be fixed. Workaround was implemented successfully by customer.
Workaround Description
 1. Set CommandType to adCmdText is no parameter objects are used in the ADO app



OR



2. After processing the first SELECT check for more results:



sybRecordset.NextRecordset



CR:316215
CR Number:   316215
Product Name:   ESQL
Product Component:   C
Status:   Closed
OS:   NA
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 2003 Fixed
25 Aug 2003 Presently Not Targeted For Any Future Release Of This Product
Description
CPRE: Usage of typedef for character arrays in ESQL/C is not available now. Preprocessor gives error: M_SCALAR_CHAR, Error: non-array character variable <xx> is being used illegally as a host variable at line <yy>.



CR:316263
CR Number:   316263
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Nov 2004 Fixed
Description
jConnect: Set the TCP KeepAlive property to true by default for ASE connections so that idle connections are not broken.



CR:316465
CR Number:   316465
Product Name:   Open Client
Product Component:   dblib
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   2.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 May 2007 Fixed
Description
Runtime installation of Open Client does not include DB-Lib libsybdb.dll
Workaround Description
 Manually copy it from another location

and then build your own runtime installation

package.



CR:316582
CR Number:   316582
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 May 2003 Fixed
5.2 06 May 2003 Fixed
5.5 06 May 2003 Fixed
5.2 06 May 2003 Fixed
5.2 06 May 2003 Fixed
5.2 06 May 2003 Fixed
Description
jConnect has added a new Connection property -- ESCAPE_PROCESSING_DEFAULT. This property defaults to true. It can be used to set the default value for Statement.setEscapeProcessing(boolean val). If you do not intend to include any JDBC function escapes in your SQL, setting the property to false can result in a performance improvement.



With this CR, we also added a performance enhancement to Connection.commit() and Connection.rollback().



Finally, we added a fix to properly report the datatype in metadata when the server sends back LONGCHAR data.



CR:316984
CR Number:   316984
Product Name:   ESQL
Product Component:   C
Status:   Open
OS:   NA
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 May 2003 Fixed
07 Nov 2003 Fixed
13 May 2004 Fixed
16 May 2005 Fixed
07 Dec 2004 Fixed
Description
CPRE: Using typdef with character arrays does not work in ESQL/C.



CR:317002
CR Number:   317002
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 May 2003 Fixed
17 Sep 2002 Presently Not Targeted For Any Future Release Of This Product
Description
NETLIB: On Sun solaris, gateway server memory usage can be very high when many connections are concurrently active and threaded libraries are used. This is because the default stacksize for net-library threads used to be set to 1MB. This is now changed to 64K for unix platforms. On AIX, you may encounter a bug with ho_byname2() with these changes. To resolve this, please install IBM patch APAR IY39589.



CR:317043
CR Number:   317043
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jan 2004 Fixed
Description
ODBC: SQLFreeStmt(SQL_CLOSE) does not deallocate the ASE cursor.
Target Version
 To Be Determined
Review Status
 Reviewed Aug 2003. Fix is being considered (but not committed) for the 5.0 release in Q1 2004.
Workaround Description
 Close the connection.



CR:317065
CR Number:   317065
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Closed
OS:   Unknown
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 May 2003 Fixed
16 May 2003 Fixed
Description
BCP: Raise an error when ct_con_props() property CS_PACKETSIZE is set to a value >=64KB



CR:317072
CR Number:   317072
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Aug 2003 Fixed
Description
SRVLIB: srv_yield() fails to resume thread after yielding.
Review Status
 SRVLIB: srv_yield() fails to resume thread after yielding.



CR:317107
CR Number:   317107
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Jun 2003 Fixed
5.2 23 Jun 2003 Fixed
5.5 23 Jun 2003 Fixed
5.2 23 Jun 2003 Fixed
5.2 23 Jun 2003 Fixed
5.2 23 Jun 2003 Fixed
Description
jConnect no longer causes data truncation to occur when sending values to ASE numeric columns that have (precision, scale) values of (2,0), (2,1), (2,2), (1,1) or (1,0).
Workaround Description
 The customer currently uses a workaround that involves recreating the table with a change in the column datatype to something like Numeric(3,0) or greater.



CR:317286
CR Number:   317286
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Aug 2003 Presently Not Targeted For Any Future Release Of This Product
Description
ODBC: SQLSetStmtAttr(SQL_ATTR_MAX_ROWS) does a complete table scan on ASE
Target Version
 12.5.1
Review Status
 Reviewed Aug 2003. Fix is targeted (but not committed) for the ODBC 5.0 release in Q1 2004.
Workaround Description
 In certain cases can use SET ROWCOUNT X when using SM=Direct, in Initialization String. However, this is not always desireable since the cust may sometimes need to scan entire table. It is best to control via API call.



CR:317407
CR Number:   317407
Product Name:   Connectivity Utilities
Product Component:   scripts
Status:   Closed
OS:   Digital UNIX
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 May 2003 Fixed
07 May 2003 Fixed
Description
CTLIB: Changed compile/link flag for nthread_axposf in '-pthread' for ctlib examples.



CR:317485
CR Number:   317485
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   NA
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
jConnect: Request for support of getTypeMap() on Connection object.
Review Status
 Reviewed Aug 2003. Not to be fixed. jConnect does not support the SQL distinct or structured types. Therefore, we do not support the setTypeMap and getTypeMap methods.
Workaround Description
 Nope



CR:317630
CR Number:   317630
Product Name:   Open ServerCONNECT for CICS
Product Component:   tcp/ip
Status:   Closed
OS:   MVS
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Aug 2003 Fixed
Description
TCP IP Listener hangs when requested CICS transaction is disabled
Workaround Description
 Stop the Sybase TCP/IP Listener transaction i.e. SYLB instead of disabling the RPC transaction to prevent undesirable attempts by DC clients on the LAN to submit RPC requests (e.g. at certain restricted time periods)



CR:317873
CR Number:   317873
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Oct 2003 Fixed
Description
ODBC: When using Interfaces File, the driver was not updating the "LogonID" value in the registry, in the HKEY_LOCAL_USER\Software\ODBC\ODBC.INI section, under the specified DSN.
Review Status
 Reviewed Aug 1003. Fix is targeted for the 5.0 release in Q1 2004.
Workaround Description
 Customer might try EBF 11098, CtLib based ODBC 12.5 driver - this works fine.



CR:317882
CR Number:   317882
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Jun 2003 Fixed
23 Jun 2003 Fixed
Description
jConnect now implements the Statement query timeout as intended in the JDBC specification. Previously, we would set a socket read timeout to be equal to the value set for setQueryTimeout on each socket read for a Statement. Now, we properly count down from the initial timeout value to 0 as we do socket reads.



CR:318394
CR Number:   318394
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.50.09
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Apr 2007 Presently Not Targeted For Any Future Release Of This Product
Description
The problem is when an OSC Application Abends, using CICS 3.x Terminal security, on task termination SYBTRUE is Cleaning up the TCP/IP Socket but not signing off the terminal.



CR:319004
CR Number:   319004
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Oct 2003 Fixed
Description
ODBC: Login failure messages return in different order and are truncated. Therefore, by customer request, removed an existing error message from the error messages the driver returns when attempting to connect with an invalid UID and/or Server information.



CR:319166
CR Number:   319166
Product Name:   Open ClientCONNECT for CICS
Product Component:   Open ClientCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Aug 2003 Fixed
Description
Language events fail if the input stream contains "@" symbol.



CR:319188
CR Number:   319188
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Sep 2003 Fixed
2.0 15 Sep 2003 Fixed
2.0 15 Sep 2003 Fixed
2.0 15 Sep 2003 Fixed
2.0 15 Sep 2003 Fixed
2.0 15 Sep 2003 Fixed
Description
jConnect no longer changes the transaction isolation level when a client calls Connection.isClosed() and the backend database is an Adaptive Server Anywhere. The transaction isolation level will not be affected by calls to Connection.isClosed().
Target Version
 To Be Determined
Review Status
 Reviewed Aug 2003. Fix is targeted for a future release of the product.



CR:319479
CR Number:   319479
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Oct 2003 Fixed
Description
ODBC: CtLib based ODBC Driver fails to connect to ASE 125 (64bit) with 16K pagesize



CR:319538
CR Number:   319538
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   NA
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Aug 2003 Fixed
18 Aug 2003 Fixed
Description
SRVLIB: Negotiated packetsize is set to 256 instead of server packetsize when client specifies packetsize >= 32768.



CR:319746
CR Number:   319746
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Solaris
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Jun 2003 Fixed
5.2 23 Jun 2003 Fixed
Description
When a client calls getObject on a NUMERIC or DECIMAL type output parameter, *and* the client has not registered a scale, jConnect no longer returns null. Instead, we will return a value which uses the scale returned by the database. Please note that as per the JDBC API, clients should always register the scale of a NUMERIC or DECIMAL output parameter before they execute their Statement.



CR:319942
CR Number:   319942
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jul 2003 Fixed
26 Jun 2001 Not a Bug
Description
ODBC: CtLib 4.10 driver needs to be built with CS_VERSION_120. Prior to this Sybase ASE ODBC Driver version, 4.10.0058, if the driver was used with OCS 12.0, and a console based application was used, such as vbscript, an error would occur on initialization:



The context allocation routine failed.



The following problem caused the failure:



Invalid context version.



Now, this build of the Sybase ASE ODBC Driver, ctlib based, requires you to use OCS 12.0 ONLY. If you want to use OCS 12.5 you must use EBF 11081 (12.5.0/P-EBF11081 ESD#11/04.10.0000).



CR:320102
CR Number:   320102
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Aug 2003 Fixed
Description
CTLIB: A multithreaded application creating and dropping connections while calling

ct_poll can generate a SEGV.



CR:320119
CR Number:   320119
Product Name:   OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Aug 2003 Fixed
Description
OLEDB: Row Cache Size is not working properly. When Sybase ASE OLE DB Provider is set to SelectMethod=0 (Cursor) only one row is fetched and the Recordset is not getting populated. Also the following error was reported: "Run-time error '3021':Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record." This has been resolved.
Workaround Description
 Customer is currently using ODBC driver.



CR:320196
CR Number:   320196
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Aug 2003 Workaround
Description
ResultQuery.RowCount returns -1 when using RDO in VB

Tested and reproduced with Sybase ASE ODBC Driver 4.10.0000 and 4.10.0049.

Works fine with old "Sybase System 11" ODBC Driver 3.11.0000

Also works fine when using ADO, instead of RDO, with any ODBC driver version.

The workaround is to include rdoEngine.rdoDefaultCursorDriver = rdUseOdbc in coding.
Workaround Description
 The workaround is to include rdoEngine.rdoDefaultCursorDriver = rdUseOdbc in coding.



CR:320747
CR Number:   320747
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jun 2003 Fixed
10 Jun 2003 Fixed
Description
EXAMPLE: sample program wide_compute could not compile on Windows platforms.
Workaround Description
 Break the string up into two #define statements.



CR:321153
CR Number:   321153
Product Name:   Open Client
Product Component:   dblib
Status:   Closed
OS:   HP-UX
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jun 2003 Fixed
18 Jun 2003 Fixed
Description
DBLIB: On HPUX 64-bit libraries, dbbind() fails to convert negative integer to NTBSTRINGBIND



CR:321477
CR Number:   321477
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Closed
OS:   NA
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Jun 2003 Fixed
19 Jul 2003 Fixed
Description
CTISQL: Make the display of date/time from isql shorter to avoid wasting space.



CR:321836
CR Number:   321836
Product Name:   Open Client-Doc
Product Component:   Client-Library C Reference Manual
Status:   Closed
OS:   all
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Galaxy 02 Aug 2005 Fixed
Description
Open Client property BLK_CONV added to enable client side character set conversion, set via blk_props().





--------------------------------------华丽的分割线-------------------------------------------------------------------------
之前就已经研发成功了能够从Sybase SQL Anywhere的DB文件中恢复数据的工具:ReadASADB。
此工具支持ASA v5.0,v6.0,v7.0,v8.0,v9.0,v10.0,v11.0,v12.0等版本。
恢复Sybase SQL Anywhere的工具在国内应该算首创。

ReadASADB功能
能够从损坏的SQL Anywhere数据文件(.db)和UltraLite数据文件(.udb)上提取数据的非常规恢复工具

  1. 适用于所有的SQL Anywhere版本    包括:5.x,6.x,7.x,8.x,9.x,10.x,11.x,12.x
  2. 适用于所有的UltraLite版本
  3. 能够恢复出来表结构和数据
  4. 能够恢复自定义数据类型
  5. 能够恢复存储过程等对象的语法
  6. 能够导出到目标数据库
  7. 能够导出到SQL文件并生成导入脚本
  8. 支持多种字符集  包括:cp850、cp936、gb18030、utf8等
  9. 能够恢复未加密或者简单加密类型的数据
  10. 简单易用
  11. 限制:不支持AES加密的数据文件
请参考:研发成功了从Sybase SQL Anywhere的DB文件上恢复数据的工具
            SQL Anywhere数据库非常规恢复工具ReadASADB使用介绍

ReadASADB适用场景

各种误操作:

  1. 误截断表(truncate table)
  2. 误删除表(drop table)
  3. 错误的where条件误删数据
  4. 误删除db或log文件
  5. 误删除表中的字段

本工具的应用场景:

1.因为物理磁盘故障、操作系统、系统软件方面或者掉电等等原因导致的Sybase SQL Anywhere数据库无法打开的情况;
2.误操作,包括truncate table,drop table,不正确的where条件导致的误删除等;
Sybase SQL Anywhere无法打开时,比较常见的错误是:Assertion failed。
如:
1、Internal database error *** ERROR *** Assertion failed:201819 (8.0.1.2600) Checkpoint log: invalid bitmap page -- transaction rolled back
2、Internal database error *** ERROR *** Assertion failed:201819 (8.0.1.2600) Page number on page does not match page requested -- transaction rolled back
3、Internal database error *** ERROR *** Assertion failed:200502 (9.0.2.2451) Checksum failure on page 23 -- transaction rolled back
4、File is shorter than expected
5、Internal database error *** ERROR *** Assertion failed: 201116 Invalid free list index page found while processing checkpoint log -- transaction rolled back
6、*** ERROR *** Assertion failed: 51901 Page for requested record not a table page or record not present on page等等。
+-------------------------------------华丽的分割线-------------------------------------------------------------------------