By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,230 Members | 2,436 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,230 IT Pros & Developers. It's quick & easy.

Using WHERE condition in UNLOAD or LOAD

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a

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

P: n/a
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.