Date mismatch from Windows to AIX

David (cahoot) Wilson

Date mismatch from Windows to AIX

We run Windows 2000 and DB2 7.2.4 on AIX.
When running
INSERT INTO tab1 (datefield) VALUES ('13/01/2004')
on AIX with the following config
Database territory = GB
Database code page = 819
Database code set = ISO8859-1
Database country code = 44
we have no problems.
When running the same code from control centre with Windows regional
settings set to UK and date format set to DD/MM/YY
we get SQL0181N - date/time mismatch.

Question is : Are there some other setting in Windows/DB2 that could cause
this date field to default to US format.

David Wilson

Internet communications are not necessarily secure and may be intercepted or
changed after they are sent. cahoot does not accept liability for any such
If you wish to confirm the origin or content of this communication, please
contact the sender using an alternative means of communication.

This communication does not create or modify any contract.

This email may contain confidential information intended solely for use by
the addressee. If you are not the intended recipient of this communication
you should destroy it without copying, disclosing or otherwise using its

Please notify the sender immediately of the error.

cahoot is a division of Abbey National plc.
Abbey National plc is registered in England, registered number 2294747.
Registered Office: Abbey National House, 2 Triton Square, Regent's Place,
London, NW1 3AN.

Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at