onpladm create object QUERY
Posted in 2007
mohitanchlia@gmail.com — — source: Usenet: comp.databases.informix
I am trying to run a project that has an object of type query.
Something like
BEGIN OBJECT QUERY t_td
# Compulsory Attributes
PROJECT p_data_1
DATABASE dev06
SELECTSTATEMENT "select * from t where t_id < 100"
END OBJECT
I created the project and created the object successfully. Now I am
running the project so that it also runs the query but it's doesn't
seemt to be doing anything. I did the following:
1. onpladm create project p_data_1
2. onpladm create object -F t_td
3. onpladm run project p_data_1 -fu
It doesn't seem to be doing anything. What possibly am I doing wrong ?
Could you please tell me how to unload and load with queries.
Also I have to unload the blobs can I use onpladm