Re: Routine to create SQL Insert statements from table data

FProse wrote: > > Does someone have a routine which will take the contents of a table > and create SQL Insert statements? I've searched the IIUG library but > can't find what I'm looking for. We have a need to repopulate certain > tables in a training database several times a day and want the > instructors to control this. Why not just have a script that does a dbaccess UNLOAD and another that does a LOAD? The instructors can then just run the two scripts as appropriate. I do have an awk script to generate such scripts from dbschema/myschema output if that would help. Art S. Kagel