DSXchange

Sainath.Srinivasan wrote:Look for delimiter String. ...

yes

i just to say
u can create one job just make sequential file to dataset file.

TRIM(COL_A,"0","L") is right, i have tried it.

i think u can do it by transforms stage

ray.wurlod wrote:You can make the target column a VarChar and assemble the string however you like. ...

thanks
i have known the way.
just
trim(decimaltostring(dslink.col),"0","L")

i have the same question,a column is decimal(10,2)
for example:

the data is 12000

output of the sequence file will be 00012000.00

but i need 12000.00

what can i do?
friends.

Hello, I have to parse Spanish Characters in the incoming flat file. We are using RCP with details described in the schema file . Can you please advice how to add NLS properties while describing the String in schema file and the encoding Spanish characters set to used? Thanks in advance i think it'...

hari4dsx wrote:Input field is a decimal (eg. 00012.)..
This is to be converted into integer, with the preceeding zeroes retained.

Does anyone have any solution for this...?


Thanks in advance.

U can try

substr("00000":link.column,-5,5)

ray.wurlod wrote:

chulett wrote:Mmmmm... pie.

(Said in my best Homer Simpson voice)

Nah. It's Weebl! ...

new i have the same question.
and who knnow how to resolve

Delimited with ,

now i have the same question

i can telnet server ,and access teradata by bteq

server env is HP

helphelp

now i have the same question

i can telnet server ,and access teradata by bteq

server env is HP

helphelp