title: TO_DECIMAL for SAP HANA Conversion from String
body: <p>I am using an SAP HANA DB/table connection to add a query layer in ArcGIS for Desktop.  The table that I would like to use has longitude and latitude fields stored as string data types.  I would like to write a query for this layer which converts these fields as decimal data types so that I am able to present XY data. </p>
  
  <p>An example of my field values are longitude: <code>-117.619193</code> and latitude: <code>33.453381</code></p>
  
  <p>The error that is thrown is <code>General error; 319 decimal scale specifier is out of range: 6:(0-3)::S1000</code></p>
  
  <p>Query:<br>
  <code>select "JOBID", TO_DECIMAL(LONGITUDE,3,6) AS "LONG_DEC", TO_DECIMAL(LATTITUDE,3,6) AS "LAT_DEC" from "_SYS_BIC"."SEU.GD.LM/CA_KT_TICKETSTATUS"</code></p>
  
  <p>When I change the decimal identifiers to 3, my precision will not be as correct; how should this be changed to maintain the precision of 6 decimal places?</p>