Help in Uploading a file in IBM DB2

Help in Uploading a file in IBM DB2

Hi John,

You can use the IMPORT command in order to insert data from an external file which should be of the supported file format into  table, hierarchy or view.

LOAD command is also the other option however it does not support loading data at the hierarchy level.

Following syntax can be used as an example on how to import information from myfile.ixf to the STAFF table:

Using LOAD command.

  LOAD–+——–+–FROM—-+-filename—+-+–OF–filetype—–>

                             '-cursorname-'  

Using IMPORT command.

IMPORT FROM–filename–OF–filetype————————–>

For further reading, please navigate to the link.

Hope this helps.

Thanks

Baker