Query Layer help

[CoreyKalinoski]

I have a DB2 table that has Lat/Long data within fields in decimal form. Instead of having a field with a spatial data reference, i.e. point representation of these fields. I have attempted to write a query that utilizes the DB2 function to convert these fields into a point, this function is db2gse.point_st . Within a Jupyter Notebook this seems to work fine and I create a field that is added with the spatial reference for the point based on the lat/long. However if I try to include this function as part of my query within ESRI Query Layer, it will not show the field to select as the spatial reference. Any advice on this?

[CoreyKalinoski]

Can the XY event layer work similar to the Query Layer? I was thinking I needed the query layer so that everytime the map was opened the query would run against the DB and get the most recent data available only. There could be hundreds of thousands of entries for each object ID but I was setting the query to return only the most recent time stamp entry.