Writing output to a file in columns Post: 302933928

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Writing output into different files while processing file using AWK

Hi, I am trying to do the following using AWK program. 1. Read the input data file 2. Parse the record and see if it contains errors 3. If the record contains errors, then write it into Reject file, else, write into usual output file or display it on the screen Here is what I have done -...

2. Shell Programming and Scripting

writing the output of SQL into one file

Hi All, Please help me writing the below script. I have two sql queries. 1. Select count(1),Client_id from TABLE_A group by Client_id; 2. Select count(1),Client_id from TABLE_B group by Client_id; I need the output of above two sql queries in a single file. The output 2nd query should be...

3. Shell Programming and Scripting

Writing only timing statistics output of Timer to File

I'm running long integrations on a remote server, and I'm working in terminal in a tcsh shell. I'm looking to write ONLY the timing statistics to a file. For example: $time ls >timer.out writes both the files in my current directory & the timer statistics to the file timer.out. I only...

4. UNIX for Dummies Questions & Answers

Writing a script that will take the first line from each file and store it in an output file

Hi, I have 1000 files names data1.txt through data1000.txt inside a folder. I want to write a script that will take each first line from the files and write them as output into a new file. How do I go about doing that? Thanks!

5. Shell Programming and Scripting

validating data in columns and writing them to new file

I have a file that contains records in the below format: 23857250998423948239482348239580923682396829682398094823049823948 23492780582305829852095820958293582093585823095892386293583203248 23482038509825098230958235234230502958205983958235820358205892095...

6. Shell Programming and Scripting

Cat writing only one record in the output file

Hi All, I have an input file containing data as below: Input.DAT XXXXXXX|YYYYYYY|ZZZZZZZZZZ|12334446456|B|YY|111111111|111111111|111111111|111111111|15|3|NNNNNN|Y|3|AAA|111111111...

7. Shell Programming and Scripting

Comparing Columns and writing a new file

I have a table with one column File1.txt 1 2 3 4 5 6 7 8 9 10 Another table with two columns; This has got a subset of entries from File 1 but not unique because they have differing values in col 2. File2.txt 1 a 2 d 2 f 6 r 6 e

8. Shell Programming and Scripting

Getting output with sed without writing to a file

HI I am trying to grep 3 characters from hostname and append a character at the end. I tried as in the following: root@abag3:~# hostname | cut -c1-3 hyu Now I am trying to append "g" at the end of this output as in the following. root@abag3:~# hostname | cut -c1-3 | sed -s...

9. Shell Programming and Scripting

Wrong output when writing to file

Hello, I am having problem while redirecting output to a file where as on console output is proper. for dir in */; do printf "%s, " "$dir"; ls -m "$dir"; echo; done > output.txt Output of above command is coming in single line but when i am redirecting output to a file, single line i...

LEARN ABOUT PHP

ingres_fetch_assoc

INGRES_FETCH_ASSOC(3)							 1						     INGRES_FETCH_ASSOC(3)

ingres_fetch_assoc - Fetch a row of result into an associative array

SYNOPSIS

       array ingres_fetch_assoc (resource  $result)

DESCRIPTION

	This  function	is  stores  the data fetched from a query executed using ingres_query(3) in an associative array, using the field names as
       keys.

	With regard to speed, the function is identical to ingres_fetch_object(3), and almost as quick as ingres_fetch_row(3) (the  difference	is
       insignificant).

	By  default,  arrays created by ingres_fetch_assoc(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 associative array that corresponds to the fetched row, or FALSE if there are no more rows

EXAMPLES

       Example #1

	      Fetch a row into an associative array

	      <?php
	      $link = ingres_connect($database, $user, $password);

	      $result = ingres_query($link,"select * from table");
	      while ($row = ingres_fetch_assoc($result)) {
		  echo $row["user_id"];  // using associative array
		  echo $row["fullname"];
	      }
	      ?>

SEE ALSO

       ingres_query(3), ingres_num_fields(3), ingres_field_name(3), ingres_fetch_array(3), ingres_fetch_object(3), ingres_fetch_row(3).

PHP Documentation Group 												     INGRES_FETCH_ASSOC(3)