Data Type mapping rules are used to convert data types. For example, in the following scenarios, you will see that data type mapping rules are used to determine if the data type result includes parentheses.
If the source data type has parameters for length, and the target data type has mandatory or optional parameters for length, the data type result includes the source data type's parameters, as follows:
char(18)
char()
char(18)
If the source data type has parameters for length, and the target data type has no parameters for length, the data type result does not include parameters, as follows:
char(18)
char
char
If the source data type has no parameters for length, and the target data type has mandatory parameters for length, the data type result includes parameters with the default value of 100, as follows:
char
char()
char(100)
If the source data type has no parameters for length, and the target data type has optional or no parameters for length, the data type result has no parameters, as follows:
char
char() or char
char
Copyright © 2012 CA. All rights reserved. |
|