I have the following class definitions:
SQL
Caché, Caché Objects, Development Environment, Job Offer, ObjectScript, SQL, UI Development, Web Development
Good afternoon everyone,
I hope you are well,
Hello there,
I have some problem with inserting date to table using dynamic sql.
Last answer 3 August 2018
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.
Last answer 18 July 2018 Last comment 26 July 2018
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:
Last answer 23 July 2018 Last comment 23 July 2018
Hi I've got a service setup to query a sql server via ODBC.
I've got all the parameters etc setup and everything is ok
My Query is
Last comment 18 July 2018
I would linke to have the functionalities provided by the Table Field/Property Collation
Last answer 16 July 2018 Last comment 17 July 2018
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.
Last answer 13 July 2018 Last comment 12 July 2018
I am trying to fetch the data from cache database. But i got the error like "CSP application closed the connection before sending a responce".
Below is the query.
Last answer 7 July 2018 Last comment 9 July 2018
I'm facing a specific sort problem.
There are several thousands of articles sold all over.
Users expect to get a description in local language sorted by their specific collation.
Last answer 22 June 2018 Last comment 22 June 2018
I have a serial object:
Class EmbedObj Extends %SerialObject
which is stored as a property of another object
Class ContainerObj Extends %Persistent
Property InnerObj As EmbedObj;
Last answer 13 June 2018 Last comment 17 June 2018
Caché, Caché Objects, Databases, Business Operation, Business Process (BPL), JDBC, SQL, Stored Procedures (SQL)
I have several stored procedures that when I execute them they will only return a single snapshot.
Last answer 14 June 2018
Hello,
I want to know if there is any possible way to use the same query for different ODBC schemas.
Thanks.
Last answer 13 June 2018 Last comment 14 June 2018
Hi Everyone,
I am trying to built a SSIS package thru BIDS Visual Studio 2013. My Datasource is a InterSystems Cache Database, I wanted to Import Tables records from the Datasource to MS SQL Server 2014.
Last answer 12 June 2018 Last comment 12 June 2018
The Art of Mapping Globals to Classes (4 of 3)
The forth in the trilogy, anyone a Hitchhikers Guide to the Galaxy fan?
Last comment 12 June 2018
Does anyone have any sample code for updating Caché users (and specifically Full Name and Comments) via SQL?
Last answer 8 June 2018 Last comment 5 June 2018
Without installing Kerberos has anyone Authenticated a SQL JDBC connection?
Last comment 7 June 2018
Date range queries going too slow for you? SQL Performance got you down? I have one weird trick that might just help you out! (SQL Developers hate this!)*
Last comment 4 June 2018
I have generated a class using the linked procedure wizard however I can't get it to work if the datatype of one of the parameters is VARCHAR(MAX). It works fine if I change it to say VARCHAR(500) and rerun
Last answer 10 May 2018 Last comment 1 June 2018
Hi All
I'm looking for the a simple-quick-easy solution to monitor a SQL table thought Ensemble.
I have a process that update a DataBase ,a scheduled task that runs every night (Not Ensemble)
Last answer 24 May 2018 Last comment 29 May 2018
Last comment 25 May 2018
Hello glabal masters,
I am trying to develop WAS using Cache and Spring Framework.
The ON DUPLICATE KEY UPDATE is not working.
Source :
Last answer 25 May 2018 Last comment 25 May 2018
The documentation only provides the syntax but does not provide any sample DDL for this case.
Last answer 19 May 2018 Last comment 19 May 2018
I have a SQL procedure that I call into and it does some processing and passes back any data validations that fail.
Last answer 14 May 2018 Last comment 14 May 2018