Shell Programming and Scripting

I have requirement to connect to different sybase server's and store the data into flat file and load into oracle using sqlloader
for each day drop the table and re create it and load the data based on business date as parameter which was taking from parameter file.Any help on this should be appreciated.


create_table.sql

Code:

drop table;
create table xx(server varchar2(10),a1 date,xf1 varchar2,xf2 number);

Agora_server.txt

Code:

hk1|PMKOMAN01|db001|username|password
hk2|PMKOMAN02|db001|username|password

a.sql

Code:

select srv as sever,a1,xf1,xf2 from tab(sysbase server)
where busdate=today(pass parameter) and srv value take 1st value of Agora_server.txt

Regards,
MR