New post
AllAccepted answers
Robert Cemper · Apr 29, 2024

As you now explained what you really are looking for:   $System.SQL.Schema.SetDefault()

From Docu:

classmethod SetDefault(schema As %Library.String = "", ByRef oldval As %Library.String, Namespace As %Library.Boolean = 0) as %Library.Status

Sets the default schema used by SQL.
This configuration setting provides the ability to define a default schema name other than SQLUser, the default. When an unqualified table name is encountered in an SQL statement (and there is no #import statement specified), the default schema will be used. This setting has nothing to do with the mappings between SQL schema names and the class package name, it only specifies the default schema. Parameter:

schema
String containing the default SQL schema name. If schema is "" or not defined, the default schema will be set to SQLUser.
oldval
Passed By Reference. Contains the previous value of the setting.
Namespace
Boolean 1/0 flag. If TRUE, set the default schema for the current namespace only. The default for Namespace is FALSE

Returns:

Status Code

NOTES:

- You must have the "USE" permission on the %Admin Manage Resource in order to change this configuration setting.
- Changing this configuration setting will affect all processes immediately.
Robert Cemper · Apr 27, 2024

I just discovered in class code a different way to get Vector Values from object

USER>set obj=##class(AG.GEO).%OpenId(13)
USER>write obj.VBASE
8EB052EF186E024A8AAC58ED708EB114@$vector
USER>zwrite obj.VBASE
{"type":"integer", "count":2, "length":2, "vector":[4812,-1622]}  ; <VECTOR>
;
;;; THIS  is from the generated code
USER>set vec=obj.VBASELogicalToOdbc(obj.VBASE)
USER>zw
obj=<OBJECT REFERENCE>[17@AG.GEO]
vec="4812,-1622"
USER>
Robert Cemper · Apr 24, 2024

From Terminal in namespace %SYS you can run

  • DO ^JOBEXAM
  • select your job by list of PID
  •  Job# NSpace  Routine        Commands   Globals State PID      Current device
   23 USER    shell               425        64 READ  17060    |TRM|:|17060
Namespace:          USER                     SessionID:
Routine:            shell
Open Devices:       |TRM|:|17060*
Mem Lim/Peak/Curr:  256M/154K/116K           In Trans:      No
Priority:           8                        Info:
User Name:          UnknownUser
Roles/EscalatedRoles:%All/None
OS User Name:       cemper                   EXE Name:
Client Node Name:   TRM:                     IP Address:    127.0.0.1
Location:                                    PrivGblBlks:   3
Last reference:     ||RCC(5)
 
Current line:
 
Entry Process     X#   S# Flg Item Locked

(V)ariable, (L)ocks, (S)tack, (P)rocess Private Globals, (Q)uit =>  P
  • and can see  PPG 
    Process Private Global (?): RCC
^||RCC(1)=1
^||RCC(2)=2
^||RCC(3)=3
^||RCC(4)=4
^||RCC(5)=5
 
Process Private Global (?):
     
Robert Cemper · Apr 24, 2024

Hi @Michael Davidovich !
you hit exactly what I addressed in in my recent article
  The bewitched line terminator

As long as you get (text-) files from your own OS the default is OK
BUT: if you work cross OS platforms - rather likely for CSP pages -
the approach of  %CSP.BinaryStream is the best for import.

For output stream you have to decide based on the expected target OS.

My personal trigger to that subject was file transfer between
WIN as Docker host and a Container (Ubuntu) causing a lot of  confusion until detected.
 

Robert Cemper · Apr 11, 2024

you describe 2 different record layouts that reside within the same storage 
#1 - just a name
#2 - a name + a "transferred" property

depending on the situation you use either layout #1  or layout #2 for INSERT
reading might be OK for layout #2 in both cases.

Caché once had a somewhat similar sample with Person
and Employee extending Person. 
available here: https://docs.intersystems.com/iris20241/csp/docbook/Doc.View.cls?KEY=ASAMPLES
this Repo:
https://github.com/intersystems/Samples-Data/tree/master/cls/Sample