# Data Transfer from Mainframe to NT **URL:** \ **Category:** Forum\ **Tags:** Adabas-Natural, Adabas, Adabas-on-Linux, Adabas-Utilities-on-Open-Systems\ **Created:** [October 21, 2005, 12:24pm UTC](https://techcommunity.softwareag.com/t/data-transfer-from-mainframe-to-nt/57803 "2005-10-21T12:24:47Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Mukunthan\_Sundararajan2](https://avatars.discourse-cdn.com/v4/letter/m/dbc845/32.png) [@Mukunthan\_Sundararajan2](https://techcommunity.softwareag.com/u/Mukunthan_Sundararajan2)\ **Post date:** [October 21, 2005, 12:24pm UTC](https://techcommunity.softwareag.com/t/data-transfer-from-mainframe-to-nt/57803/1 "2005-10-21T12:24:47Z")
Hi, Please see below , the following are the steps i did to transfer data from adabas/mainframe to adabas/NT 1. DECOMPRESSED data using ADACMP. (e.g - Decompressed say 10,000 records which has got Thai characters) 2. FTP using binary mode onto PC. 3. Used CVT\_FMT -f \<.binary file name\> dbid filenumber. ( e.g. - All 10,000 records we received in output file) 4. Using DBA Workbench, File structure is created from the FDT structure that we get from ADACMP. 5. We used COMPRESS option from MENU from DBA Workbench to load the data into this file. (e.g. - All 10,000 records were loaded) 6. When we see the all the records using Natural, we are able to see junk characters in place of Thai characters. All numeric fields were holding right data. English characters were also visibile. after completing all the steps. when i browse the data using Natural Data browser i am not able to see the thai characters. i need solution very badly. is there any limitation with NPP software provided by software ag or any setting in adacmp to recogonize the thai characters. please help me out in this reg. :? ---
**Author:** ![Andreas\_Schuetz](https://avatars.discourse-cdn.com/v4/letter/a/eb9ed0/32.png) [@Andreas\_Schuetz](https://techcommunity.softwareag.com/u/Andreas_Schuetz)\ **Post date:** [October 24, 2005, 5:35pm UTC](https://techcommunity.softwareag.com/t/data-transfer-from-mainframe-to-nt/57803/2 "2005-10-24T17:35:15Z")
The problem is that the standard code page translation via CVT\_FMT only translates standard US-EBCDIC into US-ASCII characters. The translation table does not include Thai characters. Instead of using CVT\_FMT the utility ADACMP should be used, but with the correct codepage translation table supplied via the userexit ADACMP Userexit 6. For information how please check the Adabas documentation. In case of further question, please contact me at [as@softwareag.com](mailto:as@softwareag.com). Rgds Andreas ---
**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\ **Post date:** [October 25, 2005, 5:23pm UTC](https://techcommunity.softwareag.com/t/data-transfer-from-mainframe-to-nt/57803/3 "2005-10-25T17:23:11Z")
Using CVT\_FMT is no longer the recommended way to transfer data from mainframe to Open Systems. It is recommended to use the FTP site rdw option and to use ADACMP with the parameter RECORD\_STRUCTURE=RDW . For more information see the Utilities Manual, chapter ADACMP. For the code page conversion it is not necessary to write a user exit as Andreas Sch ---
**Author:** ![Melo](https://avatars.discourse-cdn.com/v4/letter/m/e495f1/32.png) [@Melo](https://techcommunity.softwareag.com/u/Melo)\ **Post date:** [February 17, 2006, 11:52pm UTC](https://techcommunity.softwareag.com/t/data-transfer-from-mainframe-to-nt/57803/4 "2006-02-17T23:52:36Z")
Hi Wolfgang, I need trasfer a lot of data (30GB) into an Adabas MF (VSE) and an Adabas C (SuSE). I use the transfer model of Mukunthan said, but is very slow. Is possible transfer the data using Protection Log? Or other manner most fast… Tks. ---
**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\ **Post date:** [February 23, 2006, 11:08pm UTC](https://techcommunity.softwareag.com/t/data-transfer-from-mainframe-to-nt/57803/5 "2006-02-23T23:08:31Z")
Unfortunately the only way is to decompress the data on Mainframe and to compress them again on Open Systems. Sorry about that. Wolfgang ---
**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\ **Post date:** [March 28, 2006, 6:41am UTC](https://techcommunity.softwareag.com/t/data-transfer-from-mainframe-to-nt/57803/6 "2006-03-28T06:41:45Z")
Wolfgang, I saw your comment about the “CVT\_FMT no longer the recommended way to transfer data”. We have always been using this - I quess I just wanted reassurance that all packed fields, MU’s, PE’s are handled correctly. I will try your method. That would be considerable time saver for us. We have 400 GB of data to transfer and load. ---
**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\ **Post date:** [March 28, 2006, 11:54pm UTC](https://techcommunity.softwareag.com/t/data-transfer-from-mainframe-to-nt/57803/7 "2006-03-28T23:54:53Z")
I tried the RDW option but I could not get it to work. I FTP’ed using the RDW option and tried to Compress again using the RDW option however it does not work - it always comes back with “0” records compressed. ---
**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\ **Post date:** [April 5, 2006, 6:18pm UTC](https://techcommunity.softwareag.com/t/data-transfer-from-mainframe-to-nt/57803/8 "2006-04-05T18:18:18Z")
Hi Garry, Did you FTP the data as binary? Wolfgang ---
**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\ **Post date:** [April 2, 2021, 2:38pm UTC](https://techcommunity.softwareag.com/t/data-transfer-from-mainframe-to-nt/57803/9 "2021-04-02T14:38:52Z")