Solved

Username and password issue in Unix

Posted on 2009-05-05
1
396 Views
Last Modified: 2012-05-06
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
0
Comment
Question by:Micheal_Male
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 51

Accepted Solution

by:
ahoffmann earned 125 total points
ID: 24313717
each database comes with a client program, such as plsql for Oracle, mysql for MySQL and so on ...
You need to use that client program and pass the proper database, table, username and password. The syntax of these command line arguments is different for each, check your man pages.
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

My previous tech tip, Installing the Solaris OS From the Flash Archive On a Tape (http://www.experts-exchange.com/articles/OS/Unix/Solaris/Installing-the-Solaris-OS-From-the-Flash-Archive-on-a-Tape.html), discussed installing the Solaris Operating S…
Why Shell Scripting? Shell scripting is a powerful method of accessing UNIX systems and it is very flexible. Shell scripts are required when we want to execute a sequence of commands in Unix flavored operating systems. “Shell” is the command line i…
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Suggested Courses

626 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question