identifying columns of user defined type

Hi, One of my databases gets a warning when performing an onunload. The message is th e following repeated several times: Warning: The given database or table contains column(s) of user defined datatype. Onload and Onunload do not handle such data types. The load may not be successful or may not load back the correct data. How can I determine which tables contain a column like this? Thanks! Anna

The coltype will be in the systypes table. Art S. Kagel ----- Original Message ----- From: Anna Johnson <ids@iiug.org> At: 5/07 17:13:11 Hi, One of my databases gets a warning when performing an onunload. The message is th e following repeated several times: Warning: The given database or table contains column(s) of user defined datatype. Onload and Onunload do not handle such data types. The load may not be successful or may not load back the correct data. How can I determine which tables contain a column like this? Thanks! Anna ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

This query should give you what you are looking for by substituting table and column names. select st.tabname , sc.colname , xt.name from systables st , syscolumns sc , sysxtdtypes xt where st.tabid = sc.tabid and sc.extended_id = xt.extended_id and st.tabname = 'tableOfInterest' and sc.colname = 'colnameOfInterst' Stuart McCann Integrated Spatial Services Unit Information Communication & Technology Department of Lands, Bathurst Phone: (02) 63328285 stuart.mccann@lands.nsw.gov.au -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of ART KAGEL, BLOOMBERG/ 731 LEXIN Sent: Tuesday, 8 May 2007 10:29 AM To: ids@iiug.org Subject: Re: identifying columns of user defined type [9088] The coltype will be in the systypes table. Art S. Kagel ----- Original Message ----- From: Anna Johnson <ids@iiug.org> At: 5/07 17:13:11 Hi, One of my databases gets a warning when performing an onunload. The message is th e following repeated several times: Warning: The given database or table contains column(s) of user defined datatype. Onload and Onunload do not handle such data types. The load may not be successful or may not load back the correct data. How can I determine which tables contain a column like this? Thanks! Anna ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. *************************************************************** This message is intended for the addressee named and may contain confidential information. If you are not the intended recipient, please delete it and notify the sender. Views expressed in this message are those of the individual sender, and are not necessarily the views of the Department of Lands. This email message has been swept by MIMEsweeper for the presence of computer viruses. ***************************************************************

Hi, I once had this because I didn't know that lvarchar type is internally treated as user defined type. Check if you have recently added any lvarchar columns. This might be the problem. In this case, only dbexport/dbimport will work correctly instead of onunload/onload. Marcus -----Original Message----- From: ANNA JOHNSON [mailto:anna.johnson@signal-ctc.com] Sent: Monday, May 07, 2007 11:13 PM To: ids@iiug.org Subject: identifying columns of user defined type [9084] Hi, One of my databases gets a warning when performing an onunload. The message is th e following repeated several times: Warning: The given database or table contains column(s) of user defined datatype. Onload and Onunload do not handle such data types. The load may not be successful or may not load back the correct data. How can I determine which tables contain a column like this? Thanks! Anna ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.