All Packages Class Hierarchy This Package Previous Next Index
Class com.ibm.as400.ui.util.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,
'*', '?', " (double quote), ' (single quote), ' ' (blank)
SQL Name is the same as *NAME
except '.' are not allowed and length is limited to 128 (or 130) characters.
- See Also:
- IllegalUserDataException, AS400NameFormatter, AS400SnameFormatter, AS400CnameFormatter, AS400CharFormatter, AS400SQLColumnNameFormatter
-
AS400SQLNameFormatter(AS400)
- Constructs an
AS400SQLNameFormatter
.
-
parse(String)
- Parses and checks a string as a valid AS/400 SQL Name.
AS400SQLNameFormatter
public AS400SQLNameFormatter(AS400 systemObject)
- 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:
- systemObject - an
AS400
object.
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.
- Parameters:
- source - the string to be parsed
- Returns:
- the valid checked result
- Overrides:
- parse in class DataFormatter
All Packages Class Hierarchy This Package Previous Next Index