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

[nandamuribidda]

April 2010.

[pandemkodi]

if Isnull(Lnk_Input)
then setnull() else Convert('"','',Lnk_Input)

idi em chestadi mama

[pandemkodi]

cheppandi bayya old jobs choostuntey vundi oka daanlo

[nandamuribidda]

0 vachhina comma vachhina lnk_input ni place chestundi null vaste set null chestundi.

[nandamuribidda]

correste naa.

[BhagatSingh]

[quote name='nandamuribidda' timestamp='1333752512' post='1301608378']
correste naa.
[/quote]


thelvadhu bhayya

[pandemkodi]

[quote name='nandamuribidda' timestamp='1333752512' post='1301608378']
correste naa.
[/quote]
telvadu mama old jobs choostuntey kanpichindi so naaku artham kaala vesa ikkada

nuvvu cheppindi artham kaala mama

[nandamuribidda]

Adenti ala antaav

if Isnull(Lnk_Input) then setnull()
else
Convert('"','',Lnk_Input)

comma kaadu 0 vaste input column ivvu ani kada and source null vunte set null cheyyi anni.

if i am not wrong this requirement is very specific to the database software used not with Datastage

[pandemkodi]

[quote name='nandamuribidda' timestamp='1333752940' post='1301608388']
Adenti ala antaav

if Isnull(Lnk_Input) then setnull()
else
[b]Convert('"','',Lnk_Input)[/b]

comma kaadu 0 vaste input column ivvu ani kada and source null vunte set null cheyyi anni.

if i am not wrong this requirement is very specific to the database software used not with Datastage
[/quote]
mama naaku just convert function artham kaala annanu anthey
daani pidi telusu mama

[nandamuribidda]

correction bava. i misread it convert function choodaledu.

[nandamuribidda]

Convert Converts specified characters in a string to designated replacement characters fromlist (string)
tolist (string)
<a name="wp378806__wp379147">expression (string) result (string)


http://publib.boulder.ibm.com/infocenter/iisinfsv/v8r0/index.jsp?topic=/com.ibm.swg.im.iis.ft.usage.doc/topics/r_deeref_String_Functions.html

[BhagatSingh]

[quote name='nandamuribidda' timestamp='1333754784' post='1301608417']
Convert Converts specified characters in a string to designated replacement characters fromlist (string)
tolist (string)
<a name="wp378806__wp379147">expression (string) result (string)


[url="http://publib.boulder.ibm.com/infocenter/iisinfsv/v8r0/index.jsp?topic=/com.ibm.swg.im.iis.ft.usage.doc/topics/r_deeref_String_Functions.html"]http://publib.boulde..._Functions.html[/url]
[/quote]

ednharo developers kondharikey vachhu coding [img]http://www.gifsoup.com/view1/1900845/prabhas-o.gif[/img]

[dalapathi]

[quote name='pandemkodi' timestamp='1333754369' post='1301608405']
mama naaku just convert function artham kaala annanu anthey
daani pidi telusu mama
[/quote]
oka vela adhi null ayithey Database loni table lo null ani raayamantunanadu......null kaakapothey..........etla vunandhi atlaney raayamantunnaadu.......aslau aah convert endhuku vaadindoo......

general gaa convert function ni itla vaaduhtaaru........

convert("/","-",columnname ) ani antey aah data lo '/' lu vunna chota '-' lu pettamani.......

kaanie paina aah func. use chesinodu.....dennie replace cheyyatlehdu..........endhuku pettidoo telidhu.....

[dalapathi]

[quote name='arey ooo samba' timestamp='1333751376' post='1301608340']



nandamuribidda mazakkaa...baa ika ee thread loo nuvvu chupinchali nee thadakaa

ayna ee thread lo ki ivaala reply ichadu kada ani..junior annanu lee baa

eppati nunchi wrkng baa
[/quote]
naa thadaakaa naa

[dalapathi]

[quote name='nandamuribidda' timestamp='1333751856' post='1301608351']
April 2010.
[/quote]
JPMC aah.......???