com.ibm.as400.ui.util
Class AS400SQLNameFormatter
java.lang.Object
com.ibm.as400.ui.framework.java.DataFormatter
com.ibm.as400.ui.util.AS400Formatter
com.ibm.as400.ui.util.AS400SQLNameFormatter
public class AS400SQLNameFormatter
extends AS400Formatter
Checks validity of a string as an AS/400 SQL identifier.
A valid SQL Name is:
- 1 to 128 characters
- first character 'A'-'Z', '$', '#', '@'
- other characters 'A'-'Z', '0'-'9', '$', '#', '@', '_'
A valid SQL Name in Quoted Form:
- 1 to 130 characters including quotes
- starts and ends with " (double quote)
- All characters valid except: EBCDIC x00 - x3F, xFF.
SQL Name is the same as *NAME except '.' is not allowed and length is limited to 128 (or 130) characters.
- Since:
- v4r2m0
- Version:
- 1.0, 06/01/98
- Author:
- B. Cragun
- See Also:
IllegalUserDataException,
AS400NameFormatter,
AS400SnameFormatter,
AS400CnameFormatter,
AS400CharFormatter,
AS400SQLNameColumnFormatter
Method Summary
Object |
parse(String source)
Parses and checks a string as a valid AS/400 SQL Name. |
| Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
AS400SQLNameFormatter
public AS400SQLNameFormatter(AS400 system)
- Constructs an
AS400SQLNameFormatter.
The CCSID of the input AS400 object will be used for checking.
If a null AS400 object is used, 37 is used as a default CCSID.
- Parameters:
system - an AS400 object.- Since:
- v4r2m0
parse
public Object parse(String source)
throws IllegalUserDataException
- Parses and checks a string as a valid AS/400 SQL Name.
If the string is not valid an
IllegalUserDataException is thrown.
- Overrides:
parse in class DataFormatter
- Parameters:
source - the string to be parsed
- Returns:
- the valid checked result
- Throws:
IllegalUserDataException- Since:
- v4r2m0