Copying complex objects

 

You can copy from and to files that contain user-defined functions (UDFs), user-defined types (UDTs), DataLinks (DLs), large objects (LOBs), identity columns, or ROWIDs.

• Copying files that contain user-defined functions
  You can specify CRTFILE(*YES) on the CPYF and CPYFRMQRYF commands when you copy files that contain user-defined functions (UDFs). UDFs do not get created with the new to-file.

• Copying files that contain user-defined types
  You can specify CRTFILE(*YES) on the CPYF and CPYFRMQRYF commands when you copy files that contain user-defined types (UDTs). If the from-file is an SQL table, view, or index that contains a UDT, these commands create an SQL table.

• Copying files that contain datalinks
  You can specify CRTFILE(*YES) on the CPYF and CPYFRMQRYF commands when you copy files that contain datalinks. If the from-file is an SQL table, view, or index that contains a datalink, these commands create an SQL table.

• Copying files that contain large objects
  You can specify CRTFILE(*YES) on the CPYF and CPYFRMQRYF commands when you copy files that contain large objects (LOBs). If the from-file is an SQL table, view, or index that contains a LOB, these commands create an SQL table.

• Copying files that contain identity columns or ROWID attributes
  You can specify CRTFILE (*YES) on the CPYF and CPYFRMQRYF commands when you copy files that contain identity columns or ROWIDs.

 

Parent topic:

Copying files