Documentation

esProc

Tutorial

Function Reference

Sample Program

Code Reference

User Reference

External Library Guide

Data File Tool Manual

DQL Tutorial

Cluster Server Manager Manual

SPL Command Executor Manual
YModel

User Reference

JSON-style Parameter Guide
Official Website

Data Type
Operators
Mathematical Functions
String Functions
Date/Time Functions
Sequence Functions
Table Sequence Functions
Loop Functions
Functions for Associative Operations
File-handling Functions
Database Functions
Cursor Functions
Statements
System- & interface-related Functions
Cluster Computing Functions
Chart-plotting Functions
External Library Functions

Alicloud

Cassandra

Multidimensional database

Dynamodb

ElasticSearch

Financial Functions

Ftp

Hbase

Hdfs

Hive

Influxdb

Informix

Kafka

Math

Mongo

R2dbc

Redis

Report5

Salesforce

Sap

Spark

Webcrawl

Webservice

Ymodel

Zip
Composite-Table-Related Functions
Simple SQL
Functions

#c

$(db)sql;…

${macroExp}

=expression

>statement

[a:b]

@

@x:…

A()

A.( x,… )

[a 1 ,…a n ]

abs()

acos()

acosh()

age()

align()

ali_open()

ali_close()

ali_query()

alter()

T.alter( F i ,…; F’ i ,… )

and()

append()

argpost

array()

asc ()

asin()

asinh()

atan()

atanh()

attach()

avg()

base64 ()

between ()

bi()

bits()

bits()

blob()

bool ()

break {a}

C

Cr()

calc()

call()

call path/spl( … )

calls path/spl( … )

callx()

cand()

canvas()

case()

ceil()

cellname()

ch.()

channel()

char()

chardetect()

charencode()

chi_p()

chi2inv()

chn()

clear

clipboard()

close()

cmp()

cor()

comabs()

comangle()

combin()

comconj()

comexp()

comimage()

commit()

compair()

complex()

comreal()

comsign()

comstr()

comunwrap()

concat()

conj()

conjx()

connect()

contain()

corskew()

cos()

cosh()

count()

cov()

covm()

create()

cs.()

cum ()

cursor()

date()

datederive()

dateinterval()

datetime()

day()

days()

decimal()

delete()

deq()

derive()

det()

diff()

digits()

directory()

dis()

dism()

dup()

dynadb._close()

dynadb.execute()

dyna_open()

dynadb._query()

dynadb.table()

E()

E()

elapse()

elasticnet()

end s

enum()

env()

eq()

error()

eval()

es_close ()

es_delete ()

es_export ()

es_head ()

es_open ()

es_get ()

es_post ()

es_put ()

execute()

exists()

exp()

export()

eye()

f@o(…)

Faccrint()

Faccrintm()

fact()

false

Fcoupcd()

Fcoups()

Fdb()

Fddb()

Fdisc()

Fduration()

fetch()

field()

file()

filename()

find()

Fintrate()

finv()

Firr()

fisher_p ()

float()

floor()

Fmirr()

fname()

fno()

Fnper()

Fnpv()

for

fork

format()

Fpmt()

Fprice()

Frate()

Freceived()

freq ()

Fsln()

Fsyd()

ftp_cd()

ftp_open()

ftp_close()

ftp_dir()

ftp_get()

ftp_mget()

ftp_mput()

ftp_put()

func()

Fv()

Fvdb()

Fyield()

get()

gcd()

goto C

group()

groupi()

groupn()

groups()

groupx()

hash()

hbase_close()

hbase_cmp()

hbase_filter()

hbase_filterlist()

hbase_get()

hbase_open()

hbase_rest()

hbase_scan()

hdfs_open()

hdfs_close()

hdfs_dir()

hdfs_download()

hdfs_exists()

hdfs_file()

hdfs_upload()

hdfs_write()

hive_open()

hive_close()

hive_cursor()

hive_execute ()

hive_query()

hosts()

hour ()

httpfile()

I()

i()

icursor()

icount()

id()

if

if()

ifa()

ifdate()

ifn()

ifnumber()

ifr()

ifstring()

ift()

iftime()

ifv()

ifx_close()

ifx_conn()

ifx_cursor()

ifx_listfrag()

ifx_savefrag()

ifx_setfrag()

ifx_takefrag()

import()

impute()

index()

inf()

influx_close()

influx_insert()

influx_open()

influx_query()

influx2_close()

influx2_delete()

influx2_open()

influx2_query()

influx2_rest()

insert()

int()

interval()

inv()

inverse()

invoke()

isalpha()

isdigit()

isect()

iselect()

islower()

isolate()

isupper()

iterate()

join()

joinx()

json()

jvm()

k()

k.sbs()

kafka_close()

kafka_commit()

kafka_offset()

kafka_open()

kafka_poll()

kafka_send()

key()

keys()

kmeans()

lasso()

lcm()

left()

len()

lg()

like()

linefit()

lineplan()

ln()

lock()

long()

lower()

m()

mae()

max()

maxp()

mcumsum()

mcursor()

md5()

median()

memory()

merge()

Mergex()

mfind()

mi()

mid()

millisecond()

min()

minp()

minute()

mmean()

mnorm()

mode()

modify()

mongo_close ()

mongo_open()

mongo_shell()

month()

movefile()

mul()

mse()

mstd()

msum()

mvp()

n.f( x )

name()

new()

news()

next{a}

nodes()

norm()

norminv()

not()

now()

ntile ()

null

number()

numnorm()

nvl()

o()

olap_close()

olap_open()

olap_query()

ones()

open()

or()

output()

p()

pad()

parse()

paste()

pca()

pdate ()

pearson()

penum()

periods()

permut()

pfind()

pi()

pivot()

pls()

pmax()

pmin()

polyfit()

pos()

power()

prior()

proc()

product()

property()

pseg()

pselect()

pseudo()

psort()

ptop()

push()

query()

r.( x )

r.F

r.F=x

r2dbc_close()

r2dbc_exec()

r2dbc_open()

r2dbc_query()

rand()

rands()

range()

range( s,e,k:n )

rank()

ranki()

rankm()

ranks()

record()

redis_close()

redis_command()

redis_open()

regex()

register()

remainder()

rename()

replace()

report_config()

report_exportDoc()

report_exportHtml()

report_exportPdf()

report_exportXls()

report_open()

report_run()

reset()

result

return xi

rgb()

ridge()

right()

rollback()

round()

run()

rvs()

s.sbs()

sap_client()

sap_close()

sap_cursor ()

sap_execute ()

sap_getparam ()

sap_table ()

savepoint()

se()

second()

segp()

select()

seq()

sert()

setenum()

sf_close()

sf_open()

sf_query()

sf_wsdlclose()

sf_wsdlopen()

sf_wsdlquery()

sf_wsdlview()

sg()

shift()

sign()

sin()

sinh()

size()

skew ()

skip()

sleep()

smooth()

sort()

sortx()

spark_open()

spark_close()

spark_cursor()

spark_query()

spark_read()

spearman()

split()

splserver()

sqlparse()

sqltranslate()

substr ()

stax_close ()

stax_open()

stax_cursor()

stax_query ()

sqrt()

step()

string()

sum()

svm()

swap()

switch()

syncfile( hs,p )

system()

T()

tarcorskew()

tan()

tanh()

time()

tinv()

to()

top()

total()

transpose()

trim()

true

try

ttest_p()

union()

update()

upper()

urlencode ()

v()

var()

web_crawl()

webhdfs()

words()

workday()

workdays()

write()

ws_call()

ws_client()

xjoin()

xjoinx()

xlscell()

xlsclose()

xlsexport()

xlsimport()

xlsopen()

xlswrite()

xml()

xor()

year()

ym_build_model()

ym_close()

ym_env()

ym_exec()

ym_importance()

ym_json()

ym_load_pcf()

ym_model()

ym_performance()

ym_predict()

ym_present()

ym_result()

ym_save_pcf()

ym_setparam()

ym_server_quit()

ym_statistics()

ym_target()

z()

zeros()

zip()

zip_add()

zip_close ()

zip_compress()

zip_del()

zip_encrypt()

zip_extract()

zip_open()

Intersection of sequences

Comparison operation

Hexadecimal long integer

Modulus

Concatenation of sequences

Arithmetic operations

Compound assignment

String

Alignment arithmetic operations

Difference between sequences

Union of sequences

Multiplication of sequences

Table sequence constant

Record constant

Loop functions

The writing rules for expression x in loop functions

Batch Computation

Identifier

Opposite Number

Empty Sequence

Assignment

Value Computation and Assignment

Escape Character

Logical Operations

Long Integer

Cell type

Code block type
Chart Elements

G .draw()

G.hlink

G .plot()

Chart Element Parameters

Previous | Next

isupper()

Read（698） Like（0） Label: upper case letter, boolean value,

Description:

Check if a string is composed of upper case letters.

Syntax:

isupper(string)

Note:

The function checks if the string string is composed of upper case letters. If string is an integer, look it up in the ASCII table to see if the correponding characters are in upper case.

Parameter:

String

String expression/numeric expression

Return value:

Boolean value

Example:

isupper("ADSFDGKJ")	true
isupper(85)	true
isupper("SDsdsSDAS")	false
isupper("8ASDS7")	false

Related function: