Inititalize a value retrieved from DB to variable stored in Database
Hi,
Is it possible to assign a value in one variable to the same variable that is setup or stored as "&" variable?
For EX:
The SQLEXEC returns a year of 2022 and stores it in &YEAR.
We have the same "&YEAR" value is stored in one of custom tables
Table Structure (COUNTRY_TBL) and sample value
Country CUSTOM_VALUE
US &YEAR
Now, when we query on COUNTRY_TBL and retrieve the CUSTOM_VALUE, we have &YEAR
Is it possible to pass the 2022 value obtained in 1st SQLEXEC to above &YEAR?
So, the value in &YEAR should be assigned to the variable &YEAR stored in COUNTRY_TBL.CUSTOM_VALUE