2. Creating a New Ingres Development Environment : How You Prepare Your Applications : Report-Writer Syntax Change When Upgrading from Ingres 6.4
 
Share this page                  
Report-Writer Syntax Change When Upgrading from Ingres 6.4
When upgrading from 6.4, Report-Writer requires a space after all dot-commands.
For example, “.NL3” must be changed to “.NL 3”.
UNIX: To fix such occurrences automatically, you can use the following “sed” commands:
sed -e 's/\([<space><tab>]\.[a-zA-Z][a-zA-Z]*\)\([0-9]\)/\1 \2/' foo.rw | \
sed -e 's/^\(\.[a-zA-Z][a-zA-Z]*\)\([0-9]\)/\1 \2/' >newfoo.rw
Compare newfoo.rw against foo.rw to ensure that only the expected changes occurred.
An alternative to altering Report-Writer files is to sreport them into a database, then copyrep the reports back out.