how to export/import through script.

Can anyone provide a sample script.

Scripting is pretty much identical to do things on the shell prompt:
Of course, the question is which platform you are using because Windows requires a few more preparations.

Not entirely true! On Windows there can also be only ONE! file to execute SQLs from. Please see the script sections of this forum, where I have published solution. Look for topic Execute SQLs from files only with one batch file - DB2 on Windows

My point was that you need to start a db2cmd prompt on Windows. On Unix, all you have to do is to source the db2profile (which is usually done via .profile upon login automatically).

db2 on AIX.

I agree with you. On Windows there is little more tweaky, but my script can reduce complexity.

By the way, this difference between Linux/Unix and Windows script execution I little bit hate, because I can't use only one solution to have both systems up and running by scripts. Why doesn't IBM eliminate the need of this db2cmd starting for each script on Windows? Why is there not the same solution like on Linux/Unix?

use Stolce suggestion.

BTW, I use if logic in script to control if command executed successfully (Unix script):
Note: each DB2 command after execution returns status to system variable "$?". If variable is 0 there it is OK. If variable is 1 there is warning. Any other value there is error.

Hope this helps,
Grofaty

Actually, it's not as bad as it seems: it suffices to set the environment variable DB2CLP to the same value as that from a running db2cmd window. From then on, you can do exactly the same as on unix (e.g., using a Cygwin bash window).
I guess this could be automated (i.e., scripted) in one way or the other, say by issuing db2cmd in the background and capturing the DB2CLP setting, but I did not yet bother to do so.