Skip to main content
Previous section   

Caché MVBasic Supported Features

The tables in this document list the features of UniVerse Basic and their status in Caché MVBasic. There are two possibilities:

  • Present – This feature is implemented in Caché MVBasic.

  • Caché Alternative Exists – The feature is not supported, but much of this functionality is available in other ways in Caché.

Rows with neither column checked indicate that the development is still underway. If the word “reserved” appears in a column, it indicates that the term is a reserved word, but is not a statement or function in MultiValue Basic.

For a quick reference to specific items, use one of the following links:

Reserved Words By Initial Letter
Other Items

For full details, please refer to the Caché MVBasic Language Reference documentation.

MultiValue Basic Commands, Functions, and Reserved Words

MultiValue Basic - Reserved Words A...
Syntax Item Present Caché Alternative Exists
ABORTE X -
ABORTM X -
ABORT X -
ABS() X -
ABSS() X -
acceptConnection() - X
ACCESS() X  
ACOS() X -
addAuthenticationRule() - X
addCertificate() - X
addRequestParameter() - X
ADDS() X -
ALL X -
ALPHA() X -
amInitialize() - X
amReceiveMsg() - X
amReceiveRequest() - X
amSendMsg() - X
amSendRequest() - X
amSendResponse() - X
amTerminate() - X
analyzeCertificate() - X
ANDS() X -
AND X -
ARG X -
ASCII() X -
ASIN() X -
ASSIGN X -
ASSIGNED() X -
ATAN() X -
AUTHORIZATION - X
AUXMAP - X
MultiValue Basic - Reserved Words B...
Syntax Item Present Caché Alternative Exists
BCONVERT - X
BEFORE X -
BEGIN X -
BITAND() X -
BITNOT() X -
BITOR() X -
BITRESET() X -
BITSET() X -
BITTEST() X -
BITXOR() X -
BREAK X -
BSCAN X -
BYTE() X -
BYTELEN() X -
BYTETYPE() - X
BY X -
MultiValue Basic - Reserved Words C...
Syntax Item Present Caché Alternative Exists
CALCULATE() X -
CALLING X -
CALL X -
CAPTURING X -
CASE X -
CATS() X -
CAT X -
CENTURY.PIVOT() - X
CHAIN X -
CHANGE() X -
CHAR() X -
CHARLEN() - -
CHARS() X -
CHECKSUM() X -
CLEARCOMMON X -
CLEARDATA X -
CLEARFILE X -
CLEARINPUT X -
CLEARPROMPTS - -
CLEARSELECT X -
CLEAR X -
CLOSESEQ X -
closeSocket() - X
CloseXMLData() - X
CLOSE X -
COL1() X -
COL2() X -
COMMIT X -
COMMON X -
COMPARE() - -
COM X -
CONTINUE X -
CONVERT() X -
CONVERT X -
COS() X -
COSH() X -
COUNT() X -
COUNTS() X -
createCertification() - X
createCertRequest() - X
createSecureRequest() - X
createSecurityContext() - X
CREATE X -
CRT X -
MultiValue Basic - Reserved Words D...
Syntax Item Present Caché Alternative Exists
DATA X -
DATE() X -
DBTOXML() - X
DCOUNT() X -
DEBUG X -
DECLARE - X
DEFFUN X -
DELETE() X -
DELETELIST X -
DELETEU X -
DELETE X -
DEL X -
DESCRINFO() - -
DIAGNOSTICS - X
DIGEST() - -
DIMENSION X -
DIM X -
DIR() - -
DISPLAY X -
DISPLAYWIDTH() - -
DIV() X -
DIVS() X -
DOWNCASE() X -
DO X -
DQUOTE() X -
DROUND() - -
DTX() X -
MultiValue Basic - Reserved Words E...
Syntax Item Present Caché Alternative Exists
EBCDIC() X -
ECHO X -
ELSE X -
ENCODE() - -
ENCRYPT() - See class %SYSTEM.Encryption
END X -
ENTER X -
EOF(arg) X -
EQS() X -
EQUATE X -
EQU X -
EQ X -
EREPLACE() X -
ERRMSG X -
ERROR X -
EXCHANGE() - -
EXECUTE X -
EXEC reserved reserved
EXIT X -
EXP() X -
EXTRACT() X -
MultiValue Basic - Reserved Words F...
Syntax Item Present Caché Alternative Exists
FADD() X -
FDIV() X -
FFIX() - -
FFLT() - -
FIELD() X -
FIELDS() X -
FIELDSTORE() X -
FILEINFO() X -
FILELOCK X -
FILEUNLOCK X -
FIND X -
FINDSTR X -
FIX() X -
FLUSH X -
FMT() X -
FMTDP() - -
FMTS() X -
FMTSDP() - -
FMUL() X -
FOLD() X -
FOLDDP() - -
FOOTING X -
FORMLIST X -
FOR X -
FROM X -
FSUB() X -
FUNCTION X -
MultiValue Basic - Reserved Words G...
Syntax Item Present Caché Alternative Exists
GARBAGECOLLECT - X
GCI - X
generateKey() - X
GES() X -
GET(arg) X -
GET - -
getCipherSuite() - X
GETENV() X -
getHTTPDefault() - X
GETLIST X -
GETLOCALE() - X
GETPTR() X -
GETPU() X -
GETQUEUE() - -
GETREADU() - -
GETREM() X -
getSocketErrorMessage() - X
getSocketInformation() - X
getSocketOptions() - X
GETUSERGROUP() - -
GETUSERID() - -
GETUSERNAME() - -
GETX - -
GE X -
GOSUB X -
GOTO X -
GO X -
GROUP() X -
GROUPSTORE - -
GTS() X -
GT X -
MultiValue Basic - Reserved Words H...
Syntax Item Present Caché Alternative Exists
HASH() - -
HEADINGE - -
HEADINGN - -
HEADING X -
HUSH X -
MultiValue Basic - Reserved Words I...
Syntax Item Present Caché Alternative Exists
ICHECK() - X
ICONV() X -
ICONVS() X -
IFS() X -
IF X -
ILPROMPT() - -
IN X -
IN() - -
INCLUDE - -
INDEX() X -
INDEXS() X -
INDICES() X -
initSecureServerSocket() - X
initServerSocket() - X
INMAT() X -
INPUTCLEAR X -
INPUTDISP - -
INPUTDP - -
INPUTERR X -
INPUTIF X -
INPUTNULL - -
INPUTTRAP - -
INPUT X -
INPUTERR X -
INSERT() X -
INS X -
INT() X -
ISMB() - -
ISNULL() - -
ISNULLS() - -
ISMV() - -
ISNVS() - -
ISOLATION reserved reserved
ITYPE() X -
MultiValue Basic - Reserved Words K...
Syntax Item Present Caché Alternative Exists
KEYEDIT - -
KEYEXIT - -
KEYIN() X -
KEYTRAP - -
KEY X -
MultiValue Basic - Reserved Words L...
Syntax Item Present Caché Alternative Exists
LEFT() X -
LEN() X -
LENDP() - -
LENS() X -
LENSDP() - -
LES() X -
LET X -
LEVEL reserved reserved
LE X -
LISTUSER() - -
LITERALLY X -
LIT X -
LN() X -
loadSecurityContext() - X
LOCALEINFO() - X
LOCATE X -
LOCKED X -
LOCK X -
LOOP X -
LOWER() X -
LPTR reserved reserved
LTS() X -
LT X -
MultiValue Basic - Reserved Words M...
Syntax Item Present Caché Alternative Exists
MATBUILD X -
MATCHES X -
MATCHFIELD() - -
MATCH X -
MATPARSE X -
MATREADL X -
MATREADU X -
MATREAD X -
MATWRITEU X -
MATWRITE X -
MAT X -
MAXIMUM() X -
MBLEN() - -
MESSAGE reserved reserved
MINIMUM() X -
MOD() X -
MODS() X -
MTU reserved reserved
MULS() X -
MultiValue Basic - Reserved Words N
Syntax Item Present Caché Alternative Exists
NAP X -
NEG() X -
NEGS() X -
NES() X -
NEXT X -
NE X -
NO.ISOLATION - -
NOBUF X -
NOTS() X -
NOT() X -
NULL X -
NUM() X -
NUMS() X -
MultiValue Basic - Reserved Words O...
Syntax Item Present Caché Alternative Exists
OCONV() X -
OCONVS() X -
OFF X -
ON X -
OPEN X -
OPENCHECK - X
OPENDEV - -
OPENPATH X -
openSecureSocket() - X
OPENSEQ X -
openSocket() - X
ORS() X -
OR X -
OUT X -
MultiValue Basic - Reserved Words P...
Syntax Item Present Caché Alternative Exists
PAGE X -
PASSLIST X -
PCDRIVER - X
PERFORM X -
PRECISION X -
PrepareXML() - X
PRINT X -
PRINTER X -
PRINTERIO - X
PRINTERR - X
PROCREAD X -
PROCWRITE X -
PROGRAM X -
PROG X -
PROMPT X -
protocolLogging() - X
PWR() X -
MultiValue Basic - Reserved Words Q
Syntax Item Present Caché Alternative Exists
QUOTE() X -
MultiValue Basic - Reserved Words R...
Syntax Item Present Caché Alternative Exists
RAISE() X -
RANDOMIZE X -
READ.COMMITTED - -
READ.UNCOMMITTED - -
READBLK X -
READLIST X -
READL X -
READNEXT X -
READSEQ X -
readSocket() - X
READT - -
READU X -
READVL X -
READVU X -
READV X -
ReadXMLData() - X
READ X -
REAL() - -
RECIO - X
RECORDLOCKED() X -
RECORDLOCKL X -
RECORDLOCKU X -
ReleaseXML() - X
RELEASE X -
REM X -
REM() X -
REMOVE X -
REMOVE() X -
REPEATABLE.READ - -
REPEAT X -
REPLACE() X -
RESET X -
RETURNING X -
RETURN X -
REUSE() X -
REVREMOVE X -
REWIND - -
RIGHT() X -
RND() X -
ROLLBACK X -
RPC.CALL() - X
RPC.CONNECT() - X
RPC.DISCONNECT() - X
RQM X -
RTNLIST X -
MultiValue Basic - Reserved Words S
Syntax Item Present Caché Alternative Exists
SADD() X -
saveSecurityContext() - X
SCMP() X -
SDIV() X -
SEEK(arg) X -
SEEK X -
SELECTE X -
SELECTINDEX X -
SELECTINFO() X -
SELECTN X -
SELECTV X -
SELECT X -
SEND - -
SENTENCE() X -
SEQ() X -
SEQS() X -
SEQSUM - X
SERIALIZABLE - -
setAuthenticationDepth() - X
setCipherSuite() - X
setClientAuthentication() - X
setHTTPDefault() - X
SETLOCALE() - X
setPrivateKey() - X
setRandomSeed() - X
SETREM X -
setSocketOptions() - X
SETTING X -
SET - -
SETENV() - -
showSecurityContext() - X
SIGNATURE() - X
SIN() X -
SINH() X -
SLEEP X -
SMUL() X -
SOAP functions - X
SORT() X -
SOUNDEX() X -
SPACE() X -
SPACES() X -
SPLICE() X -
SPOOLER() X -
SQLALLOCENV - See the developer materials on Caché SQL
SQLALLOCONNECT - See above.
SQLALLOCSTMT - See above.
SQLBINDCOL - See above.
SQLCANCEL - See above.
SQLCOLATTRIBUTES - See above.
SQLCONNECT - See above.
SQLDESCRIBECOL - See above.
SQLDISCONNECT - See above.
SQLERROR - See above.
SQLEXECDIRECT - See above.
SQLEXECUTE - See above.
SQLFETCH - See above.
SQLFREECONNECT - See above.
SQLFREEENV - See above.
SQLFREESTMT - See above.
SQLGETCURSORNAME - See above.
SQLNUMRESULTCOLS - See above.
SQLPREPARE - See above.
SQLROWCOUNT - See above.
SQLSETCONNECT-OPTION - See above.
SQLSETCURSORNAME - See above.
SQLSETPARAM - See above.
SQRT() X -
SQUOTE() X -
SSELECTN X -
SSELECTV X -
SSELECT X -
SSUB() X -
START X -
STATUS() X -
STATUS X -
STEP X -
STOPE X -
STOPM X -
STOP X -
STORAGE - X
STR() X -
STRS() X -
submitRequest() - X
SUBROUTINE X -
SUBR() X -
SUBS() X -
SUBSTRINGS() X -
SUM() X -
SUMMATION() X -
SWAP X -
SWAP() - -
MultiValue Basic - Reserved Words T...
Syntax Item Present Caché Alternative Exists
TABSTOP - -
TAN() X -
TANH() X -
TERMINFO() - -
THEN X -
TIME() X -
TIMEDATE() X -
TIMEOUT - -
TO X -
TPARM() - -
TPRINT - -
TRANS() X -
TRANSACTION X -
TRIM() X -
TRIMB() X -
TRIMBS() X -
TRIMF() X -
TRIMFS() X -
TRIMS() X -
TTYCTL - X
TTYGET - X
TTYSET - X
MultiValue Basic - Reserved Words U...
Syntax Item Present Caché Alternative Exists
UNASSIGNED() X -
UNICHAR() X -
UNICHARS() X -
UNISEQ() X -
UNISEQS() X -
UNIT X -
UNLOCK X -
UNTIL X -
UPCASE() X -
UPRINT - X
USING X -
MultiValue Basic - Reserved Words W...
Syntax Item Present Caché Alternative Exists
WEOFSEQF - -
WEOFSEQ X -
WEOF - -
WHILE X -
WORDSIZE - X
WORKWRITE - X
WRITEBLK X -
WRITELIST X -
WRITESEQF X -
WRITESEQ X -
WRITET - -
WRITEU X -
WRITEVU X -
WRITEV X -
WRITE X -
MultiValue Basic - Reserved Words X...
Syntax Item Present Caché Alternative Exists
XDOM functions - X
XLATE() X -
XMAP functions - X
XML functions - X
XTD() X -

Conversion Codes

The MultiValue conversion codes listed in the following table can be used in various ways, including the following:

  • The MVBasic ICONV, ICONVS, OCONV, and OCONVS functions.

  • The MVBasic FMT and FMTS functions.

  • Implicit formatting with the MVBasic DISPLAY, CRT, and PRINT statements.

  • The CMQL query language CONV (or CONVERSION) clause.

  • The VOC Attribute 7 value.

For further details and program examples for individual conversion codes, refer to the ICONV and OCONV functions in the Caché MVBasic Language Reference.

MultiValue Basic Conversion Codes
Code(s) Present Description
A OCONV Arithmetic and equality functions
BB - Bit conversion (binary)
BX - Bit conversion (hexadecimal)
C OCONV Concatenation
D ICONV/OCONV Date conversion
DI ICONV/OCONV Internal date conversion
ECS - Extended character set conversion
F - Mathematical functions
G ICONV/OCONV Group extraction
L ICONV/OCONV Length function
MB - Binary conversion
MCA ICONV/OCONV Masked character alphabetic
MC/A OCONV Masked character exclude alphabetic
MCAX ICONV/OCONV Masked character to ASCII conversion
MCB ICONV/OCONV Masked character both alphabetic and numeric
MC/B OCONV Masked character exclude both alphabetic and numeric
MCD OCONV Decimal to hexadecimal conversion
MCDX ICONV/OCONV Decimal to hexadecimal conversion
MCL, MCU ICONV/OCONV Masked lowercase and uppercase conversion
MCM, MC/M - Masked multi- and single-byte conversion
MCN ICONV/OCONV Masked character numeric
MC/N OCONV Masked character exclude numeric
MCP OCONV Masked non-printable character conversion
MCT OCONV Masked initial capitals conversion
MCW - Masked wide character conversion
MCWX ICONV/OCONV Masked wide character to ASCII conversion
MCX ICONV/OCONV Hexadecimal to decimal conversion
MCXA ICONV/OCONV Character to 8-bit hexadecimal conversion
MCXD ICONV/OCONV Hexadecimal to decimal conversion
MCXW ICONV/OCONV Character to 16-bit (wide) hexadecimal conversion
MD ICONV/OCONV Masked decimal conversion
ML, MR ICONV/OCONV Masked left, right conversion
MM - NLS monetary conversion
MO - Octal conversion
MP - Packed decimal conversion
MT ICONV/OCONV Time conversion
MU0C - Hexadecimal Unicode character conversion
MX ICONV/OCONV Hexadecimal conversion
MY OCONV ASCII conversion
NL - NLS Arabic numeral conversion
NR - Roman numeral conversion
P OCONV Pattern-matching
Q - Exponential conversion
R OCONV Range function
S OCONV Soundex conversion
S;val;zeroval OCONV Substitution for non-zero values and zero values
T OCONV Text extraction
T<filename> - File translation
TI - International time conversion
U<hex> OCONV User exit to entrypoint <hex>. The specified entrypoint must be a hexadecimal number.
ZV OCONV Dynamic array element extraction

Compiler Directives

MultiValue Basic - Compiler Directives
Syntax Item Present Caché Alternative Exists
#INCLUDE X -
#PRAGMA X  
$CHAIN - -
$COPYRIGHT X -
$DEFINE X -
$EJECT - -
$IFDEF X -
$IFNDEF X -
$INCLUDE X -
$INSERT X -
$MAP - X
$PAGE - -
$UNDEFINE X -

For details, refer to “Compiler Directives” in the Caché MVBasic Language Reference.

System Variables (@ Variables)

MultiValue Basic - @-Variables
Syntax Item Present Caché Alternative Exists
@ABORT.CODE - -
@ACCOUNT X -
@AM X -
@ANS X -
@AUTHORIZATION X -
@COMMAND.STACK X -
@COMMAND X -
@CRTHIGH X -
@CRTWIDE X -
@DATA X -
@DATA.PENDING X -
@DATE X -
@DAY X -
@FALSE X -
@FILE.NAME X -
@FILENAME X -
@FM X -
@HDBC - -
@HSTMT - -
@ID X -
@IM X -
@ISOLATION - -
@LEVEL X -
@LOGNAME X -
@LPTRHIGH X -
@LPTRWIDE X -
@MONTH X -
@MV - -
@NB X -
@ND X -
@NI X -
@NS X -
@NULL.STR - -
@NULL - -
@NV X -
@OPTION - -
@PARASENTENCE X -
@PATH X -
@RECCOUNT X -
@RECORD X -
@SCHEMA - -
@SELECTED X -
@SENTENCE X -
@SM X -
@STDFIL X -
@SVM X -
@SYS.BELL X -
@SYSTEM.RETURN.CODE X -
@SYSTEM.SET X -
@TERM.TYPE X -
@TIME X -
@TM X -
@TRANSACTION.ID - -
@TRANSACTION.LEVEL - -
@TRANSACTION X -
@TRUE X -
@TTY X -
@UDTNO X -
@UID X -
@USER.NO X -
@USER.TYPE X -
@USER.RETURN.CODE X -
@USERNO X -
@USERn X -
@VM X -
@WHO X -
@YEAR4 X -
@YEAR X -

For details, refer to “System Variables” in the Caché MVBasic Language Reference.

String Extraction Operators

MultiValue Basic - String Extraction
Syntax Item Present Caché Alternative Exists
<> X -
[] X -

For details, refer to “Operators” in the Caché MVBasic Language Reference.