Username and password issue in Unix
Posted on 2009-05-05
Hello. I have a .SQL file named employee.sql which contains the statement below :-
load from '/use/local/bin/name.csv' delimiter ',';
insert into employee_access
My only question is how to define the JDBC url with username and password in unix script ? I know it can be done in perl but was wondering if it is possible to be done in a korn shell ?.
If i know how to define my JDBC connection info with username and password i can execute this statement in my script which will insert all the values from the CSV file :-
dbaccess employees < employee.sql