. How Connect to a Database in Shell Programming?Please tell me Step by Step

To Connect to Oracle Database and Collect the data in to text file from the table.echo "Enter User Name "read nameecho "Enter passwd "stty -echoread passstty echoecho "Enter Detp no"read dnosqlplus -S $name@oracle/$pass< Suppose you are using db2 and ksh #!/usr/bin/ksh connect to :@ user using ----------------------------------- If u have profile and catalog then ---------------------------------- #!/usr/bin/ksh db2 connect to ----------------------------------- To run a sample proc .. use the below db2 ""

No comments: