Help in Uploading a file in IBM DB2

Asked By john harryjo 0 points N/A Posted on - 01/27/2013

Hello guys!

I am currently developing a project, and I'm using IBM DB2.

Now, I wanted to learn uploading a file in IBM DB2.

Can you please comment back an easy step-by-step process?

Thanks!

• Status: Open
• Question Views: 1002
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: DB2

Answered By Baker Mich 5 points N/A #166010

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—–>

         '-CLIENT-'          +-pipename—+                   

                             +-device—–+                   

                             '-cursorname-'  

 

Using IMPORT command.

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

For further reading, please navigate to the link.

Hope this helps.

Thanks

Baker

About Baker Mich

Questions
3

Answers
101

Best Answers
53

• Vote Up 0 Vote Down

• Posted on - 01/29/2013
• Question Category: DB2