How to get rid of the dot next to the sequence owner in a SQL statement

[SAPSupport]

Hello,

For the creation of sequences, I need to define an OWNER for it:
alter sequence myUSER.mySEQUENCE owner to myUSER;

I have coded in the resource file, in SCRIPT / OBJECTS / SEQUENCE / AFTER_CREATE:
alter sequence [%QUALIFIER%]%SQNC% owner to %.13:QUALIFIER%;\n

The "." is always generated after %QUALIFIER% if the owner length is less than 13! How can I ensure it is never generated?

Thank you

------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

[SAPSupport · Accepted solution]

Hello,

The code '(%.13:QUALIFIER%)' extracts the first 13 characters of the variable '%QUALIFIER%', which corresponds to the value of the user code plus the period (.) in the dot notation.
To meet your requirements, you should use 'alter sequence [%QUALIFIER%]%SQNC% owner to %Owner.Code%' instead.

Kind regards