Need faster method to find value in ISPF table column
Posted: Wed Jan 16, 2013 12:54 am
I have a very large ISPF table with multiple columns. There are multiple values in this particular column I'm dealing with. Lets say the column name is COLOR. I would like to be able to issue a command that will tell me if a value is present in the COLOR column. Example.... the COLOR column might have a value of "BLACK WHITE RED BLUE". I want to know if RED is in the value list. Currently in a REXX exec I am doing TBSKIP to move from row to row, while checking to see if the COLOR value contains RED. This is slow since the table is large. I can't use TBSCAN since RED would not match "BLACK WHITE RED BLUE"
I'm thinking there is a command that can do this because if I display the tables contents using a utility I can issue on the command line "F COLOR RED" and it will take me to the row that contains RED, even though the columns value is "BLACK WHITE RED BLUE"
Thanks in advance for any recommendations.
I'm thinking there is a command that can do this because if I display the tables contents using a utility I can issue on the command line "F COLOR RED" and it will take me to the row that contains RED, even though the columns value is "BLACK WHITE RED BLUE"
Thanks in advance for any recommendations.