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

[pandemkodi]

[color=#000000][font=Verdana, Arial, Helvetica, sans-serif][size=3][left]to get the different beteween two dates you can use the Iconv function [/left][/size][/font][/color]

[color=#000000][font=Verdana, Arial, Helvetica, sans-serif][size=3][left]Iconv(DataEnd, "D/E") - Iconv(DataStart, "D/E")[/left][/size][/font][/color]



[color=#000000][font=Verdana, Arial, Helvetica, sans-serif][size=3][left]copy from dsx[/left][/size][/font][/color]

[Silver_mani]

[quote name='pandemkodi' timestamp='1335463986' post='1301692259']
[left]to get the different beteween two dates you can use the Iconv function[/left]


[left][color=#000000][font=Verdana, Arial, Helvetica, sans-serif][size=3]Iconv(DataEnd, "D/E") - Iconv(DataStart, "D/E")[/size][/font][/color][/left]




[left][color=#000000][font=Verdana, Arial, Helvetica, sans-serif][size=3]copy from dsx[/size][/font][/color][/left]

[/quote]


Iconv,Oconv parallel lo vundavu kada baa

[pandemkodi]

[quote name='Silver_mani' timestamp='1335490155' post='1301695054']


Iconv,Oconv parallel lo vundavu kada baa
[/quote]
yup

[Silver_mani]

Nenu SQL lo raaskunna kaka .....! datediff(datepart,date1,date2 ) .It works [img]http://lh6.ggpht.com/-S06hy4eXSHo/T4r_4iTFEwI/AAAAAAAAGUI/qgaGkUYuBh8/s150/PK.gif[/img]....Data stage lo kudaraledu ...evarikaina vsaste cheppandi

[pandemkodi]

[quote name='Silver_mani' timestamp='1335490644' post='1301695087']
Nenu SQL lo raaskunna kaka .....! datediff(datepart,date1,date2 ) .It works [img]http://lh6.ggpht.com/-S06hy4eXSHo/T4r_4iTFEwI/AAAAAAAAGUI/qgaGkUYuBh8/s150/PK.gif[/img]
[/quote]
sql lo work avvudhi mama
but particular ga tool use chesi cheyyalantey

[Silver_mani]

[quote name='pandemkodi' timestamp='1335490711' post='1301695090']
sql lo work avvudhi mama
but particular ga tool use chesi cheyyalantey
[/quote]


emo mama ...datastage lo konni try chesina ...raledu ... lite teeskunna ..... free time vunnappudu malli try cheyyali [img]http://lh6.ggpht.com/-S06hy4eXSHo/T4r_4iTFEwI/AAAAAAAAGUI/qgaGkUYuBh8/s150/PK.gif[/img]

[pandemkodi]

babulu help kaavali

flat file lo evary row end ki control M char vastondi daanni ela remove cheyyali cheppandi plz
konchem urgent

dsxchange try chesa but avi workout avvtley

[qwerty1204]

[quote name='pandemkodi' timestamp='1336153607' post='1301739084']
babulu help kaavali

flat file lo evary row end ki control M char vastondi daanni ela remove cheyyali cheppandi plz
konchem urgent

dsxchange try chesa but avi workout avvtley
[/quote]

COnvert function use chesi cheyachi emo chudu baa...aa control M symbol corresponding ASCII value tho convet function use cheyii like this

Convert(char(number),"", input_column_name)

[pandemkodi]

[quote name='arey ooo samba' timestamp='1336153902' post='1301739112']

COnvert function use chesi cheyachi emo chudu baa...aa control M symbol corresponding ASCII value tho convet function use cheyii like this

Convert(char(number),"", input_column_name)
[/quote]
aa number entio baa control M vachey place aa

[qwerty1204]

[quote name='pandemkodi' timestamp='1336154131' post='1301739128']
aa number entio baa control M vachey place aa
[/quote]

try 13 in that number place baa

[url="http://www.unix-manuals.com/refs/misc/ascii-table.html"]http://www.unix-manuals.com/refs/misc/ascii-table.html[/url]

look into this link..might be helpful

[pandemkodi]

[quote name='arey ooo samba' timestamp='1336155252' post='1301739199']

try 13 in that number place baa

[url="http://www.unix-manuals.com/refs/misc/ascii-table.html"]http://www.unix-manu...scii-table.html[/url]

look into this link..might be helpful
[/quote]
thanks baa i will try this

[pandemkodi]

[quote name='pandemkodi' timestamp='1336156242' post='1301739279']
thanks baa i will try this
[/quote]
mma nit working mama oka file lo konni control M vunnai

konni records ki levu

[RE8EL]

Vachesa.....koncham late ayindi guys...office lo heavy traffic....

(null)

[dalapathi]

[quote name='pandemkodi' timestamp='1336153607' post='1301739084']
babulu help kaavali

flat file lo evary row end ki control M char vastondi daanni ela remove cheyyali cheppandi plz
konchem urgent

dsxchange try chesa but avi workout avvtley
[/quote]
control M antye endho teliyadhu akanie........okasaari extra line vasthuntey....idhi vaadinaa.........idhi okasaari ichi chuudu.....

convert(char(9):char(10):char(13),'',InputColoumn)

so, induloo may be ee muditlo edho okati vaadalanukuntaa.........char 9 ooh 10 ooh 13 ooh......

[pandemkodi]

[quote name='dalapathi' timestamp='1336159430' post='1301739660']
control M antye endho teliyadhu akanie........okasaari extra line vasthuntey....idhi vaadinaa.........idhi okasaari ichi chuudu.....

convert(char(9):char(10):char(13),'',InputColoumn)

so, induloo may be ee muditlo edho okati vaadalanukuntaa.........char 9 ooh 10 ooh 13 ooh......
[/quote]
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