DSXchange

Matthieu, that is exactly the problem i am facing.... how do i fit in a decimal(8,3) in a column declared decimal(7,3) ? to circumvent this problem, i read the input as Varchar(8) to_char(round(input,3)) Now the problem is how to convert this string value to decimal ? In another thread Ray mentioned...

hi,

i will let u know the exact results on Monday.

Thanks a lot
Jay

Hi All, How can i convert a String(1234.567) to Decimal(1234.567) ? Input Column defined as: Varchar(8) Output Column defined as: Decimal(7,3) StringToDecimal(convert(".", "", Link.ColumnName)/1000) gives 1234.000 The decimal part is not coming. Thanks in advance Have a good week...

if compare(CARDHID[1,9], PHSSN) = 0 then they are equal else not equal.

try it.

Hi Matthieu The conversion from Decimal(18,6) to decimal(7,3) is working when the input number=1234.123 But gives a 0000.000 when input number=12345.123456 I try to round(number,3) at source. If i view source, it shows as decimal(38,10), i.e. 0000000000000000000000012345.1234560000 Any idea as to wh...

Hi Matthieu,

What is 'round_inf' doing ?

Thanks
Jay

Thanks Matthew. I'll try it and let you know how it goes.

Hi All This is my problem. Source is Decimal(18,6). Target is Decimal(7,3). So if input is 000000002323.423567 result should be 2323.424. Database: Oracle 8.0 DS version: PX 6.0 I am reading input as Varchar and using field() to extract values. I dont know how far i will be successful this way. This...

Hey All

i ended up with this one-liner...

awk 'length>1' <file_name> | sed -e '/^^/d'

is this ok?

thanks all
j

Hi All,

Thanks for all the replies.

I have been playing around with the 'sed' command. i'll let you know, what i end up with.

Thanks
j

Hi All,

We get flat files which have blank lines at the end of the file. This creates the "Mismatch in number of columns" error.

How to get rid of the lines? Before-job subroutine calling a shell script?
Can i get some ideas as to how to write the script?

Thanks in advance
J

hey chulett,

got it...thanks...

jay

gotcha. thanks.lemme work on it.

Hi All,

Has anyone done a conversion from an internal date format to Julian Day format?

If yes, please let me know.

Thanks in advance,
Jay

I had this problem in the last project. Sometimes what happens is that if you abort or rename the job and some thing happens(i dont exactly know what), the job in UV remains like a dangling pointer. So you have to go to the UV shell (normally the dsadmin will have access to this dir) and find out th...