How many tables can be added in a batch spufi

srilata83 · New User Joined: 02 Apr 2009 Posts: 16 Location: chennai

I'm executing DDL in batch. My question is how many DDL (its an ALTER TABLE) statements for diiferent tables can be added in a single job?

dick scherrer · Posted: Thu Apr 30, 2009 9:42 pm

Hello,

I'm not aware of some fixed limit. . .

What is happening when you run your batch job - some abend, some unwanted sqlcode, something else?

srilata83 · New User Joined: 02 Apr 2009 Posts: 16 Location: chennai

Hi,
Actually i had a total of 90 tables all together, but i was afraid to run for all the tables all together, so before running, i just wanted to confirm whether to proceed or not...then finally I decided to run for 20 to 24 tables together, forwhich i created 4 or 5 JCLs.
It ran finely.

The DDL i was ruuning is ALTER TABLE creator.tablename DATA CAPTURE NONE:

Thanks,

dick scherrer · Posted: Fri May 01, 2009 12:30 am

Good to hear it worked - thanks for letting us know

d