Couple Questions - Client Access ODBC and ADO

[frosteemjj]

ADO

Is there a way to limit the resulting recordset object to x records, like doing a "Select Top" in SQL Server? I am connecting to a very large file, and sometimes I only want to validate a couple of things, so it would be nice not to have to rely solely on the "WHERE" clause to filter.

Is it possible to get to a list of files in a library (like to present them in a pick list)?

Can anyone point me to a sample program that would be able to get to the field definitions on a 400 file ( like field xxx is CHAR, and field yyy is ZONED-8,0 )?

ODBC

I am having a problem linking to files (JD Edwards) that have CHAR data stored in a field that is CCSID 65535. The information comes back unreadable, and appears to just be ignoring the check box for "Convert binary data (CCSID 65535) to text" ( The box is checked on the Translation tab of the ODBC setup. ). I am using v5r2m0 Service Level SIO4484 of IBM iSeries Access for Windows. The 400 is at v4r5m0.

I was only able to get ADO to return values because I found an article that mentioned using "Force Translate" on the connection object.

Any suggestions would be appreciated.

[jtemple]

Re: Couple Questions - Client Access ODBC and ADO

For ODBC - on the Translation tab of the ODBC driver configuration ensure that "Convert binary data (CCSID 65535) to text" is checked.

[frosteemjj]

Re: Couple Questions - Client Access ODBC and ADO

Thanks. I edited the original post to emphasize that the box is checked, but is apparently being ignored.