APAR status
Closed as fixed if next.
Error description
When using SQL Server, possibly only SQL Server 2005, running the Transaction Extract causes the error: Incorrect syntax near the keyword 'AND'.
Local fix
A temporary rewrite entirely in VBScript can be used to replace this functionality. Additionally, an upgrade to ITUAM 6.1 will probably fix the problem or an upgrade to TUAM 7.1 will definitely fix the problem.
Problem summary
Transaction Extract Error of "Incorrect syntax near the keyword 'AND'"
Problem conclusion
Temporary fix
There is a temporary VBScript rewrite for customers prior to ITUAM 6.1. Preferred solution is upgrade to ITUAM 6.1 or TUAM 7.1
Comments
APAR Information
APAR number
IZ04634
Reported component name
USAGE & ACT MGR
Reported component ID
5724O4700
Reported release
510
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2007-09-11
Closed date
2007-09-11
Last modified date
2007-09-11
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
R610 PSY
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSNHH4","label":"Tivoli Usage and Accounting Manager for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"510","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
11 September 2007