Datatype file validation

Shell Programming and Scripting
1 
 
I have a sourcefile which contains data as below.I want to check whether datatype,structure and date format looks good as mentioned. 
Data is delemited by cydila  .
 
Source file-Emp.txt
sno name   phoneno  dept joineddate
1   vivek  0861     CSE  2013-05-29 00:00:00
2   dinesh 123456   ECE  2013-05-29 00:00:00
3   sai    78945    EEE  2013-05-29 00:00:00
4   sridar 45612    IT   2013-05-29 00:00:00
 
Defination of emp.txt file.
column name datatype format
sno number(2)
name varchar(20)
phoneno number(10)
dept varchar(20)
joineddate date yyyy-mm-dd hh:mm:ss
 
Please suggest me which command should use to check whether datatype,structure and date format is correct.
2

Same as here:

3

sourec file EMP.txt

sno�name�phoneno�dept�joineddate
1�vivek�0861�CSE�2013-05-29 00:00:00
2�dinesh�123456�ECE�2013-05-29 00:00:00
3�sai�78945�EEE�2013-05-29 00:00:00
4�sridar�adf�IT�2013-05-29 00:00:00

log file
err 1�vivek�0861�CSE�2013-05-29 00:00:00-this should be fine not sure why getting error.
ok 2�dinesh�123456�ECE�2013-05-29 00:00:00
ok 3�sai�78945�EEE�2013-05-29 00:00:00
ok 4�sridar�adf�IT�2013-05-29 00:00:00-Third column should be number but it is varchar not sure why it is not throwing error.

Please suggest me.