VBA SQL against Mainframe DB2

[adbrad]

I am doing an SQL statement in VBA against a Mainframe DB2 database. The table on the mainframe has High Values in the field. When I do a query on the mainframe, I would put "SELECT * FROM Table WHERE STATE = X'FFFF'". I get an General ODBC error when using it in VBA SQL. Is there a way to get the records with fields that have high values in it? I have also tried "..WHERE STATE = 'ÿÿÿ', which it returns in the STATE field when I don't have the STATE in the query.

Anyone know a solution?

 

[RayFrye]

Your queries look strange, suspect some sort of character transformation. Basically, based on my experience, any SQL build on any platform should execute on any other.