Rauf
VIP Member
Is there any issue if I give direct read-only DB access to a non-JDE applications ( developed in Microsoft .NET). These application are developed in-house. Or should I go through the lengthy interoperability procedures.
There's not a lot of harm you can do with read-only, besides performance impacts and read locks...So there is no harm if we do proper data conversion
One other thing to add. We actually added in two Scalar-Valued Functions directly into the JDE Business Data DBs that can help with the date part of the data conversion. You can also obviously do the conversion at the app level (which we also do) but sometimes its easier to do it right in the query.So there is no harm if we do proper data conversion
Absolutely essential and recommended as well.One other thing to add. We actually added in two Scalar-Valued Functions directly into the JDE Business Data DBs that can help with the date part of the data conversion. You can also obviously do the conversion at the app level (which we also do) but sometimes its easier to do it right in the query.
JDEJulian2Date - converts JDE date in DB to a SQL date type
Date2JDEJulian - converts a SQL date type to JDE Julian number
We use essential cookies to make this site work, and optional cookies to enhance your experience.