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.
Date validating
Previous topic • Next topic • 2 posts
• Page 1 of 1
Date validating
by reddy1122 » Sun Oct 31, 2010 4:59 am
- reddy1122
- Posts: 1
- Joined: Sat Oct 30, 2010 2:10 am
- Has thanked: 0 time
- Been thanked: 0 time
Re: Date validating
by dick scherrer » Sun Oct 31, 2010 7:32 am
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).
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).
Hope this helps,
d.sch.
d.sch.
-
dick scherrer - Global moderator
- Posts: 6268
- Joined: Sat Jun 09, 2007 8:58 am
- Has thanked: 3 times
- Been thanked: 93 times
Previous topic • Next topic • 2 posts
• Page 1 of 1