Hi,
how can I extract source table from the loading script of a document ?
For example I have:
....
AnagraficaCampagne:
sql select PCMSTAB || trim(to_char(PCMANNO,'0000')) || PCMCIMP ||
TRIM(TO_CHAR(PCMPROG,'000')) as CampagnaLaminazione,
PCMSTAB || trim(to_char(PCMANNO,'0000')) || PCMCIMP ||
TRIM(TO_CHAR(PCMPROG,'000')) as CampagnaLaminazioneAnag,
PCMFLGVERS as FlagVersato,
PCMFLGNC as FlagNonConforme,
PCMACAM as CodiceAmbitoCampagna
from TABLEX;
.....
I would like to extract TABLEX in automatic mode.
Thanks
Giovanni