Object Management Extension User Guide > Object Management Extension User Guide > Understanding DBMS Server Requirements for User-Defined Data Types > User-defined Data Types and the Copy Statement
Was this helpful?
User-defined Data Types and the Copy Statement
When you use the SQL copy statement with user-defined data type, be aware of the following points:
• The copy statement interprets user-defined data types using the char data type.
• Copying user-defined data types across different machines can produce unexpected results.
• Use bulk copy statement or a field format that specifies the length of the user-defined field. Copying user-defined data types using a format other than fixed or bulk format can produce unexpected results.
• Do not use character delimiters such as colon, newline, or tab with user-defined data types.
Last modified date: 11/28/2023