This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
DB2 is a database not a programming language. I'm not aware of any built in search functions. You can define a field to be a substring of another field, but I don't think that's what you are looking for.
A SQL example on an i-series machine would look like this: SELECT * FROM library/file WHERE upper(field) like 'G%'
Note: you do not need to use "upper", but if you do make sure your search value is in upper-case or you will never select any records.
Mid-rangeze file=table, field=column, record=row [ October 14, 2004: Message edited by: Ray Marsh ]
Anxiety does not empty tomorrow of its sorrows, but only empties today of its strength. – Charles Spurgeon