Sponsored Content
Full Discussion: Script to run sql query.
Top Forums UNIX for Dummies Questions & Answers Script to run sql query. Post 302879862 by chacko193 on Monday 16th of December 2013 08:29:50 AM
Old 12-16-2013
Have you tried this Moved Permanently

It gives a lot of new perspectives.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

script variable within a sql query

I created a script to read a csv file with four columns. The script also saved values of each col in a arry. In the script, i connected to db try to run a query to pull out data baisc on the values from the csv file. select Num from tableName where Sec_Num in ('${isin}') /*isin is an arry... (1 Reply)
Discussion started by: Sherry_Run
1 Replies

2. Shell Programming and Scripting

Script executing sql query

Hello, I have a sh script excuting a sql query through sqlplus. I am having trouble making my date equal to the date of the server time in the sql script. How can i call the server date from my query? Thanks (2 Replies)
Discussion started by: kingluke
2 Replies

3. Shell Programming and Scripting

run sql query via perl script

Hello, If I run this command on the server it works. # dbc "update config set radio_enabled = 0;" how can I execute the same command in perl. I have defined the dbc path. Can any one please correct the last line. #!/usr/bin/perl #database path $dbc='/opt/bin/psql -Userver... (0 Replies)
Discussion started by: sureshcisco
0 Replies

4. Shell Programming and Scripting

Need help to run sql query from a script..which takes input from a file

I need to run sql script from shell script which takes the input from a file and contents of file will be like : 12345 34567 78657 and query will be like : select seq_nbr from bus_event where event_nbr='12345'; select seq_nbr from bus_event where event_nbr='34567'; select seq_nbr... (1 Reply)
Discussion started by: rkrish
1 Replies

5. Shell Programming and Scripting

How to run a SQL select query in Oracle database through shell script?

I need to run a SQL select query in Oracle database and have to capture the list of retrieved records in shell script. Also i would like to modify the query for certain condition and need to fetch it again. How can i do this? Is there a way to have a persistent connection to oracle database... (9 Replies)
Discussion started by: vel4ever
9 Replies

6. Shell Programming and Scripting

Run SQL thru shell script: how to get a new line when run sql query?

Hi, this's Pom. I'm quite a new one for shell script but I have to do sql on shell script to query some information from database. I found a concern to get a new line...When I run my script, it retrieves all data as wondering but it's shown in one line :( What should I do? I'm not sure that... (2 Replies)
Discussion started by: Kapom
2 Replies

7. Shell Programming and Scripting

SQL query within an awk script !!

Hello Experts, This sounds crazy, but one of my requirements is that if ID in 5th column in my input file (: separated) is not present in the oracle database table (say t_id) then this record should be skipped. I am using awk for all other requirements. So I was thinking if this requirement... (4 Replies)
Discussion started by: juzz4fun
4 Replies

8. Shell Programming and Scripting

Shell script to run sql query having a long listing of parameters

Hi, I have a query regarding execution of a sql query having long listing of parameters ..I need to execute this query inside a shell script. The scenario is like.... Suppose I have a file abc.txt that has the card numbers..it could be in thousands.. then I need to fire a query like ... (12 Replies)
Discussion started by: vsachan
12 Replies

9. Shell Programming and Scripting

Run sql query after ssh in UNIX

I am running this test.ksh on server1. It successfully logins to server2 but runs the queries of query.sql on server1. query.sql is present in both server1 and server2 Can anybody please help. I need to run queries on server2 itself.:confused: Below is the test script... (10 Replies)
Discussion started by: shruthimithra
10 Replies

10. Shell Programming and Scripting

Run sql query in shell script and output data save as delimited text

I want to run sql query in shell script and output data save as delimited text (delimited text would be comma) Code: SPOOL_FILE=/pgedw/dan.txt SQL=/pgedw/dan.sql sqlplus -s username/password@myhost:port/servicename <<EOF set head on set COLSEP , set linesize 32767 SET TRIMSPOOL ON SET... (8 Replies)
Discussion started by: Jaganjag
8 Replies
CISS(4) 						   BSD Kernel Interfaces Manual 						   CISS(4)

NAME
ciss -- Common Interface for SCSI-3 Support driver SYNOPSIS
To compile this driver into the kernel, place the following lines in your kernel configuration file: device scbus device ciss Alternatively, to load the driver as a module at boot time, place the following line in loader.conf(5): ciss_load="YES" DESCRIPTION
The ciss driver claims to provide a common interface between generic SCSI transports and intelligent host adapters. The ciss driver supports CISS as defined in the document entitled CISS Command Interface for SCSI-3 Support Open Specification, Version 1.04, Valence Number 1, dated 2000/11/27, produced by Compaq Computer Corporation. We provide a shim layer between the ciss interface and CAM(4), offloading most of the queueing and being-a-disk chores onto CAM. Entry to the driver is via the PCI bus attachment ciss_probe(), ciss_attach(), etc. and via the CAM interface ciss_cam_action(), and ciss_cam_poll(). The Compaq ciss adapters require faked responses to get reasonable behavior out of them. In addition, the ciss command set is by no means adequate to support the functionality of a RAID controller, and thus the supported Compaq adapters utilize portions of the control protocol from earlier Compaq adapter families. Currently ciss supports the ``simple'' and ``performant'' transport layer. Non-disk devices (such as internal DATs and devices attached to the external SCSI bus) are supported as normal CAM devices provided that they are exported by the controller firmware and are not marked as being masked. Masked devices can be exposed by setting the hw.ciss.expose_hidden_physical tunable to non-zero at boot time. Direct Access devices (such as disk drives) are only exposed as pass(4) devices. Hot-insertion and removal of devices is supported and notification messages will be reported to the console and logs. The problem which adapter freezes with the message ``ADAPTER HEARTBEAT FAILED'' might be solved by updating the firmware and/or setting the hw.ciss.nop_message_heartbeat tunable to non-zero at boot time. HARDWARE
Controllers supported by the ciss driver include: o Compaq Smart Array 5300 (simple mode only) o Compaq Smart Array 532 o Compaq Smart Array 5i o HP Smart Array 5312 o HP Smart Array 6i o HP Smart Array 641 o HP Smart Array 642 o HP Smart Array 6400 o HP Smart Array 6400 EM o HP Smart Array E200 o HP Smart Array E200i o HP Smart Array P212 o HP Smart Array P220i o HP Smart Array P222 o HP Smart Array P230i o HP Smart Array P400 o HP Smart Array P400i o HP Smart Array P410 o HP Smart Array P410i o HP Smart Array P411 o HP Smart Array P420 o HP Smart Array P420i o HP Smart Array P421 o HP Smart Array P430 o HP Smart Array P430i o HP Smart Array P431 o HP Smart Array P530 o HP Smart Array P531 o HP Smart Array P600 o HP Smart Array P721m o HP Smart Array P731m o HP Smart Array P800 o HP Smart Array P812 o HP Smart Array P830 o HP Smart Array P830i o HP Modular Smart Array 20 (MSA20) o HP Modular Smart Array 500 (MSA500) SEE ALSO
cam(4), pass(4), xpt(4), loader.conf(5), camcontrol(8) CISS Command Interface for SCSI-3 Support Open Specification, Version 1.04, Valence Number 1, Compaq Computer Corporation, 2000/11/27. AUTHORS
The ciss driver was written by Mike Smith <msmith@FreeBSD.org>. This manual page is based on his comments and was written by Tom Rhodes <trhodes@FreeBSD.org>. BSD
January 26, 2012 BSD
All times are GMT -4. The time now is 03:05 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy