Current date - n days

[Michael Banjumi]

Where n is the parm reads from the file. How can I handle this without
giving any syntax error and produce the desired result?

TIA

[Joachim Banzhaf]

Re: Current date - n days

Please don't let us guess!

Which programming language (and technique: ESQL with COBOL, CLI, ...)
or which shell (Windows CMD.EXE, Linux bash, ...)?
Which format has the file?

I assume the file test.dat contains one line, one column: the number
I assume unix shell: bash

db2 "connect to YOURDB user YOU using YOURPW"
db2 "values current date - `cat test.dat` days"

HTH

Joachim Banzhaf

Michael Banjumi wrote:
[color=blue]
> Where n is the parm reads from the file. How can I handle this without
> giving any syntax error and produce the desired result?
>
> TIA[/color]