How to Import data in QMF

perez_a · New User Joined: 02 Feb 2006 Posts: 25 Location: Italy

Hi friends,
can anyone help me.
I need to "import data" in qmf, but I don't know the syntax.
regards Alex

dbzTHEdinosauer · Posted: Tue Aug 07, 2007 3:07 pm

Here is a link to the DB2 Vsn 9.1 Libarary. On the left side you will see QMF.

Dingu · Posted: Tue Aug 07, 2007 3:09 pm

I hope you are asking about export data from a table and then importing the same to another table.

import table <tablename> from <export dsname>(action=append)

If you are not able to type this in commandline you could go to the proc option and then issue this command.
You can export the query results using the command
export data to <exportds name>

Thanks,
Prajesh

hariibm · New User Joined: 05 Feb 2007 Posts: 61 Location: Chennai

Hi Prajesh,

Do you mean to say that a table can be loaded with the data from a dataset which is an unload of another table? Is that possible through QMF?

Please explain me as I have no idea of this feature..

And what if the table structure changes?

Hari.

Prajesh_v_p · Active User Joined: 24 May 2006 Posts: 133 Location: India

Hari...

Table structure should match.. If you want to copy a few record from a test region region to other..This is really helpful.

It actually looks at the QMF header added by the export utility(at the time of export) to map the data to the tables. So this should map with the table you are going to load the data.

May be our experts can add more details..

Thanks,
Prajesh