I haven't worked with DB2, but the code you're using here would produce a memo with SQL Server. The blob type maps out to a memo field in many databases. Does this code work in VFP? According to the help file, the line to create the table should be:
create table gtest ( fieldname g).
Hope that helps.
>Hi,
>
>I am using IBM DB2 ODBC DRIVER to connect to DB2 UDB 8.1.
>I have created a table for example:
>
>CREATE TABLE Gtest( gen blob)
>
>When I try to access the table from foxpro I use:
>
>H=SQLCON()
>SQLEXEC(h,'select * from gtest')
>append blank
>brow
>
>The problem is that the blob type appears as a "memo" instead of as a "general" in the foxpro environment.
>
>Is there anything I can do about this?
Steve Howie, owner
DaSH Technology
Denver, CO