Re: SQL CLI Help

[Jeff Young <cooljeff913@xxxxxxxxx>]

Scott,
I had an incorrect value set in my last message.
The code I am getting an error on is:
   cbRows_to_Fetch = %Len(Rows_to_Fetch);         
   Rc = SQLSetStmtAttr (hstmt                   : 
                        SQL_ATTR_ROW_ARRAY_SIZE : 
                        pRows_to_Fetch          : 
                        cbRows_to_Fetch);         
This is returning a RC = -1 and the SQ99999 with Error 9.
 
Any ideas?
 
Thanks,
 
Jeff Young


----- Original Message ----
From: Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx>
To: RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
Sent: Wednesday, July 19, 2006 12:43:24 PM
Subject: Re: SQL CLI Help


Hi Jeff,

>  Rc = SQLGetStmtAttr (hstmt               :
>                     SQL_ATTR_ROW_NUMBER :
>                     pRows_Returned      :
>                     %Len(Rows_Returned) :
>                     Bytes_Returned);
>  Error type 9 is argument value not valid.

I can't find any reference to SQL_ATTR_ROW_NUMBER in the manual?  What is 
SQL_ATTR_ROW_NUMBER? I suspect that the problem is that 
SQL_ATTR_ROW_NUMBER isn't supported on iSeries.