Upload .dbf file

[abhishek.tripathi]

Hi,

I am tring to upload data into .dbf file from a dataset using odbc connector. The table in which i have to upload the data doesn't exist so i am using Write Method as 'Insert' and Table Action as 'Create' in the odbc connector. I have defined the dsn in uvodbc.config. But i am unable to create and upload the .dbf file using the odbc connector, i tried the same using Dynamic RDBMS stage but unable to get success there too. If anyone has ever created and uploaded foxpro .dbf file using datastage then please help me. I am getting the following error:

ODBC_Connector_89: [IIS-CONN-ODBC-000106] Statement generated is create table Moses(bus_type (2),product (7),purpose (8),group (30),date_stamp (20),postcode (11),fund (1),cedant (3),tty_id (7),curr (2),reinstype (6),cess_type (2),pric_trche (2),retr_type (1),plan (3),acc_unit (6),cedrec_id (15),mrerec_id (20),er_paid (1))
[IIS-CONN-ODBC-000013] ODBC Info: SQLSTATE = 42000: Native Error Code = -3,553: Msg = [Microsoft][ODBC dBase Driver] Syntax error in field definition.
Resource bundle corresponding to message key CONN-NGBR-00002 not found! Check that DSHOME or APT_RESPATH is set.
Resource bundle corresponding to message key CONN-NGBR-00002 not found! Check that DSHOME or APT_RESPATH is set.


I have set the DSHOME = P:\IBM\InformationServer\Server\DSEngine and APT_RESPATH = P:\IBM\InformationServer\Server\DSComponents\res\DSEE in user defined environment variables as well.