andy_smith
Well Known Member
Hi List,
When dates are stored in OneWorld tables they are held in the JDE data
format - does anyone know how these are converted / translated ? (is it
a BSFN that does it or the ODBC driver ?).
We have an issue whereby the job queue has 'stopped' and also new jobs
cant be submitted. When a new report is ordered, the JDENet process (on
the server) that carries out the SQL statement to INSERT in to F986110
fails and the debug trace shows it is trying to use a value of
'04/12/2003' in the date column whereas it should be something like
103338 in JDE format.
I am not clear where this conversion is supposed to take place - any
ideas anyone ?
Thanks, regards,
Xe Intel Win2K, SQL7
Andy Smith
Technical Consultant
WHITEHOUSE
Consultants
http://www.whitehouse-consult.co.uk
Office: 01564 711037
Direct: 01159 825987
Mobile: 07949 603770
E-Mail: [email protected]
Andy Smith
Whitehouse Consultants
Win2K SQLServer7 Xe
When dates are stored in OneWorld tables they are held in the JDE data
format - does anyone know how these are converted / translated ? (is it
a BSFN that does it or the ODBC driver ?).
We have an issue whereby the job queue has 'stopped' and also new jobs
cant be submitted. When a new report is ordered, the JDENet process (on
the server) that carries out the SQL statement to INSERT in to F986110
fails and the debug trace shows it is trying to use a value of
'04/12/2003' in the date column whereas it should be something like
103338 in JDE format.
I am not clear where this conversion is supposed to take place - any
ideas anyone ?
Thanks, regards,
Xe Intel Win2K, SQL7
Andy Smith
Technical Consultant
WHITEHOUSE
Consultants
http://www.whitehouse-consult.co.uk
Office: 01564 711037
Direct: 01159 825987
Mobile: 07949 603770
E-Mail: [email protected]
Andy Smith
Whitehouse Consultants
Win2K SQLServer7 Xe