- 论坛徽章:
- 0
|
请问,如下字段,我该怎么截取出符合自己需要的数据呢 ?
System Database Directory
Number of entries in the directory = 17
Database 1 entry:
Database alias = ADtest
Database name = ADtest
Node name = EAMTNODE
Database release level = c.00
Comment =
Directory entry type = Remote
Authentication = SERVER
Catalog database partition number = -1
Alternate server hostname =
Alternate server port number =
Database 2 entry:
Database alias = Mdtest
Database name = Mdtest
Node name = BLDBNODE
Database release level = d.00
Comment =
Directory entry type = Remote
Catalog database partition number = -1
Alternate server hostname =
Alternate server port number =
Database 3 entry:
Database alias = Uatest
Database name = Uatest
Local database directory = /DB2/testserver
Database release level = f.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =
Database 4 entry:
Database alias = Cstest
Database name = Cstest
Local database directory = /DB2/testserver
Database release level = f.00
Comment = Cognos DB
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =
Database 5 entry:
Database alias = WPtest
Database name = WPtest
Local database directory = /DB2/testserver
Database release level = f.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =
Database 6 entry:
Database alias = BADBOY
Database name = BADBOY
Local database directory = /DB2/testserver
Database release level = f.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =
Database 7 entry:
Database alias = USADSES
Database name = USADSES
Local database directory = /DB2/testserver
Database release level = f.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =
Database 8 entry:
Database alias = SPCPRD
Database name = SPCPRD
Local database directory = /DB2/testserver
Database release level = f.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =
Database 9 entry:
Database alias = PMPA
Database name = PMPDMPRD
Node name = PMPNODE
Database release level = d.00
Comment =
Directory entry type = Remote
Catalog database partition number = -1
Alternate server hostname =
Alternate server port number =
Database 10 entry:
Database alias = USADSTGE
Database name = USADSTGE
Local database directory = /DB2/testserver
Database release level = f.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =
Database 11 entry:
Database alias = JDBSS
Database name = JDBSS
Local database directory = /DB2/testserver
Database release level = f.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =
Database 12 entry:
Database alias = TEST
Database name = TEST
Local database directory = /DB2/testserver
Database release level = d.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =
Database 13 entry:
Database alias = AJDBDB
Database name = AJDBDB
Local database directory = /DB2/testserver
Database release level = f.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =
Database 14 entry:
Database alias = RELDB
Database name = RELDB
Node name = DB2INST6
Database release level = d.00
Comment =
Directory entry type = Remote
Catalog database partition number = -1
Alternate server hostname =
Alternate server port number =
Database 15 entry:
Database alias = PDBDMPR
Database name = PDBDMPR
Node name = DMNODE
Database release level = d.00
Comment =
Directory entry type = Remote
Catalog database partition number = -1
Alternate server hostname =
Alternate server port number =
Database 16 entry:
Database alias = Btest
Database name = Btest
Local database directory = /DB2/testserver
Database release level = f.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =
Database 17 entry:
Database alias = CBMtest
Database name = CBMtest
Local database directory = /DB2/testserver
Database release level = f.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =
要求:共有17个段落,每个段落代表一个database的信息,现在我需要根据每个段落中的 “Directory entry type" 这一列的值来判断,如果这列值等于Indirect,则找出该段落的Database name的值,其余的跳过,请教CU shell牛人。。。 |
|