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"))
);
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