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

[dalapathi]

[quote name='pandemkodi' timestamp='1336160429' post='1301739770']
nenu ippudu char(13) use chesa mama but not working adi

actual gaa nenu

string to decimal marchaley oka str ni so adi target lo zeros istondi
endukantey daani tarvata control M char vunnai
so naaku control M remove kaavaaley
konni rows ki control M ledu malli
[/quote]
emo....ee control M gurinchi asalu idea ledhu.........aah thread lo google2011 cheppindhi workout kaaledaa.....???

[pandemkodi]

actual gaa seq file lo record delimiter string= DOS format ani istey ^m perfect remove chestondi and o/p kuda ok
but naa source lo two types vunnai with control M and without so job aborting

[pandemkodi]

[quote name='dalapathi' timestamp='1336160589' post='1301739781']
emo....ee control M gurinchi asalu idea ledhu.........aah thread lo google2011 cheppindhi workout kaaledaa.....???
[/quote]
yaa adi workout indi unix lo ivvala manipulate chesam but automate cheyyali kada so ds lo workout avvuddemo nani choostunna mama

control M anedi DOs format lo line terminantion mama

[dalapathi]

[quote name='pandemkodi' timestamp='1336160661' post='1301739787']
yaa adi workout indi unix lo ivvala manipulate chesam but automate cheyyali kada so ds lo workout avvuddemo nani choostunna mama

control M anedi DOs format lo line terminantion mama
[/quote]
ooh......ok

[Silver_mani]

[quote name='pandemkodi' timestamp='1336160429' post='1301739770']
nenu ippudu char(13) use chesa mama but not working adi

actual gaa nenu

string to decimal marchaley oka str ni so adi target lo zeros istondi
endukantey daani tarvata control M char vunnai
so naaku control M remove kaavaaley
konni rows ki control M ledu malli
[/quote]


aa zeros povadaniki fix zero ivvali ..

eg:
string to decimal ("input column", " fix zero")

[pandemkodi]

mams
naa source seq file --->tx--->seq file

source lo okatey col and daanlo okatey value NULL

so nenu TX lo if isnull(col) then nulltoval(col,current date()) else col ani icha but adi target loki still null istondi mama
em cheyyali

[pandemkodi]

"**********" o/p from seq file

[pandemkodi]

inko case kuda test chesa

rowgen--->TX--->seq

date column teeskoni daanni tx lo ee function raasa
if (isnull(col) or len(col)>10) then '2000-01-31' else NullToValue(col,'9999-09-23')

idi actual gaa output emi ivvali 9999-09-23 ivvali but idi colgen generate chisina values istondi

o/p
date,length

"1960-01-02","10"
"1960-01-04","10"
"1960-01-06","10"
"1960-01-08","10"
"1960-01-10","10"
"1960-01-12","10"
"1960-01-14","10"
"1960-01-16","10"
"1960-01-18","10"
"1960-01-20","10"
"1960-01-22","10"
"1960-01-24","10"
"1960-01-26","10"
"1960-01-28","10"
"1960-01-30","10"
"1960-02-01","10"
"1960-02-03","10"
"1960-02-05","10"
"1960-01-01","10"
"1960-01-03","10"
"1960-01-05","10"
"1960-01-07","10"
"1960-01-09","10"
"1960-01-11","10"
"1960-01-13","10"
"1960-01-15","10"
"1960-01-17","10"
"1960-01-19","10"
"1960-01-21","10"
"1960-01-23","10"
"1960-01-25","10"
"1960-01-27","10"
"1960-01-29","10"
"1960-01-31","10"
"1960-02-02","10"
"1960-02-04","10"

[pandemkodi]

yelp

[Silver_mani]

[quote name='pandemkodi' timestamp='1338330198' post='1301879872']
inko case kuda test chesa

rowgen--->TX--->seq

date column teeskoni daanni tx lo ee function raasa
if [b](isnull(col) or len(col)>10)[/b] then '2000-01-31' else NullToValue(col,'9999-09-23')

idi actual gaa output emi ivvali 9999-09-23 ivvali but idi colgen generate chisina values istondi

o/p
date,length

"1960-01-02","10"
"1960-01-04","10"
"1960-01-06","10"
"1960-01-08","10"
"1960-01-10","10"
"1960-01-12","10"
"1960-01-14","10"
"1960-01-16","10"
"1960-01-18","10"
"1960-01-20","10"
"1960-01-22","10"
"1960-01-24","10"
"1960-01-26","10"
"1960-01-28","10"
"1960-01-30","10"
"1960-02-01","10"
"1960-02-03","10"
"1960-02-05","10"
"1960-01-01","10"
"1960-01-03","10"
"1960-01-05","10"
"1960-01-07","10"
"1960-01-09","10"
"1960-01-11","10"
"1960-01-13","10"
"1960-01-15","10"
"1960-01-17","10"
"1960-01-19","10"
"1960-01-21","10"
"1960-01-23","10"
"1960-01-25","10"
"1960-01-27","10"
"1960-01-29","10"
"1960-01-31","10"
"1960-02-02","10"
"1960-02-04","10"
[/quote]

mama nee nee condition tappu ...akkada contrasting values icchav chudu .... isnull values 2 times ichav

[Silver_mani]

[color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]if[/background][/size][/font][/color][b] len(col) >10[/b][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)] then '2000-01-31' else if isnull(col) then NullToValue(col,'9999-09-23')[/background][/size][/font][/color]

[pandemkodi]

[quote name='Silver_mani' timestamp='1338357857' post='1301881232']


mama nee nee condition tappu ...akkada contrasting values icchav chudu .... isnull values 2 times ichav
[/quote]
Ala ivvochu mama
Every job alaney null handling chestan

[pandemkodi]

nenu condition tappu raasa

if isnull(0col) or len(col)<1 then condi else another cond
but naaku o/p wrong vastondi

[Silver_mani]

[quote name='pandemkodi' timestamp='1338358565' post='1301881244']
Ala ivvochu mama
Every job alaney null handling chestan
[/quote]


naaku artham kaale mama .... null aithe either ee value [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]'2000-01-31' ichav ....ledante ee value ichav [/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][background=rgb(240, 244, 247)]NullToValue(col,'9999-09-23')....rendu ela istav ?[/background][/font][/color]

[pandemkodi]

[quote name='Silver_mani' timestamp='1338358788' post='1301881254']


naaku artham kaale mama .... null aithe either ee value [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]'2000-01-31' ichav ....ledante ee value ichav [/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][background=rgb(240, 244, 247)]NullToValue(col,'9999-09-23')....rendu ela istav ?[/background][/font][/color]
[/quote]
correctey

null ithey ney nulltoval kada

marchipoya
naa mind dobbesindi

repu malli try cheta
thanks mama