TCL Statement
Posted: Thu Oct 12, 2000 9:11 am
Within a datastage routine, I am trying to execute a TCL statement to copy records from one file to another.
In Universe the statement I would use is:
SELECT FILE1 with F7 # ""
COPY FROM FILE1 TO FILE2
I have tried the following in the routine and it doesnt work.
ex = SELECT FILE1 WITH F7 # ""
execute ex capturing xyz
ex = COPY FROM FILE1 to FILE2
execute ex capturing xyz
Please advise on how this is done within a datastage routine. Thx.
In Universe the statement I would use is:
SELECT FILE1 with F7 # ""
COPY FROM FILE1 TO FILE2
I have tried the following in the routine and it doesnt work.
ex = SELECT FILE1 WITH F7 # ""
execute ex capturing xyz
ex = COPY FROM FILE1 to FILE2
execute ex capturing xyz
Please advise on how this is done within a datastage routine. Thx.