01-03-2008
hi,
Actually i have sql queries and with those queries i want to check the feed files in unix.
so i have the joining condition as:
Column 4 from F1= Column 29 from F2;
Column 10 from F1= Column 165 in F2;
and if value in column 8 from F2='3'
so that i can retrieve the value of column 7(in F2) which i need finally.
now can u help me.?
thanks
10 More Discussions You Might Find Interesting
1. Programming
Hi,
I want to know different ways of suppressing printing of last N lines.
Can anyone help?
Thanks,
Sree (1 Reply)
Discussion started by: chakri400
1 Replies
2. Shell Programming and Scripting
I have this files:
./frm/lf_mt1_cd.Ic_cell_template.attr
./die/addgen_tb_pumd.Ic_cell_template.attr
./min_m1_n.Ic_cell_template.attr
When I use:
awk -F\/ '{print NF}'
Would result to:
3
3
2
I would like to list the files with 3 fields on it. Any Suggestions? (1 Reply)
Discussion started by: jehrome_rando
1 Replies
3. Shell Programming and Scripting
Hi all , i need to grep for a string in a text file and print the string and the 3rd line above it.
As always , Thanks. (4 Replies)
Discussion started by: okiedokie
4 Replies
4. Shell Programming and Scripting
I want to print "Hello,How are you" in green colour using printf. How to do so? (5 Replies)
Discussion started by: proactiveaditya
5 Replies
5. Shell Programming and Scripting
Hi,
We are facing some issues while finding the particular string.
Our file is:
cat 1.txt
Node Name(s)
Preparation fragment
Partition:
Transformation instance:
Transformation:
Applied rows:
Affected rows:
Rejected rows:
Throughput(Rows/Sec):
Throughput(Bytes/Sec):
Last... (3 Replies)
Discussion started by: Amey Joshi
3 Replies
6. Shell Programming and Scripting
Hello all,
I need to print all the lines before a specific string and print a custom message 2 lines after that.
So far I have managed to print everything up the string, inclusively, but I can't figure out how to print the 2 lines after that and the custom message.
My code thus far is:... (4 Replies)
Discussion started by: SEinT
4 Replies
7. Shell Programming and Scripting
Hi,
I need to find the lines which are repeating in a file
cat file1
abcdef 23-1
abcdef 24-1
bcdeff 25-0
ttdcfg 26-0
ttdcfg 20-0
bcdef1 25-0
bcdef2 25-0
bcdef3 25-0
bcdef4 25-0
bcdef4 00-0any help is greatly appreciated. Thanks in advance.
In need to find which one are... (3 Replies)
Discussion started by: jpkumar10
3 Replies
8. Shell Programming and Scripting
Hi !
I need some help with a script I am writing.
I am trying to compare two files, the first file being in this format :
Header1
Text1-1
Text1-2
Text1-3
Header2
Text2-1
etc...
For each header, I want to check if it appears in the second file, and if it is the case print the header... (4 Replies)
Discussion started by: jbi
4 Replies
9. Shell Programming and Scripting
Hello Everyone,
I want to print out the records after and before a certain record. I am able to figure out how to print that particular record but not the ones before and after. Looking for some advice
Thank you (6 Replies)
Discussion started by: danish0909
6 Replies
10. UNIX for Dummies Questions & Answers
Hi,
I have a text file that looks like the following:
ILMN_1343291 6 74341083 74341772
ILMN_1343291 6 74341195 74341099
ILMN_1343295 12 6387581 6387650
ILMN_1651209 1 1657001 1657050
ILMN_1651209 5 83524260 83524309
I... (1 Reply)
Discussion started by: evelibertine
1 Replies
LEARN ABOUT PHP
cubrid_column_names
CUBRID_COLUMN_NAMES(3) 1 CUBRID_COLUMN_NAMES(3)
cubrid_column_names - Get the column names in result
SYNOPSIS
array cubrid_column_names (resource $req_identifier)
DESCRIPTION
The cubrid_column_names(3) function is used to get the column names of the query result by using $req_identifier.
PARAMETERS
o $req_identifier
-Request identifier.
RETURN VALUES
Array of string values containing the column names, when process is successful.
FALSE, when process is unsuccessful.
EXAMPLES
Example #1
cubrid_column_names(3) example
<?php
$conn = cubrid_connect("localhost", 33000, "demodb", "dba");
$result = cubrid_execute($conn, "SELECT * FROM game WHERE host_year=2004 AND nation_code='AUS' AND medal='G'");
$column_names = cubrid_column_names($result);
$column_types = cubrid_column_types($result);
printf("%-30s %-30s %-15s
", "Column Names", "Column Types", "Column Maxlen");
for($i = 0, $size = count($column_names); $i < $size; $i++) {
$column_len = cubrid_field_len($result, $i);
printf("%-30s %-30s %-15s
", $column_names[$i], $column_types[$i], $column_len);
}
cubrid_disconnect($conn);
?>
The above example will output:
Column Names Column Types Column Maxlen
host_year integer 11
event_code integer 11
athlete_code integer 11
stadium_code integer 11
nation_code char 3
medal char 1
game_date date 10
SEE ALSO
cubrid_prepare(3), cubrid_execute(3), cubrid_column_types(3).
PHP Documentation Group CUBRID_COLUMN_NAMES(3)