Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2012
    Posts
    2

    Unanswered: Unsuccessful creation of job with onpladm

    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!

  2. #2
    Join Date
    Sep 2011
    Location
    Pont l'Abbé, Brittany, France
    Posts
    381
    Provided Answers: 1
    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

  3. #3
    Join Date
    Feb 2012
    Posts
    2
    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...

  4. #4
    Join Date
    Sep 2011
    Location
    Pont l'Abbé, Brittany, France
    Posts
    381
    Provided Answers: 1
    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

  5. #5
    Join Date
    Apr 2012
    Posts
    1

    Onpladm create object syntax error in interface file

    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 View Post
    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...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •