Can anyone please help me how to use regular expression/wild character on a sql query for a pattern like C00.0 to C00.9, C01.0 to C01.9 and so on until C77.0 to C77.9 .
I have a system that is sending Line Breaks\Carriage Returns within the text of a field that is breaking the parsing of the message. Does anyone have a way to get around this?
Have a iris.dat file that was zipped in axis but , now I unzipped it and can see the file in my c drive but when I go to iris management console to perform a new db to pull in the current iris.dat file , in the wizard I do not see the iris.dat file listed.
Need some help with getting it restore the Cache backup in my iris community edition.
I am a beginner in cache. I need to extract data from multiple tables (4-5) tables based on an SQL query . The data is more than 9 lakhs of records (i checked using count). The total number columns is 16.
When I am running this SQL query through management portal, I am getting time out exception. Could you please suggest how I can retrieve those records. Which way will be good (Dynamic query using %SQL.Statement or Embedded SQL (not known to me) or Writing to a global will help or not).
I am currently using D $SYSTEM.SQL.Shell() command or management portal to retrieve the data from database. I just learned we can also run cache table sql queries in MS access. MS access already installed on my machine.
I need to ask how I can connect my database of USER or sample namespace in MS access to run these SQL queries.
I have a use case where I'm using embedded SQL within a Business Process to interact with a SQL table. However, when it comes to deployment into our production, the table wont form part of the deployment package created from the production.
Beyond manually creating the table on the production system, is there a standard way of ensuring that a table needed for a class is created during deployment?
I want to grant access to view the Error Trap in System Management Portal to certain admins, without giving them access to anything that would alter Caché behavior, such as users or database sizes. I was looking for a granular Resource that would do this, but haven't been able to find what I'm looking for.
In trying to define a Class Parameter that I can use in SQLComputeCode I can't seem to get any of the syntaxes for the using of the parameter where the SQL compute code will actually evaluate the parameter values. There is nothing specific that I can find in the docs about SQLCompute Code and Parameter usage.
Is there some specific syntax for accessing a class defined parameter in the SQL Compute Code that works?
This is on: IRIS for Windows (x86-64) 2022.1.1 (Build 374U) Tue Oct 18 2022 17:37:34 EDT
I need a help in the following error I am getting while running the SQL Query. I am running the SQL Query from different table using inner join. I run this everyday for last 90 days but for few days while extracting the data through this query I am getting this error. Please assist.
SQLException was thrown: Incorrect list format: 0 >= 0_SQLSTATE: S1000
SQLException was thrown: Incorrect list format: 0 >= 0_SQLSTATE: S1000
I have a registered object class that extends %XML.Adaptor and I want to convert an object of it into canonical XML.
From reading the documentation and some trial and error, it seems like I would need to use %XML.Writer to write the object to XML first using the RootObject() method, then read it with %XML.Reader, and then use the Canonicalize() method of %XML.Writer to write it out again.
I have a test version of Cache installed on my laptop, but I cannot get logged into the database. I think my ID may be locked due to too many password failure attempts. I have not changed the Admin password or SuperUser password. Does anyone know what the default password would be for the Admin and/or SuperUser Id's? Or if someone knows how I can get in and unlock/reset my password, it would be much appreciated??
A client recently upgraded from Cache2010 to Cache2017 and now reports that for certain tables, WinSQL does not show the indices which were previously visible in Cache2010. Has anyone heard of this type of behavior before? Is there a remedy or some change which needs to be made to the table definitions? Thanks.
I have an issue when trying to generate an object when reading an XML file. All files I'll mention will be attached to this post as a PDF file, but it's really a ZIP one.
In which folder under the "C:>InterSystems>IRISHealth" are the Mumps/cache routine stored? These are the routines created via the Studio module of the IRISHealth application.