Can anyone provide some sample in ObjectScripts to import a tab separate txt file into a SQL table? I checked the document, there are two available classes, %SQL.Import.Mgr and %SQL.Until.Procedures, which one is better choice?
i come back to you , i've a problem with Client description in Oauth2, when i tick the Supported grant types and i save , there are not registred on the OAuth2_Client.Metadata table .
We are using Cache 5.0.15 version. We are facing error. I tried to copy the dat file, I am getting cyclic redudancy error.
I did run the integrity check and repair utility . Nothing works.
Now My question is how to recover the dat file with data.
Apologies if this has been asked already but I was not able to find it. When I look at the Add/Edit screen I see authentication methods of Password and Kerberos and am wondering if passing an identify file is supported.
I recently encountered a issue with Caché and I can't figure out where the problem is coming from.
I noticed that the license limit (200) was reached whenever I was opening my Studio (so it seems). When this occurs, I restart Caché (with the Cube in the Taskbar), and the number of license used is back to 1%, but grows back after. The time taken before the number of license grows back again looks pretty random.
I want to be able to import XML (say, using %XML.Reader) to Caché objects permissively (ignoring invalid/unexpected tags/attributes), but also to validate the same XML and list any/all invalid tags/attributes that it contains.
Hi, I'm a student, weak programming. I ask for your help, I write a program in C #, there are two tables, but I do not understand how to organize the connection between them many to many. Table in DataGridView1 from DataSet1 on Form1 key connection in DataGridView1 from DataSet1 to Form3
It looks like Mumps is supported, and there is also an existing language with a .cls extension, which would account for why I see some very odd highlighting going on with some of my code.
There is a page on contributing a new language here...
I am trying to age based on a given date and current date here is my code:
Property DOB As %Date
Method GetAge() As %Integer
{
if (..DOB="")
{
set today=0
}
else
{
set today=$ZDate($HOROLOG,2)-$ZDate(..DOB)
}
write "Today's==="_$ZDate($HOROLOG),!
write today
return today
}
And related question: is there a way to return several values (which may contain commas) from one callout call. Or rather what's the best approach when doing that?
We have 1lakh records in table and while using sql select statement , it is taking more than 9mins to 12 mins to get the records. could you please how to optimize this performance issue if we have more records. how to optimize it.
is there a way to get the Call-Parameter in an UrlMap to call a method that lies in another class?
Example:
I have a generic class 'RestApi' where I define all my routes for the different Rest-Services I offer - in order to get the same URL for every service.
Hi All, Can you please tell me how to get the Size of the Global Subcript.
In Cache 2016 - they are using ##Class(%GlobalEdit).GetGlobalSizeBySubscript()
For Older version how to get the GlobalSize of the Subscript.
Because the method is not exist in Older Versions and all.
By update
.