#Caché

I am trying to create a Procedure in Caché, but this message is showing:

<UNDEFINED>frmit+118^%qaqpsq *mt("v",1)

This is the procedure:

CREATE PROCEDURE testebi.sp_cargainicial()
BEGIN
INSERT INTO testebi.Fato_Atendimentos (
PK_OsProcedimento )
SELECT ID
from dado.TblOsProcedimento ;

Hi,

Can anyone please recommend an editor for cache database. I am looking for free version.

I am using winsql free version but data is missing while extracting or copying data from winsql.

Thanks

Jude

We are using Native .NET API from IRISProviderCore21 package, inside .NET Core app, and having issue when trying to call function that takes instance of the class as parameter. The server is IRIS 2020.1.0.217.1

In a nutshell, the code looks like this:

// Create instance of the parameter class, proxy object

var paramObject = iris.ClassMethodObject("MyParameterClass", "%New") as IRISObject;

paramObject.Set("property", "value");

Background: We have our own SQL map that predates InterSystems'. A program writes an XML file for each table map class as $system.OBJ.Export would. $system.OBJ.LoadDir loads the XML files into .cls files.

The reason is a long story, but we need to update parameter EXTENTSIZE (only) in existing classes. This does not seem to happen. As a test I used $system.OBJ.Export to make an XML file and edited EXTENTSIZE in the two places it appears in the XML:

Hi,

I am testing some BI tools like Tableau, Power BI and Qlik with Caché using ODBC driver

Is there another way to connect them with Caché?

I am trying to populate a table using the sql Data Import Wizard. The input file is a tab delimited text file. But the import keeps failing with a 104 error showing validation for the columns which use %Library.TimeStamp and %Boolean datatypes is failing. Yet when I insert values into the table through a SQL insert command, the values get saved correctly in the table.

For the TimeStamp format in the wizard form, I am choosing YYYY-MM-DD-HH:MI:SS because there was no option for this format: YYYY-MM-DD HH:MM:SS.

Hello Everyone,

I have a question, someone know how to put a password in a pdf file? Or in a pdf base64?

Best regards, Flávio.

Hi All,

I have to convert a binary 32-bit IEEE 754 floating point to an decimal representation.

Is there any inbuilt function available in Cache 2015.1 version to convert IEEE 754 floating point to decimal representation?

For Example:

Input:
IEEE 754 value => 0 10000111 10111000000000000000000

Output:
After Converting => 440.0

Thanks,

How do I programatically query a task set up in the task manager? I need to know the code being executed.

Thanks

I have a terminal script that queries sys.process' and then parses the results writing to a logfile. As part of the processing of the results, each row of the result set includes an element from the static string. But I am not clear on the scoping of the static string. The write statement sees the static string as undefined. What I want is something to the affect:

set statStr = "aa|bb|.."

set sqlStatement = xxx

set tState = ##class(%SQL.Statement).%New()

set qStat = tState.%Prepare(< sql statement> )

Hi Community,

I would like to migrate a Zen application to Iris but I am facing issue below:

so far I was not able to solve this issue myself, is there somebody who has some suggestions?

Thanks!

Hi

Does anyone know where the user generated code resides, the stuff one might write for a production, I presume it lives in a table somewhere within a database?

Basically, I want to do some dependency analysis of what I've written - find out what's in use, how it's referenced, etc. I know I can export it to an XML file and work on that, but direct access on a table would be quicker for me.

Cheers

Hi there have been various posts around how to clean up globals without parent data but none have gone into how you solve these issues.

Our database is approaching 600gb in size so i am looking into how to reduce this.

We use standard purge tasks.

Our cache stream class has a global size of 2463243 from running global size so it is what i would like to tackle first.

1) is there any way i can find based on my oldest message session for where most of these globals

In my Python script I import intersys2.pythonbind3 to create the connection and define a database object as db

I execute the method

res = self.db.run_class_method("%Library.GlobalEdit", "GetGlobalSize",[<db>, allocated,used])

This executes correctly as I loop through a list of databases.