SQL

I have created a view to stage some data in a different format and then want to reference that view in a SQL query from a table that filters the data from the view using a property of the table. 

Mapping Examples

Hello,

I have a question about creating properties with curl.

I already did create properties in Java with the following command.

I would like to know , if its safe to use %NOLOCK  in insert query while doing some parallel processing in Ensemble. We will have pool size of more than 1 for a business process.

Hi Community!

We are pleased to invite you to the upcoming  webinar "Taking Control of Your SQL Performance" on 12th of September at 11:00 a.m. EDT!

Hi all,

We have a big problem because we have the following message when I try to open the messages in a production.

ERROR <Ens>ErrException: <DATABASE>zfindStatement+29^%SQL.DynamicStatement.1 ^%sqlcq("MYNAMESPACE","Query",8,"Gns8AZO5dJclytqv13l9gUuLUyo=",""),c:\intersystems\healthshare\mgr\cache\ -- logged as '-' number - @''

SOURCE ELEMENT: %ZEN.Component.tablePane (resultsTable)

Is there a way to lock at the record level? I know that you can lock at the table level:

I have the following class definitions:

Hi

Good afternoon everyone,

I hope you are well,

Would like to know if there is an alternative or better way to paginate through a dataset using dynamic SQL than what I am using below.

I'm trying to have my REST service return the entire data set for one of our legacy globals.  Currently I am parsing the object from a SQL statement into generic objects to be returned like this:

I have a class that has a property calledTags (like DescriptiveWords, but tags), where multiple tags are possible.  I am trying to decide on list of Objects vs. array of Objects.