@@@@calling All Datastage Developers@@@@

[qwerty1204]

[quote name='arey ooo samba' timestamp='1355866166' post='1302975638']
table loo data ila undi

NAME ADDRESS DOB
TOM FREMONT BLVD 10/10/2012
TOM LA BLVD 10/10/2012
REX FOLSOM BLVD 9/9/2012
REX FOLSOM BLVD 9/9/2012


ee above data loo ,....I have to output the NAME who is living in two ADDRESSES

i.e I should TOm as o/p..what should the query look ike?
[/quote]

SELECT NAME FROM SAMPLE_TEST
GROUP BY NAME
HAVING COUNT(DISTINCT ADDRESS) > 1;

ento question nenu adigi ...answer nenu vesukuntunna...DS guyss

[pandemkodi]

[quote name='arey ooo samba' timestamp='1355867896' post='1302975924']

[/quote]
db2 connector lo sql select lo ila rayi mama
select address,name,address from table
qualify row_number() over(partition by name,dob, order by address)>1

[qwerty1204]

[quote name='pandemkodi' timestamp='1355871598' post='1302976386']
db2 connector lo sql select lo ila rayi mama
select address,name,address from table
qualify row_number() over(partition by name,dob, order by address)>1
[/quote]

ee error cmng baa

SQL0104N An unexpected token "row_number" was found

[pandemkodi]

[quote name='arey ooo samba' timestamp='1355872064' post='1302976414']

ee error cmng baa

SQL0104N An unexpected token "row_number" was found
[/quote]
bayya idi teradata lo test chesa
nuvvu em use chestunna database

[qwerty1204]

[quote name='pandemkodi' timestamp='1355872444' post='1302976440']
bayya idi teradata lo test chesa
nuvvu em use chestunna database
[/quote]

DB2 bhayya..but I got that answer..as I posted the query...nuvvu ichina query ento bhayyooo kasta kothagaa undi

[pandemkodi]

[quote name='arey ooo samba' timestamp='1355872547' post='1302976450']

DB2 bhayya..but I got that answer..as I posted the query...nuvvu ichina query ento bhayyooo kasta kothagaa undi
[/quote]
kottaga em ledu bayya just pertitioning chestunnam anthey akkada
row number fn tho anthey

neeku just name kaavala dob and address kuda kaavala result lo

[qwerty1204]

[quote name='pandemkodi' timestamp='1355872767' post='1302976476']
kottaga em ledu bayya just pertitioning chestunnam anthey akkada
row number fn tho anthey

neeku just name kaavala dob and address kuda kaavala result lo
[/quote]

name is enough baa...

SELECT NAME
FROM SAMPLE
GROUP BY NAME
HAVING COUNT( DISTINCT ADDRESS)> 1;


this works for me

[qwerty1204]

[quote name='arey ooo samba' timestamp='1355860602' post='1302974923']
kani naa main doubt adhi kadu bhayyaa..

I have a case where I have two tables having parent child relationship between them

I loaded the the parent table first with 10 records

and then while loading child table..if the job aborts aftes..is there a way i can delete the records in parent table too.??

[color=#ff8c00][b]Can I do all this in a single job? like giving two input links to a single DB2 stage[/b][/color]
[/quote]


edhi ela cheyali loo idea undaa baa

[pandemkodi]

[quote name='arey ooo samba' timestamp='1355873159' post='1302976523']

name is enough baa...

SELECT NAME
FROM SAMPLE
GROUP BY NAME
HAVING COUNT( DISTINCT ADDRESS)> 1;


this works for me
[/quote]
hmm nenu anni kaaali ani ala chesa but nenu ichindi only for TD

[qwerty1204]

[quote name='pandemkodi' timestamp='1355873300' post='1302976539']
hmm nenu anni kaaali ani ala chesa but nenu ichindi only for TD
[/quote]

TeraData ki customer base bagane undaa bhayya..

chala job desc loo chusa tera data EXP adugutha untaruu

[mrudhula99]

[quote name='arey ooo samba' timestamp='1355873282' post='1302976535']


edhi ela cheyali loo idea undaa baa
[/quote]
good job..

nee psot ki nuvvee commenting gaaa

[pavan_613]

[img]http://lh3.ggpht.com/_KVkPY2XIbRQ/TWAgXprYLuI/AAAAAAAABCo/VzL0ae41lc4/brahmi%20laugh.gif[/img]

[mrudhula99]

[quote name='CITI' timestamp='1355876132' post='1302976881']
[img]http://lh3.ggpht.com/_KVkPY2XIbRQ/TWAgXprYLuI/AAAAAAAABCo/VzL0ae41lc4/brahmi%20laugh.gif[/img]
[/quote]

[Market Mastaan]

all jump in godavari..

[pandemkodi]

[quote name='mrudhula99' timestamp='1355875882' post='1302976849']
good job..

nee psot ki nuvvee commenting gaaa
[/quote]
nannu adugutunnadu artham kaaleda