IBM Mainframe Forum

HI

GDG file with records in it loads values in new DB2 tables, how to validate the date field that all the dates are loaded in correct format. Is there any sql query to validate dates and table.

Hello and welcome to the forum,

Well, gdg files do not load data into tables. Non-gdg files also do not load data into tables. . .

Some utility or aplicaton code loads data into tables.

How are these particular tables being loaded? Depending on what is actually being done, the answer to your question will vary.

It will probably help if you show a few sample records/dates and the database fefinitions for thes columns (from the CREATE TABLE).