We help IT Professionals succeed at work.

This is in Sun Solaris ..I need a script

I have a script when executed reads the load.CTL file and update in the database.

I need to edit my script when run it should read and update in mulitple databases

say for example: Database1 :  agentinfo/Inf!@#
                            Database2:   clientinfo/nf#$

when ran the script I want it to update it to read load.CTL and update in the schemas of both the databases at the sametime
Comment
Watch Question

Commented:
What language of the script are you using? I prefer write a perl script to update contents to databases
Kamaraj SubramanianApplication Support Analyst

Commented:
how your load.ctl file is red by the script ?

basically you need to create a loop to perform update in multiple databases.

but it, will update in same time. ( it will update one by one )

Commented:
Create children process to perform concurrent tasks
read this http://www.perlmonks.org/?node_id=176222
awking00Information Technology Specialist
CERTIFIED EXPERT

Commented:
Can you post your load.ctl script?
Load Data

append

into table Agent.WORK_ORDER_ID

(

fld0 filler,

WORK_ORDER POSITION(42:58),

fld1 filler,

ORDER_ID POSITION(70:85),    

fld2 filler

)
 
CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019

Commented:
That is a sql loader control file.  It will not load into multiple databases at the same time.

You will need to run it twice.

Author

Commented:
worked

Author

Commented:
worked
awking00Information Technology Specialist
CERTIFIED EXPERT

Commented:
What worked?

Explore More ContentExplore courses, solutions, and other research materials related to this topic.