Solved

Username and password issue in Unix

Posted on 2009-05-05
1
354 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
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

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Using libpcap/Jpcap to capture and send packets on Solaris version (10/11) Library used: 1.      Libpcap (http://www.tcpdump.org) Version 1.2 2.      Jpcap(http://netresearch.ics.uci.edu/kfujii/Jpcap/doc/index.html) Version 0.6 Prerequisite: 1.      GCC …
Java performance on Solaris - Managing CPUs There are various resource controls in operating system which directly/indirectly influence the performance of application. one of the most important resource controls is "CPU".   In a multithreaded…
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…
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:

747 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now