Hi people, i need youre help on this.
I need to create an Shell SCript to list in a directory some sql files and then execute them one by one .
Also i need to have Logs from the executed Sql's to send to our costummers.
Can anyone help me on this
Regards,
osramos (2 Replies)
Hi,
I know in oracle a .sql file is called by @ <path> /<filename>.
But how to call in sql 2005, I am opening the sql sessionwith sqsh, is there any command to execute there a .sql file (query in sql 2005) in K shell script. (0 Replies)
Hi All,
Please help me to write a shell script to execute the below sql query.
select c.account_no,b.bill_no,a.pay_type,(b.total_due + b.recvd + b.adjusted + b.disputed + b.transferred) as amt_not_billed,d.cash_on_delivery,
(select j.bill_no from
billinfo_T y,
bill_t j
where... (1 Reply)
hi all,
how to execute shell script in another server that contain sql script. i tried using "ssh -l" option.. but i am unable to load the environment variable of the remote host.
please suggest how execute the shell script contain sql part inside it. (2 Replies)
I am using HP-UX:
I have written a ksh script where I need to connect to sqlplus and execute few sql scripts. Part of this code is -
sqlplus user/temp1234 <<!
set serverout on
set feedback off
set pages 1000
set colsep ,
set echo off
spool /home/supp1/pks/output.csv... (8 Replies)
hello forum ,
I am new to shell scripting. as part of my assignment i have to execute a sql querry from the shell script. please help me.
example.
sql queerry:db2 "select emp_id from tsble emp".
i have to execute the above querry from the script.
advance thanks to forum
Siva ranganath (1 Reply)
Hi All,
I want some help in writing a shell script which will be in the below form:
A logical representation of shell scripts:
->Shell scripts start
->Connect to database
->Execute a sql and store the output in a cursor(need to know is there any concept of cursor in unix)
->Using a loop... (2 Replies)
Hi Experts,
Need your support.
Not able to use sql query alias in shell script.
Could you please help me in finding right way to use alias with sql query in shell script.
Below is the code i am using.
#!/bin/bash
sqlplus -s abc/abc@abc << EOF> bcd.csv
set trimspool on
select zone_id... (4 Replies)
I am new to shell scripting and i want to know how to execute the *.sql files from a folder through sqlplus in shell script and files should be execute in sequentially one by one while execution if any ORA error it has to exit from sqlplus session
1) scripts from external folder
2) logs has... (1 Reply)
Discussion started by: sreekanth Reddy
1 Replies
LEARN ABOUT BSD
adduser
ADDUSER(8) System Manager's Manual ADDUSER(8)NAME
adduser - procedure for adding new users
DESCRIPTION
A new user must choose a login name, which must not already appear in /etc/passwdor /etc/aliases. It must also not begin with the hyphen
(``-'') character. It is strongly recommended that it be all lower-case, and not contain the dot (``.'') character, as that tends to con-
fuse mailers. An account can be added by editing a line into the passwd file; this must be done with the password file locked e.g. by
using chpass(1) or vipw(8).
A new user is given a group and user id. Login's and user id's should be unique across the system, and often across a group of systems,
since they are used to control file access. Typically, users working on similar projects will be put in the same groups. At the Univer-
sity of California, Berkeley, we have groups for system staff, faculty, graduate students, and special groups for large projects.
A skeletal account for a new user "ernie" might look like:
ernie::25:30::0:0:Ernie Kovacs,508 Evans Hall,x7925,642-8202:/a/users/ernie:/bin/csh
For a description of each of these fields, see passwd(5).
It is useful to give new users some help in getting started, supplying them with a few skeletal files such as .profile if they use
"/bin/sh", or .cshrc and .login if they use "/bin/csh". The directory "/usr/skel" contains skeletal definitions of such files. New users
should be given copies of these files which, for instance, use tset(1) automatically at each login.
FILES
/etc/master.passwd user database
/usr/skel skeletal login directory
SEE ALSO chpass(1), finger(1), passwd(1), aliases(5), passwd(5), mkpasswd(8), vipw(8)BUGS
User information should (and eventually will) be stored elsewhere.
4th Berkeley Distribution October 23, 1996 ADDUSER(8)