Unload via OpenAdmin Task Scheduler
Is it possible to unload an Informix table using the OpenAdmin Task Scheduler?
I have created a task with the execution statement as
unload to Turret_DnB_Table.txt delimiter "|"
select sales_off from livturdb:turret_ar_dnb_table;
Thank you
John
Not like that... "UNLOAD" does not belong to the SQL dialect. It's an
"handy tool" provided by dbaccess (and maybe other tools like SQLCMD).
You can however create an external table in your procedure with the same
structure as the real table and INSERT INTO SELECT FROM...
It will work, and depending on some constraints it will be much faster than
the traditional UNLOAD
Regards
On Tue, Sep 3, 2013 at 6:09 PM, JOHN KRUPA <jkrupa@turretsteel.com> wrote:
> Is it possible to unload an Informix table using the OpenAdmin Task
> Scheduler?
>
> I have created a task with the execution statement as
>
> unload to Turret_DnB_Table.txt delimiter "|"
> select sales_off from livturdb:turret_ar_dnb_table;>
> Thank you
> John
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--
Fernando Nunes
Portugal
http://informix-technology.blogspot.com
My email works... but I don't check it frequently...
--047d7b86f1023f44f904e57de0f6
You can look at the following blog http://www.jfmiii.com/informix/?p=161
as an
example of using unload a table in a stored procedure. Unload is not
an SQL statement and therefore can not be used.
John F. Miller III
STSM, Lead Architect
miller3@us.ibm.com
503-747-1366
IBM Informix Dynamic Server (IDS)
ids-bounces@iiug.org wrote on 09/03/2013 10:09:41 AM:
> From: "JOHN KRUPA" <jkrupa@turretsteel.com>
> To: ids@iiug.org,
> Date: 09/03/2013 10:11 AM
> Subject: Unload via OpenAdmin Task Scheduler [31338]
> Sent by: ids-bounces@iiug.org
>
> Is it possible to unload an Informix table using the OpenAdmin Task
> Scheduler?
>
> I have created a task with the execution statement as
>
> unload to Turret_DnB_Table.txt delimiter "|"
> select sales_off from livturdb:turret_ar_dnb_table;>
> Thank you
> John
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Not that way, no. The unload verb is implemented in dbaccess not in the
server! But you can us sn external table to perform the unload from inside
the engine.
Art
On Sep 3, 2013 1:09 PM, "JOHN KRUPA" <jkrupa@turretsteel.com> wrote:
> Is it possible to unload an Informix table using the OpenAdmin Task
> Scheduler?
>
> I have created a task with the execution statement as
>
> unload to Turret_DnB_Table.txt delimiter "|"
> select sales_off from livturdb:turret_ar_dnb_table;>
> Thank you
> John
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--047d7b343cd217349504e57f0a5d
Also, OpenAdmin Tool helps with configuring an unload task, providing
automatic creation of the external table or using an existing external
table. The configured unload task can also be saved and run on demand.
It's in Schema Manager. Choose the table, then:
1) To configure an unload: Actions->Tables->Unload Table
2) To view the configured unload tasks: Maximize the Information & Task
Status pod and navigate to the Task or Task Status tabs
Sumanth.
On Tue, Sep 3, 2013 at 11:41 AM, Art Kagel <art.kagel@gmail.com> wrote:
> Not that way, no. The unload verb is implemented in dbaccess not in the
> server! But you can us sn external table to perform the unload from inside
> the engine.
>
> Art
> On Sep 3, 2013 1:09 PM, "JOHN KRUPA" <jkrupa@turretsteel.com> wrote:
>
> > Is it possible to unload an Informix table using the OpenAdmin Task
> > Scheduler?
> >
> > I have created a task with the execution statement as
> >
> > unload to Turret_DnB_Table.txt delimiter "|"
> > select sales_off from livturdb:turret_ar_dnb_table;> >
> > Thank you
> > John
> >
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --047d7b343cd217349504e57f0a5d
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--047d7bd6c2c460c69804e591fbfa