does anyone have a shell script that will clean up db2 backups that are older than X months old? I'm trying to write one but I don't know enough about aix shell scripts to do it. Also, in a shell script command, you can run a db2 command like:

var1='select current date from sysibm.sysdummy1'

and this will put the current date into variable var1

what delimeter do I use to build a literal within the db2 script? the " doesn't work, but if you look at the following script, you'll see what I want to do:

var1=' select "today is: " concat select current date from sysibm.sysdummy1'