DB2MOVE Utility Not Moving 'WITH DEFAULT' Definition

Jeffrey Schade

DB2MOVE Utility Not Moving 'WITH DEFAULT' Definition
I have been using the DB2MOVE and DB2LOOK utilities on a Windows DB2 UDB
Version 8 platform to extract DDL from OS/390 DB2 Version 6 on a
mainframe and I have noticed that all my columns defined as 'NOT NULL
WITH DEFAULT' came over as 'NOT NULL'. The 'WITH DEFAULT' option was
dropped. Can anyone give me a clue as to why this happened and how I can
correctly move the table definitions. I must admit I am seriously
disappointed in how many changes I have to make to my mainframe DDL to
get it to work on Windows UDB. I expected everything except the
tablespaces to be compatible and yet that is not the case.



Jeff

_________________________________________
Jeffrey Schade

Systems Consultant, Technology Engineering


Insurance Services Office, Inc.
545 Washington Boulevard
Jersey City, NJ 07310
Voice: (201) 469-3738

FAX: (201) 748-1500
[login to unmask email] <mailto:[login to unmask email]>




---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm