Date validating



Discuss about QA in Mainframe, Back-End Test, Offline code testing and Testing Tools

Date validating

Postby reddy1122 » Sun Oct 31, 2010 4:59 am

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.
reddy1122
 
Posts: 1
Joined: Sat Oct 30, 2010 2:10 am
Has thanked: 0 time
Been thanked: 0 time

Re: Date validating

Postby 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).
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times


Return to Application Testing