Whats a good tool/software to import (excel, csv) into IBM DB2

15 pts.
Tags:
CSV
import DB2
Microsoft Excel
Whats a good tool/software to import (excel, csv) into IBM DB2? Would be great if this tool/software is free or doesn't costs to much. thanks

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hello Geyes,
<a href=”https://www.regsoft.net/regsoft/vieworderpage.php3?productid=79982″>this tool costs only 20€</a> so i’d say it is not too much.
Bye

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Msenatore@fisa
    Dear GEYES, Please specify your platform and version number when you post a question here, it is helpful to those who really want to give you a high quality answer. Now, if you are on UDB for Linux, Unix or Windows (LUW) you can easily learn the syntax of the import command by entering DB2 ? Import or for export DB2 ? export. In your case, you should save your excel file as a csv ( comma delimted) then use the import command as follows: IMPORT From FIlename OF DEL delimited by ',' ......... Insert or Create into schemaname.tablename. From DB2 ? Import.... IMPORT FROM filename OF {IXF | ASC | DEL | WSF} [LOBS FROM lob-path [ {,lob-path} ... ] ] [MODIFIED BY filetype-mod ...] [METHOD {L ( col-start col-end [ {,col-start col-end} ... ] ) [NULL INDICATORS (col-position [ {,col-position} ... ] )] | N ( col-name [ {,col-name} ... ] ) | P ( col-position [ {,col-position} ... ] )}]
    185 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following