存档

Archive by ,文章数:326

随着Sybase被完全整合到SAP下,Sybase原来的支持网站被SAP Support Portal取代。
只有购买了SAP服务的用户才能使用账号登录SAP Support Portal进行介质下载、补丁升级、报Incident等。
目前,原Sybase所有产品(包括:Adaptive Server Enterprise、Sybase IQ、Replication Server、PowerDesigner等)的官方手册仍然可以从http://infocenter.sybase.com/help/index.jsp进行浏览或下载。暂不清楚该网站http://infocenter.sybase.com/help/index.jsp何时会被完全迁移到SAP Support上!
Sybase官方手册英文版有html和pdf两种格式,而中文版手册只有pdf一种格式。为了国内Sybase用户更方便、快捷地搜索Sybase常见产品的官方手册内容,特将中文版Sybase官方手册转为html格式!
Sybase产品官方手册中文版的html格式所有内容的版权归SAP公司所有!本博客站长是Sybase数据库的铁杆粉丝!

以下官方手册为ASE 15.7 ESD#2中文版:

  1. 新增功能公告 适用于 Windows、Linux 和 UNIX 的 Open Server 15.7 和 SDK 15.7
  2. 新增功能摘要
  3. 新增功能指南
  4. ASE 15.7 发行公告
  5. 配置指南(windows)
  6. 安装指南(windows)
  7. 参考手册:构件块
  8. 参考手册:命令
  9. 参考手册:过程
  10. 参考手册:表
  11. Transact-SQL® 用户指南
  12. 系统管理指南,卷 1
  13. 系统管理指南,卷 2
  14. 性能和调优系列:基础知识
  15. 性能和调优系列:锁定和并发控制
  16. 性能和调优系列:监控表
  17. 性能和调优系列:物理数据库调优
  18. 性能和调优系列:查询处理和抽象计划
  19. 性能和调优系列:使用 sp_sysmon 监控 Adaptive Server
  20. 性能和调优系列:利用统计分析改进性能
  21. 程序员参考 jConnect for JDBC 7.0.7
  22. Adaptive Server Enterprise 中的 Java
  23. 组件集成服务用户指南
  24. Ribo 用户指南
  25. 内存数据库用户指南
  26. Sybase Control Center for Adaptive Server® Enterprise
  27. 安全性管理指南
  28. 实用程序指南

上面每一本手册的目录列表请参考:ASE 15.7 ESD#2中文版官方手册目录列表

ASE 15.7 ESD#2中文版官方手册目录列表2

随着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信息!
不仅仅包括BUG的详细描述信息,还包括首次报告BUG的平台、数据库版本以及BUG修复历史过程;有些BUG还提供了Workaround来临时解决该BUG带来问题。

PB Enterprise的所有已知BUG列表(1)
PB Enterprise的所有已知BUG列表(2)
PB Enterprise的所有已知BUG列表(3)
PB Enterprise的所有已知BUG列表(4)
PB Enterprise的所有已知BUG列表(5)
PB Enterprise的所有已知BUG列表(6)
PB Enterprise的所有已知BUG列表(7)
PB Enterprise的所有已知BUG列表(8)
PB Enterprise的所有已知BUG列表(9)
PB Enterprise的所有已知BUG列表(10)
 

CR
Number
Description
666115 When a NUMBER type column is added to the table created to Oracle Database, the data pipeline of PowerBuilder cannot recognize correct.

A NUMBER type column changes to a FLOAT type.

This issue is reproduced by Oracle 11.

666583 When setting different levels of Print.Preview.Zoom, inexact positioning leads to artefacts, specially when using boxes around columns.
666678 Z order of the button control located to the header area of DataWindow is not correct.
666957 The customer has a tab with many tab pages on a very small response window. There are so many tab pages that the tabs are wrapped at the top. This pushes down the area where the tab pages display. In the tab constructor even, he makes several tab pages invisible such that only 2 or 3 tab pages are visible and there is no longer any need to wrap the tabs. But the tab page display is still pushed down as if the tab pages were still wrapped. Because there window is so small, text gets chopped at the bottom.

As a workaround he is using a popup window. This works fine, and re-displays the non wrapped tab pages correctly. But he needs this to work for a response window.

666982 BUG * Treeview RowFocusIndicator issue. Behavior not consistent when changing SelectNodeByMouse property.
667239 PageCount() DataWindow expression function on a Datawindow control may return incorrect values in non-Preview mode if the DataWindow has a control in the summary area.

随着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信息!
不仅仅包括BUG的详细描述信息,还包括首次报告BUG的平台、数据库版本以及BUG修复历史过程;有些BUG还提供了Workaround来临时解决该BUG带来问题。

PB Enterprise的所有已知BUG列表(1)
PB Enterprise的所有已知BUG列表(2)
PB Enterprise的所有已知BUG列表(3)
PB Enterprise的所有已知BUG列表(4)
PB Enterprise的所有已知BUG列表(5)
PB Enterprise的所有已知BUG列表(6)
PB Enterprise的所有已知BUG列表(7)
PB Enterprise的所有已知BUG列表(8)
PB Enterprise的所有已知BUG列表(9)
PB Enterprise的所有已知BUG列表(10)
 

CR
Number
Description
490858 Error during 'New Table' create using Specific Kanji columns name.
490859 Error during 'Table Name' uses specific Kanji table name.
490884 When trying to create a datawindow from a stored

procedure as the datasource, the following error will occur if the input arguments

are on different lines or have tabs within them:

DataWindow Wizard

Cannot create DataWindow.

'SQL Error -201: A syntax error has occurred

1 execute tsmaint.accm_test3;0 =:a, =: , =: , =: '

490901 Excel 2003 (excel 8) had a row limit of 65536 and

a column limit of 256.

Excel 2007 and higher has a greater row limit and column limit as per:

http://office.microsoft.com/en-us/excel/HP100738491033.aspx?pid=CH101030621033

Currently in the dwrxls.cpp, it is set to 65535:

// check the row-count against Excel's worksheet limit

if (rowCount > 65535)

return rc;

490907 Assemblies created with PB 11 get a wrong LibraryList when called from a VisualStudio WebService. Calling the assembly from a normal VisualStudio WinForm application works fine.

随着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信息!
不仅仅包括BUG的详细描述信息,还包括首次报告BUG的平台、数据库版本以及BUG修复历史过程;有些BUG还提供了Workaround来临时解决该BUG带来问题。

PB Enterprise的所有已知BUG列表(1)
PB Enterprise的所有已知BUG列表(2)
PB Enterprise的所有已知BUG列表(3)
PB Enterprise的所有已知BUG列表(4)
PB Enterprise的所有已知BUG列表(5)
PB Enterprise的所有已知BUG列表(6)
PB Enterprise的所有已知BUG列表(7)
PB Enterprise的所有已知BUG列表(8)
PB Enterprise的所有已知BUG列表(9)
PB Enterprise的所有已知BUG列表(10)
 

CR
Number
Description
416605 Get NotModified! for modified data after Filter and GetFullState/SetFullState
416610 The Today Item is not included correctly into the registry when using the enhanced cab generation tool. Whe using the project painter it works fine.
416662 WM5 Specific - SIP doesn't always go down when it should - for MAIN! window only

(works fine in WM-2003)

Using "Reeds Tests"

a) SIP Tests - MAIN

a1) focus on any control, the SIP remains up.

Even though the property "ShowSIPOnFocus" is either true or false

**this is an error**

a2) button SIP_DOWN never happens

**this is an error**

a3) button SIP_ForceDown works properly

b) SIP Tests - RESPONSE

b1) all conditions work properly

Even though all the code and properties are the same

c) TrackBarTest works fine

c1) focus to the SLE - you get the SIP

c2) focus to the master trackbar - SIP goes down

随着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信息!
不仅仅包括BUG的详细描述信息,还包括首次报告BUG的平台、数据库版本以及BUG修复历史过程;有些BUG还提供了Workaround来临时解决该BUG带来问题。

PB Enterprise的所有已知BUG列表(1)
PB Enterprise的所有已知BUG列表(2)
PB Enterprise的所有已知BUG列表(3)
PB Enterprise的所有已知BUG列表(4)
PB Enterprise的所有已知BUG列表(5)
PB Enterprise的所有已知BUG列表(6)
PB Enterprise的所有已知BUG列表(7)
PB Enterprise的所有已知BUG列表(8)
PB Enterprise的所有已知BUG列表(9)
PB Enterprise的所有已知BUG列表(10)
 

CR
Number
Description
352128 Request for an option for closer integration of DW.NET(DWDesigner) with VisualStudio. Customer feels that the best way is to save DW not in PBL(PBD) but in RESX-files. This way there will be no need to deploy pbd with app, resx could be embeded in EXE(DLL).
352133 Filter method returns void not the number of rows filtered as the on-line help indicates.
352137 This is a follow-on to CR 348892. A datawindow has only a computed column displayed, and the expression uses the value of a source datawindow column. The datawindow is empty (no rows). If you use dot notation to insert a value into the source column for a row that doesn't exist, the rows are inserted and the value is assigned to the appropriate source column in the appropriate row. But the computed column based on the source column does not display.
352162 Add GetFullState, SetFullState in PocketBuilder.
352164 Add option to have a web page using the PowerBuilder Window ActiveX control be configured to use the WinXP style for visual controls.
352165 PB errors out for a DW stored proc. insert when the first argument is null. This happens for an ODBC driver and one gets an error message Program Type Out of range which comes from ODBC driver manager.
352175 Errors in compiled HTML Help file: Several Titles/Topics are incomplete, or simply listed as "untitled".
352177 If you create a comment in the header section of the XML template for a DataWindow that is then used as a nested DataWindow in another DataWindow, when saving rows as XML the nested datawindow is not included in the XML generated.
352185 DataWindow Designer 1.0 needs an option "Open last project at startup" or "Reload project on startup" in the "System Options".
352249 Making an odbc connection from a PowerBuilder component in EAS 5.0 fails

when using a FILE DSN or DSN-less connect.

This CR is related to CR 329080 for earlier EAServer versions.

==========

DSN-less connects are not supported, the connection parameters need to be written to a dsn file. Also the length of the pathname may not be too long (up to 80-90 characters).

Examples:

SQLCA.DBParm = "ConnectString='FILEDSN=c:\test_asa.dsn;uid=dba;pwd=sql'"

随着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信息!
不仅仅包括BUG的详细描述信息,还包括首次报告BUG的平台、数据库版本以及BUG修复历史过程;有些BUG还提供了Workaround来临时解决该BUG带来问题。

PB Enterprise的所有已知BUG列表(1)
PB Enterprise的所有已知BUG列表(2)
PB Enterprise的所有已知BUG列表(3)
PB Enterprise的所有已知BUG列表(4)
PB Enterprise的所有已知BUG列表(5)
PB Enterprise的所有已知BUG列表(6)
PB Enterprise的所有已知BUG列表(7)
PB Enterprise的所有已知BUG列表(8)
PB Enterprise的所有已知BUG列表(9)
PB Enterprise的所有已知BUG列表(10)
 

CR
Number
Description
306191 A systemerror in open event of a response window, is delayed until the window closes.

This is not a bug, but a result of the changes in 8.0 with exception handling. See CR 239632 for details.

306194 Problems when setting Autoscript Delay to 10 milliseconds with autopopup.
306278 Using the EncryptMessage function with SOAP, receiving the

following error:

SOAP Exception

Error while parsing SOAP XML payload: reference to invalid character number

The load file shows:

CLOSED

REQUEST:

随着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信息!
不仅仅包括BUG的详细描述信息,还包括首次报告BUG的平台、数据库版本以及BUG修复历史过程;有些BUG还提供了Workaround来临时解决该BUG带来问题。

PB Enterprise的所有已知BUG列表(1)
PB Enterprise的所有已知BUG列表(2)
PB Enterprise的所有已知BUG列表(3)
PB Enterprise的所有已知BUG列表(4)
PB Enterprise的所有已知BUG列表(5)
PB Enterprise的所有已知BUG列表(6)
PB Enterprise的所有已知BUG列表(7)
PB Enterprise的所有已知BUG列表(8)
PB Enterprise的所有已知BUG列表(9)
PB Enterprise的所有已知BUG列表(10)
 

CR
Number
Description
256943 Editmask of type uppercase does not accept numbers as a valid value.
256950 WebDW DDDW/DDLB remains enabled on zero taborder or protected.
256964 datastore.reset() not freeing up datastore memory.
257016 PB treats the Oracle USER function as a literal
Workaround: Use Convert to Syntax
257024 8.0 Regression: Edit Mask !!!!-####-## not working properly
257064 Nested DW w/Footer Band info not printing at bottom of LAST PAGE ONLY
257065 Version info is not correctly written to 8.0 PB executables.
257176 PB catalog Varchar columns are created as datalink
257213 If the targets and storage location for archives is located on a network drive and the same folder then Add to source control and update to pbg file will fail.
257216 PB 8 build 6048, 7041 , PBNative Source Control

If Local Root Folder is set to root folder (d when workspace is created in d:\temp) then SCC connects in offline mode
It is probably because when you click the browse button and choose d drive then the folder inserted for local root is "d" not
"d:"

257220 PB 8 build 6028, 7041, PBNative Source Control

If workspace and local root are in the folder where PB 8 is installed and the target and archives are on the network (or differend Drive) then when you try to add an object to source control the object is successfully added but the pbg file does not get updated with the new addition

257233 Udating a dddw column in a dw on OLEDB connection gives update error

随着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信息!
不仅仅包括BUG的详细描述信息,还包括首次报告BUG的平台、数据库版本以及BUG修复历史过程;有些BUG还提供了Workaround来临时解决该BUG带来问题。

PB Enterprise的所有已知BUG列表(1)
PB Enterprise的所有已知BUG列表(2)
PB Enterprise的所有已知BUG列表(3)
PB Enterprise的所有已知BUG列表(4)
PB Enterprise的所有已知BUG列表(5)
PB Enterprise的所有已知BUG列表(6)
PB Enterprise的所有已知BUG列表(7)
PB Enterprise的所有已知BUG列表(8)
PB Enterprise的所有已知BUG列表(9)
PB Enterprise的所有已知BUG列表(10)
 

CR
Number
Description
216897 When you change a computed field created by manipulating NUMERIC columns (na + nb) and one of the column values in the expression is NULL, the computed field becomes "0" after you change it's expression. (to, say "na")

ex:
If na and nb are numeric columns and compute_1 is made up of 'na+nb' and na and nb are null, the computed field will turn from NULL (blank) to zero when the expression is changed to "na". It should remain NULL since one or both of the columns is null.

216901 The dw export file from PB5.x does not migrate nor import correctly to PB7.x if property HSplitScroll is enabled. Repaint problems happen when the VScrollBar DownArrow is pressed.
216906 PB 7.0.2 build 8026 regression from PB 6.5.1.

Datawindow with string/character colum with an editmask. Highlight value in column and press the Delete key. When user tries to reenter data the first character input is ignored and does not appear. All subsequent characters are fine.

As an example if a character column has an editmask on it and the string is 'ABCD'. Highlight the entire string and hit the delete key. Try reentering 'EFGH' and you will only see 'FGH'.

216909 7.0 Regression. The TableCriteria/TableOwner setting used with PBDIR to DB2/MVS causes a GPF in PBVM70.DLL when either opening the table list in the database painter or anywhere the 'Select Tables' dialog is presented (as in the datawindow painter, SQL Select datawindow creation).

Appears to work fine in 7.0 builds > 8025

216930 Filter expression with "column in (<list>)" causes memory leak. This can become severe with a high number of iterations.
217051 In runtime a Datawindow of style grid is not refreshed sometimes. If dragging (very fast) another window e.g. Explorer over a grid dw it could happen that a black square appears.

Map the pbm_paint in the window and place following script in the event:
dw_1.setredraw(FALSE)
dw_1.visible = FALSE
dw_1.setredraw(TRUE)
dw_1.visible = TRUE