Here is the list of use Full jBase Functions.
@ | function | Cursor and screen manipulation. |
ABS | function | Returns absolute value. |
ABSS | function | Returns absolute value of elements in a dynamic array |
ADDS | function | Adds corresponding elements in two dynamic arrays. |
ALPHA | function | Returns Boolean result for alphabetic check. |
ANDS | function | Create a dynamic array of logical AND of corresponding elements from two arrays. |
ASCII | function | EBCDIC to ASCII conversion function. |
ASSIGNED | function | Returns Boolean result for variable assignment. |
BITAND | function | Performs a bitwise AND comparison of two integers. |
BITCHANGE | function | Toggles the state of the specified bit. |
BITCHECK | function | Returns the current value of the specified bit. |
BITLOAD | function | Assigns values in the local bit table. |
BITNOT | function | Returns the bitwise negation of an integer specified by a numeric expression. |
BITOR | function | Performs a bitwise OR comparison of two integers. |
BITRESET | function | Resets the value of the specified bit. |
BITSET | function | Sets the value of the specified bit. |
BITTEST | function | Tests the bit number of the integer specified by an expression. |
BITXOR | function | Performs a bitwise XOR comparison of two integers. |
BYTELEN | function | returns the length of the expression as the number of bytes rather than the number of characters. |
CALLONEXIT | function | specifies the name of a subroutine to call when the program terminates |
CATS | function | Concatenates corresponding elements in two dynamic arrays. |
CHANGE | function | Sub-string replacement. |
CHANGE | function | Adjust existing time stamp to return new timestamp value. |
CHAR | function | Returns the ASCII equivalent of a numeric expression. |
CHARS | function | Returns the ASCII equivalents of the numeric expressions in a dynamic array. |
CHDIR | function | Changes the current directory. |
CHECKSUM | function | Returns numeric checksum for the supplied expression. |
COL1 / COL2 | functions | Position determination subsequent to use of the FIELD function. |
COMPARE | function | Compares two strings. |
CONVERT | function | Converts a character string to another. |
COS | function | Returns the cosine of an angle. |
COUNT | function | Returns the number of times that one string occurs in another. |
COUNTS | function | Counts the number of times a substring is repeated in each element of a dynamic array. |
DATE | function | Returns the date in internal form. |
DCOUNT | function | Counts the number of elements in a string separated by a specified delimiter. |
DECRYPT | function | Decodes an encrypted string. |
DIR | function | Returns information about a file. |
DIVS | function | Divides corresponding elements in two dynamic arrays. |
DIV | function | Calculates the value of the quotient after division of the dividend by the divisor. |
DOWNCASE | function | Converts all uppercase characters in an expression to lowercase. |
DQUOTE | function | Encloses a value in double quotation marks. |
DROUND | function | Performs double-precision rounding on a value. |
DTX | function | Returns the hexadecimal representation of a decimal expression. |
DYNTOXML | function | Converts a dynamic array to XML. |
EBCDIC | function | Converts a string value from ASCII to EBCDIC. |
ENCRYPT | function | Encrypts strings. |
EQS | function | Tests if elements of one dynamic array are equal to the elements of another dynamic array. |
EREPLACE | function | Replace substring in an expression with another substring. |
EXP | function | Returns the mathematical constant e to the specified power. |
EXTRACT | function | Archaic method of extracting elements from a dynamic array. |
FADD | function | Performs addition on two floating point numbers. |
FDIV | function | Performs division on two floating point numbers. |
FIELD | function | Returns one or more delimited fields from a string. |
FIELDS | function | Returns a dynamic array of delimited fields from a dynamic array of strings. |
FILEINFO | function | Returns information on a specified file variable |
FMT | function | Formats a string to a specified pattern. |
FMTS | function | Formats the elements of a dynamic array for output. |
FMUL | function | Performs multiplication on two floating point numbers. |
FOLD | function | Re-delimits a specified string with attribute marks. |
FSUB | function | Performs subtraction on two floating point numbers. |
GES | function | Compares corresponding elements in two dynamic arrays. |
GETCWD | function | Returns the name of the current working directory. |
GETENV | function | Determines the value of the specified environment variable. |
GROUP | function | Returns one or more delimited fields from a string. |
ICONV | function | Converts data in external format to internal format. |
ICONVS | function | Converts elements of a dynamic array to internal format. |
IFS | function | returns a dynamic array whose elements are chosen individually from one of two arrays based on the contents of a third array. |
INDEX | function | Returns the position of a character or characters within another string. |
INDICES | function | Returns information about a file's secondary index. |
INMAT | function | Returns the number of dimensioned array elements. |
INSERT | function | Allows the insertion of elements into a dynamic array. |
INT | function | Truncates a numeric value to the nearest integer. |
IOCTL | function | Returns file information. |
ISALPHA | function | Checks that an expression consists entirely of alphabetic characters. |
ISALNUM | function | Checks that an expression consists entirely of alphanumeric characters. |
ISCNTRL | function | Checks that an expression consists entirely of control characters. |
ISDIGIT | function | Checks that an expression consists entirely of numeric characters. |
ISPRINT | function | Checks that an expression consists entirely of printable characters. |
ISSPACE | function | Checks that an expression consists entirely of space type characters. |
ISUPPER | function | Checks that an expression consists entirely of upper case characters. |
JBASECOREDUMP | function | Dumps a portion of the application to an external file for later analysis. |
KEYIN | function | Reads a single character from the input buffer and returns it. |
LATIN1 | function | Converts a UTF-8 byte sequence to it's Binary or Latin equivalent. |
LEFT | function | Extracts the first n characters from a string. |
LEN | function | Returns the character length of an expression. |
LENS | function | Returns a dynamic array of the number of bytes in each element of a dynamic array. |
LENDP | function | Returns the display length of and expression. |
LES | function | Determines whether elements of one dynamic array are less than or equal to the corresponding element in another dynamic array. |
LN | function | Returns the value of the natural logarithm of a supplied expression. |
LOCALDATE | function | Returns an internal date using the specified Timestamp and TimeZone combination. |
LOCALTIME | function | Returns and internal time using the specified Timestamp and TimeZone combination. |
LOWCASE | function | Converts all uppercase characters in an expression to lowercase. |
LOWER | function | Lowers delimiters in a string to their next lowest value. |
MAKETIMESTAMP | function | Generates a Timestamp using internal date, time and timezone. |
MAXIMUM | function | Returns the highest numerical value in a dynamic array. |
MATCHES | function | Allows pattern matching to be applied to an expression. |
MATCHFIELD | function | Checks a string against a match pattern. |
MINIMUM | function | Returns the lowest numerical value in a dynamic array. |
MOD | function | Returns the arithmetic modulo of two numeric expressions. |
MODS | function | Creates a a dynamic array from the remainder of the division of the elements in two dynamic arrays. |
MULS | function | Divides corresponding elements in two dynamic arrays. |
NEG | function | Returns the inverse of a value. |
NEGS | function | Returns the negative values for the elements of a dynamic array. |
NES | function | Determines whether the elements of one dynamic array are equal to the corresponding elements in another dynamic array. |
NOT | function | Inverts the Boolean value of an expression. |
NOTS | function | Returns a dynamic array of the logical complement of the elements of a dynamic array. |
NUM | function | Returns Boolean true if the supplied value is numeric. |
NUMS | function | Determines whether the elements of a dynamic array are numeric. |
OCONV | function | Converts data in internal format to external format. |
OCONVS | function | Converts the elements of a dynamic array to external format. |
ORS | function | Creates a dynamic array of the logical OR of the corresponding elements of two dynamic arrays. |
PUTENV | function | Sets environment variables for the current process. |
PWR | function | Raises a number to a specified power. |
QUOTE | function | Encloses a value in double quotation marks. |
RAISE | function | Raises delimiters in a string to their next highest value. |
RECORDLOCKED | function | Returns the status of a record lock. |
REGEXP | function | Pattern matching with regular expressions. |
REM | function | Returns the arithmetic modulo of two numeric expressions. |
REMOVE | function | Successively extracts delimited strings from a dynamic array. |
REPLACE | function | Archaic method of replacing elements in dynamic arrays. |
RIGHT | function | Extracts the last n characters from a string. |
RND | function | Generates a random number. |
SADD | function | Performs string addition. |
SDIV | function | Performs string division. |
SENTENCE | function | Returns the command used to invoke a program and the arguments it was given. |
SEQ | function | Returns the numeric ASCII value of a character. |
SEQS | function | Converts a dynamic array of ASCII characters to their numeric string equivalents. |
SIN | function | Returns the sine of an angle. |
SMUL | function | Performs string multiplication. |
SORT | function | Sorts a dynamic array. |
SOUNDEX | function | Converts strings to their phonetic equivalents. |
SPACE | function | Generates strings of spaces. |
SPACES | function | Generates a dynamic array with elements comprising of blank spaces. |
SPLICE | function | Creates a dynamic array from the element by element concatenation of two dynamic arrays. |
SPOOLER | function | Returns spooler information. |
SQRT | function | Returns the square root of a number. |
SQUOTE | function | Encloses a value in single quotation marks. |
SSUB | function | Performs string subtraction. |
STATUS | function | Determines cause of a file open failure. |
STOP | function | Program termination. |
STR | function | Performs string duplication. |
STRS | function | Generates a dynamic array containing the specified number of repetitions of each element of a dynamic array |
SUBS | function | Subtracts corresponding elements in two dynamic arrays. |
SUBSTRINGS | function | Returns sub-strings of elements from a dynamic array. |
SUM | function | Sums elements of a dynamic array. |
SYSTEM | function | Returns system information. |
SWAP | function | Sub-string replacement. |
TAN | function | Returns the tangent of an angle. |
TIME | function | Returns the current system time. |
TIMEDATE | function | Returns the current time and date. |
TIMEDIFF | function | Returns the interval between two timestamps as a dynamic array. |
TIMEOUT | function | Terminates a READBLK or READSEQ statement. |
TIMESTAMP | function | Returns a UTC timestamp as decimal seconds. |
TRANS | function | Retrieves a field from a file. |
TRANSQUERY | function | Used to determine if currently in a transaction. |
TRIM | function | Removes characters from a string. |
TRIMB | function | Removes trailing blanks. |
TRIMBS | function | Removes trailing spaces and tabs from elements of a dynamic array. |
TRIMF | function | Removes leading blanks. |
TRIMFS | function | Removes leading spaces and tabs from elements of a dynamic array. |
UNASSIGNED | function | Returns Boolean result for variable assignment. |
UNIQUEKEY | function | Returns a unique 16-byte character key. |
UPCASE | function | Converts all lowercase characters in an expression to uppercase. |
UTF8 | function | Converts a latin1 or binary string into the UTF-8 equivalent byte sequence. |
WRITEXML | function | Writes an XML record to a hashed file. |
XLATE | function | Retrieves a field from a file. |
XMLTODYN | function | Converts XML to a dynamic array. |
XMLTOXML | function | Transforms XML using an XSL |
XTD | function | Returns the decimal representation of a hexadecimal expression. |
No comments:
Post a Comment