01-09-2006
File Handling in C
Hi all,
I have a problem in handling files through C.
here is the problem im having:
i will query the database (for instance consider employees table )
for empno,ename,job,salary fields.The query returns me some 100 of rows. now i need to place them in a file in row wise pattern as they exist in the database.
now , if any row is updated in the database i need to update the same row in the file . also if any row is deleted i need to remove the same row in the file , and if any new row is inserted into the data base i need to insert the row in the file.
can any one suggest me any method to do this .
The performance is and main criteria(i mean time to do file operations. )
please help me in this regard,
thanks in advance,
Trinath Somanchi,
Hyderabad.
10 More Discussions You Might Find Interesting
1. Programming
Hi all,
I got a little issue here. Imagine that I have more than one process accessing one file. Is it possible to know which process(es) are accessing that file when I open the file??
Thanks for the help.
Best regards,
Ernesto (2 Replies)
Discussion started by: ninjanesto
2 Replies
2. UNIX for Advanced & Expert Users
Hi,
I have a log file which runs into 3 to 5 GB.
We store this typically for 6 months. When a new month starts we move the previous month into a 9 month back up log (file.9m) and delete the last month of the 9 month back up.
Iam using awk to find the data and cat to join the files like... (3 Replies)
Discussion started by: baanprog
3 Replies
3. UNIX for Advanced & Expert Users
sir i have to get first line from a file
for example
>cat file1
abc
zxc
asd
adsf
from that file1 i need only first line
expected result
>abc
please help me ! (1 Reply)
Discussion started by: ponmuthu
1 Replies
4. UNIX for Advanced & Expert Users
my input for a script is another csv file
but in that file say 7 lines are there ...
how can i get line by line to that input
for example :
>cat link.csv
www.yahoo.com,yahoo
www.google.com,google
www.unix.com,unix
another file
in that file i need to ping the above links
... (2 Replies)
Discussion started by: ponmuthu
2 Replies
5. Shell Programming and Scripting
I have been doing automation of daily check activity for a server, i have been using sqls to retrive the data and while loop for reading the data from the file for several activities. BUT i got a show stopper the below one.. where the data is getting store in $temp_file, but not being read by while... (1 Reply)
Discussion started by: KuldeepSinghTCS
1 Replies
6. Programming
$# some text
$$ some text
$@ some text
$$. some text
Mg1 some text
Mg2 some text
.
.
.
Mg10 some text
The above 10 lines are to be extracted except the lines starting from $#,$$.,... (4 Replies)
Discussion started by: baig.abdul
4 Replies
7. Shell Programming and Scripting
Specifically on RHEL 5.7.
When does the underlying ksh process open and close files? Every time they're accessed, or as little as possible?
Say you have some script like:
CreateFiles()
{
grep "<VALUE1>" ${infile} >> ${outfile}
grep "<VALUE2>" ${infile} >> ${outfile}
...... (4 Replies)
Discussion started by: CarloM
4 Replies
8. UNIX for Dummies Questions & Answers
Hi Team,
I am trying to cut a large file into multiple files. It has
Header
50,050 records
Trailer
-------------------------------------------
I need to cut the files into multiple files of 1000 records and should have the same header and trailer as the original files.
... (4 Replies)
Discussion started by: Gurkamal83
4 Replies
9. UNIX for Dummies Questions & Answers
I have a file
1
298167
298168
1093209
1093210
1422663
I want to write a code where in I want to read contents of above file
like first read is 1
second read is 298167
Substract second read from first and if this is greater than or less than 99,999.
Similarly I want to traverse thru... (3 Replies)
Discussion started by: Guru148
3 Replies
10. Shell Programming and Scripting
Hi All,
I need to extract the data from the text file. The data of the text file is shown below
#L 0.000017 4.329939 0.000017 4.716267 r7.9 P 1 1;Net=IN32
The extracted data should be IN32. Could anyone help to script in c shell.? (4 Replies)
Discussion started by: gopishrine
4 Replies
LEARN ABOUT PHP
ingres_fetch_row
INGRES_FETCH_ROW(3) 1 INGRES_FETCH_ROW(3)
ingres_fetch_row - Fetch a row of result into an enumerated array
SYNOPSIS
array ingres_fetch_row (resource $result)
DESCRIPTION
ingres_fetch_row(3) returns an array that corresponds to the fetched row, or FALSE if there are no more rows. Each result column is stored
in an array offset, starting at offset 1.
Subsequent calls to ingres_fetch_row(3) return the next row in the result set, or FALSE if there are no more rows.
By default, arrays created by ingres_fetch_row(3) start from position 1 and not 0 as with other DBMS extensions. The starting position can
be adjusted to 0 using the configuration parameter ingres.array_index_start.
Note
Related Configurations
See also the ingres.array_index_start, ingres.fetch_buffer_size and ingres.utf8 directives in Runtime Configuration.
PARAMETERS
o $result
- The query result identifier
RETURN VALUES
Returns an array that corresponds to the fetched row, or FALSE if there are no more rows
EXAMPLES
Example #1
Fetch a row of result into an enumerated array
<?php
$link = ingres_connect($database, $user, $password);
$result = ingres_query($link, "select * from table");
while ($row = ingres_fetch_row($result)) {
echo $row[1];
echo $row[2];
}
?>
SEE ALSO
ingres_num_fields(3), ingres_query(3), ingres_fetch_array(3), ingres_fetch_assoc(3), ingres_fetch_object(3).
PHP Documentation Group INGRES_FETCH_ROW(3)