06-13-2008
isql some_creditial_parameters < input_file > output_file
input_file is something like
Quote:
SELECT filename FROM mydb WHERE condition=xyz
GO
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I need to append the data in to a file by using tab delimiter.
eg:
echo "Data1" >> filename.txt
echo "\t" >> filename.txt (its not working)
echo "Data2" >> filename.txt.
the result sould be like this.
Data1 Data2 (6 Replies)
Discussion started by: Sharmila_P
6 Replies
2. UNIX for Dummies Questions & Answers
One of the fortunate things about posting in a "Dummies" forum is you probably aren't expecting a lot of out me...
I'm trying to pull fields from two lines in the same file(s), and then append them together in a new file.
So...I get a nice line-by-line of the first bit of data I'm looking... (6 Replies)
Discussion started by: Milano_EH3
6 Replies
3. UNIX for Dummies Questions & Answers
i want to develop a script newdata that writes new data to a file called items
the file items has the following headings columns separated by tabs:
channel date time programe
if i type executable file newdata on the command line with parameters, it should append it to the items files
the... (1 Reply)
Discussion started by: fletcher
1 Replies
4. Shell Programming and Scripting
I have an xml file data as shown below:
<impl name="Nortel" is-enabled="true">
<package-mappings>
<const-mapping target-state="EndPoint"
target-param="cfCNDSubscribed" constant-value="true"/>
<const-mapping... (2 Replies)
Discussion started by: ravi_rn
2 Replies
5. Shell Programming and Scripting
hai..i am new to unix..and i've currently learn shell script..
i have this small problem where i would like to save every data from log file into user directory if the data is equal to the name of the user..
i manage to do that with below script..
i would like to ask if there is any solutions so... (1 Reply)
Discussion started by: meggae
1 Replies
6. Shell Programming and Scripting
Hi ,
i have two log files, i need to combine this as a one log file.
i need to do this by SED ,
test1.log
sadadadaadfsaf
test2.log
adadadadadada
i need this in a single file from test 1 to test2.log
test2.log(expected result)
adadadadadada (7 Replies)
Discussion started by: mhdmehraj
7 Replies
7. Shell Programming and Scripting
I have a script which has to be scheduled to run 3 times a day.
My script picks the required fields from logfile and stores the data in a.csv file.
Sample data.
my logfile contain:
0097A,0374D,100903,1519,00000606191
0097A,C88RA,100903,0724,00000606105
So the output of first execution... (3 Replies)
Discussion started by: shrima.pratima
3 Replies
8. Shell Programming and Scripting
I have a file which has data in the below format:
7810902|6783014102| || |0| |0| |0| |0|||||T|04/13/2006||9423|7421||100|2006-04-13 16:50:28|||2006-04-13 16:50:28|n|51|-1||214
1089929|||||NewSpCreateAction request successful. Activity ID = <826528>||||100|n|2006-04-13 16:50:27|2006-04-13... (3 Replies)
Discussion started by: ankianand88
3 Replies
9. Shell Programming and Scripting
Hi
I search for certain values in a file across many directories using the following awk code
awk '/Sl.*thickness/ {Sl=$3;Tt=$NF}END{print Sl, Tt}' DILAT.DAT
What I would like to do is write out Sl and Tt obtained from these files from many directories to a single file. So for example if... (2 Replies)
Discussion started by: lost.identity
2 Replies
10. Shell Programming and Scripting
Hi,
I have a data like
Input:
12||34|56|78
Output:
XYZ|12||34|56|78
I tried like this , but it puts it on another line
awk -F "|" ' BEGIN {"XYZ"} {print $0} 'file
Any quick suggessitons in sed/awk ? am using HP-UX (3 Replies)
Discussion started by: selvankj
3 Replies
LEARN ABOUT PHP
sqlite_open
SQLITE_OPEN(3) SQLITE_OPEN(3)
sqlite_open - Opens an SQLite database and create the database if it does not exist
SYNOPSIS
resource sqlite_open (string $filename, [int $mode = 0666], [string &$error_message])
DESCRIPTION
Object oriented style (constructor): SQLiteDatabase::__construct (string $filename, [int $mode = 0666], [string &$error_message])
Opens an SQLite database or creates the database if it does not exist.
PARAMETERS
o $filename
- The filename of the SQLite database. If the file does not exist, SQLite will attempt to create it. PHP must have write permis-
sions to the file if data is inserted, the database schema is modified or to create the database if it does not exist.
o $mode
- The mode of the file. Intended to be used to open the database in read-only mode. Presently, this parameter is ignored by the
sqlite library. The default value for mode is the octal value 0666 and this is the recommended value.
o $error_message
- Passed by reference and is set to hold a descriptive error message explaining why the database could not be opened if there was
an error.
RETURN VALUES
Returns a resource (database handle) on success, FALSE on error.
EXAMPLES
Example #1
sqlite_open(3) example
<?php
if ($db = sqlite_open('mysqlitedb', 0666, $sqliteerror)) {
sqlite_query($db, 'CREATE TABLE foo (bar varchar(10))');
sqlite_query($db, "INSERT INTO foo VALUES ('fnord')");
$result = sqlite_query($db, 'select bar from foo');
var_dump(sqlite_fetch_array($result));
} else {
die($sqliteerror);
}
?>
NOTES
Tip
On Unix platforms, SQLite is sensitive to scripts that use the fork() system call. If you do have such a script, it is recommended
that you close the handle prior to forking and then re-open it in the child and/or parent. For more information on this issue, see
The C language interface to the SQLite library in the section entitled Multi-Threading And SQLite.
Tip
It is not recommended to work with SQLite databases mounted on NFS partitions. Since NFS is notoriously bad when it comes to lock-
ing you may find that you cannot even open the database at all, and if it succeeds, the locking behaviour may be undefined.
Note
Starting with SQLite library version 2.8.2, you can specify :memory: as the $filename to create a database that lives only in the
memory of the computer. This is useful mostly for temporary processing, as the in-memory database will be destroyed when the process
ends. It can also be useful when coupled with the ATTACH DATABASE SQL statement to load other databases and move and query data
between them.
Note
SQLite is safe mode and open_basedir aware.
SEE ALSO
sqlite_popen(3), sqlite_close(3), sqlite_factory(3).
PHP Documentation Group SQLITE_OPEN(3)