Hi Frank,
[[EMAIL PROTECTED] wrote]
>
> Hi,
>
> I want to extract data via REPMCLI (by using DATAEXTRACT)
> from a source table. The source table contains the OUTFILE
> value in one column. Is there a possibility to retrieve this
> value from the table and use it during DATAEXTRACT processing (maybe
> concatenate it to a fix path string)?
>
> Thank you in advance!
> Frank Schimmelpfennig
>
>
No, no way using only the repman.
Generally there is no
possibility to get result sets with repmcli as you are used to
get with sql tools. The tool is still a batch tool. This means - repmcli
sends the command to the server which processes it. The data
gotten from a table is always written to a storage medium (files yet).
Even if you execute an sql stmt like 'select ... from table ...' which
is possible you will only get the return code. No data is delivered.
So you could only write the data to a file, read it, and then build your
command to run it thereafter. But thats impossible using repmcli/lserver.
You could use the perl/python interface to repman and write a little
program doing it. But this seems quite complicated.
Regards,
Steffen
