Define a unique value variable from external source

20 Views

Hi everybody, nice to be here again!

this time I'm trying to get some unique date value from a database, and use it as the SET PERIOD of a Procedure.

Can this be done?

Here's something I'm trying now but is not working.

thanks for your help!

ACCESS LSLINK

Connect ClaroControl

select SUBSTR(max(IDCALENDARIO),7,2)||'/' ||SUBSTR(max(IDCALENDARIO),5,2)||'/' ||SUBSTR(max(IDCALENDARIO),1,4) FECHA FROM CT_TB_CARGAS_ETL_AUD WHERE IDJOB = 100 AND STATUS = 'OK'

LSS CREATE FECHA_ACTUAL = FECHA

...select DISTINCT to_char(current_date -1 , 'DD/MM/YYYY') fecha_actual FROM TMP_SSM_ALTAS

... SELECT DISTINCT ('25/09/2011') FECHA_ACTUAL FROM TMP_SSM_ALTAS

EXIT

SET CONTROL FECHA_INICIO &FECHA_ACTUAL

SET CONTROL FECHA_FIN &FECHA_ACTUAL

SHOW CONTROL

SET PERIOD &FECHA_INICIO - &FECHA_FIN