Using fliters with HPL
Only 1 message in topic - view as tree
From: Tam OShanter - view profile
Date: Wed, Dec 6 2006 5:54 pm
Email: "Tam OShanter"


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.


Reply » Rate this post: Text for clearing space


End of messages