quinta-feira, 21 de julho de 2011

Dicas de Classificação Arquivos Sequenciais - SORT / Definições

                                                                      
    FORMATOS:                                                                  
              BI  -  BINARIO, SEM SINAL                                        
                     HE O MAIS INDICADO, OTIMIZA TEMPO.                        
              CH  -  CARATER  EBCDIC, SEM SINAL                                
              PD  -  COMPACTADO DECIMAL (FIXED), COM SINAL                     
              AQ  -  CARATER EBCDIC, COM SEQUENCIA MODIFICADA.                 
                                                                               
    CLASSIFICACAO:                                                             
                                                                               
               A  -  ASCENDENTE                                                
               D  -  DESCENDENTE                                               
                                                                               
    COND:                                                                      
         EQ  -  NE  -  GT  -  LT  -  LE                                        
                                                                               
    OPERADOR:                                                                  
             & = AND                                                           
             | = OR                                                            
                                                                               
    OPCOES:                                                                    
                                                                               
           ALTSEQ CODE = (FFTT,FFTT,....,FFTT)                                 
                          FF = CARATER EM HEX QUE SE QUER MUDAR                
                          TT = CARATER EM HEX QUE DEVERA SER CLASS             
                          UTILIZADO PARA MUDANCA DE CARATER NA CLASS           
                          EX: QUERO CLASS TODO 9 COMO 0.                       
                                                                               
           INCLUDE COND = (P1,T1,F1,COND,|P2,T2,F2-OU CONST-|,(AND,OR,)        
           INCLUDE COND = (P1,T1,COND,|P2,T2-OU CONST-|,(AND,OR,)...)          
                                                                               
                           P1,P2 = POSICAO INICIAL DO CAMPO DO REGISTRO        
                           T1,T2 = TAMANHO DO CAMPO                            
                           F1,F2 = FORMATO DO CAMPO                            
                           COND  = CONDICAO DE COMPARACAO                      
                           CONST = CONSTANTE - PODENDO SER:                    
                                   - DECIMAL                                   
                                   - CARATER                                   
                                   - HEXADECIMAL                               
                           UTILIZADO PARA SELECIONAR OS REGISTROS QUE          
                           DEVERAO SER GRAVADOS NA SAIDA.                      
                                                                               
           OMIT    COND = (P1,T1,F1,COND,|P2,T2,F2-OU CONST-|,(AND,OR,)        
           OMIT    COND = (P1,T1,COND,|P2,T2-OU CONST-|,(AND,OR,)...)          
                                                                               
                           IDEM  INCLUDE                                       
                           UTILIZADO PARA NAO GRAVAR OS REGISTROS QUE          
                           SATISFACAM A CONDICAO.                              
                                                                               
           INREC  FIELDS=  (S,P,T,A,...S,P,T,A)                                
                                                                               
                           UTILIZADO PARA FORMATAR O REGISTRO DE ENTRA         
                           DA ANTES DA CLASSIFICACAO, PARA DIMINUIR A          
                           QUANTIDADE DE RECURSOS A SEREM UTILIZADOS,          
                           CASO NAO NECESSARIO A UTILIZACAO.                   
                           EX: O REGISTRO DE ENTRADA TEM 5K MAS SO SERA        
                               UTILIZADO 50 BYTES.                             
                                                                               
                                                                               
           OUTREC FIELDS=  (S,P,T,A,...S,P,T,A)                                
                                                                               
                            S = PARAMETRO OPCIONAL                             
                                (N)X - QTD DE BYTES A SEREM INCLUIDOS          
                                       COM BRANCOS.                            
                                                                               
                                (N)Z - QTD DE BYTES A SEREM INCLUIDOS          
                                       COM ZEROS.                              
                                                                               
                            P = PRIMEIRA POSICAO DO CAMPO A SER MOVIDO         
                            T = TAMANHO DO CAMPO                               
                            A = ALINHAMENTO DO CAMPO                           
                                H - HALFWORD                                   
                                F - FULLWORD                                   
                                D - DOUBLEWORD                                 
                                                                               
           SUM          =  FIELDS=(P,T,F,...P,T,F)                             
           SUM          =  FIELDS=(P,T,...P,T),FORMAT=F                        
           SUM          =  FIELDS=NONE                                         
                                                                               
                           FIELDS - INDICA OS CAMPOS NUMERICOS QUE             
                                    SERAO SOMADOS.                             
                           P      - PRIMEIRA POSICAO DO CAMPO                  
                           T      - TAMANHO DO CAMPO                           
                           F      - FORMATO DO CAMPO                           
                           NONE   - INDICA QUE DOS REGISTROS DUPLICADOS        
                                    APENAS UM DEVERA SER GRAVADO,              
                                    NAO SOMANDO OS REGISTROS.                  
                           SUM - ESPECIFICA QUE SEMPRE QUE FOREM ENCON         
                                 TRADOS REGISTROS COM A MESMA CHAVE            
                                 APENAS UM DEVERA SER GRAVADO, COM A           
                                 SOMATORIA DE TODOS OS IGUAIS.                 
                                                                               
           EQUALS       =  INDICA QUE OS REGISTROS IGUAIS DEVERAO PERMA        
                           NECER CLASS NA MESMA ORDEM DE ENTRADA.              
                           QUANDO DESNECESSARIO  NAO  USAR.                    
                           DEGRADA MUITO A UTILIZACAO.                         
                                                                               
           SKIPREC      =  NNNNNN                                              
                           DESPREZA REGISTROS DO INICIO DO ARQUIVO DE          
                           ENTRADA                                             
                                                                               
           STOPAFT      =  NNNNNN                                              
                           LIMITE DE REGISTROS PARA O ARQUIVO DE SAIDA         

Nenhum comentário:

Postar um comentário