Kumar, doing a "LEN(<char field>)" does an implicit conversion to VarChar, which is why it works. A Char column has no length apart from it's defined maximum.kumar_s wrote:For a char field Len(Trim(field_name)) will return the count without whitspace.ArndW wrote:Kumar, what does TRIM() on a CHAR(10) field containing "hello " return?kumar_s wrote:Trim also works for Char...
Warning during execution of StringToDecimal Function
Moderators: chulett, rschirm, roy
As that may be true, as mention if Trim used on a char field with the APT_STRING_PADCHAR as 0x0 you can find the ascii null instead of spaces.
Where as if you map the char field directly to a varchar field, you will still get the spaces.
Where as if you map the char field directly to a varchar field, you will still get the spaces.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
Warnings during the execution of StringToDecimal Function
Hi Kumar,kumar_s wrote:The option available in transformer (Also available project level).
If enabled, DataStage tries to combine all possible orchestrate operator to a single operator while compiling to reduce the over head.
Though the funcitons are given in an order, which should also work according to its own precedence, sometimes the trim and the StringToDecimal conversion may get combined. Hence it may work in other order.
I made Combinability Mode to fasle. Previously the error was
APT_CombinedOperatorController,0: A numeric string was expected, got "101 "; using Decimal, the default value.After making to false it is giving like
Transformer_3,0: A numeric string was expected, got "101 "; using Decimal, the default value.
Kindly help me
Re: Warnings during the execution of StringToDecimal Functio
Madhu -Madhu1981 wrote:kumar_s wrote:
I made Combinability Mode to fasle. Previously the error was
APT_CombinedOperatorController,0: A numeric string was expected, got "101 "; using Decimal, the default value.After making to false it is giving like
Transformer_3,0: A numeric string was expected, got "101 "; using Decimal, the default value.
Kindly help me
Were you able to figure out and overcome the warning. If so can u pls post what the solution was as it would be helpful in correcting the issue we are having currently.
Thanks in advance.
g.kiran
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: