| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| BUG in Fixpack 8 of WBIMB 5 |
« View previous topic :: View next topic » |
| Author |
Message
|
| Feysn |
 Posted: Thu Aug 24, 2006 6:08 am Post subject: BUG in Fixpack 8 of WBIMB 5 |
 |
|
Apprentice
Joined: 04 Jun 2004
Posts: 33
Location: Wilrijk
|
Has anyone experienced the same problem as described in here.
When executing an SQL statement with where clause be carefull.
DECLARE VAR2 CHAR;
DECLARE VAR1 INTEGER;
SELET ... FROM ... WHERE
Table.Field = VAR1 AND Table.field = VAR2;
Will not work anymore. The and function with a variable of the type Integer will not interpret the var value correctly. No values are returned from the database.
In the trace everything is resolved
example:
| Code: |
DECLARE ID INTEGER 15;
SET Environment.Variables.Fam.FAM_BRANCH_INFO[]=
(SELECT T.FBI_SALES_DISTRICT, T.FBI_SALES_OFFICE, T.FBI_SALES_GROUP, T.FBI_SAP_CUSTOMER_NUMBER
FROM Database.DB2ADMIN.TBLSAP_COMMON_FAM_BRANCH_INFO AS T
WHERE T.FBI_FAM_CODE = ID AND T.FBI_BPCS_BRANCH_CODE = BRC); |
Trace:
2006-08-24 14:19:46.230037 796 UserTrace BIP2538I: Node 'SAP_I007_CUSTOMER_MASTER.Map to sap_debmas06': Evaluating expression 'DATABASE(SELECT T.FBI_SALES_DISTRICT, T.FBI_SALES_OFFICE, T.FBI_SALES_GROUP, T.FBI_SAP_CUSTOMER_NUMBER FROM DB2ADMIN.TBLSAP_COMMON_FAM_BRANCH_INFO T WHERE ((T.FBI_FAM_CODE)=(?))AND((T.FBI_BPCS_BRANCH_CODE)=(?)), ID, BRC)' at (, 1.1).
2006-08-24 14:19:46.230228 796 UserTrace BIP2538I: Node 'SAP_I007_CUSTOMER_MASTER.Map to sap_debmas06': Evaluating expression 'ID' at (.SAP_I007_CUSTOMER_MASTER_Map_MATMAS06.Main, 174.31).
2006-08-24 14:19:46.230358 796 UserTrace BIP2538I: Node 'SAP_I007_CUSTOMER_MASTER.Map to sap_debmas06': Evaluating expression 'BRC' at (.SAP_I007_CUSTOMER_MASTER_Map_MATMAS06.Main, 174.63).
2006-08-24 14:19:46.230484 796 UserTrace BIP2544I: Node 'SAP_I007_CUSTOMER_MASTER.Map to sap_debmas06': Executing database SQL statement 'SELECT T.FBI_SALES_DISTRICT, T.FBI_SALES_OFFICE, T.FBI_SALES_GROUP, T.FBI_SAP_CUSTOMER_NUMBER FROM DB2ADMIN.TBLSAP_COMMON_FAM_BRANCH_INFO T WHERE ((T.FBI_FAM_CODE)=(?))AND((T.FBI_BPCS_BRANCH_CODE)=(?))' derived from (, 1.1); expressions 'ID, BRC'; resulting parameter values '15, '000020''.
2006-08-24 14:19:46.235080 796 UserTrace BIP2570W: Node 'SAP_I007_CUSTOMER_MASTER.Map to sap_debmas06': (.SAP_I007_CUSTOMER_MASTER_Map_MATMAS06.Main, 172.13) : There were no items in the FROM clause satisfying the WHERE clause.
When harcoding the values in the statement it works:
| Code: |
SET Environment.Variables.Fam.FAM_BRANCH_INFO[]=
(SELECT T.FBI_SALES_DISTRICT, T.FBI_SALES_OFFICE, T.FBI_SALES_GROUP, T.FBI_SAP_CUSTOMER_NUMBER
FROM Database.DB2ADMIN.TBLSAP_COMMON_FAM_BRANCH_INFO AS T
WHERE T.FBI_FAM_CODE = 15 AND T.FBI_BPCS_BRANCH_CODE = BRC); |
Trace:
2006-08-24 14:19:46.243492 796 UserTrace BIP2544I: Node 'SAP_I007_CUSTOMER_MASTER.Map to sap_debmas06': Executing database SQL statement 'SELECT T.FBI_SALES_DISTRICT, T.FBI_SALES_OFFICE, T.FBI_SALES_GROUP, T.FBI_SAP_CUSTOMER_NUMBER FROM DB2ADMIN.TBLSAP_COMMON_FAM_BRANCH_INFO T WHERE ((T.FBI_FAM_CODE)=(15))AND((T.FBI_BPCS_BRANCH_CODE)=(?))' derived from (, 1.1); expressions 'BRC'; resulting parameter values ''000020''.
2006-08-24 14:19:46.248310 796 UserTrace BIP2562I: Node 'SAP_I007_CUSTOMER_MASTER.Map to sap_debmas06': Assigning a list to 'Environment.Variables.Fam.FAM_BRANCH_INFO[]'.
2006-08-24 14:19:46.248466 796 UserTrace BIP2566I: Node 'SAP_I007_CUSTOMER_MASTER.Map to sap_debmas06': Assigning value ''BE0020'' to field / variable 'Environment.Variables.Fam.FAM_BRANCH_INFO[1]'.
2006-08-24 14:19:46.248592 796 UserTrace BIP2566I: Node 'SAP_I007_CUSTOMER_MASTER.Map to sap_debmas06': Assigning value ''0049'' to field / variable 'Environment.Variables.Fam.FAM_BRANCH_INFO[1]'.
2006-08-24 14:19:46.248714 796 UserTrace BIP2566I: Node 'SAP_I007_CUSTOMER_MASTER.Map to sap_debmas06': Assigning value ''043'' to field / variable 'Environment.Variables.Fam.FAM_BRANCH_INFO[1]'.
2006-08-24 14:19:46.248836 796 UserTrace BIP2566I: Node 'SAP_I007_CUSTOMER_MASTER.Map to sap_debmas06': Assigning value '' '' to field / variable 'Environment.Variables.Fam.FAM_BRANCH_INFO[1]'.
When reversing the variables so that the integer one comes at the end after the AND clause it also works
PMR will be opened with IBM by IBM itself with link to this description. |
|
| Back to top |
|
 |
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
