Re: SQL CLI Help

[Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx>]

Hi Jeff,

> Regarding the SQLFetchScroll, according to the manual, the offset 
> parameter can be the number rows to fetch.
>
> SQLINTEGER FetchOffset input Number of the row to fetch. The 
> interpretation of this argument depends on the value of the 
> FetchOrientation argument.

This says "Number of the row to fetch".  This means that it will fetch ONE 
row (note that it says "row", not "rows") and the row that it fetches will 
be identified by the number you specify.

For example:

       SQLFetchScroll( stmt: SQL_FETCH_RELATIVE: 15);

This means that it'll move the cursor forward 15 rows, and then fetch the 
row at that position.

The third parameter (called "offset") is ignored for SQL_FETCH_NEXT, 
SQL_FETCH_PRIOR, SQL_FETCH_FIRST and SQL_FETCH_LAST -- as I said earlier, 
it's only used with SQL_FETCH_RELATIVE (on other systems, there's also 
SQL_FETCH_ABSOLUTE, though this isn't listed in the iSeries docs.)

> I assume that the SQLGetDiagRec is failing for the same reason as the 
> other statement?
> If so, what should I use to get the reason for an error?

I'm not familiar with SQLGetDiagRec, I always use SQLError