Why?bicap wrote:I have to read from Database and write into a DataSet from all the available tables in each schema by using a single DataStage job.
A DataStage Data Set can only have a single record structure.
So, unless every single one of these tables has the same record structure, or your single DataStage job is going to construct the same record structure (a single string) then your mission is doomed.
Resist stupid requirements!
Now, if your requirement had been to write into another database, then we might have a cogent answer. I've done this, though only for 823 tables.