Friday, June 13, 2014

Useful jBase Functions

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