MVSFORUMS.com

[Sqlcode]

Could anyone give me solution to below mentioned condition?

I want to use Partition Unload for a table. I have table T1 which has 50 partition today, I am doing partition unload on the table and hence it will create 50 dataset.

I am using all 50 partitioned unload datasets in the next step which is SORT. Sort step needs to take all 50 partition unload as input.

Now, let say after a month DBA decides to add 10 more partition then Unload dataset will get created but my SORT step, in which 50 datasets are hardcoded and hence it won't pick up new 10 unload partition datasets.

Questions:-

1) I thought of Unloading partitions into GDG versions but Db2 is not letting create unload datasets that are GDGs.

2) I am able to create 50 flat files, but then Everytime DBA adds partitions, I need to change my proc to include new partition datasets.

Is there a way to automate this situation?

Thanks,