469,313 Members | 2,639 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,313 developers. It's quick & easy.

Using WHERE condition in UNLOAD or LOAD

Does anyone know if we can do SELECTIVE unload/load data from/to a
Tablespace using Where condition on z/OS with IBM DB2 UNLOAD / LOAD
utility?

Thanks,
Srini

Oct 20 '06 #1
2 3888

Srini wrote:
Does anyone know if we can do SELECTIVE unload/load data from/to a
Tablespace using Where condition on z/OS with IBM DB2 UNLOAD / LOAD
utility?

Thanks,
Srini
If you are using DB2 for z/OS (perhaps V7 up), you can use UNLOAD FROM
TABLE spec. In FROM TABLE spec, you can select rows by
WHEN(selection-condition).
Selection-condition includes basic predicate, BETWEEN predicate, IN
predicate, LIKE predicate and NULL predicate.

Oct 22 '06 #2
Tonkuma,

We are on DB2 for z/OS V8. It worked. I tried those options, but
couldn't get succeeded initally. But, finally it worked.

Thanks a lot for your help.

Cheers,
Srini

Oct 24 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Mirano | last post: by
1 post views Thread by DB2 Novice | last post: by
2 posts views Thread by Lauren Hines | last post: by
6 posts views Thread by Wal Turner | last post: by
1 post views Thread by hal | last post: by
1 post views Thread by Hal | last post: by
4 posts views Thread by Brett Baisley | last post: by
1 post views Thread by Ivan | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by Geralt96 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.