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

[pandemkodi]

[quote name='Silver_mani' timestamp='1365636753' post='1303580662']
nasty vuncle ..........................nee field lo null values vunnayi ani cheptundi
[/quote]
chesa ley mama ...indaka frustration peaks velli vesa ipoindi ley

[Silver_mani]

[quote name='pandemkodi' timestamp='1365636819' post='1303580664']
chesa ley mama ...indaka frustration peaks velli vesa ipoindi ley
[/quote]
nulls vunnay kada ? warning adena ?inka vere emaina issue naa ??

[pandemkodi]

[quote name='Silver_mani' timestamp='1365636964' post='1303580676']
nulls vunnay kada ? warning adena ?inka vere emaina issue naa ??
[/quote]
nulls ni handle cheyyala maama seq file teeskoduga nulls
so just format lo nullfieldvalue=' ' icha set indi

[Silver_mani]

[quote name='pandemkodi' timestamp='1365637394' post='1303580710']
nulls ni handle cheyyala maama seq file teeskoduga nulls
so just format lo nullfieldvalue=' ' icha set indi
[/quote]
ok

[qwerty1204]

Naaku incoming xml ila untadi

<esal:ESALDATA>

<ESAL>
<UsrID>1</UsrID>
<Screen>a</Screen>
</ESAL>

<ESAL>
<UsrID>2</UsrID>
<Screen>b</Screen>
</ESAL>

<ESAL>
<UsrID>3</UsrID>
<Screen>c</Screen>
</ESAL>

</esal:ESALDATA>

aa xml lo nunchi for every <ESAL> tag, I have to retrieve one record out of it and load it into a database

so naa o/p record layout ila ravali...how to do it in xml i/p stage

USER_ID SCREEN
1 a
2 b
3 c

[sujithrede]

oka doubt help plz..

input data


ID name date
1 xyz 10/11
1 ---- 10/12
1 daa --

output
id name date name1 date1 name2 date2
1 xyz 10/11 -- 10/12 daa ---

pivot use cheyocha? etla chestaru koncham cheppandi

[Manthrii]

[quote name='raasaleelalu' timestamp='1366397605' post='1303634881']
oka doubt help plz..

input data


ID name date
1 xyz 10/11
1 ---- 10/12
1 daa --

output
id name date name1 date1 name2 date2
1 xyz 10/11 -- 10/12 daa ---

pivot use cheyocha? etla chestaru koncham cheppandi
[/quote]
out put lo enni extra columns ravalo thelvadhu kabatti RCP vadalanukunta...
sort stage lo same id unna rows lo unique identity ichi.. next a identity unnavi pivot stage cheyyu

[gangster_rap]

anyone know how to fix issue..dsdseq unable to open file when running a job?

[Manthrii]

[quote name='Baava' timestamp='1366408697' post='1303636228']
anyone know how to fix issue..dsdseq unable to open file when running a job?
[/quote]
sequential stage lo file open avvatledha? [size=4] [/size]

[pandemkodi]

file permissions choodu

[gangster_rap]

[quote name='Manthrii' timestamp='1366408944' post='1303636251']
sequential stage lo file open avvatledha?
[/quote]
adi seq file bro..sometimes ok.but konni sarlu ila error ostundi

[gangster_rap]

[quote name='pandemkodi' timestamp='1366409134' post='1303636267']
file permissions choodu
[/quote]
appudappudu fail avtundi bro job

[pandemkodi]

[quote name='Baava' timestamp='1366409287' post='1303636287']
appudappudu fail avtundi bro job
[/quote]
adenti emantondi eeror enti

[Manthrii]

[quote name='Baava' timestamp='1366409287' post='1303636287']
appudappudu fail avtundi bro job
[/quote]
may be data lo edhaina problem undhemo chudakapoyava bhayya..

[gangster_rap]

[quote name='pandemkodi' timestamp='1366409790' post='1303636331']
adenti emantondi eeror enti
[/quote]
dsd.seqopen unable to open file<filename> in <dir>----idi exact error