RE: OUTPUT ... and File Layout

Excellent !! Thanks, I used this principle, changing the output to an unload, like in your example, and then used "sed" to fill in the rest. Works like a dream ! Thanks TJ Regards Dirk -----Original Message----- From: The Joker [mailto:monsieur_argent@hotmail.com] Sent: Thursday, May 22, 2003 2:57 PM To: Dirk Moolman Subject: RE: OUTPUT ... and File Layout Dirk If this is to be passed into another script or just written to a file then I would unload the data required and reformat in say [n]awk or sed. It should be easy and just as efficient. For example: [not full code] dbaccess -e DBNAME <<SQLEND 2>&1UNLOAD TO '/path/myfile' DELIMITER '|' SELECT UNIQUE tabname, colname FROM systables a, syscolumns b, sysindexes c WHERE a.tabid = b.tabid AND b.tabid = c.tabid AND b.colno = c.part1 AND a.tabid > 99 AND tabtype = 'T'; SQLEND if [ -s "/path/myfile" ]; then nawk -D"|" ' { # Process each line into SQL printf "UPDATE STATISTICS HIGH FOR TABLE %s (%s)\\n",$1,$2 printf " DISTRIBUTIONS ONLY;\\n" }' /path/myfile > /path/mywfile.new # If you then want to action file cat /path/myfile.new | dbaccess -e DBNAME - 2>&1 fi If that is what you want and I would suggest you hold DBNAME and file names in variables. I have not fully tested this script but I have many like this one I use all the time. Do you have enough room to swing the cat, cause you can skin it many ways!! Play with it, you'll get it to work .... ;-) TJ _________________________________________________________________ On the move? Get Hotmail on your mobile phone http://www.msn.co.uk/msnmobile