Print a certain number of characters from the end of the string SQL DB2

Question

In DB2 I want to get 3 symbols from the end of the string. How can I do that? Example:

Input:

yyre*dsnj*001*19
asdf*wqer*136002*20

Output:

001
002

Answer 1

RIGHT function ALPHA has a value of ABCDEF.

SELECT RIGHT(ALPHA,3)
     FROM SYSIBM.SYSDUMMY1

returns DEF,

https://www.ibm.com/support/producthub/db2/docs/content/SSEPGG_11.5.0/com.ibm.db2.luw.sql.ref.doc/doc/r0000844.html?pos=2