DSXchange

Hi,

How to read a DBF file and convert it to CSV file in Unix shell script.

the datatypes is ntext

Ray, can you provide me syntax of using these paramters in uvodbc.config

Ray, I cannot use uvodbc.config as the configuration seems to be very different where I am working , all values from uvodbc are not present in odbc. Infact when I check uvodbc file, I see only one ODBC connection. but could not get an update. I also see that columns with ntext are causing this issue...

What are the other stages I can use to extract data from DBT files. Also, I checked for number of bytes per block size, and i got "ODBC_Connector_0,0: Current heap size: 6071520 bytes in 19603 blocks". Hope this is help ful. Any idea how to move furhter? what are the other stages that can ...

ETL job is using ODBC stage to extract .DBF file.

I am getting below error

Throwing exception: APT_BadAlloc: Heap allocation failed.

I tried checking other threads , but did not get much help

Please help here.

Hi ,

How to find Job start time, Job end time and job status from XMETA tables

Hi, How to read DBF files in data stage which is installed on Unix.

I already have a ODBC Configured in ODBC.ini file. But not sure of the steps to read DBF file using ODBC Connector or any other stage.
Need help with steps to read the file.

HI I am sending a PDF attachment using Notification activity in the sequence job. But along with PDF attachment, I am receiving an Empty File attached with name ATT00001.txt I went through one of the Posts where it was written that there is nothing to do with datastage, it is Microsoft Xchange setti...

Hi All,

I am moving an XML content from SQL server table to a file.

In my XML content , I have (') , and Control Z characters.

datastage is not able to read these values , it writes the file with 'SUB' character.

PLease help to solve this.

thanks

Hi Chulette, the post was posted by me only, I am trying to find a way to load xml data into a single column., I am exploring a way thorugh datastage and another way through unix.

do you know how to write a unix script I have to write to connect to SQL Seerver table

Hi

I have to insert XML content present in a file into an XML column in SQL server table. through datastage, I am not able to insert complete XML into single column.
SO , I want to use a Bulk insert command in Unix SQL script and insert this data.

Any help is much appreciated.

thanks
Naren

Hi All,

Any idea how to write a script to connect to SQL server from unix?

thanks
Naren

hi. i can get full XML file when I write to disk. the problem is with ODBC Connector stage.

HI All,

I am trying to insert an XML content into XML Column datatype in SQL Server table. But I am able to insert only half of the XML.

I am using ODBC Connector stage to insert XML content.

can anyone help me in this please

Thanks
Naren