DSXchange

Hi,

I'm trying to use a Paradox (.db) table, but when I try to export the metadata definition in DS Manager, the ODBC shows this error:

DSR.MetaGeta(GET.COLUMNS)(SQLStatistics("","","cam_0703")): BCI Error:
SQLSTATE=S1000,CODE=-5015,[DataStage][SQL Client][ODBC][Microsoft][ODBC Paradox Driver]

When I click the ok button, the following message appears:

type: TABLE
Qualifier: D:\MY DOCUMENTS\CAM
Fully-qualified name: D:\MY DOCUMENTS\CAM'\'database'
Unqulified name: database
Using NLS map: MS1252

There not much about exporting Paradox tables in DS in the forum,

any ideas???

Thanks,

Do you mean IMPORT the table definition? There is no capacity in DataStage Manager to export table definitions, other than as DataStage export files (DSX or XML format).

Search (Google?) for S1000 as an SQLState value, and search your Paradox driver information as to the meaning of error code -5015. The square brackets in the message reveal that this error was generated by that driver.