DSXchange

Any one help in this regard

"YYYY-MM-DD" i need to add one year to this the out put format is same

Eg: 2007-06-09 i need to get 2008-06-08

2007-06-01 then i need 2007-05-31

Pls. tell me any function is there to add one year to a given date

Thanks in advance


Vijay

its a in built routine i am passing 1 as default argument

i have 190 jobs for all i have to modify or any other way .... i heared that one korean characters will stored in two bytes, i our case the call centre people they are copy pasting the descrtiopns in the front ent applications at that time some korean characters are storing half byte only i want to...

use this for current timestamp "DateCurrentDateTime("1")"

i have 190 jobs for all i have to modify or any other way .... i heared that one korean characters will stored in two bytes, i our case the call centre people they are copy pasting the descrtiopns in the front ent applications at that time some korean characters are storing half byte only i want to ...

i wrongly posted in to this forum,
and
1. its an server job
2. i am using NLS enabled datastage
3. if i write it to a flat file it showing last byte as "?"

help me

Hi,

While loading data from Sybase to Oracle/Sql last byte is truncating for the fields having Korean characters what is the problem how to resolve this problem.

Help to resolve this problem...

Hi,

While loading data from Sybase to Oracle/Sql last byte is truncating for the fields having Korean characters what is the problem how to resolve this problem.

Help to resolve this problem...

use this i got same problem

routinename='rtDateTimeStamToOraOCIWithTime'

If Arg1 Then
Ans=Arg1[1,19]
end else
Ans=Arg1
End

use this in one routine and pass the time stap to the target
it will work

in built routines are there to convert and to load oracle check path routines--sdk--date

first load it to sequencial file and then load it to oracle it will work

Any one help me to read byte by byte korean char or tell me how to remove half byte

in job i am getting korean characters as input, actully in front end they are copy pasting the large text to the text box more than size while pressing the enter in two bytes one byte is storing in to the database i want to remove that character, in datastage it showes as ? and database it showing s...