The following code returns different result in df20 than 19.1.

I converted an existing app from 19.1 to df20 and was having issues with eSQL calls.

There is a difference as shown below.

I know help states that it is sometimes -1 depending on the usage but this is a distinct difference in the same code

Code:

Procedure SQLtest
   String[][] sData
   String sSQL
   Integer iRows
   Handle hConnect hStmt
   
   Move 'select * from myfile' to sSQL
   Get SQLConnectionId of ghoConnection 'MyConnID' to hConnect
   
   Get SQLOpen of hConnect to hStmt
   If hStmt Begin
      Send SQLSetStmtAttribute of hstmt SQLSTMTATTRIB_CURSOR_TYPE  SQL_CURSOR_STATIC  // SQL_CURSOR_STATIC
   End
   Send SQLExecDirect of hStmt sSQL
   Get SQLGetStmtAttribute  of hStmt SQLSTMTATTRIB_ROWCOUNT    to iRows <--------------- 19.1 reports correctly the number of rows returned to sData  df20 always returns -1


   Get SQLFetchResultsetValues of hStmt to sData
   
   Send SQLClose of hStmt
   Send SQLDisconnect of hConnect


End_Procedure