LO40409: RFC_READ_TABLE NOT RETURNING EXPECTED VALUES

APAR status

• Closed as fixed if next.

Error description

• Using the SAP connector 172    calling RFC_READ_TABLE  different
  results occur
  when accessing DEC 10 data see details below:
  
  1) This works
  Set up which RFC we want to call
   gSAPCon.Database = "RFC_READ_TABLE"
  
   'We want to work with IMPORTS and EXPORTS, * allows us to do
  this
   gSAPCon.Metadata = "*"
   gSAPCon.mapbyname = True
  
   strLCExecuteStatement = ""
  ' strLCExecuteStatement = strLCExecuteStatement +
  |QUERY_TABLE="TableX",|
   strLCExecuteStatement = strLCExecuteStatement +
  |QUERY_TABLE="TableY",|
   strLCExecuteStatement = strLCExecuteStatement +
  |DELIMITER="#",|
   strLCExecuteStatement = strLCExecuteStatement + |NO_DATA="
  ",|
   strLCExecuteStatement = strLCExecuteStatement + |ROWSKIPS=0,|
   strLCExecuteStatement = strLCExecuteStatement + |ROWCOUNT=0,|
  
   strLCExecuteStatement = strLCExecuteStatement +
  |OPTIONS.1.TEXT="VALUE =
  'xxxxxxxxx' AND NUMBER = 9999999999"|
  
  
  2) This fails
  'logon
   gSAPCon.Connect
  
   'Set up which RFC we want to call
   gSAPCon.Database = "RFC_READ_TABLEZZZZZZZ"
  
   'We want to work with the table ZZZZZZZ
   gSAPCon.Metadata = "ZZZZZZZ"
   gSAPCon.mapbyname = True
  
   Dim strSAPFieldsList List As String
  
  strSAPFieldsList("field2")=""
   strSAPFieldsList("otherfield")=""
  
   strLCExecuteStatement = ""
   i = 1
   Forall fastrField In strSAPFieldsList
    strLCExecuteStatement = strLCExecuteStatement + |FIELDS.| &
  Ltrim$(Str$( i ))
  & |.FIELDNAME="| & Listtag( fastrField ) & |",|
    i = i + 1
   End Forall
  
   strLCExecuteStatement = strLCExecuteStatement +
  |OPTIONS.1.TEXT="VALUE =
  'xxxxxxxx' AND NUMBER = 99999999"|
  
   PrintLog(  "The select statement is:" )
   PrintLog(  strLCExecuteStatement )
   PrintLog(  " " )
   PrintLog(  "The select statement is " &
  Len(strLCExecuteStatement) & "
  characters long" )
  
   ' Call (Excute) the RFC function
   intCountInsert = gSAPCon.Execute( strLCExecuteStatement,
  LCFLoutput )
  

Local fix

Problem summary

• The problem will be fixed in the next release of the product.
  

Problem conclusion

Temporary fix

Comments

• This APAR is associated with SPR# SSHE7RYGWF.
  The problem will be fixed in the next release of the product.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

• NA
  

Fix information

Applicable component levels

• R801 PSN

     UP