Question P Patz · Nov 19, 2017 Force inner select to be executed I have a query that I am attempting to run, but inner query is being rolled up into the overall query - per the optimizer (and jobexam observation). While I know that if the inner query runs first, I will eliminate a number of records (making the result set smaller, and return quicker).Just an example of what I am attempting to do: #SQL #Caché 0 8 0 410
Question P Patz · Jun 1, 2017 Dirty read prevention - 'START TRANSACTION ISOLATION LEVEL READ COMMITTED' I need to guarantee that a parent AND child rows has been inserted successfully before any other process is able to read ANY of the data. #Caché #JDBC #ObjectScript 0 3 0 755
Question P Patz · May 12, 2017 Use a class property to pass a flag Looking for a way in which I could possibly pass a flag through a property when performing an Insert statement, on a mapped class.insert into my.class (serialNumber, modelNumber, myFlag) value ('testSerial', 'testModel', 0) myFlag is not stored in the DB.The mapped class then calls a legacy routine (MAC) via CodeMode = 'objectgenerator', (Insert method within the 'objectgenerator')Within the legacy routine, I am setting an index... but I don't always want to set it (multiple inserts, and I will only set the index on the LAST insert) #Caché #ObjectScript 0 4 0 254
Questions