I am running a table in DB2 thorugh Lotus using LEI. One of the tables has a column that displays 1 or 0 (1 = yes and 0 = no). I’ve created another column so that people can type yes or no instead of 1 or 2. I need this column to display yes if original field says 1 and no if original field says 0. Here is the code
FIELD prodbaseos2 := @If(prodbaseos = 1; prodbaseos2 = “Yes”; prodbaseos2 = “No”); “”;
This code is not working however. I have it under Input Translation of prodbaseos2. Any suggestions?