10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have c program that I run like this:
And my test files look like this all the way up to 100:
Is there a way to run this more efficiently so I don't have to hit up and change the number every time? (4 Replies)
Discussion started by: cokedude
2. Shell Programming and Scripting
1)In a particualr path i have a set of inputfiles like
........and so on
in above path there wil be nearly 15 to 20 files starting with map and in other path i have another file input file... (4 Replies)
Discussion started by: katakamvivek
3. Shell Programming and Scripting
I can rename a file with sequential numbers from 1 to N with this script:
for file in *.dat;do
mv "$file" "$(printf "%u" $num).txt"
The script begins with renaming a some.dat file to 1.dat.txt and goes on sequentially renaming other DAT files to... (1 Reply)
Discussion started by: shoaibjameel123
Writing a Tool to simulate non-sequential disk I/O (simulate db file sequential read) in C POSIX
I have over the years come across the same issue a couple of times, and it normally is that the read speed on SAN is absolutely atrocious when doing non-sequential I/O to the disks. Problem being of... (7 Replies)
Discussion started by: vrghost
5. Shell Programming and Scripting
I have a file sequential way i.e. written in contineous mode and the Record Seperator is AM from which the record is seperated .Now to process I have to make line sequential,and more over record length is not same it varies as per the input address,
AM1234563 John Murray 24 Old streeet old... (5 Replies)
Discussion started by: vakharia Mahesh
6. Shell Programming and Scripting
Could someone please assist on a quick way of How to extract data from indexed files (ISAM files) maintained in an UNIX(AIX) server.The file data needs to be extracted in flat text file or CSV or excel format .
Usually we have programs in microfocus COBOL to extract data, but would like... (2 Replies)
Discussion started by: devina
7. UNIX for Dummies Questions & Answers
I am having 3 files as
I want to merge thes file such that the resultnt file should be as (1 Reply)
Discussion started by: arunkumar_mca
8. UNIX for Advanced & Expert Users
I posted this over at Macnn and was redirected here... I'm not a unix programmer at all, but I have some backup if needed. Thanks in advance for any input.
Is there a command for the osX terminal that will list sequentially numbered groups of file as one line instead of individually,... (1 Reply)
Discussion started by: kentm
We have to convert a sequential file to a 80 char line sequential file (HP UX platform).The sequential file contains special characters. which after conversion of the file to line sequential are getting coverted into "new line" or "tab" and file is getting distorted. Is there any way to read these... (2 Replies)
Discussion started by: Rajeshsu
10. UNIX for Dummies Questions & Answers
I need to access files from a specific folder of a Linux system from an another Linux System Remotely.
I know how to, Export a folder on One SCO System & can access the same by using Import via., NFS in the Sco Unix SVR4 System using the scoadmin utility.
Also, I know to use mount -t ... (2 Replies)
Discussion started by: S.Vishwanath
sqlite_unbuffered_query - Execute a query that does not prefetch and buffer all data
resource sqlite_unbuffered_query (resource $dbhandle, string $query, [int $result_type = SQLITE_BOTH], [string &$error_msg])
resource sqlite_unbuffered_query (string $query, resource $dbhandle, [int $result_type = SQLITE_BOTH], [string &$error_msg])
Object oriented style (method): SQLiteUnbuffered SQLiteDatabase::unbufferedQuery (string $query, [int $result_type = SQLITE_BOTH],
sqlite_unbuffered_query(3) is identical to sqlite_query(3) except that the result that is returned is a sequential forward-only result set
that can only be used to read each row, one after the other.
This function is ideal for generating things such as HTML tables where you only need to process one row at a time and don't need to ran-
domly access the row data.
Functions such as sqlite_seek(3), sqlite_rewind(3), sqlite_next(3), sqlite_current(3), and sqlite_num_rows(3) do not work on result
handles returned from sqlite_unbuffered_query(3).
- The SQLite Database resource; returned from sqlite_open(3) when used procedurally. This parameter is not required when using the
- The query to be executed. Data inside the query should be properly escaped.
-The optional $result_type parameter accepts a constant and determines how the returned array will be indexed. Using SQLITE_ASSOC
will return only associative indices (named fields) while SQLITE_NUM will return only numerical indices (ordinal field numbers).
SQLITE_BOTH will return both associative and numerical indices. SQLITE_BOTH is the default for this function.
- The specified variable will be filled if an error occurs. This is specially important because SQL syntax errors can't be fetched
using the sqlite_last_error(3) function.
Two alternative syntaxes are supported for compatibility with other database extensions (such as MySQL). The preferred form is the
first, where the $dbhandle parameter is the first parameter to the function.
Returns a result handle or FALSE on failure.
sqlite_unbuffered_query(3) returns a sequential forward-only result set that can only be used to read each row, one after the other.
|Version | |
| | |
| | Description |
| | |
| 5.1.0 | |
| | |
| | Added the $error_msg parameter |
| | |
PHP Documentation Group SQLITE_UNBUFFERED_QUERY(3)