on 07-06-2006 4:50 PM
What is the best data type for quantity / amount fields ?
I am using 'string' type .. but is it better to use xsd:decimal?
It depends on your scenario.
First of all, it won't be checked until you do a mapping.
If your receiver needs a really clean XML Structure and it must be a decimal, a decimal would be better.
If it doesn't count, you can use String because it is a String what you get.
If you want to use Proxies, I am not sure if the Field Types will be the same in the Java Code or if any field is a String.
Regards
Philipp
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
There will not be any issue.But you may get Runtime Error . Because data type mismatch. for this use Java Userdefined function to make sure that your input Quantity field is valid to map with the target field.
So you can check for Special Characters etc in the source structure.
Regards,
Moorthy
Hi,
As per now, there is no validation happens for the data facets. SO you can go for String type. And if you want to validate, it is easier with using some java functions in the mapping.
Regards,
Moorthy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.