TC and MS Access datetime field

[andres]

(XE and db2 as/400)
i'm trying to export data with TC from jde to MSAccess database. This
datebase exists previusly and has a datetime field.
when exporting a date everything is ok, but when trying to export a time
value (jde string in this case is the field with the time value) there's no
way that ms access accept it.
i mean, if you has a datetime ms access field and you want to export a time
value, how do you do it?
thanks,
josé.

 

[ccamponuevo]

santucho27,
To export/import data to access you will need a DataSource configuration of Julian dates in the enviroment. Go to GH9011, Database Data SOurces, select the <YourServerName> machine "System - B7333", and edit the DataSource config... Uncheck the option the option "Use Julian Dates". The conversion will executed by the system, so you will read jualian dates in PRODDTA and save DateTime in access.

hope this help.

 

[andres]

i tried that, but it doesn't resolve the problem.
because i have a field datetime in ms access and i want to export there a time value, but in oneworld can be anything (string, numeric, etc) that when you run the tc it doesn´t accept it.