远程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:494314
CR Number:   494314
Product Name:   Open Client/Open Server-Doc
Product Component:   Common Libraries Reference Manual
Status:   Closed
OS:   all
Original Version:   11.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jun 2008 Fixed
Description
DOC BUG: "Open Client Error Messages" doc. is missing from Sybooks' Open Client/Server 11.1.1 (Archive) at :

http://sybooks.sybase.com/nav/detail.do?docset=1065

It can be found at

http://manuals.sybase.com/onlinebooks/group-cnarc/cng1110e/ocerrors/

link should be moved to Open Client/Server 11.1.1 (Archive)as well



CR:494560
CR Number:   494560
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Linux
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Jul 2008 Fixed
Description
OpenSwitch delays new connections by COORD_TIMEOUT seconds when

the CM is disconnected from the network and COORD_MODE=avail.
Workaround Description
 On Solaris adjust the tcp_ip_abort_interval. On Linux adjust tcp_retries2.



CR:494571
CR Number:   494571
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Open
OS:   NA
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
BCP may insert more rows in a batch then specified if a -b value larger than 65536 is specified.
Workaround Description
 Use a batch size smaller than 65K



CR:494616
CR Number:   494616
Product Name:   Organic OLE DB Provider
Product Component:   Configuration UI
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#13 08 Dec 2013 Fixed
12.5.1 ESD#23 08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: 揝erver Port label is incorrectly named as 揂lternate Servers in the Sybase Data Source Administrator.



CR:494807
CR Number:   494807
Product Name:   Database Development
Product Component:   Creation Wizards
Status:   Closed
OS:   Windows XP
Original Version:   2.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Apr 2008 Fixed
Description
Problem: A stored procedure cannot be renamed after adding a "no result set" declaration.

Resolution: This has been fixed.



CR:494873
CR Number:   494873
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   15.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Apr 2008 Not a Bug
Description
TDGETUSR is not returning the correct code page when TDPROP is set



CR:495289
CR Number:   495289
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   15.0 ESD#12
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 May 2010 Fixed
Description
ODBC Driver by Sybase: ADO Parameters Refresh doesn't fill the Parameters Collection if the specified stored procedure name contains an underscore.



CR:495351
CR Number:   495351
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   1.1 ESD#12
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.15 ESD#14 06 Jun 2008 Fixed
1.1 ESD#23 06 Jun 2008 Fixed
Description
ADO.NET: MissingPrimaryKeyException thrown when using ASECommandBuilder with MissingSchemaAction = MissingSchemaAction.AddWithKey setting.
Workaround Description
 Info from customer: We found a workaround, but we prefer it to be fixed, because it much more complicated to implement.



We execute an SQL to define the database.

Then we execute the ASECommandBuilder.

Then we replace in the SQLText the table name with the database

prefix..tablename.

Finally, we execute an SQL to define the default database.

It works, but it is not very clean.

And because the connection are in the pool,

I not sure if changing so many times the database can impact performance or

make other problem.



If this can be fixed ASAP, it's better, or we will wait for the next ESD.



CR:495482
CR Number:   495482
Product Name:   Database Development
Product Component:   SQL Editor
Status:   Closed
OS:   Windows XP
Original Version:   2.0 ESD1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Mar 2008 Not a Bug
Description
Not all join type shown in SQL Editor



CR:495501
CR Number:   495501
Product Name:   Open Server
Product Component:   srvlib
Status:   Open
OS:   HP-UX
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Open Server will core-dump when shutdown if ct_close(CS_UNUSED) is used with SYNC_IO connection.
Workaround Description
 To call ct_close(CS_FORCE_CLOSE) directly or change the connection property to CS_ASYNC_IO



CR:495581
CR Number:   495581
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Open
OS:   Microsoft Windows XP
Original Version:   2.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Error "Invalid amount of parameters" when source query has Alias and more columns then destination table, even though using AseBulkCopyColumnMapping() to map explicit columns to match destination table.



CR:495582
CR Number:   495582
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Open
OS:   Microsoft Windows XP
Original Version:   2.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Error "Value does not fall within the expected range" when source query has a constant as part of the column list, even though using AseBulkCopyColumnMapping() to map explicit columns to match destination table. The column isn't being ignored internally.



CR:495667
CR Number:   495667
Product Name:   Database Development
Product Component:   SQL Editor
Status:   Closed
OS:   Windows 2000
Original Version:   2.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Apr 2008 Fixed
Description
Problem: Syntax highlighting with RIGHT OUTER JOIN or LEFT OUTER JOIN doesn't highlight the RIGHT or LEFT, e.g RIGHT OUTER JOIN, LEFT OUTER JOIN.

Resolution: This has been fixed.



CR:495672
CR Number:   495672
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#12
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#15 08 Dec 2013 Fixed
12.5.1 ESD#24 08 Dec 2013 Fixed
Description
ODBC Driver by Sybase: ODBC driver is truncating the data type name on export from MS Access



CR:495754
CR Number:   495754
Product Name:   Database Development
Product Component:   Other
Status:   Closed
OS:   Windows 2000
Original Version:   2.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Apr 2008 Fixed
Description
Problem: WorkSpace locks up when parsing/loading objects with F3.

Resolution: This has been fixed.



CR:496056
CR Number:   496056
Product Name:   Database Development
Product Component:   Database Explorer
Status:   Open
OS:   Generic
Original Version:   2.0 ESD1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer would like a Database monitoring option



CR:496159
CR Number:   496159
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#2 02 30 Apr 2008 Fixed
Description
TDPROPS SET is now prevented from setting Server and Client CCSID.



CR:496486
CR Number:   496486
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Closed
OS:   Solaris
Original Version:   12.5.1 ESD#22
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Apr 2008 Fixed
23 Apr 2008 Fixed
20 May 2008 Fixed
Description
CTBCP: When BCP copying in data with a format file with the -Q option, it reports error "Unexpected EOF encountered in BCP data-file".



CR:496493
CR Number:   496493
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#15 08 Dec 2013 Fixed
12.5.1 ESD#25 08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: OLE DB Application exits with 慡ystem.Exception: "External component has thrown an exception." when processing a very large resultset.



CR:496944
CR Number:   496944
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#15 08 Dec 2013 Fixed
12.5.1 ESD#25 08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: The SDK installer does not create the registry entry that sets up the default directory where .SOD files will be located.



CR:497011
CR Number:   497011
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   1.15 ESD#12
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.15 ESD#14 06 Jun 2008 Fixed
1.1 ESD#23 06 Jun 2008 Fixed
Description
ADO.NET: Output values of stored procedure parameters marked with ParameterDirection.InputOutput are truncated.



CR:497110
CR Number:   497110
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Open
OS:   Microsoft Windows 2003
Original Version:   15.0 ESD#12
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Organic ODBC Driver:

From a Micosoft SQL Server 2005 Linked Server connection a query on a table having

a nullable CHAR column gives error:



Msg 7356, Level 16, State 1, Line 1

The OLE DB provider "MSDASQL" for linked server "LINKED_SERVER" supplied inconsistent metadata for a

column.

The column "COLUMN" (compile-time ordinal 3) of object "DATABASE.dbo.TABLE" was reported to have

a "DBCOLUMNFLAGS_ISFIXEDLENGTH" of 16 at compile time and 0 at run time.



Similar query with the OLEDB Provider succeeds.



CR:497120
CR Number:   497120
Product Name:   ADO.NET Data Provider
Product Component:   Development Environment Integration
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   1.15 ESD#12
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD 7 06 Aug 2010 Fixed
Description
ADO.NET: Request to integrate Sybase ASE ADO.NET Data Provider within the Visual Studio development environment.



CR:497255
CR Number:   497255
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Unknown
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 May 2008 Fixed
Description
jConnect: ArithmeticException encountered when ENABLE_BULK_LOAD is set to true.
Workaround Description
 Check in isql that sp_drv_bcpmetadata <table>,<owner>,<database>

not give 0 column in return.



sp_drv_bcpmetadata sample,null,tempdb

go



-----------

1



(1 row affected)



CR:497406
CR Number:   497406
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   SuSE/UL Linux
Original Version:   15.0 ESD#13
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#14 09 Jun 2008 Fixed
08 Dec 2013 Fixed
Description
ODBC Driver by Sybase: ODBC Metadata calls fail when using unicode applications on Linux because of parameter truncation.



CR:497508
CR Number:   497508
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 May 2008 Fixed
Description
ISQL: Scratch file was not created in Windows temporary directory.



CR:497527
CR Number:   497527
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#14 17 Jun 2008 Fixed
Description
ODBC Driver by Sybase: When backEnd Type = DB2 Access Service and linking a table with MS Access SQLExecute fails with "Incorrect syntax" error, if there is a quote in the string . This occurs when you select a Unique Record Identifier when linking to the table.
Workaround Description
 The only workaround is to continue to use OEM ODBC Driver.



CR:497736
CR Number:   497736
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.6 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 ESD#5 04 29 May 2008 Fixed
15.0 ESD#2 04 10 Jun 2008 Fixed
Description
Handle zOS 1.9 changes to IBM listener.



CR:498017
CR Number:   498017
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Red Hat Enterprise Linux
Original Version:   15.0 ESD#13
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#14 09 Jun 2008 Fixed
Description
ODBC Driver by Sybase: 64-bit ODBC Driver cannot fetch a negative integer value from an integer column bound as SQL_C_CHAR.



CR:498188
CR Number:   498188
Product Name:   Open ClientCONNECT for CICS
Product Component:   Open ClientCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.6 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Oct 2012 Not a Bug
Description
Customer would CSBCONFIG to return the OCC actual version (12.6.4)



CR:498256
CR Number:   498256
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Galaxy 30 Jan 2009 Fixed
Description
Cust would Like more detailed explaination of how Numeric and Decimals are use



CR:498538
CR Number:   498538
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows 2003
Original Version:   15.0 ESD#13
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
MS SQLServer linked Server to ASE using Organic OLEDB Provider 15 ESD 13



When replicating a table parameterized with a table having a combination of datatypes an error occurs:



[ASEOLEDB]Data overflow. Increase specified column size or buffer size (Source: MSSQLServer, Error number: 30128)



CR:498562
CR Number:   498562
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#2 04 12 Jun 2008 Failed
Description
Allow listener configuration to reject gateway connections.



CR:498739
CR Number:   498739
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jun 2008 Fixed
Description
jConnect: Request to limit the number of SQLWarning chained off a connection



CR:498998
CR Number:   498998
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   NA
Original Version:   6.5 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
encrypt_password fails to encrypt/decrypt a null password



CR:499275
CR Number:   499275
Product Name:   Open Client
Product Component:   ctlib
Status:   Open
OS:   all
Original Version:   15.0 ESD#13
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
SDK / InstallShield : Request for minimal runtime client install.



CR:499278
CR Number:   499278
Product Name:   Open Client
Product Component:   ctlib
Status:   Open
OS:   all
Original Version:   15.0 ESD#13
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
SDK InstallShield: Request for MSI installer for minimal client runtime install.



CR:499581
CR Number:   499581
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.0 ESD#13
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Apr 2008 Fixed
Description
SRVLIB: Open Server application may raise: "Memory allocation for '0' bytes failed in 'srv_get_text' for 'byte-swap buffer'" when updating a unitext column with zero length.



CR:500112
CR Number:   500112
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#2 03 10 Jun 2008 Fixed
Description
Incorrect message for missing userid.



CR:500144
CR Number:   500144
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jun 2008 Fixed
07 Oct 2008 Fixed
Description
jConnect: Registering output parameter as Numeric(38,0) results in arithmetic overflow error.
Workaround Description
 After registering and prior to execution use the jdbcx extension to pass in precision and scale in setBigDecimal



BigDecimal theBigDecimal = new BigDecimal(new BigInteger("0"), 0);

SybPreparedStatement sps = (SybPreparedStatement) st;

// use the com.sybase.jdbcx.SybPreparedStatement extension

sps.setBigDecimal(1, theBigDecimal, 38, 0);

st.setBigDecimal(1, theBigDecimal);



CR:500658
CR Number:   500658
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Dec 2013 Fixed
15.0 ESD#14 08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: The 揕anguage parameter in the connection string is being ignored.
Workaround Description
 By editing syslogins and set language back to NULL is a possibility, but ASE team warned that this is not a supported procedure to be taken after a login is created. So, customer will not do this.



CR:500659
CR Number:   500659
Product Name:   Open Client
Product Component:   dblib
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Jun 2008 Workaround
Description
After upgrading application calling a external ini file to parse the server name is

failing with 12.5.1 The DBlib application no longer can connect.

If the customer rolls back to the base version of 12.5.1 it works fine.

All versions of 15.0 and ESD are working fine the defect is only in the 12.5.1 ESD#;s



Error message is unbale to connect to servername and the applicaiton will stop

ERROR: 1028 Unable to open connection to server: MIC_DET_SQL06.

ERROR: 1024 DB-Library error: 20003 SQL Server connection timed out.



CR:500822
CR Number:   500822
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#13
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#15 08 Dec 2013 Fixed
12.5.1 ESD#25 08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: With Microsoft Linked Server, selecting datalength(column) returns an incorrect length when the column is of type varchar(257) or larger.



CR:523751
CR Number:   523751
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   2.0 ESD#13
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.15 ESD#17 13 Jul 2010 Fixed
1.1 ESD#26 08 Dec 2013 Fixed
Description
ADO.NET: Executing a Stored Procedure with varchar argument of 16000 characters or longer in length results in implicit conversion not allowed error.



CR:528473
CR Number:   528473
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Linux
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Jul 2008 Not a Bug
Description
connection Time being ignored at run time in Linux SUSE and REDHAT

with Open Client CTlib 12.5.1 and ESD#22

If you involke a time out value on a conenction object the time out will be never happen

the command object will continue to pool for the server after five min of so you will

get a connection time out even thou the connection should of timed out in 15 sec for example.

/*

**

** Description

** -----------

** This is the example program that is printed in Chapter 1 of the

** Client-Library Programmer's Guide. It connects to a server,

** sends a select query, prints the rows, disconnects, and exits.

**

** Inputs

** ------

** None.

**

** Server Tables

** -------------

** This program requires the pubs2 database.

*/



/*

** Language Query Example Program.

*/

#include <stdio.h>

#include <stdlib.h>

#include <string.h>

#include <ctpublic.h>

#include "example.h"



#define MAXCOLUMNS 2

#define MAXSTRING 40

#define ERR_CH stderr

#define OUT_CH stdout



/*

** Username and password are defined in example.h

*/

CS_CHAR *Ex_username = EX_USERNAME;

CS_CHAR *Ex_password = EX_PASSWORD;



/*

** Define a macro that exits if a function return code indicates

** failure.

*/

#define EXIT_ON_FAIL(context, ret, str) \

if (ret != CS_SUCCEED) \

{ \

fprintf(ERR_CH, "Fatal error: %s\n", str); \

if (context != (CS_CONTEXT *) NULL) \

{ \

(CS_VOID) ct_exit(context, CS_FORCE_EXIT); \

(CS_VOID) cs_ctx_drop(context); \

} \

exit(EX_EXIT_FAIL); \

}



/*

** Callback routines for library errors and server messages.

*/

CS_RETCODE CS_PUBLIC csmsg_callback PROTOTYPE((

CS_CONTEXT *context,

CS_CLIENTMSG *clientmsg ));

CS_RETCODE CS_PUBLIC clientmsg_callback PROTOTYPE((

CS_CONTEXT *context,

CS_CONNECTION *connection,

CS_CLIENTMSG *clientmsg ));

CS_RETCODE CS_PUBLIC servermsg_callback PROTOTYPE((

CS_CONTEXT *context,

CS_CONNECTION *connection,

CS_SERVERMSG *servermsg ));



/*

** Main entry point for the program.

*/

int

main(int argc, char *argv[])

{

CS_CONTEXT *context; /* Context structure */

CS_CONNECTION *connection; /* Connection structure. */

CS_COMMAND *cmd;/* Command structure. */



/* Data format structures for column descriptions: */

CS_DATAFMT columns[MAXCOLUMNS];



CS_INT datalength[MAXCOLUMNS];

CS_SMALLINT indicator[MAXCOLUMNS];

CS_INT count;

CS_RETCODE ret;

CS_RETCODE results_ret;

CS_INT result_type;

CS_CHAR name[MAXSTRING];

CS_CHAR city[MAXSTRING];

CS_INT timeval =15; //<---- set the time out value









EX_SCREEN_INIT();









/*

** Step 1: Initialize the application.

*/



/*

** First allocate a context structure.

*/

context = (CS_CONTEXT *)NULL;

ret = cs_ctx_alloc(EX_CTLIB_VERSION, &context);

EXIT_ON_FAIL(context, ret, "cs_ctx_alloc failed");



/*

** Initialize Client-Library.

*/

ret = ct_init(context, EX_CTLIB_VERSION);

EXIT_ON_FAIL(context, ret, "ct_init failed");



ret = ct_config(context, CS_SET, CS_TIMEOUT, &tmOut, CS_UNUSED, NULL);//< involking it here,.

EXIT_ON_FAIL(context, ret, "error setting timeout");



/*

** Step 2: Set up the error handling. Install callback handlers

** for: - CS-Library errors - Client-Library errors - Server

** messages.

*/



/*

** Install a callback function to handle CS-Library errors.

*/

ret = cs_config(context, CS_SET, CS_MESSAGE_CB,

(CS_VOID *)csmsg_callback,

CS_UNUSED, NULL);

EXIT_ON_FAIL(context, ret,

"cs_config(CS_MESSAGE_CB) failed");



/*

** Install a callback function to handle Client-Library errors.

**

** The client message callback receives error or informational

** messages discovered by Client-Library.

*/

ret = ct_callback(context, NULL, CS_SET, CS_CLIENTMSG_CB,

(CS_VOID *)clientmsg_callback);

EXIT_ON_FAIL(context, ret,

"ct_callback for client messages failed");



/*

** The server message callback receives server messages sent by

** the server. These are error or inforamational messages.

*/

ret = ct_callback(context, NULL, CS_SET, CS_SERVERMSG_CB,

(CS_VOID *)servermsg_callback);

EXIT_ON_FAIL(context, ret,

"ct_callback for server messages failed");



/*

** Step 3: Connect to the server. We must: - Allocate a connection

** structure. - Set user name and password. - Create the

** connection.

*/



/*

** First, allocate a connection structure.

*/

ret = ct_con_alloc(context, &connection);

EXIT_ON_FAIL(context, ret, "ct_con_alloc() failed");



/*

** These two calls set the user credentials (username and

** password) for opening the connection.

*/

ret = ct_con_props(connection, CS_SET, CS_USERNAME,

Ex_username, CS_NULLTERM, NULL);

EXIT_ON_FAIL(context, ret, "Could not set user name");

ret = ct_con_props(connection, CS_SET, CS_PASSWORD,

Ex_password, CS_NULLTERM, NULL);

EXIT_ON_FAIL(context, ret, "Could not set password");



/*

** Create the connection.

*/

if(EX_SERVER==NULL)

ret = ct_connect(connection, (CS_CHAR *)NULL, 0);

else

ret = ct_connect(connection, (CS_CHAR *)EX_SERVER, strlen(EX_SERVER));

EXIT_ON_FAIL(context, ret, "Could not connect!");



/*

** Step 4: Send a command to the server, as follows: - Allocate a

** CS_COMMAND structure - Build the command to be sent with

** ct_command. - Send the command with ct_send.

*/



/*

** Allocate a command structure.

*/

ret = ct_cmd_alloc(connection, &cmd);

EXIT_ON_FAIL(context, ret, "ct_cmd_alloc() failed");



/*

** Initiate a language command. This call associates a query with

** the command structure.

*/

ret = ct_command(cmd, CS_LANG_CMD,

"select au_lname, city from pubs2..authors \

where state = 'CA'",

CS_NULLTERM, CS_UNUSED);

EXIT_ON_FAIL(context, ret, "ct_command() failed");



/*

** Send the command.

*/

ret = ct_send(cmd);

EXIT_ON_FAIL(context, ret, "ct_send() failed");



/*

** Step 5: Process the results of the command.

*/



while ((results_ret = ct_results(cmd, &result_type))

== CS_SUCCEED)

{



/*

** ct_results sets result_type to indicate when data is

** available and to indicate command status codes.

*/

switch ((int)result_type)

{

case CS_ROW_RESULT:



/*

** This result_type value indicates that the rows

** returned by the query have arrived. We bind and

** fetch the rows.

**

** We're expecting exactly two character columns:

** Column 1 is au_lname, 2 is au_city.

**

** For each column, fill in the relevant fields in

** the column's data format structure, and bind

** the column.

*/

columns[0].datatype = CS_CHAR_TYPE;

columns[0].format = CS_FMT_NULLTERM;

columns[0].maxlength = MAXSTRING;

columns[0].count = 1;

columns[0].locale = NULL;

ret = ct_bind(cmd, 1, &columns[0],

name, &datalength[0],

&indicator[0]);

EXIT_ON_FAIL(context, ret,

"ct_bind() for au_lname failed");



/*

** Same thing for the 'city' column.

*/

columns[1].datatype = CS_CHAR_TYPE;

columns[1].format = CS_FMT_NULLTERM;

columns[1].maxlength = MAXSTRING;

columns[1].count = 1;

columns[1].locale = NULL;



ret = ct_bind(cmd, 2, &columns[1], city,

&datalength[1],

&indicator[1]);

EXIT_ON_FAIL(context, ret,

"ct_bind() for city failed");



/*

** Now fetch and print the rows.

*/

while (((ret = ct_fetch(cmd, CS_UNUSED, CS_UNUSED,

CS_UNUSED, &count))

== CS_SUCCEED)

|| (ret == CS_ROW_FAIL))

{



/*

** Check if we hit a recoverable error.

*/

if (ret == CS_ROW_FAIL)

{

fprintf(ERR_CH,

"Error on row %ld.\n",

(long)(count + 1));

}



/*

** We have a row, let's print it.

*/

fprintf(OUT_CH, "%s: %s\n", name, city);

}



/*

** We're finished processing rows, so check

** ct_fetch's final return value to see if an

** error occurred. The final return code should be

** CS_END_DATA.

*/

if (ret == CS_END_DATA)

{

fprintf(OUT_CH,

"\nAll done processing rows.\n");

}

else

/* Failure occurred. */

{

EXIT_ON_FAIL(context, CS_FAIL,

"ct_fetch failed");

}



/*

** All done with this result set.

*/

break;



case CS_CMD_SUCCEED:



/*

** We executed a command that never returns rows.

*/

fprintf(OUT_CH, "No rows returned.\n");

break;



case CS_CMD_FAIL:



/*

** The server encountered an error while

** processing our command. These errors will be

** displayed by the server-message callback that

** we installed earlier.

*/

break;



case CS_CMD_DONE:



/*

** The logical command has been completely

** processed.

*/

break;



default:



/*

** We got something unexpected.

*/

EXIT_ON_FAIL(context, CS_FAIL,

"ct_results returned unexpected result type");

break;

}

}



/*

** We've finished processing results. Check the return value of

** ct_results() to see if everything went okay.

*/

switch ((int)results_ret)

{

case CS_END_RESULTS:



/*

** Everything went fine.

*/

break;



case CS_FAIL:



/*

** Something terrible happened.

*/

EXIT_ON_FAIL(context, CS_FAIL,

"ct_results() returned CS_FAIL.");

break;



default:



/*

** We got an unexpected return value.

*/

EXIT_ON_FAIL(context, CS_FAIL,

"ct_results returned unexpected return code");

break;

}



/*

** Step 6: Clean up and exit.

*/



/*

** Drop the command structure.

*/

ret = ct_cmd_drop(cmd);

EXIT_ON_FAIL(context, ret, "ct_cmd_drop failed");



/*

** Close the connection and drop its control structure.

*/

ret = ct_close(connection, CS_UNUSED);

EXIT_ON_FAIL(context, ret, "ct_close failed");

ret = ct_con_drop(connection);

EXIT_ON_FAIL(context, ret, "ct_con_drop failed");



/*

** ct_exit tells Client-Library that we are done.

*/

ret = ct_exit(context, CS_UNUSED);

EXIT_ON_FAIL(context, ret, "ct_exit failed");



/*

** Drop the context structure.

*/

ret = cs_ctx_drop(context);

EXIT_ON_FAIL(context, ret, "cs_ctx_drop failed");



/*

** Normal exit to the operating system.

*/

return(EX_EXIT_SUCCEED);

}



/*

** Handler for server messages. Client-Library will call this

** routine when it receives a message from the server.

*/

CS_RETCODE CS_PUBLIC

servermsg_callback(CS_CONTEXT *cp, CS_CONNECTION *chp, CS_SERVERMSG *msgp)

{



/*

** Print the message info.

*/

fprintf(ERR_CH,

"Server message:\n\t");

fprintf(ERR_CH,

"number(%ld) severity(%ld) state(%ld) line(%ld)\n",

(long)msgp->msgnumber, (long)msgp->severity,

(long)msgp->state, (long)msgp->line);



/*

** Print the server name if one was supplied.

*/

if (msgp->svrnlen > 0)

fprintf(ERR_CH, "\tServer name: %s\n", msgp->svrname);



/*

** Print the procedure name if one was supplied.

*/

if (msgp->proclen > 0)

fprintf(ERR_CH, "\tProcedure name: %s\n", msgp->proc);



/*

** Print the null terminated message.

*/

fprintf(ERR_CH, "\t%s\n", msgp->text);



/*

** Server message callbacks must return CS_SUCCEED.

*/

return (CS_SUCCEED);

}



/*

** Client-Library error handler. This function will be invoked

** when a Client-Library has detected an error. Before Client-

** Library routines return CS_FAIL, this handler will be called

** with additional error information.

*/

CS_RETCODE CS_PUBLIC

clientmsg_callback(CS_CONTEXT *context, CS_CONNECTION *conn, CS_CLIENTMSG *emsgp)

{



/*

** Error number: Print the error's severity, number, origin, and

** layer. These four numbers uniquely identify the error.

*/

fprintf(ERR_CH,

"Client Library error:\n\t");

fprintf(ERR_CH,

"severity(%ld) number(%ld) origin(%ld) layer(%ld)\n",

(long)CS_SEVERITY(emsgp->severity),

(long)CS_NUMBER(emsgp->msgnumber),

(long)CS_ORIGIN(emsgp->msgnumber),

(long)CS_LAYER(emsgp->msgnumber));



/*

** Error text: Print the error text.

*/

fprintf(ERR_CH, "\t%s\n", emsgp->msgstring);



/*

** Operating system error information: Some errors, such as

** network errors, may have an operating system error associated

** with them. If there was an operating system error, this code

** prints the error message text.

*/

if (emsgp->osstringlen > 0)

{

fprintf(ERR_CH,

"Operating system error number(%ld):\n",

(long)emsgp->osnumber);

fprintf(ERR_CH, "\t%s\n", emsgp->osstring);

}



/*

** If we return CS_FAIL, Client-Library marks the connection as

** dead. This means that it cannot be used anymore. If we return

** CS_SUCCEED, the connection remains alive if it was not already

** dead.

*/

return (CS_SUCCEED);

}



/*

** CS-Library error handler. This function will be invoked

** when CS-Library has detected an error.

*/

CS_RETCODE CS_PUBLIC

csmsg_callback(CS_CONTEXT *context, CS_CLIENTMSG *emsgp)

{



/*

** Print the error number and message.

*/

fprintf(ERR_CH,

"CS-Library error:\n");

fprintf(ERR_CH,

"\tseverity(%ld) layer(%ld) origin(%ld) number(%ld)",

(long)CS_SEVERITY(emsgp->msgnumber),

(long)CS_LAYER(emsgp->msgnumber),

(long)CS_ORIGIN(emsgp->msgnumber),

(long)CS_NUMBER(emsgp->msgnumber));



fprintf(ERR_CH, "\t%s\n", emsgp->msgstring);



/*

** Print any operating system error information.

*/

if (emsgp->osstringlen > 0)

{

fprintf(ERR_CH, "Operating System Error: %s\n",

emsgp->osstring);

}



return (CS_SUCCEED);

}
Target Version
 To Be Determined



CR:528839
CR Number:   528839
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   2.0 ESD#13
Fixed Version Build Resolution Date Closure Code (If Appropriate)
2.0 ESD#19 26 Jun 2009 Fixed
Description
ADO.NET: Poor performance from some ADO.NET Provider methods such as AseConnection.Open().



CR:528905
CR Number:   528905
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)
15 May 2008 Fixed
Description
The Sybase XA driver on Windows failed in the final xa_close calls,

triggered by the MQCMIT call.



CR:529395
CR Number:   529395
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Open
OS:   Microsoft Windows XP
Original Version:   1.15 ESD#17
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ASE.Net Internal Error: 30002 when EncryptPassword=1 and connect to a ASE 1502.



CR:529647
CR Number:   529647
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   NA
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
jConnect: When connected to SQL Anywhere version 10, the executeBatch method is sending INSERTs in loop, not as a batch.



CR:529673
CR Number:   529673
Product Name:   Connectivity Utilities
Product Component:   dscp
Status:   Closed
OS:   Solaris
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 May 2008 Fixed
Description
DSCP: Output for Server Security mechanism shows **Unknown value** when Server information is being requested from an LDAP directory service.



CR:530387
CR Number:   530387
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Jun 2008 Fixed
15 Jul 2008 Fixed
01 Jul 2008 Fixed
Description
OpenSwitch rejects a login attempt if the user's password has expired and SHOW_SPID property is 1.
Workaround Description
 Set the following properties in your OpenSwitch config file if possible.

--------------------------------

SHOW_SPID = 0

CMON = 1

--------------------------------



CR:530531
CR Number:   530531
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#14 08 Dec 2013 Fixed
12.5.1 ESD#24 08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: Unexpected characters displayed when character column contains new line characters.



CR:530552
CR Number:   530552
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Solaris
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Jul 2008 Fixed
27 Jul 2008 Fixed
Description
NETLIB: When more than 250 clients are connected to openserver on 32bit Solaris, calling fopen() in openserver code fails.



CR:530581
CR Number:   530581
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   1.1 ESD#23
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.1 ESD#24 06 Jun 2008 Duplicate
1.15 ESD#14 06 Jun 2008 Duplicate
1.15 ESD#14 24 Jun 2008 Duplicate
Description
ADO.NET: Output values of stored procedure parameters marked with ParameterDirection.InputOutput are truncated.



CR:530773
CR Number:   530773
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jun 2008 Fixed
11 Jun 2008 Fixed
Description
jConnect: Request to update jConnect meta-data stored procedures for SQL Anywhere 10.0 and 11.0 releases.



CR:530926
CR Number:   530926
Product Name:   Open ClientCONNECT for CICS
Product Component:   Open ClientCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   15.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Oct 2012 Not a Bug
Description
ISQLCICS does not support DB2 datatype "LONG VARCHAR FOR BIT DATA".



CR:531042
CR Number:   531042
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows 2003
Original Version:   15.0 ESD#12
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#15 08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: Operating on very large resultsets from Microsoft Linked Server to ASE using OLE DB exhibits slower performance and/or Msg 7330 揅annot fetch a row from OLE DB provider 厰



CR:531119
CR Number:   531119
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Dec 2008 Fixed
22 Dec 2008 Fixed
Description
jConnect: Request for key sequence support on ASA 10 with primary key constraint (declarative)



CR:531257
CR Number:   531257
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Jun 2008 Fixed
01 Jul 2008 Fixed
21 Jul 2008 Fixed
Description
A thread in OpenSwitch goes into an endless loop in thrd__dyns_dealloc() while deallocating dynamic prepared statement.
Workaround Description
 Set 1 to FULL_PASSTHRU if possible.



CR:531259
CR Number:   531259
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Sep 2008 Fixed
Description
A thread in OpenSwitch goes into an endless loop in thrd__dyns_free() after disconnecting a client connection.
Workaround Description
 Set 1 to FULL_PASSTHRU if possible.



CR:531311
CR Number:   531311
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#2 04 19 Jun 2008 Fixed
Description
RDO definition for SYBLSTNR CONCURRENCY should be THREADSAFE.



CR:531496
CR Number:   531496
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Oct 2012 Presently Not Targeted For Any Future Release Of This Product
Description
Feature to Server Option (15) for CICS to use the CICS AUTOINSTALL feature



CR:531772
CR Number:   531772
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Unknown
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Dec 2008 Fixed
08 Jan 2009 Fixed
Description
jConnect: Excessive warning messages generated during XA transaction operations.



CR:531804
CR Number:   531804
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   12.5.1 ESD#23
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#15 06 May 2010 Fixed
12.5.1 ESD#25 06 May 2010 Fixed
Description
OLE DB Provider by Sybase: Performance issues with some of the Meta-data stored procedures such as sp_oledb_primarykey and sp_oledb_databases.



CR:531876
CR Number:   531876
Product Name:   ADO.NET Data Provider
Product Component:   TDS Library
Status:   Open
OS:   Microsoft Windows 2003
Original Version:   1.15 ESD#11
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ASE.NET connection fails if non english in your windows setup and you login have a

language set like this:

suid name language

----------- ------------------------------ ----------

4 sybase_us_english us_english 4



You get this msg from the ASe server.

msg 4017: Language name in login record 'swedish' is not an official name on this ASE. Using default 'us_english' from syslogins instead.
Workaround Description
 set language properties for ASE.NET



CR:532081
CR Number:   532081
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Jun 2008 Fixed
15 Jul 2008 Fixed
01 Jul 2008 Fixed
Description
An OCS assertion fails in com__tds_cstotds_map when ASE returns parameter result sets that contain timestamp data.
Workaround Description
 Build OpenSwitch with the OPTIMIZED version of the OCS libraries.



CR:532108
CR Number:   532108
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.0 ESD#13
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#14 06 Jun 2008 Fixed
12.5.1 ESD#24 08 Dec 2013 Fixed
Description
ODBC Driver by Sybase: Connections to DirectConnect server configured for SSL fail.



CR:532170
CR Number:   532170
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   12.5.1 ESD#23
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#15 08 Dec 2013 Fixed
12.5.1 ESD#25 08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: OLE DB application performance issues due to repeated calls to Meta-data stored procedures such as sp_drv_typeinfo



CR:532201
CR Number:   532201
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Unknown
Original Version:   15.0 ESD#15
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Oct 2008 Fixed
Description
SRVLIB: On Linux x86-64 and Linux on Power, non-threaded Open Server applications have segmentation fault when running under RHEL 5.0, SUSE 10 or above. The workaround of setting environment variable LD_POINTER_GUARD is no longer required after this fix.



CR:532386
CR Number:   532386
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT
Status:   Closed
OS:   MVS
Original Version:   12.6 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Oct 2012 EOL'd version. Not to be Fixed.
Description
AMD2 transaction abends with 0C4, reason code 10.
Workaround Description
 Since it is not possible to avoid loading SYGWXCPH CICS load module near the end of a 1-MB memory page, the workaround is to re-link SYGWXCPH and extend it with low-values using the Linkage Editor's IEWL EXPAND function



// EXEC PGM=IEWL,PARM='XREF,LIST,NORENT,AMODE=31,RMODE=ANY'

//SYSPRINT DD SYSOUT=*

//SYSLMOD DD DISP=SHR,DSN=....SYGWXCPH....LOADLIB

//SYSUT1 DD UNIT=WORK,SPACE=(CYL,(1,1))

//SYSLIN DD *

INCLUDE SYSLMOD(SYGWXCPH)

ENTRY TDVCONS

EXPAND TDGLOBAL(32768)

NAME SYGWXCPH(R)

/*



Now the COMP instruction will reference the extension of SYGWXCPH filled with low-values



CR:532451
CR Number:   532451
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#13
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#17 06 May 2013 Fixed
12.5.1 ESD#26 01 May 2013 Fixed
Description
OLE DB Provider by Sybase: Executing a Stored Procedure with varchar argument of 16000 characters or longer in length results in implicit conversion not allowed error.



CR:532547
CR Number:   532547
Product Name:   Organic OLE DB Provider
Product Component:   Configuration UI
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#13
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 May 2010 Fixed
Description
OLE DB Provider by Sybase: Some Japanese localized screens for Sybase Data Source Administrator do not display correctly.



CR:532666
CR Number:   532666
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   12.5.1 ESD#23
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.1 ESD#25 08 Dec 2013 Fixed
15.0 ESD#15 08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: Request to set field attribute for calculated columns to "Fixed + UnknownUpdatable" rather than the current "ReadOnly" value to maintain compatibility with the discontinued OEM OLE DB Provider.



CR:532888
CR Number:   532888
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows XP
Original Version:   12.5.1 ESD#23
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
After large result set, there's a 1-2 second delay when application ends



CR:533420
CR Number:   533420
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   12.5.1 ESD#23
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.1 ESD#25 08 Dec 2013 Fixed
15.0 ESD#15 08 Dec 2013 Fixed
Description
ODBC Driver by Sybase: SQLSetPos doesn't work properly on updating data.



CR:533480
CR Number:   533480
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jul 2008 Fixed
22 Jul 2008 Presently Not Targeted For Any Future Release Of This Product
29 Sep 2008 Fixed
08 Jun 2009 Fixed
Description
SRVLIB: If a client application connects to ASE through a gateway Open Server application, the client application hangs when srv_xferdata() returns a charset conversion error.



CR:533606
CR Number:   533606
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Closed
OS:   Linux
Original Version:   15.0 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Jul 2008 Fixed
01 Jul 2008 Fixed
Description
ODBC Driver by Sybase: ODBC applications hang during connection failover event.



CR:533615
CR Number:   533615
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Open
OS:   Microsoft Windows 2003
Original Version:   1.15 ESD#14
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
After registering Sybase.Data.AseClient.dll and policy.1.15.Sybase.Data.AseClient.dll assembly caches into .NET Framework 2.0, all VB applications compile fine, but produce the following error at runtime:



************** Exception Text **************

System.IO.FileNotFoundException: Could not load file or assembly 'Sybase.Data.AseClient, Version=1.15.320.0, Culture=neutral, PublicKeyToken=26e0f1529304f4a7' or one of its dependencies. The system cannot find the file specified.

File name: 'Sybase.Data.AseClient, Version=1.15.320.0, Culture=neutral, PublicKeyToken=26e0f1529304f4a7' ---> System.IO.FileNotFoundException: Could not load file or assembly 'Sybase.Data.AseClient, Version=1.15.320.0, Culture=neutral, PublicKeyToken=26e0f1529304f4a7' or one of its dependencies. The system cannot find the file specified.

File name: 'Sybase.Data.AseClient, Version=1.15.320.0, Culture=neutral, PublicKeyToken=26e0f1529304f4a7'
Workaround Description
 Two workarounds:



1) Use .NET Framework 1.1 only or

2) Within .NET Framework 2.0, remove policy.1.15.Sybase.Data.AseClient.dll from GAC

(this did not work on my esd #15 install)



CR:533637
CR Number:   533637
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#13
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#15 08 Dec 2013 Fixed
12.5.1 ESD#24 08 Dec 2013 Fixed
Description
ODBC Driver by Sybase: SSL connections from ODBC driver are lost after 20 seconds of idle-time.



CR:533649
CR Number:   533649
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#13
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#17 08 Dec 2013 Fixed
08 Mar 2009 Presently Not Targeted For Any Future Release Of This Product
Description
OLE DB Provider by Sybase: The OleDbTransaction.Commit() times out if transaction takes longer than 30 seconds to commit.
Workaround Description
 When the timeout of Commit occurs, please set 0 as LoginTimeOut. A timeout is disabled.



CR:533717
CR Number:   533717
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   15.0 ESD#13
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Jun 2008 Fixed
11 Jul 2008 Fixed
30 Jul 2008 Duplicate
Description
DRIVERS: Using security driver with 'data integrity' or 'replay detection' option may raise a TDS protocol error: "An invalid PARAMFMT stream was received."



CR:533731
CR Number:   533731
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#2 05 20 Jun 2008 Fixed
12.6 ESD#6 01 21 Oct 2010 Fixed
Description
Listeners are not displayed from EZAO,INQ,LISTENER.



CR:534166
CR Number:   534166
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.0 ESD#13
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#15 26 Aug 2013 Fixed
12.5.1 ESD#25 08 Dec 2013 Fixed
Description
ODBC Driver by Sybase: Microsoft Access application prompts for login information multiple times, even though same user id is used.



CR:534302
CR Number:   534302
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#18 30 Mar 2009 Duplicate
Description
OLE DB Provider by Sybase: OLEDB Provider does not support IRowsetUpdate interface.



CR:534311
CR Number:   534311
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#13
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#18 15 Apr 2009 Fixed
Description
OLE DB Provider by Sybase: Grid performance is slow with Delphi ADO and adUseServer CursorLocation
Workaround Description
 Eliminate CacheSize or set to 1



CR:534558
CR Number:   534558
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#13
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#18 30 Mar 2009 Fixed
Description
OLE DB Provider by Sybase: Using a Delphi Data Grid, changed data in a field is not reflected after selecting another row.



CR:534562
CR Number:   534562
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#13
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#15 08 Dec 2013 Fixed
12.5.1 ESD#23 08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: Calling a stored procedure with integer output parameter twice in a row causes failures in some situations.



CR:534811
CR Number:   534811
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Generic
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Jun 2008 Fixed
15 Jul 2008 Fixed
01 Jul 2008 Fixed
Description
When CMON_PASSWORD specified in the [SERVER] section of the Mutual Aware OSW config file is NOT NULL, OSW inserts wrong CMON_PASSWORD into the ASE cluster tables.



CR:534956
CR Number:   534956
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#18 30 Mar 2009 Fixed
Description
OLE DB Provider by Sybase: Poor performance while updating large RowSets in a Delphi application.



CR:534991
CR Number:   534991
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Generic
Original Version:   ESD1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jul 2008 Fixed
Description
OpenSwitch fails when handling results from ASE executing heavy duty stored procedures with errors like "srv_senddone() was called with a bad count parameter".



CR:535077
CR Number:   535077
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Nov 2009 EOL'd version. Not to be Fixed.
16 Jul 2008 Fixed
Description
rp_kill may be unable to shut down connections established to the specified pool.
Workaround Description
 Don't specify pool name like.



1> rp_kill null, <server name>, <spid>

2> go



CR:535933
CR Number:   535933
Product Name:   Database Development
Product Component:   SQL Debugger
Status:   Closed
OS:   Windows XP
Original Version:   2.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Sep 2008 Duplicate
Description
Feature request:

Please include the parameters of a stored procedure in the Variables view of the debugger.

When debugging a stored procedure with OUTPUT parameters, and these get changed in the proc, the new values should be reflected in the variables view.



CR:536340
CR Number:   536340
Product Name:   Open Client
Product Component:   cslib
Status:   Closed
OS:   Linux
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Aug 2012 Presently Not Targeted For Any Future Release Of This Product
Description
CSLIB: When cs_convert() fails, it should set *resultlen to CS_UNUSED.
Workaround Description
 Rely on the value return by cs_convert() rather than what is in resultlen.

resultlen is an optional parameter and can be passed as NULL.



CR:536341
CR Number:   536341
Product Name:   Open Client
Product Component:   cslib
Status:   Closed
OS:   Linux
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
cs_convert does not set resultlen to CS_UNUSED upon failure
Workaround Description
 Rely on the value return by cs_convert() rather than what is in resultlen.

resultlen is an optional parameter and can be passed as NULL.



CR:536623
CR Number:   536623
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#14
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#15 08 Dec 2013 Fixed
12.5.1 ESD#25 08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: Memory leak observed in the OLE DB Provider during each connect and disconnect cycle.



CR:536837
CR Number:   536837
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jul 2008 Not a Bug
Description
If you specify NULL to the pool_name when you run rp_switch, rp_switch can switch connections to the alternate ASE but does not change pool name of the connections.



CR:536925
CR Number:   536925
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#14
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jul 2008 Fixed
24 Jul 2008 Fixed
30 Jul 2008 Fixed
Description
CTBCP: Use of a single backslash character as row/field terminator does not work correctly anymore after fix of CR#331285 in CTBCP version 15.0 ESD#8 and version 12.5.1 ESD#18



CR:537130
CR Number:   537130
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#3 01 27 Feb 2009 Fixed
Description
Gateway Handler is writing out a trace message "HAND - TDSNDDON".



CR:537371
CR Number:   537371
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#14
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#18 30 Mar 2009 Fixed
Description
OLE DB Provider by Sybase: When SetData is called on a row containing a calculated column or an alias, IRowsetUpdate::Update sends an UPDATE statement containing that column. This results in the row not being updated.



CR:537376
CR Number:   537376
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#14
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#18 30 Mar 2009 Fixed
Description
OLE DB Provider by Sybase: Executing a statement causes a dynamic prepare (DYNAMIC2 / DYN_PREPARE) token to be sent to ASE. The prepared statement is then ignored and a LANGUAGE token is used to execute the statement.





--------------------------------------华丽的分割线-------------------------------------------------------------------------
之前就已经研发成功了能够从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等等。
+-------------------------------------华丽的分割线-------------------------------------------------------------------------