DSXchange

Tried without the TRIM, no change.

Ash I can definitely try that but here is a smple of the output: AddressLineOne, Length "16 PENNY LANE","13" "4-310 13TH AVE S","16" " ","40" " ","40" " ","40" " ","40" " &quo...

Hi Ash

The reason of doing that is because if it encounters a NULL, the TRIM fails. So if there is a NULL, I convert it to space and then trim it.

ashwin141 wrote:Why you are using TRIM function on a Varchar field - do you think it's needed?


Ash

Hi Ash

I am using TRIM because I found spaces in the target sequential file and I wanted to reject those rows.

I have column AddressLineOne (Nullable, Varchar(50)) coming from a Complex Flat File (EBCDIC) and then goes to the transoformer, where I check if the column is NULL or it has spaces only or 0 length. If it does it needs to be rejected, else write to seq file. Here is the condition IF (Len(Trim(NullT...

Hi I have a sequential file that contains the following values: "Col1", "Col2" "1","a" "1","b" "1","c" "2","d" "3","e" "4","f" "4","g" I nee...

So what should be the valid argument in the DecimalToDecimal function?
Thanks

DSguru2B wrote:Can you have input coming in with a valid scale (00010002.2) ?

Dear Mr. Guru To Be I respectfully would like to state that I am no guru but I do know what is scale :D The statement decimal (p, s) with p as precision and s as scale represents a decimal number with up to p digits and s of them will be on the right of the decimal point. I already stated above that...

Can u specify scale in StringToDecimal()? If yes, can u please tell me the complete syntax? Thanks It is because your trying to fit a decimal number into a varchar field. It will not work. You need to do StringToDecimal() to fix the lenth and precision and then use DecimalToString() to convert it ba...

Hi I am have a varchar(50) field: Source Value Example: 00000000000100000. (it has a decimal at the end wihout any digits after the decimal) Needed value at traget: 100000.00 Source and target both need to be varchar(50) data type. I tried to do the folowing: Trim(DecimalToString(DecimalToDecimal(St...

Thanks a lot Craig

DS Plug-In documentation for Oracle OCI Load Stage says: Automatic Mode: "The stage populates the Oracle database immediately after loading the source data." 1-Does "immediately after loading the source data" means that the data is first loaded onto a flat file and then written t...