Using multiple SQL statements as input file source
Posted: Fri Feb 14, 2003 5:29 pm
Hello folks:
I have an output file from an program which contains the following information.
update table1 set col1 = 10 where col3='ID';
update table2 set col5 = 10 where col23='ID';
delete from table1 where col3='ID';
insert into table3 values(......);
......................;
......................;
EOF
Can I use this file as input source to run the ETL job?
What is the best practice on how to use this input file?
Please advice.
Thanks in advance,
VJ
I have an output file from an program which contains the following information.
update table1 set col1 = 10 where col3='ID';
update table2 set col5 = 10 where col23='ID';
delete from table1 where col3='ID';
insert into table3 values(......);
......................;
......................;
EOF
Can I use this file as input source to run the ETL job?
What is the best practice on how to use this input file?
Please advice.
Thanks in advance,
VJ