DSXchange

Posted: **Thu Jul 12, 2001 5:37 pm**

> Dear all,
>
> Im getting the following error on use of an ODBC stage for foxpro, I
> pass the tablename "D" as the parameter to the job.
>
> FolderRD.HLLMST.source: DSD.BCIOpenR call to SQLExecDirect failed.
> Statement was:SELECT D.XMY, D.XMY FROM D SQLSTATE=S1004, DBMS.CODE=0
> [Ardent][SQL Client]An unsupported SQL data type was encountered
>
> Thanks in advance,
> Vivek Pandey
>
>
>
>
>

Posted: **Thu Jul 12, 2001 8:39 pm**

Ouch. Dont like the look of that.

Did you use Manager to import the metadata from the table via ODBC?

What version of the FoxPro ODBC driver are you using? Is it the latest? I have seen different versions of this driver return different metadata form the same source file/table.

David Barham
Information Technology Consultant
InformAtect Pty Ltd
Brisbane, Australia

e-mail: david@barham.hm
mobile: 0412 169 518
fax: 07 3304 5586

-----Original Message-----
From: Vivek Pandey. [mailto:vive@sonata-software.com]
Sent: Friday, 13 July 2001 3:38 AM
To: datastage-users@oliver.com
Subject: aggregator error

> Dear all,
>
> Im getting the following error on use of an ODBC stage for foxpro, I
> pass the tablename "D" as the parameter to the job.
>
> FolderRD.HLLMST.source: DSD.BCIOpenR call to SQLExecDirect failed.
> Statement was:SELECT D.XMY, D.XMY FROM D SQLSTATE=S1004, DBMS.CODE=0
> [Ardent][SQL Client]An unsupported SQL data type was encountered
>
> Thanks in advance,
> Vivek Pandey
>
>
>
>
>

Posted: **Fri Jul 13, 2001 12:09 am**

Do you log these issues with support, or simply use this list as your personal support group?

The error message is perfectly clear; your Foxpro table has at least one data type that is not supported by DataStage. It is clearly the data type of the column D.XMY, since this is the only column you are selecting.

-----Original Message-----
From: Vivek Pandey. [mailto:vive@sonata-software.com]
Sent: Friday, 13 July 2001 03:38
To: datastage-users@oliver.com
Subject: aggregator error

> Dear all,
>
> Im getting the following error on use of an ODBC stage for foxpro, I
> pass the tablename "D" as the parameter to the job.
>
> FolderRD.HLLMST.source: DSD.BCIOpenR call to SQLExecDirect failed.
> Statement was:SELECT D.XMY, D.XMY FROM D SQLSTATE=S1004, DBMS.CODE=0
> [Ardent][SQL Client]An unsupported SQL data type was encountered
>
> Thanks in advance,
> Vivek Pandey
>
>
>
>
>