Re: Trigger names redux - 256 character name

On 14-Oct-2016 10:56 -0500, David Gibbs wrote:

On 10/14/2016 10:51 AM, Sue Romano wrote:

I can explain this one. All SQL names can be up to 128 long when
delimiters are removed. For any " in a name, the delimited form of
the name must have that character doubled. So you could have a
name with 128 " characters. To use that name in an SQL statement,
you would need to double each of the " and then add delimiters on
the outside - for a total of 258 " characters.

I do not recall any enablement of escaped delimiters on the Command Language (CL), so I am unsure how that would work; separately delimiting the delimited-identifier will just keep the extra double-quote as escape-character as part of the name. While the SQL requires the double-quote to be escaped, the name that gets stored has not been stripped of the quotes used as escape-characters, so I doubt that has ever functioned properly; something I never tested for.

Could you give an example of how a long name would be specified with
" delimiters?

Little different than any other system object name using the double-quote as delimiter; e.g.:

crtdtaara qtemp/"lgl_DtaA" *LGL /* "lgl_DtaAra" is too long */

crtdtaara qtemp/"lgl_DtaAra" *LGL /* ie. CPD0074 'too long' */

So for example:

addpftrg FILE(the_file) TRGTIME(*BEFORE) TRGEVENT(*INSERT)
PGM(the_pgm) TRG("Example_of_a_delimited_name")
/* valid system name, as a quote-delimited name */

addpftrg FILE(the_file) TRGTIME(*BEFORE) TRGEVENT(*INSERT)
PGM(the_pgm) TRG('"Example of a delimited name"')
/* apostrophes additionally required per spaces */