USE of Escape Symbol (@) in new Open SQL with work area and Internal Table + Condition

Step1. Up to now, we have a select query with required fields separated by commas and also as per the rule the host variable/target variable LT is prefixed by @LT. This is fine but we have a where condition. This gives a syntax check error. So the rule is if the fields in the select query are separated by commas then the host variable/target variable may be the work area or internal table should be prefixed by the escape @ character and also all the parameters in the where condition should be prefixed by escape @character.

Step2. So make condition as " where carrid = @p_car . " So there is no error. Execute it.

Step3. Provide the I/P and execute.

Step4. O/P: