Monday, January 19, 2015

tMysqlTableList Example

List all table name of a database-

1. put a tMysqlConnection component which database table you want to see.
2. put tMysqlTableList
3. put tIterateToFlow
4. put tLogRow
5. put tJava

use below codes with components-

to get table list-
((String)globalMap.get("tMysqlTableList_1_CURRENT_TABLE"))


to get total number of tables-
System.out.println("total no. of tables:"+
((Integer)globalMap.get("tMysqlTableList_1_NB_TABLE"))
);






No comments:

Post a Comment