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
Last Wiki Answer Submitted: May 26, 2008 9:54 am by alessandro.panzetta9,695 pts.
If you live outside the United States, by submitting your email address you consent to having your personal data transferred to and processed in the United States.
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.
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….
[COMMITCOUNT {n | AUTOMATIC}] [{RESTARTCOUNT | SKIPCOUNT} n]
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} ... ] )}]
[ROWCOUNT n] [WARNINGCOUNT n] [NOTIMEOUT] [MESSAGES message-file]
{{INSERT | INSERT_UPDATE | REPLACE | REPLACE_CREATE}
INTO {table-name [( insert-column , ... )] | hierarchy-description}
| CREATE INTO {table-name [( insert-column , ... )] |
hierarchy-description {AS ROOT TABLE | UNDER sub-table-name}
[IN tablespace-name [INDEX IN tablespace-name] [LONG IN tablespace-name]]}
[datalink-specification]
filetype-mod:
COMPOUND=x, INDEXSCHEMA=schema, FORCEIN, INDEXIXF, IMPLIEDDECIMAL,
NOCHECKLENGTHS, NOEOFCHAR, NULLINDCHAR, RECLEN=x, STRIPTBLANKS,
STRIPTNULLS, NO_TYPE_ID, NODOUBLEDEL, LOBSINFILE, USEDEFAULTS,
CHARDELx, COLDELx, DLDELx, DECPLUSBLANK, DECPTx, DATESISO,
DELPRIORITYCHAR, IDENTITYMISSING, IDENTITYIGNORE,
GENERATEDMISSING, GENERATEDIGNORE, DATEFORMAT=x, TIMEFORMAT=x,
TIMESTAMPFORMAT=x, KEEPBLANKS, CODEPAGE=x, NOROWWARNINGS,
NOCHARDEL, USEGRAPHICCODEPAGE
hierarchy-description:
{ALL TABLES | (sub-table-name [(insert-column, ...)], …)} [IN]
HIERARCHY {STARTING sub-table-name | (sub-table-name, …)}
datalink-specification:
([DL_LINKTYPE URL][{DL_URL_REPLACE_PREFIX prefix |
DL_URL_DEFAULT_PREFIX prefix}] [DL_URL_SUFFIX suffix], …)