Replace a var in sql file with shell script variable Post: 302458555

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

how to assign sql output data to shell script variable

Hi Guys ! I am new to unix and want to find out how we can make sql statement data to shell script variable? Any help/suggestion is greatly appreciated -Chandra

2. UNIX for Advanced & Expert Users

Calling sql file from shell script

Hi I have a shell script that call a sql file. The sql file will create a spool file. My requirement is, when ever i get an OS error like file not found. I have to log it in a log file. Could some who worked in a like scenario help me by giving the code sample. Many Thanks..

3. Shell Programming and Scripting

(Urgent):Creating flat file using sql script and sqlplus from UNIX Shell Script

Hi, I need help urgently for following issue. Pls help me to resolve this issue. I am calling sql script file(file1.sql) from UNIX Shell Script(script1.ksh) using sql plus and trying to create flat file that contains all records returned from SQL query in SQL script(file1.sql) I given...

4. Shell Programming and Scripting

How to assign the result of a SQL command to more than one variable in shell script.

Hi Friends... Please assist me to assign the result of a SQL query that results two column, to two variables. Pls find the below code that I write for assigning one column to one variable. and please correct if anything wrong.. #! /bin/sh no=' sqlplus -s uname/password@DBname...

5. Shell Programming and Scripting

Assigning return value of an embedded SQL in a shell script variable

I've a script of the following form calling a simple sql that counts the no of rows as based on some conditions. I want the count returned by the sql to get assigned to the variable sql_ret_val1. However I'm finding that this var is always getting assigned a value of 0. I have verified by executing...

6. UNIX for Dummies Questions & Answers

SQL Script to use variable value from input file

Here is the requirement, When I run the "run file KSH (sql)", it should substitute '${pCW_Bgn_DT}' with 201120 and '${pCW_End_DT}' with 201124 Input File ---------- $ cat prevwk.dat 201124 20110711 run file KSH (sql) ------------------ In this file, I want to use the variables...

7. Shell Programming and Scripting

Help with a shell script to check /var file system

deleting

8. Red Hat

How to pass value of pwd as variable in SED to replace variable in a script file

Hi all, Hereby wish to have your advise for below: Main concept is I intend to get current directory of my script file. This script file will be copied to /etc/init.d. A string in this copy will be replaced with current directory value. Below is original script file: ...

9. Shell Programming and Scripting

Passing variable from file to sql from script

Hi Friend, I have one file in which some number are mentioned and number of lines are vary every time And i need to pass that number to my sql command from script. Suppose i have file acc.txt 45456546456 45464564565 67854353454 67657612132 Number of records are vary every time....

10. Shell Programming and Scripting

Shell script to call sql file

hi , the below script contains sql query and after executed it sends the output of the query (output.txt) to an email body with conditional subject line based on the output of all_counts_match.txt. i want to make this script generic so that it can accept the sql file as parameter and can...

LEARN ABOUT OSX

fddist

fddist(1m)							   USER COMMANDS							fddist(1m)

NAME

       fddist - file descriptor usage distributions. Uses DTrace.

SYNOPSIS

       fddist [-r|-w]

DESCRIPTION

       This  prints  distributions for read and write events by file descriptor, by process. This can be used to determine which file descriptor a
       process is doing the most I/O with.

       Since this uses DTrace, only users with root privileges can run this command.

OPTIONS

       -r     reads only

       -w     writes only

EXAMPLES

       Sample both read and write activity,
	      # fddist

       Sample reads only,
	      # fddist -r

FIELDS

       EXEC   process name

       PID    process ID

       value  file descriptor

       count  number of events

BASED ON

       /usr/demo/dtrace/lquantize.d

DOCUMENTATION

       DTrace Guide "Aggregations" chapter (docs.sun.com)

       See the DTraceToolkit for further documentation under the Docs directory. The DTraceToolkit docs may include full worked examples with ver-
       bose descriptions explaining the output.

EXIT

       fddist will sample until Ctrl-C is hit.

SEE ALSO

       dtrace(1M)

version 0.70							   Jun 08, 2005 							fddist(1m)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

how to assign sql output data to shell script variable

Discussion started by: kattics

2. UNIX for Advanced & Expert Users

Calling sql file from shell script

Discussion started by: chintapalli001

3. Shell Programming and Scripting

(Urgent):Creating flat file using sql script and sqlplus from UNIX Shell Script

Discussion started by: praka

4. Shell Programming and Scripting

How to assign the result of a SQL command to more than one variable in shell script.

Discussion started by: little_wonder