[z/OS] Unload & LIMIT option

Cuneyt Goksu

[z/OS] Unload & LIMIT option
Hello List,

I tried to use the LIMIT option of UNLOAD utility.

According to the manual, I expected that the utility will be completed after
it has reached the LIMIT since the TS has only one table.
vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv
vvvvvv
If the number of unloaded rows reaches the specified limit, message DSNU1201
is issued for the table and no more rows are unloaded from the table. The
process continues to unload qualified rows from the other tables.
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
^^^^^^

This is my UNLOAD syntax

UNLOAD TABLESPACE SAGLIK.SAGLTS15
FROM TABLE SAGLIK.RECETAB HEADER NONE LIMIT 100
(SICIL, HASNO, BARKOD1, ADE1)
ASCII

But it continues to run!

Any Comments?

Regards,
Cuneyt

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Phil Grainger

Re: [z/OS] Unload & LIMIT option
(in response to Cuneyt Goksu)
Hi Cuneyt

When you say "it continues to run" are you saying that it continues to
unload rows or that it stops unloading rows but continues doing
"something else"?


Phil Grainger
CA
Product Manager, DB2
Tel: +44 (0)161 928 9334
Fax: +44 (0)161 941 3775
Mobile: +44 (0)7970 125 752
[login to unmask email]


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Cuneyt Goksu (Usa.net)
Sent: 06 January 2006 13:29
To: [login to unmask email]
Subject: [DB2-L] [z/OS] Unload & LIMIT option

Hello List,

I tried to use the LIMIT option of UNLOAD utility.

According to the manual, I expected that the utility will be completed
after it has reached the LIMIT since the TS has only one table.
vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv
vvvv
vvvvvv
If the number of unloaded rows reaches the specified limit, message
DSNU1201 is issued for the table and no more rows are unloaded from the
table. The process continues to unload qualified rows from the other
tables.
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
^^^^
^^^^^^

This is my UNLOAD syntax

UNLOAD TABLESPACE SAGLIK.SAGLTS15
FROM TABLE SAGLIK.RECETAB HEADER NONE LIMIT 100 (SICIL, HASNO, BARKOD1,
ADE1) ASCII

But it continues to run!

Any Comments?

Regards,
Cuneyt

------------------------------------------------------------------------
---------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that
page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm