Today, I found some DB2 field name gets started and ended by double quotes when I was using STRSQL and F4. But it seems that it happens randomly.
Is there anyone can answer for me why it's happened?
Also I'd like to hear if we can keep this as it is or is needed to be fixed?
DB2 has 2 types of names:
An ordinary identifier is an uppercase letter followed by zero or more characters, each of which is an uppercase letter, a digit, or the underscore character. Note that ordinary identifiers are converted to uppercase. An ordinary identifier should not be a reserved word.
A delimited identifier is a sequence of one or more characters enclosed within SQL escape characters. The sequence must consist of one or more characters. Leading blanks in the sequence are significant. Trailing blanks in the sequence are not significant. The length of a delimited identifier does not include the two SQL escape characters. Note that delimited identifiers are not converted to uppercase. The escape character is the quotation mark (").