Posts by P Patz on InterSystems Developer Community

Question

P Patz · Nov 19, 2017

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 474

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 826

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 295