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 DEBIAN
po_createref
PO_CREATEREF(1) PO_CREATEREF(1)
NAME
po_createref - create IOR stringified references
SYNOPSIS
po_createref -t type_id -pn profile_nb profile_description
DESCRIPTION
po_createref(1) is an utility to create specific IOR stringified references (CORBA IOR, corbaloc or URI). The reference's components and
associated configuration parameters can be specified by using the command line switches of po_createref(1) (see section OPTIONS).
OPTIONS
GIOP/IIOP profile
-pt iiop -i index -g -cr father_poa -vmj Major -vmn Minor -a Inet_Address -p Port -cn Components_Number {-ct component_id component ce}
pe
Policies component
policies -pol_nb policies_number {-model SERVER_DECLARED|CLIENT -priority value}
Code_Sets component
-char code_set -s supported_number {code_set}-wchar code_set -s supported_number {code_set}
SSL component
ssl_trans -requires value -supports value -p port_number
Alternate Address component
alternate_address -a inet_address -p port_number
AUTHOR
This manual page was written by Reto Buerki <reet@codelabs.ch> for the Debian GNU/Linux system (but may be used by others).
RESOURCES
Polyorb User Manual: http://www.adacore.com/wp-content/files/auto_update/polyorb-docs/polyorb_ug.html/
SEE ALSO
po_catref(1).
05/21/2009 PO_CREATEREF(1)