DS 7.5 - Remove COLUMN.SCALE warning from Event Log?

[gerrym730]

I am using DS 7.5 client to create a simple server job on windows platform to copy one database date MSQL field to a sequential file.

DS JOB DATE FIELD INFO:
==================
SQL TYPE: timestamp
Length: 38
Display: 20

MS SQL COLUMN INFO:
=================
Datatype: datetime
Nullable: not null

I always receive the following warning message in Event detail screen when validating the job.

WARNING MESSAGE:
===================
DSD.BCIOpenR results of SQLColAttributes(DATE_START) gave MetaData mismatch
MetaData mismatch on COLUMN.SCALE Expected = 0 Actual = 3


QUESTIONS:
------------------
How to I remove this warning message??? Change Datetype on MSQL Table? Modify DS column SQL TYPE ??? Convert date to a string field???

Thanks for any info
Gerry

[ray.wurlod]

Yes, basically the metadata in your job must match the metadata reported by the database server.