01-14-2009
the output of the sql is:
D|44083669|0192652286|10866|1
D|44083455|0192300318|10867|1
and the utput of the THS_PROF.txt is:
SQL>
SQL> select 'D'||'|'||ciam.external_id||'|'||ciem.external_id||'|'||p.element_id||'|'||
2 case when (p.element_id in (select b.member_id from package_component_members b, package_components c
3 where member_id in (10867,10866,10866,10867,10868,10866,10866,90014,90021)
4 and b.member_type=1
5 and b.component_id in (10459,10458,10658,20105,10499,10647,10810,90014,90022)
6 and c.component_id=b.component_id)) then '1'
7 end "A"
8 from customer_id_acct_map ciam, customer_id_equip_map ciem, product p, cmf c, dual
9 where ciam.account_no=p.billing_account_no
10 and ciem.subscr_no=p.parent_subscr_no
11 and p.billing_account_no=c.account_no
12 and c.account_no=ciam.account_no
13 and c.bill_period='G08'
14 and ciem.external_id_type=1
15 and ciam.external_id_type=1
16 and ciem.external_id_type=ciam.external_id_type
17 and p.element_id in (select b.member_id from package_component_members b, package_components c
18 where member_id in (10867,10866,10866,10867,10868,10866,10866,90014,90021)
19 and b.member_type=1
20 and b.component_id in (10459,10458,10658,20105,10499,10647,10810,90014,90022)
21 and c.component_id=b.component_id);
D|44083669|0192652286|10866|1
D|44083455|0192300318|10867|1
SQL>
SQL> spool off;
But i dont want THS_PROF.txt to be created jus 2 files corresponds to 2 rows of the query.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi
I am trying to add count values from two different files into one file. Could any body please suggest me best command to do this? My problem was as follows:
a.txt b.txt c.txt
10 20 30(needed)
i tried cat a.txt b.txt > c.txt (its not adding the values)
Thanks in advance..
Praveen (8 Replies)
Discussion started by: npk2210
8 Replies
2. Shell Programming and Scripting
I have results from some statistical analyses.
The format of the results are as given below:
I want to select lines that have a p-value (last column) less than 0.05 from all the results files (*.results) and cat to a new results file.
It would be very nice if a new column is added that tells... (2 Replies)
Discussion started by: genehunter
2 Replies
3. Shell Programming and Scripting
Hello ALL,
Hope all fine for you.
I have the following task but no idea about how to do.
I have 2 files (ascii)
one of them is a list of bib records, looks like this:
=LDR 01228nam 2200301 b 4500
=001 00000000000001
=005 20090429:10082000
=008 ... (2 Replies)
Discussion started by: ldiaz2106
2 Replies
4. Shell Programming and Scripting
- I have two files (File 1 and File 2) and the contents of the files are mentioned below.
- I am trying to compare the values of Column1 of File1 with Column1 of File2. If a match is found, print the corresponding value from Column2 of File1 in Column5 of File2.
- I tried to modify and use... (10 Replies)
Discussion started by: Santoshbn
10 Replies
5. Shell Programming and Scripting
One of my process will create a file Market.txt with data like below.
Count Markt file
334936 /pdm/data001/P3_Quest_5HT_AMERGE.csv
2770787 /pdm/data001/P3_Quest_ARB_ATACAND.csv
1198143 /pdm/data001/P3_Quest_Bisp_ACTONEL.csv
3821864 /pdm/data001/P3_Quest_CONTRA_ALL_OTHER_CONTRA.csv... (7 Replies)
Discussion started by: katakamvivek
7 Replies
6. Shell Programming and Scripting
Hi, I have two files
cat 1
100 1
110 2
113 4
230 5
334 7
500 8
900 10
I have another file
cat 2
100 200
201 300
301 400
401 500
501 600
601 700 (3 Replies)
Discussion started by: jacobs.smith
3 Replies
7. Shell Programming and Scripting
Hi,
I need a shell script, which would search the result values from another files.
1)execute " select column1 from table_name" query on the table.
2)Based on the result, need to be grep from .wft files.
could please explain about this.Below is the way i am using.
#!/bin/sh... (4 Replies)
Discussion started by: Rami Reddy
4 Replies
8. Shell Programming and Scripting
Hi
Am trying to compare the values of two files..
One is a big file that has many values and the other is a small file..
The big file has all values present in small file..
# cat SmallFile
4456602 22347881
7471282 15859891
8257690 21954701
7078068 18219229
2883826 6094959
100000
... (3 Replies)
Discussion started by: Priya Amaresh
3 Replies
9. Shell Programming and Scripting
Dear All,
I have two files which contain numerical data and strings. I want to create a new file that only revise numerical data from two files using interpolation. I guess AWK works, but I am new on AWK.
FileA.txt
.
.
index_2("0.1, 1, 2, 4, 8, 16, 32");
values("0.0330208, 0.0345557,... (17 Replies)
Discussion started by: jypark22
17 Replies
10. UNIX for Beginners Questions & Answers
I have two directories of files (new-config-files and old-config-files):
new-config-files/this-db/config.inc.php
new-config-files/that-db/config.inc.php
new-config-files/old-db/config.inc.php
new-config-files/new-db/config.inc.php
new-config-files/random-database/config.inc.php
etc.
... (4 Replies)
Discussion started by: spacegoose
4 Replies
LEARN ABOUT PHP
ibase_execute
IBASE_EXECUTE(3) 1 IBASE_EXECUTE(3)
ibase_execute - Execute a previously prepared query
SYNOPSIS
resource ibase_execute (resource $query, [mixed $bind_arg], [mixed $...])
DESCRIPTION
Execute a query prepared by ibase_prepare(3).
This is a lot more effective than using ibase_query(3) if you are repeating a same kind of query several times with only some parameters
changing.
PARAMETERS
o $query
- An InterBase query prepared by ibase_prepare(3).
o $bind_arg
-
o $...
-
RETURN VALUES
If the query raises an error, returns FALSE. If it is successful and there is a (possibly empty) result set (such as with a SELECT query),
returns a result identifier. If the query was successful and there were no results, returns TRUE.
Note
This function returns the number of rows affected by the query (if > 0 and applicable to the statement type). A query that suc-
ceeded, but did not affect any rows (e.g. an UPDATE of a non-existent record) will return TRUE.
EXAMPLES
Example #1
ibase_execute(3) example
<?php
$dbh = ibase_connect($host, $username, $password);
$updates = array(
1 => 'Eric',
5 => 'Filip',
7 => 'Larry'
);
$query = ibase_prepare($dbh, "UPDATE FOO SET BAR = ? WHERE BAZ = ?");
foreach ($updates as $baz => $bar) {
ibase_execute($query, $bar, $baz);
}
?>
SEE ALSO
ibase_query(3).
PHP Documentation Group IBASE_EXECUTE(3)