Re: jdbc question

[Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx>]

Hi Eric,

Unless you're getting some errors (you didn't say whether you are or 
aren't) then this means that there's no data to return.

Is there any metadata available from rsmd?

The numbers in "rs" and "rsmd" (and other things like "conn" as well) 
are not useful for debugging.  These just refer to objects within the 
Java Virtual Machine (JVM) -- so you have the 23rd object and 32nd 
object, respectively.  That's not helpful for debugging, it's only 
useful to the JVM at the time you run this, not to us.

Instead, look for messages printed to the screen and/or spooled files 
when you run this.  Look at the data in the metadata by calling 
JDBC_getColCount, JDBC_getColName, etc to see if there's any metadata.

Assuming there are no errors and the metadata is what you would expect 
-- then there simply isn't any data to read in the table. In that case, 
maybe you are in the wrong database?

-SK


On 7/18/22 9:35 PM, eric bothes wrote:
> I'm trying to access an SQL server table from the iseries using JDBC 
> by Mr. Klement.
>
> When debugging variables i get the following values:
>
> rs = 23
> rsmd = 32
>
> but when jdbc_nextRow(rs) is run, it drops to end of do.
>
> Not sure how to debug what is happening. I'm able to run a query via 
> MS Access with the same select clause and get results.
>
> Code:
> sql = 'SELECT * FROM xre.bi_XRE_Account_Detail';
> rs = jdbc_ExecQry( conn : %trim(sql) );
> if (rs = *null);
>   dsply 'null found';
> endif;
> rsmd = jdbc_GetMetaData(rs);
> dow (jdbc_nextRow(rs));
> ...
> enddo