APAR status
Closed as program error.
Error description
Job has a stored procedure stage reading from MS SQL Server, to a Transformer Stage, and writing to DB2 through a DB2 UDB stage. The log shows 535 rows are processed, yet 536 rows end up in the DB2 target database, with the extra one consisting of all blank/null/0 values, depending on datatype.
Local fix
Problem summary
**************************************************************** USERS AFFECTED: All users of Stored Procedure Stage connecting to MS SQL Server Database **************************************************************** PROBLEM DESCRIPTION: STP stage connecting to MS SQL Server is sending one extra row to the output link with all column values to NULLs and 0 (zero for procedure return code) **************************************************************** RECOMMENDATION: Apply this APAR. ****************************************************************
Problem conclusion
Problem has been corrected not to send an extra row unless the user has selected "Procedure Status to link" check-box
Temporary fix
Comments
APAR Information
APAR number
JR31623
Reported component name
INFO SRVR PLATF
Reported component ID
5724Q3612
Reported release
810
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-01-09
Closed date
2009-02-25
Last modified date
2009-02-25
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
INFO SRVR PLATF
Fixed component ID
5724Q3612
Applicable component levels
R810 PSN
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSZJPZ","label":"IBM InfoSphere Information Server"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
25 February 2009