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

[qwerty1204]

[quote name='Silver_mani' timestamp='1371690257' post='1303872217']
selector lo int value iste run avutundi ,...character iste abort aitundi baa
[/quote]



case0='A'
case1 ='B'

ila isthe abort avthundi aa

[Silver_mani]

[quote name='arey ooo samba' timestamp='1371690361' post='1303872218']



case0='A'
case1 ='B'

ila isthe abort avthundi aa
[/quote]
yup ....
case0=A= link1
case 1=B= link 2 ...idi work avvatle

ila iste work avutundii

case0=1= link1
case 1=2= link 2

[qwerty1204]

[quote name='Silver_mani' timestamp='1371690743' post='1303872222']
yup ....
case0=A= link1
case 1=B= link 2 ...idi work avvatle

ila iste work avutundii

case0=1= link1
case 1=2= link 2
[/quote]

quotes lo ivvu baa..if its a charecter

[Silver_mani]

[quote name='arey ooo samba' timestamp='1371693118' post='1303872283']

quotes lo ivvu baa..if its a charecter
[/quote]
chesanu baa ...work kale

[Manthrii]

[size=4] [/size][size=4] [/size]

[D.V.S.KARNA]

[quote name='pandemkodi' timestamp='1363019140' post='1303403346']
evarikina ee issue vachinda
The array size must be set to 1 so that the connector can process LOB values in oracle connector
nenu already array size 1 ichanu
[/quote]
connecter have that issue.....try to use oracle enterprize stage....it works for me ..long varchar or longbineary fileds cvovert to reg varchar filesd in oracle connecter

[qwerty1204]

XQUERY lo kasta help kavali

naa i/p xml ila untadi

<root>
<abc>
<number>1234</number>
</abc>
<pqr>
<number>5678</number>
</pqr>
</root>

from that I have to get the first occurance of number element value (i.e. 1234)

/root/abc/number/text() ani iche scope ledu...reason being is <abc> anedi keep on changing like someitmes it can be <mnc> etc

and /root//number[1]/text() ani ichina not working (error saying multiple occurances of the <number> element under <root>)

is there a way to get the forst occurance of <number> element?

[qwerty1204]

silver mayya..ekadaa unnavuu

[Silver_mani]

[quote name='arey ooo samba' timestamp='1375894836' post='1304080152']
XQUERY lo kasta help kavali

naa i/p xml ila untadi

<root>
<abc>
<number>1234</number>
</abc>
<pqr>
<number>5678</number>
</pqr>
</root>

from that I have to get the first occurance of number element value (i.e. 1234)

/root/abc/number/text() ani iche scope ledu...reason being is <abc> anedi keep on changing like someitmes it can be <mnc> etc

and /root//number[1]/text() ani ichina not working (error saying multiple occurances of the <number> element under <root>)

is there a way to get the forst occurance of <number> element?
[/quote]
mayya nee job design cheppu okasari

[qwerty1204]

[quote name='Silver_mani' timestamp='1375900157' post='1304080909']
mayya nee job design cheppu okasari
[/quote]


emi ledu baa..indaka chepina xml format table lo oka column lo store chesi untadi DB@ table lo

nenu epudu XQuery use chesi... first occurance of <number> field lo unna data ni extract cheyali baa

[Silver_mani]

[quote name='arey ooo samba' timestamp='1375935692' post='1304083867']


emi ledu baa..indaka chepina xml format table lo oka column lo store chesi untadi DB@ table lo

nenu epudu XQuery use chesi... first occurance of <number> field lo unna data ni extract cheyali baa
[/quote]
repu okasari office lo try chesi chepta baa ....xmf transfromer stage vadali

[qwerty1204]

[quote name='Silver_mani' timestamp='1375935954' post='1304083878']
repu okasari office lo try chesi chepta baa ....xmf transfromer stage vadali
[/quote]

xml transformer aaa ..till now xml i/p or o/p stages ee use cehsanu baa..edi vadaledu eppudu

naaku data already table lo xml column lo undi baa....select sql lo XQUery use chesi cheyachu anukunta baa...correct syntax idea ravadam ledu

[Silver_mani]

[quote name='arey ooo samba' timestamp='1375936567' post='1304083901']
xml transformer aaa ..till now xml i/p or o/p stages ee use cehsanu baa..edi vadaledu eppudu

naaku data already table lo xml column lo undi baa....select sql lo XQUery use chesi cheyachu anukunta baa...correct syntax idea ravadam ledu
[/quote]

baa ...xquery touch ledu ........ xml transformer vadalante xsd for that xml import chekovali first ... nee deggara xsd ledu anukunta kada ...anduke xquery aa ? nuvvu raasina sql okasari post chey ...i will try

[Silver_mani]

[quote name='arey ooo samba' timestamp='1375894836' post='1304080152']
XQUERY lo kasta help kavali

naa i/p xml ila untadi

<root>
<abc>
<number>1234</number>
</abc>
<pqr>
<number>5678</number>
</pqr>
</root>

from that I have to get the first occurance of number element value (i.e. 1234)

/root/abc/number/text() ani iche scope ledu...reason being is <abc> anedi keep on changing like someitmes it can be <mnc> etc

and /root//number[1]/text() ani ichina not working (error saying multiple occurances of the <number> element under <root>)


is there a way to get the forst occurance of <number> element?
[/quote]



mayya i dont think u can do that way ...first nee XML nee tree structure lo ki convert chey .... root has childen abc , pqr etc ....aa childen lo elements vunnayi .... okavela chiclden name conssitent lekapothe dani element ki ela browse chestav query tho ?


Calling dalapathi vuncle for clear explanation

[qwerty1204]

[quote name='Silver_mani' timestamp='1375983988' post='1304088064']



mayya i dont think u can do that way ...first nee XML nee tree structure lo ki convert chey .... root has childen abc , pqr etc ....aa childen lo elements vunnayi .... okavela chiclden name conssitent lekapothe dani element ki ela browse chestav query tho ?


Calling dalapathi vuncle for clear explanation
[/quote]

got it le baa

instead of this /root//number[1]/text()

I gave this: /root//(number)[1]/text()

which gives us the first occurance of the <number> element in the entire document

child name consistent ga leka pothe...we can give like this baa: //(number)[1] which will search into deeper levels.