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

[Silver_mani]

[quote name='arey ooo samba' timestamp='1375987451' post='1304088377']

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.
[/quote]
gp baa .......... ye db lo raastunnavu xquery ??

[gangster_rap]

Ee dev oka mystery naku

[mettastar]

[quote name='arey ooo samba' timestamp='1375987451' post='1304088377']

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.
[/quote]
good info..

[Silver_mani]

[quote name='Baava' timestamp='1375988761' post='1304088523']
Ee dev oka mystery naku
[/quote]
just learn man

[qwerty1204]

[quote name='Silver_mani' timestamp='1375988524' post='1304088490']
gp baa .......... ye db lo raastunnavu xquery ??
[/quote]

DB2 Database baa

[Silver_mani]

[quote name='arey ooo samba' timestamp='1375993035' post='1304089059']
DB2 Database baa
[/quote]



xquery
for $y in db2-fn:xmlcolumn('tablename.columname')/root
where $y=/root//(number)[1]/text()
return $y



anthe kada baa ??

[qwerty1204]

[quote name='Silver_mani' timestamp='1375993232' post='1304089090']
xquery
for $y in db2-fn:xmlcolumn('tablename.columname')/root
where $y=/root//(number)[1]/text()
return $y



anthe kada baa ??
[/quote]


nenu XML TABLE ani okati untadu baa..adhi aite enni fields ayna tevachu from a XML column

like this

SELECT
SAMPLE_XML.NUMBER,
SAMPLE_XML.ID,

FROM Table1 t1,
XMLTABLE('$docum/*:batch/*:transaction' passing t1.DOCUM_XML as "docum"
COLUMNS
NUMBER VARCHAR(20) PATH '//(number)[1]/text()',
ID VARCHAR(20) PATH '//(ID)[1]/text()'
) AS SAMPLE_XML

nuvvu chepindi may be a simple XQuery which retrives one field value from a xml anukunta

[Silver_mani]

[quote name='arey ooo samba' timestamp='1375995611' post='1304089362']


nenu XML TABLE ani okati untadu baa..adhi aite enni fields ayna tevachu from a XML column

like this

SELECT
SAMPLE_XML.NUMBER,
SAMPLE_XML.ID,

FROM Table1 t1,
XMLTABLE('$docum/*:batch/*:transaction' passing t1.DOCUM_XML as "docum"
COLUMNS
NUMBER VARCHAR(20) PATH '//(number)[1]/text()',
ID VARCHAR(20) PATH '//(ID)[1]/text()'
) AS SAMPLE_XML

nuvvu chepindi may be a simple XQuery which retrives one field value from a xml anukunta
[/quote]

got it baa

[soldier]

help me..any one know datastage positions

[yo12]

Meelo yavarikaina Metadata workbench idea vundha ?

data lineage report generate cheyali

[candycrush]

hi. naku urgent ga datastage female ***** kavali. please meeku evaraina teliste chepthara ?

[Silver_mani]

Anyone Using 9.1 ???

[yo12]

8.7 use chesthuna....
9.1 ayithai ledhu ...

any specific question ?

[yo12]

metadata workbench loo datalineage report run cheyali any ideas / suggestions / trainers ?

[Silver_mani]

[quote name='yo12' timestamp='1381987734' post='1304426815']
8.7 use chesthuna....
9.1 ayithai ledhu ...

any specific question ?
[/quote]

kotta options vunnayi kada ...ela vundi ani