#14000: Support enumerating iSeries members in a multimember file via Aquascript extractPartitions

westers reported 2015-12-15T21:01:10Z · last modified 2018-03-13T23:27:43Z

Dev
QA

Priority	Minor
Complexity	Moderate

Component	Tools - Schema Script Gen
Version	Future

Support enumerating members of a multi-member file using AquaScript.

var server = "iSeries";

var schema = 'MYLIB';

var conn = aqua.project.getServerConnection(server);

conn.connect();

var metadata = conn.getMetadata();

var tables = metadata.extractTables(null, schema);

for (var j=0; j<tables.length; j++){

var partitions = tables[j].extractPartitions();

for(var i=0; i<partitions.length; i++){

var obj = tables[i].extractPartition(partitions[i].getName());

if (obj != null){

aqua.console.println("SCRIPT CREATE FOR:[" + obj.getName() + "]");

aqua.console.println("");

}

conn.disconnect();

All Comments (1) Change History

NielsGron 2015-12-16T17:37:57Z

This request is to add table partitioning support for DB2 iSeries.