Update sintaxis
Hi,
Can you tell me what is the problem with these statements ?
1)
Update SDR_Clientes SET Rec_Asociado = 'S'
From SDR_TMP_Asociar
Where Rec_Number = Tmp_Number and (link fields)
Tmp_Numero <> p_NumeroViejo (variable)
2)
LET v_CadenaAux = "Select Act_Actividad From SDR_Actividad Where
SDR_Field1 In (" || v_Cadena || ") || ";";
EXEC SQL prepare Seleccion from v_CadenaAux;
EXEC SQL execute Seleccion;
Thanks,
David