Question Adel Elsayed · Dec 21, 2022 what is the time complexity of list operations? what is the big O of $lf, $lg, $li, $lts and list concatenation by "_" #Caché #InterSystems IRIS 0 7 1 342
Question Adel Elsayed · Nov 26, 2021 Looking for VS Code Extension for ObjectScript that highlights non-used variables and/or non-instantiated variables. let there be less <UNDEFINED> or <SUBSCRIPT> Errors in my life. #InterSystems IRIS #VSCode 2 4 0 278
Question Adel Elsayed · Nov 15, 2021 In Ensemble HTTP Services, Where Can I Find a Log of the Request source domain or IP ? I Mean By Default without overriding the service class and manually logging. #Ensemble 0 1 0 127
Question Adel Elsayed · Oct 30, 2021 Global buffer questions Is there a way to ensure a certain global(s) are always in buffer ?! Is there a method call to check if a global is in buffer ? #Caché #InterSystems IRIS 0 1 0 377
Question Adel Elsayed · Sep 22, 2021 embedded sql select locks i noticed -by reading .INT files of one class- that some of embedded sql select statements code blocks translates into code that uses lock command. even if i use %nolock in the select, still cursors and arrow referencing notations "->" have the same results. #Caché #InterSystems IRIS 0 4 0 168
Question Adel Elsayed · Jul 21, 2021 What is the best way to export a global or a table to a file? in order to do analysis on huge data volumes, it is better to take you data to a separate machine for analysis away from the operational machine, so trying to write huge globals or tables into files as is would take a huge space, what could be a solution or best practice ?..in python for instance, there is the pickling option (serializes data to byte string and saves it to a file) to save space, what could be best in object script ? #ObjectScript #InterSystems IRIS 0 11 0 914
Question Adel Elsayed · May 14, 2021 Using ODBC SQL Gateway programmatically I'm trying to connect to a database (outside Cache) using the examples here: https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls... and https://docs.intersystems.com/latest/csp/docbook/Doc.View.cls?KEY=BGOD_g... #ODBC #Caché 0 1 0 295
Question Adel Elsayed · Apr 3, 2021 Could I trace what scripts (classes, routines,..) are called in a process? for debugging purposes of complex applications. #ObjectScript #Caché #InterSystems IRIS 0 7 0 351
Question Adel Elsayed · Jul 13, 2020 Pyodbc error upon calling a stored procedure that has ROWSPEC column or more as %Date or %Time Pyodbc supports calling stored procedure , but if the IRIS Stored Procedure ROWSPEC has a column with datatype specified as %Date or %Time, Pyodbc fails to fetch it and throws this error. " pyodbc.Error: (' 2201', '[ 2201] [Cache ODBC][State : 22018 ][Native Code 22005]\r\nERROR #388: Unknown error, code 22005 (22005) (SQLGetData)') " on printing the cursor execute description, pyodbc reads the column as <int>. #ODBC #Python #InterSystems IRIS 0 3 0 681
Discussion Adel Elsayed · Feb 8, 2020 Executing stored procedure through Python NativeAPI I'm looking into finding ways to fetch data from cache efficiently and work with it with python - specially pandas. i tried the following but i'm wondering if this is the most efficient way? to run the stored procedure as %ResultSet inside cache in a classmethod and serialize the data to JSON and then call that class method from python #API #ObjectScript #Python #Caché #InterSystems IRIS 0 5 0 560
All posts
All posts
All posts