Using fliters with HPL
Posted in 2006
Tam OShanter — — source: Usenet: comp.databases.informix
Greetings Friends,
I'm unloading a rather large table using HPL via. command line and was
wondering about the syntax to use a filter so I only unload, or reload, the
data I want based on a given criteria.
The table in question has a column named 'creationDate' which I would like
to filter on (all the data from the past x months....)
My create job syntax is as follows:
onpladm create job acc_sales_revenue_unload -D archive_db -t
acc_sales_revenue -d acc_sales_revenue.file -f u
My syntax to start the job is as follows:
onpload -j acc_sales_revenue_unload -fu
Thanks in advance for your help.
Tam.