3 of 3 people found this helpful
The CTMERR is on a specific place in your string. I would guess, the first two variables are fine, but what do you expect with the variable %%sql? I think this one throws the ctmerr. Try another_input_string_%%INPUT_Value.%%FLNG_YR_TXT..sql
Thanks for your reply. It worked.
Here are similar issues, I am facing.
I followed your thread https://communities.bmc.com/thread/153951?start=0&tstart=0http://
about Control M variable definitions and tried the steps, but here are errors surprising me.
Does treat contact for numeric and string(text) differently ?
Expected result ==> input_fixed_string_FS19_CY0
FS_NUM = 19 in Smart folder
_CY0 is fixed text to be appended to result
input_fixed_string_FS%%FS_NUM%%._CY0 resolved as input_fixed_string_FSCTMERRFS_NUMCTMERR._CY0
input_Fixed_string_FS%%FS_NUM _CY0 resolved asinput_fixed_string_FS19
input_fixed_string_FS%%FS_NUM %%MINUS 1 _CY0 resolved as Illegal
input_fixed_string_FS%%FS_NUM %%MINUS 1 resolved as First
input_fixed_string_%%FS_CY0%%._CY0 resolved as input_fixed_string_CTMERRFS_CY0CTMERR._CY0
input_fixed_string_%%FS_CY0 resolved as input_fixed_string_FS19
Looks like ._CY0 with string variable not resolving properly, but it is working, if result is numeric. How do I concat/append to string value (from Variable resolution)?
How do I resolve this?
Thanks for sharing.