Write ##class(=datatype).Method(args)

   propname | direction

   propname alias | direction

   Run-time error '91':  Object variable or With block variable is not set

   Property Array As %String [ Collection = array ];

   Property Index As %Integer;

Method Test()
 {
   Write ..Array.GetAt(..Index)
 }

   Write '..Expr(var)

   Write '(var=1)||(var=2)

   Write '((var=1)||(var=2))

P.get_S1_S2()

P1.set_S1_S2(s2)

P.get_S1().get_S2()

and

s1 =P.get_S1();
s1.set_S2(s2); // change is only in memory
P.set_S1(s1); // change is now in the database

 Piece Return FullPath       IsDirectory
 1     c:     c:             1
 2     temp   c:\temp\       0
 3     mysub  c:\temp\mysub  0

   ERROR #5502: Error compiling SQL Table ...

   <MAXSTRING>characters^%occSAX in c:\test.xml at line 581 offset 1

   set sc=oref.XMLExport(,",indent")

   set sc=oref.XMLExport(,",indent($c(32))")

   set sc=oref.XMLExport(,",indent("_$c(9)_")")

[SQLCODE: <-400>:<Fatal error occurred>]
[Cache Error: <<LIST>AlterColumn+66^%apiDDL>]
[Details: <Serverr>]

   create table P(a integer primary key, b varchar(20))
   create table F(one integer primary key, two integer)

   insert into F(one,two) values (1,1)
   alter table F add constraint toP foreign key(two) references P(a)

   printf("%-*s", (int)display_size, pcolname);

    A_$C(0)_B_$C(0)_C_$C(0)

   "A global section with the name "_CACHE__[etc]" already exists"

   Set value=$System.Util.GetEnviron(VariableName)

   SYS$LOGIN = F$TRNLNM("SYS$LOGIN")

   LOCK ^x(1,2,3)

   LOCK ^x(1,2,3)

   LOCK +^x(1,2):0 w:$t   // $T is zero

   free size = 'available' size
             - total cached size
             - total free LHB pool size.

   'usable' size = free size
             + (2/3 of free size or total free LHB size which ever is smaller).

  "DSN=Test\0SERVER=127.0.0.1\0DATABASE=USER\0PWD=sys\0PORT=1972\0UID=_system\0"

jdbc:Caché://localhost:port/namespace[/logfile:eventclass:nodelay]

jdbc:Caché://127.0.0.1:1972/USER
jdbc:Caché://127.0.0.1:1972/USER/jdbc.log
jdbc:Caché://127.0.0.1:1972/USER/jdbc.log:event16:false
jdbc:Caché://127.0.0.1:1972/USER/jdbc.log::false
jdbc:Caché://127.0.0.1:1972/USER/::false

public void setNodelay(boolean nodelay);
public boolean getNodelay();

http://127.0.0.1/csp/samples/menu.csp?&"

http://127.0.0.1/csp/samples/menu.csp?&=

temp	;
	Set conn=##class(%SQLGatewayConnection).%New()
	Set res=##class(%ResultSet).%New("%DynamicQuery:SQL")
	Write conn.Connect("CACHE5B476 Samples","_system","")
	Set res=##class(%ResultSet).%New("%DynamicQueryGW:SQLGW")
	Write res.Prepare("select * from Sample.Company",,conn)
	Write res.Execute()

	q

  CONVERT ( data_type , expression [ , style ] )

Without century  With century (yyyy)   Input/Output**
   (yy)              (yyyy)
    -                0 or 100 (*)      mon dd yyyy hh:miAM (or PM)
    1                101               mm/dd/yy
    2                102               yy.mm.dd
    3                103               dd/mm/yy
    4                104               dd.mm.yy
    5                105               dd-mm-yy
    6                106               dd mon yy
    7                107               Mon dd, yy
    8                108               hh:mm:ss
    -                9 or 109 (*)      mon dd yyyy hh:mi:ss:mmmAM (or PM)
    10               110               mm-dd-yy
    11               111               yy/mm/dd
    12               112               yymmdd
    -                13 or 113 (*)     dd mon yyyy hh:mm:ss:mmm(24h)
    14               114               hh:mi:ss:mmm(24h)
    -                20 or 120 (*)     yyyy-mm-dd hh:mi:ss(24h)
    -                21 or 121 (*)     yyyy-mm-dd hh:mi:ss.mmm(24h)
    -                126(***)          yyyy-mm-ddThh:mm:ss:mmm(no spaces)
    -                130*              dd mon yyyy hh:mi:ss:mmmAM
    -                131*              dd/mm/yy hh:mi:ss:mmmAM

        From DATE to VARCHAR
           Example:  CONVERT(VARCHAR(20),CURRENT_DATE,100)
                     Returns:  'Jan 28 2003 03:00PM'
        From TIME to VARCHAR
           Example:  CONVERT(VARCHAR(20),CURRENT_TIME,8)
                     Returns:  '15:23:14'
        From TIMESTAMP to VARCHAR
           Example:  CONVERT(VARCHAR(20),CURRENT_TIMESTAMP,0)
                     Returns:  'Jan 28 2003 03:00PM'
        From INTEGER, SMALLINT, or TINYINT to VARCHAR
           Example:  CONVERT(VARCHAR(20),Age)
                     Returns:  '47'
        From DOUBLE or NUMERIC to VARCHAR
           Example:  CONVERT(VARCHAR(20),Total_Cost)
                     Returns:  '197.21'
        From VARCHAR to VARCHAR (used for truncation)
           Example:  CONVERT(VARCHAR(20),Description)
                     Returns:  'Weight measurement o'
        From VARCHAR to DATE
           Example:  CONVERT(DATE,'28 Jan 2003 15:12:13:436',113)
                     Returns:  59197
        From TIMESTAMP to DATE
           Example:  CONVERT(DATE,CURRENT_TIMESTAMP)
                     Returns:  59197
        From VARCHAR to TIME
           Example:  CONVERT(TIME,'28 Jan 2003 15:12:13:436',113)
                     Returns:  54733
        From TIMESTAMP to TIME
           Example:  CONVERT(TIME,CURRENT_TIMESTAMP)
                     Returns:  56508
        From VARCHAR to TIMESTAMP
           Example:  CONVERT(TIMESTAMP,'28 Jan 2003 08:13:04:443AM',130)
                     Returns:  '2003-28-01 08:13:04.443'
        From DATE to TIMESTAMP
           Example:  CONVERT(TIMESTAMP,CURRENT_DATE)
                     Returns:  '2003-28-01 00:00:00'
              Note:  When converting to a TIMESTAMP value, if the source
                     value is missing the Time component, the converted time
                     is 12:00:00AM
        From TIME to TIMESTAMP
           Example:  CONVERT(TIMESTAMP,CURRENT_TIME)
                     Returns:  '2003-28-01 15:23:34'
              Note:  When converting to a TIMESTAMP value, if the source
                     value is missing the Date component, the converted date
                     is the current day.
        From <ANY type> to INTEGER, SMALLINT, or TINYINT
           Example:  CONVERT(INTEGER,CURRENT_DATE)
                     Returns:  59197
        From <ANY type> to NUMERIC or DECIMAL
           Example:  CONVERT(NUMERIC,CURRENT_DATE)
                     Returns:  59197

SQLCODE = -141
Invalid input value passed to the CONVERT function

  CONVERT(TimeStamp,'abc',131)

   WHERE %INTERNAL(%ID) = :value

   DATEPART("wk","2003-02-10")