Using WHERE condition in UNLOAD or LOAD

[Srini]

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

[Tonkuma]

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.

[Srini]

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