Unsuccessful creation of job with onpladm

geob · #1 (**permalink**) 02-08-12, 08:18

Hi all,

I'm using the onpladm tool to unload some million rows of a table and load them back to a new one. From the original table I need to get a selection of rows, that's why I'm defining a select query

Code:

onpladm create object -F query_file

that's being created successfully (I'm listing the queries and I can see it)
I've also created a device

Code:

onpladm create object -F device_file

which was also successful
When I'm trying to create the job I get an error
Syntax error in interface file line :5
Create object FASTUNLOADJOB failed!

I use the following spec file

Code:

BEGIN OBJECT FASTUNLOADJOB jobunload
# Compulsory Attributes
PROJECT rech_proj
DEVICE dev_file
DATABASE dblive
QUERY query_file
# Optional attributes
SERVER db_srvr
END OBJECT

the database is the one the table I'm trying to unload belongs to and the server the same as $INFORMIXSERVER. The device and query are the same as listed when using onpladm list command. Does anyone have a clue what may I be missing?

Thanks!

begooden-it · #2 (**permalink**) 02-19-12, 04:14

hmm,

which engine version ?
Have you considered the use of external tables which are way easier to handle
than onpload ?
Also, in many cases, external tables are faster than onpload.

I admit to give a lazy boy suggestion, but if your engine is above 11.50 xC5, you can use external tables and save a lot of admin time :-)

Else, did you see any error message in the engine log file?

Eric

geob · #3 (**permalink**) 02-20-12, 04:22

Hi,

Thanks for your reply but, according to your sayings, I cannot use external tables, since my engine is 11.50.FC3. Anyway, my problems were that the format of the spec file was wrong, apparently it needs some specific format. What I did was to create a job using the command line and then describing it.After that I copied the format of the description, added my query and used that as a spec file. It worked just fine after that.

Thanks anyway for your time...

begooden-it · #4 (**permalink**) 02-21-12, 11:33

No problem,

you can download Innovator-C on your platform if you want to try the external tables and much more :-)

It is a free production version, but you can also use it for staging.

Eric

sallylee · #5 (**permalink**) 04-13-12, 05:44

Hi All,

Appreciate your help on this please.

My spec file, pl_hpl_unld_jb_spec_ALL.txt is as below:-

BEGIN OBJECT UNLOADJOB pljb_ALL
PROJECT plDeltaExtProj_ALL
DEVICE pldvce_ALL
MAP plmp_ALL
FILTER
SERVER
DATABASE
FLTFILE
REJECTFILE /appl/pl_hpl_reject_ALL.log
LOGFILE /appl/pl_hpl_progress_ALL.log
ISOLATIONLEVEL DR
RUNMODE
GENERATEVIORECS
TAPES
NUMRECORDS
STARTRECORD
MAXERRORS
END OBJECT

Whenever i run the below script, i will get the syntax error on the interface file, please help.

onpladm create object -F /appl/pl_hpl_unld_jb_spec_ALL.txt -S sds2_srv

Quote:

Originally Posted by geob

Hi,

Thanks for your reply but, according to your sayings, I cannot use external tables, since my engine is 11.50.FC3. Anyway, my problems were that the format of the spec file was wrong, apparently it needs some specific format. What I did was to create a job using the command line and then describing it.After that I copied the format of the description, added my query and used that as a spec file. It worked just fine after that.

Thanks anyway for your time...

Internet Services

Web Development

Digital Marketing

Consumer Tech