See

• Using Stream Fields from ODBC
• Integer Codes for Data Types
• LONGVARCHAR = CLOB = %Stream.GlobalCharacter

If you run the following code, then the type of variables a and b in the generated class will be %Stream.GlobalCharacter

create table dc.test
(
a LONGVARCHAR,
b CLOB
)

In addition, I'm no expert in JDBC but wit seems that LONGVARCHAR has a Maximum Length 32,700 characters in JDBC, not quite enough for an arbitrary stream.

Max Size for LONGVAR(BINARY/CHAR) = 2147483647, for VAR(BINARY/CHAR) = 4096

PS: By the way, in DbVisualizer you can view all types supported by the InterSystems IRIS JDBC driver, their numeric codes, maximum sizes, and much more.

Same thing, just different:

set true="1",
    false=0,
    j={}

do j.%Set("a",1,"boolean")
do j.%Set("b",0,"boolean")
set j.c=true
set j.d=false
  
set iter = j.%GetIterator()
while iter.%GetNext(.key, .value, .type ) {
  write "key = "_key_", value = "_value_", type = "_type,!
}

Output:
key = a, value = 1, type = boolean
key = b, value = 0, type = boolean
key = c, value = 1, type = string
key = d, value = 0, type = number