04-04-2012
Hot to retrieve *.sql file names which we refer in .sh file.
Hi Guys,
How to retrieve/get *.sql file names which we refer in all *.sh files.
Can any one help me on this.
Thanks,
Kolipaka
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi
How can i dynamically read files names from a list file and execute them from a single shell script.
Please help its urgent
Thanks in Advance (4 Replies)
Discussion started by: anushilrai
4 Replies
2. UNIX for Dummies Questions & Answers
I need to refer a remote(present on another unix server) directory from my unix machine as a local file.
e.g.
I have one directory D1 on 10.10.10.10 and i need to access files in this directory just like they are present on my unix machine 20.20.20.20.
Is there any way out... i read a bit... (1 Reply)
Discussion started by: blackeyed
1 Replies
3. Shell Programming and Scripting
Hi ,
I used the below script to get the sql data into csv file using unix scripting.
I m getting the output into an output file but the output file is not displayed in a separe columns .
#!/bin/ksh
export FILE_PATH=/maav/home/xyz/abc/
rm $FILE_PATH/sample.csv
sqlplus -s... (2 Replies)
Discussion started by: Nareshp
2 Replies
4. Shell Programming and Scripting
Sun Solaris Unix Question
Haven't been able to find any solution for this situation. Let's just say the file names listed below exist in a directory. I want the find command to find all files in this directory but at the same time I want to eliminate certain file names or files with certain... (2 Replies)
Discussion started by: 2reperry
2 Replies
5. UNIX for Dummies Questions & Answers
Hi Guys,
Can any one help me on this,
I want to write unix command to get all .sh unix file name which are refered .sql files in it.
Thanks
Kolipaka (3 Replies)
Discussion started by: lakshmanrk811
3 Replies
6. UNIX for Dummies Questions & Answers
This may be a dumb question, but googling is not giving me an answer. I'm trying to figure out how to refer to an input file in my code.
Lets say i run a script in bash:
"sh shellscript.sh inputfile"
(Inputfile will be variable...whatever file i run the script on)
I wanted to make... (5 Replies)
Discussion started by: legato22
5 Replies
7. Shell Programming and Scripting
Data files coming in different names in a file name called process.txt.
1. shipments_yyyymmdd.gz
2 Order_yyyymmdd.gz
3. Invoice_yyyymmdd.gz
4. globalorder_yyyymmdd.gz
The process needs to discard all the below files and only process two of the 4 file names available
... (1 Reply)
Discussion started by: dsravanam
1 Replies
8. Shell Programming and Scripting
Hi All,
In this path /home/all_files
we have follwing files and direcotries
proc_edf_sot.sql
proc_ssc_sot.sql
func_dfg_sot.sql
sot
unic
cmr
sdc
under sot directory we have other directories
sql
pas
ref
under sql directory we have
sql_sot
sql_mat (6 Replies)
Discussion started by: ROCK_PLSQL
6 Replies
9. UNIX for Beginners Questions & Answers
I am having trouble matching *two* strings from one file anywhere in a line of a second file, and could use some help getting this figured out. My preference would be to use grep for this because I would like to take advantage of its -A option. The latter is due to the fact that I would like both... (2 Replies)
Discussion started by: jvoot
2 Replies
10. Shell Programming and Scripting
Hi All,
I'm having a python script: test.py in /path/to/script/test.py
I'm using a properties file: test_properties.py (it is having values as dictionary{}) which is in same DIR as the script.
Sample Properties file:
params = {
'target_db' : 'a1_db'
'src_db' : ... (15 Replies)
Discussion started by: saps19
15 Replies
LEARN ABOUT PHP
sqlite_fetch_single
SQLITE_FETCH_SINGLE(3) SQLITE_FETCH_SINGLE(3)
sqlite_fetch_single - Fetches the first column of a result set as a string
SYNOPSIS
string sqlite_fetch_single (resource $result, [bool $decode_binary = true])
DESCRIPTION
Object oriented style (method):
string SQLiteResult::fetchSingle ([bool $decode_binary = true])
string SQLiteUnbuffered::fetchSingle ([bool $decode_binary = true])
sqlite_fetch_single(3) is identical to sqlite_fetch_array(3) except that it returns the value of the first column of the rowset.
This is the most optimal way to retrieve data when you are only interested in the values from a single column of data.
PARAMETERS
o $result
- The SQLite result resource. This parameter is not required when using the object-oriented method.
o $decode_binary
-When the $decode_binary parameter is set to TRUE (the default), PHP will decode the binary encoding it applied to the data if it
was encoded using the sqlite_escape_string(3). You should normally leave this value at its default, unless you are interoperating
with databases created by other sqlite capable applications.
RETURN VALUES
Returns the first column value, as a string.
EXAMPLES
Example #1
A sqlite_fetch_single(3) example
<?php
if ($dbhandle = sqlite_open('mysqlitedb', 0666, $sqliteerror)) {
$sql = "SELECT id FROM sometable WHERE id = 42";
$res = sqlite_query($dbhandle, $sql);
if (sqlite_num_rows($res) > 0) {
echo sqlite_fetch_single($res); // 42
}
sqlite_close($dbhandle);
}
?>
SEE ALSO
sqlite_fetch_array(3).
PHP Documentation Group SQLITE_FETCH_SINGLE(3)