Kaillou, Forum AS400

Forum AS400 et de discussions


    Mémo AS/SET (SSAA)

    Partagez
    avatar
    Shewolf
    Admin

    Nombre de messages : 190
    Localisation : 91 idf
    Emploi : Analyste Réalisateur / Chef de Projets

    Mémo AS/SET (SSAA)

    Message par Shewolf le Jeu 29 Nov - 13:27

    Lancement : STRADK

    Les Fonctions prédéfinies:

    Code:
    Short Long
    Name Name Description

    %AAV %ARRAY_AVERAGE Find Average of Array
    %ABS %ABSOLUTE Absolute Value
    %ALE %ANTILOGE Natural Antilogarithm
    %ALK %ARRAY_LOOKUP Lookup Array
    %ALO %ANTILOG10 Common Antilogarithm
    %AMI %ARRAY_MINIMUM Find smallest element
    %AMX %ARRAY_MAXIMUM Find largest element
    %APP %APPEND Append String
    %APR %ARRAY_PRODUCT Find product of Array
    %ASU %ARRAY_SUM Find Sum of Array

    %AVE %AVERAGE Average
    %BCT %BLANK_CONCAT Concatenate with blanks
    %CAP %CAPITALIZE Capitalize
    %CEI %CEILING Ceiling
    %CHG %CHANGE Change Field
    %CIN %COND_INVERT Conditional Invert
    %CJL %CENYR_JULIAN CENTURY JULIAN
    %CLF %CURSOR_LOC_FLD Cursor Location on Field
    %CMD %CENYR_MONTH_DAY CENTURY MONTH DAY
    %CON %CONCATENATE String Concatenation
    %COS %COSINE Cosine
    %COT %COTANGENT Cotangent
    %COU %COUNT Count
    %CRR %CURRENT_REL_RCD Current Relative Record Number
    %CSC %COSECANT Cosecant
    %CSL %CURSOR_LOCATION Check cursor location
    %CTC %CONVERT_TO_CHARACTER Convert Numeric to Character
    %CTD %CONVERT_TO_DATE Convert number of days to a date
    %CTN %CONVERT_TO_NUMBER Convert Character to Numeric
    %DEV %DEVIATION Standard Deviation
    %DMC %DAY_MONTH_CENYR DAY MONTH CENTURY
    %DMY %DAY_MONTH_YEAR Convert Date to DMY format
    %ET1 %END_TRANSACTION1 End Transaction1
    %ET2 %END_TRANSACTION2 End Transaction2
    %FDC %FIELD_DECIMALS Field Decimals
    %FLN %FIELD_LENGTH Field Length
    %FLR %FLOOR Floor
    %FRN %FILE_RCD_NUM File Relative Record Number
    %GIX %GET_INDEX Get Index
    %GPR %GET_PAGE_RECORD Get Page Record
    %GTM %GETMSG Get Message
    %HIG %HIGH Return Highest Value
    %HRN %HIDDEN_RCD_NUM Hidden Relative Record Number
    %IMC %IMAGE_CHANGED Image Changed
    %INV %INVERT Invert
    %JUL %JULIAN Convert Date to Julian format
    %LCK %LOCK Detect Record Lock
    %LEN %LENGTH Calculate Length of String
    %LGE %LOGE Natural Logarithm
    %LJF %LEFT_JUSTIFY Left Justify
    %LOG %LOG10 Common Logarithm
    %LOW %LOW Return Lowest Value
    %LRC %LAST_RECORD Last file record
    %LRR %LAST_REL_RCD Last Relative Record Number
    %LWC %LOWER_CASE Convert to Lowercase
    %MAX %MAXIMUM Maximum
    %MDC %MONTH_DAY_CENYR MONTH DAY CENTURY
    %MDY %MONTH_DAY_YEAR Convert date to MDY format
    %MEA %MEAN Calculate Mean
    %MIN %MINIMUM Minimum
    %MVA %MOVE_ARRAY Move Array
    %NOD %NUMBER_OF_DAYS Convert date to number of days
    %OLN %OVF_LINE_NUM Overflow line number
    %OVF %OVERFLOW Overflow
    %PCT %PERCENT Percent
    %PDF %PERCENT_DIFFERENCE Percent Difference
    %PGS %PAGE_SIZE Subfile Page Size
    %POW %POWER Exponentiation
    %PRN %PRINT_LINE_NUM Print Line Number
    %PRO %PRODUCT Calculate Product
    %REM %REMAINDER Calculate Remainder
    %RJF %RIGHT_JUSTIFY Right Justify
    %ROU %ROUND Round
    %RRS %ROUND_RESULT Round Result
    %SEC %SECANT Calculate Secant
    %SIG %SIGN Determine Sign
    %SIN %SINE Calculate Sine of Angle
    %SQU %SQUARE_ROOT Calculate Square Root
    %STS %STATUS Determine success of File keyword
    %ST1 %START_TRANSACTION1 Start Transaction1
    %ST2 %START_TRANSACTION2 Start Transaction2
    %SUB %SUBSTRING Select Substring
    %SUM %SUM Calculate Sum
    %TAN %TANGENT Calculate Tangent
    %TOT %TOTAL Accumulate Total
    %TRU %TRUNCATE Truncate
    %UND %UNDEFINED Undefined
    %UPC %UPPER_CASE Convert String to Uppercase
    %YMD %YEAR_MONTH_DAY Convert Date to YMD format
    %ZER %ZERO Convert negatives to zeros
    avatar
    Shewolf
    Admin

    Nombre de messages : 190
    Localisation : 91 idf
    Emploi : Analyste Réalisateur / Chef de Projets

    Re: Mémo AS/SET (SSAA)

    Message par Shewolf le Jeu 29 Nov - 13:31

    Code:
    Opérateurs (K)

     
    CALL      Call Program               
    CLOSE      Close Database File       
    COMMIT    Commit Changes             
    DELETE    File Record Delete         
    DO        Conditional Processing     
    DOU        Conditional Processing     
    DOW        Conditional Processing     
    ELSE      Conditional Processing
    END        End Statement                 
    EXECSQL    EXECUTE SQL STATEMENT         
    EXSUBR    Execute User subroutine       
    EXTPGM    Exit Program                 
    GETDTAA    Get Data Area                 
    GETREC    File record, single record   
    GOTO      Unconditional Branch         
    IF        Conditional Processing       
    OPEN      Open Database file           
    PGMBEGACT  Actions at start of program 
    PGMENDACT  Actions at end of program   
    PGMERRACT  Program Error Actions       
    PRINT      Print                       
    PRTGRP    Print Group                 
    RETURN    Exit Program       
    RLSDTAA    Release Data Area   
    RLSREC    Release Record Lock 
    ROLLBACK  Rollback Changes   
    SETGT      File Positioning   
    SETINDEX  Set Index           
    SETLL      File Positioning   
    SORTA      Sort Array           
    TAG        Reentry point for GOTO
    UPDATE    File record update   
    UPDDTAA    Update Data Area     
    WRITE      File record write 

      La date/heure actuelle est Sam 23 Sep - 2:13