Hi,
How to read a DBF file and convert it to CSV file in Unix shell script.
Search found 76 matches
- Thu Jun 20, 2019 7:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading DBF file in UNix and convert to CSV
- Replies: 2
- Views: 3329
- Thu Jun 20, 2019 6:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Throwing exception: APT_BadAlloc: Heap allocation failed.
- Replies: 7
- Views: 7257
- Thu Jun 20, 2019 6:10 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Throwing exception: APT_BadAlloc: Heap allocation failed.
- Replies: 7
- Views: 7257
- Tue Jun 18, 2019 7:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Throwing exception: APT_BadAlloc: Heap allocation failed.
- Replies: 7
- Views: 7257
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...
- Tue Jun 18, 2019 2:05 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Throwing exception: APT_BadAlloc: Heap allocation failed.
- Replies: 7
- Views: 7257
Re: Throwing exception: APT_BadAlloc: Heap allocation failed
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 ...
- Wed May 08, 2019 7:49 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Throwing exception: APT_BadAlloc: Heap allocation failed.
- Replies: 7
- Views: 7257
Throwing exception: APT_BadAlloc: Heap allocation failed.
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.
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.
- Wed Feb 27, 2019 10:27 pm
- Forum: General
- Topic: XMETA - How to find JobRunTime, Job status
- Replies: 1
- Views: 2453
XMETA - How to find JobRunTime, Job status
Hi ,
How to find Job start time, Job end time and job status from XMETA tables
How to find Job start time, Job end time and job status from XMETA tables
- Sun Feb 10, 2019 11:27 pm
- Forum: General
- Topic: How to Read DBF File in datastage
- Replies: 2
- Views: 3176
How to Read DBF File in datastage
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.
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.
- Wed Mar 21, 2018 5:54 am
- Forum: General
- Topic: Email Notification activity sending AT000001.txt
- Replies: 4
- Views: 4529
Email Notification activity sending AT000001.txt
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...
- Fri Aug 11, 2017 12:35 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Special characters in Test - How to handle in datastage
- Replies: 1
- Views: 2534
Special characters in Test - How to handle in datastage
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
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
- Tue May 02, 2017 1:42 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unix Script to Connect to SQL Server
- Replies: 6
- Views: 5173
- Tue May 02, 2017 12:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unix Script to Connect to SQL Server
- Replies: 6
- Views: 5173
- Mon May 01, 2017 2:22 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unix Script to Connect to SQL Server
- Replies: 6
- Views: 5173
Unix Script to Connect to SQL Server
Hi All,
Any idea how to write a script to connect to SQL server from unix?
thanks
Naren
Any idea how to write a script to connect to SQL server from unix?
thanks
Naren
- Mon May 01, 2017 2:21 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Inserting XML into SQL Server table XML column
- Replies: 3
- Views: 3938
- Fri Apr 28, 2017 2:42 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Inserting XML into SQL Server table XML column
- Replies: 3
- Views: 3938
Inserting XML into SQL Server table XML column
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
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