Re:adding lines

awk should be the best tool for the job, but I don't know it much so the following bash could work for your needs:

for FILE in "<your_file_list>"
do

    vi -c "1,\$s#infile '#infile '/DDUMPS/sybase_dump/out/DATACITI_MASTER/Oracle/#g|wq" $FILE done

The instruction between "do" and "done" must be on a single line. Make a safety copy of your scripts before doing.

Hope it helps,

Alessandro

>Hi All,
>
>By using awk or any unix commands, can we change all ctl files .We have 25 such files which is subject to change.
>
>
>load data
>infile 'DATACITI_MASTER.dbo.aspc_defaultdb.dat' "str '<EORD>'"
>into table DATACITI_MASTER.aspc_defaultdb
>fields terminated by '<EOFD>'
>trailing nullcols
>(
>virtualid ,
>host CHAR(255)
>)
>to
>
>We need to change it to below by adding data in bold(red) to all existing ctl files.
>
>UNRECOVERABLE
>load data
>infile '/DDUMPS/sybase_dump/out/DATACITI_MASTER/Oracle/DATACITI_MASTER.dbo.aspc_defaultdb.dat' "str '<EORD>'"
> append into table DATACITI_MASTER.aspc_defaultdb
>fields terminated by '<EOFD>'
>trailing nullcols
>(
>virtualid ,
>host CHAR(255)
>)
>
>
>Please provide me the solution asap.
>
>Thanks & Regards
>Noor
>
>
>DISCLAIMER:
>-----------------------------------------------------------------------------------------------------------------------
>
>The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only.
>It shall not attach any liability on the originator or HCL or its affiliates. Any views or opinions presented in
>this email are solely those of the author and may not necessarily reflect the opinions of HCL or its affiliates.
>Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of
>this message without the prior written consent of the author of this e-mail is strictly prohibited. If you have
>received this email in error please delete it and notify the sender immediately. Before opening any mail and
>attachments please check them for viruses and defect.
>
>-----------------------------------------------------------------------------------------------------------------------
>

--
http://www.freelists.org/webpage/oracle-l