using excel to write sql
Excel is a wonderful tool that can be used to write sql using substitution from cells to cusomize and update or insert.
One problem has always been dates… they never come out right
One solution to that is to use the TEXT format command to format it to DB2 formatted date…
use =TEXT(cell ref,”yyyy-mm-dd”) in excel to format as a date that can be used in a formula when you generate sql