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.


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