DB2 to Text File Conversion and Transfer




 I have created a Text File from my AS/400 DB2 table. I want to transfer this file from one iSeries system to another. How to do this?
If your intent is to move a file from one iSeries (or System i) to another iSeries/System i then I’m not sure why you are going through the intermediate step of a text file. But in any case, if you have TCP/IP up between the two systems then FTP is the way to go.


If you just want the data, ftp the file.


If you want the database:  

Create a save file on the source system  

Save the database to the save file  

Create a save file on the target system  

FTP the save file to the target system in binary mode  

Restore the database on the target system


If you’re not familiar with FTP let us know. We can guide you through the steps (there aren’t many). If you don’t have TCP/IP between the two systems, let us know what options you do have in transferring data between the two systems (SNA, tape, etc).


Bruce Vining
well, transferring your data and transferring that and your settings are different. data, such as music, letters, video, pictures can burn to disk or copy/move to external drive. installed applications won't go, you'll have to reinstall from disk or download. on the other hand, you can transfer settings, favorites etc. use files and settings transfer wizard. or laplink software and cable. you might be able to use synchronize. if you have more than 2 tables, you will need to use it multiple times. Thanks for your reply, I feared it would not be trivail, as I coudnt find any scripts. Idealy the text from the databse is place in a table witht the last column beeing the barcodes path, the images are to replace the text path and be place inside the cell, fitting within the cells width and/or height. please refer to the adaptation guide in the developer guide. there is tutorial for how to modify dtb for usb. yes you add second as a slave drive, boot from one that has os, second has data. access thru my computer for second one. I just posted an example of this over in a similar thread about JTable [here](/software-development/java/threads/373078/1605358#post1605358). Perhaps it will help. so if you want to be able to run them as separate runs, you’ll still need some way of communicating between them. one mechanism we provide for that is by serializing daml values as json through the --input-file and --output-file options to daml script. so in your case, you should make sure that the … Well, the only piece of the code you wrote that will be of any use for that assignment at all is the Scanner (though a BufferedReader would be my own choice for that). The instructions are pretty clearly laid out and does tell you what you need to use from that jss2 folder.



You need to read the file line by line. The first line is the input to create the BST. For the rest of the lines you will need to parse and match the command token to the appropriate action to take on the BST. String.split() will be useful for that part to separate <command> <parameters>.



So time to crack the books and get a start on it. Post specific questions if you run into trouble. Good luck! let table = base.gettable("table 1")

let record = await input.recordasync("record", table)

await table.updaterecordasync(record.id, {

"single select": null

}) hello,

there are more possibilities how write output to file. first is by standard methods of jscript by “scripting.filesystemobject”.

var fso = new activexobject(“scripting.filesystemobject”);

var forreading = 1;

var forwriting = 2;

if (fso.fileexists(‘c:\test.txt’))

var f1 = fso.opentextfile…