Generating the Insert Scripts for Table in DB2

Originally Posted by

Hi,
>
Is there any way to generate the Insert scripts for a table in DB2?
Is there any db2 command for the same?
>
I had know about a few Oracle Clients which had such utility(like PL/
SQL developer/ TOAD).
>
I was just wondering if there is any utility for the same in DB2.
>
Thanks
>
Rahul Babbar

Originally Posted by

On 21 Sty, 10:48, Rahul Babbar <rahul.babb...@gmail.comwrote:
>
>
>
>
>
>
>
Hi,
>
If you use windows system you have db2cmd console, for nix family
system you have to add instance information for your user by:
. /home/inst_owner/sqllib
The you have db2 command for running scripts or using interactive
mode.
>
What is more you can use DB2 Control Center (db2cc) with command
editor or free IBM Data Studio.
>
Best,
Marcin Molak

Originally Posted by

On Jan 21, 3:04 pm, "Marcin 'frodo2000' Molak" <frodo2...@gmail.com>
wrote:
>
Hi,
>
I wanted to generate the insert scripts for the data already present
in the table and not run the scripts.
>
Is there some way?

Originally Posted by

What's wrong with EXPORT/IMPORT (or LOAD)?
Running INSERT-Scripts seems liek a terribly inefficient way to go about
this....
>
Cheers
Serge

Originally Posted by

"Serge Rielau" <srie...@ca.ibm.comwrote in message
>
news:5vjk4kF1mks53U1@mid.individual.net...
>
>
>
Most third party tools have this. I used it all the time when I had
DBArtisan at my last job, mostly for small reference tables, and for a shell
of an insert for a new row that had to be scripted for insert into multiple
environments.

Originally Posted by

Can you name a few of those tools?