ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

Select statement in CL

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Select statement in CL

    just because
    PHP Code:
        /* change the current library to reflect company */   
                                                              
               
    SELECT                                         
               WHEN       COND
    (&CNUM '15'THEN(DO)         
               
    CHGCURLIB  CURLIB(LBIFIL)                      
               
    ENDDO                                          
               WHEN       COND
    (&CNUM '18'THEN(DO)         
               
    CHGCURLIB  CURLIB(LSNFIL)                      
               
    ENDDO                                          
               WHEN       COND
    (&CNUM '20'THEN(DO)         
               
    CHGCURLIB  CURLIB(HSAFIL)                      
               
    ENDDO                                          
               WHEN       COND
    (&CNUM '30'THEN(DO)         
               
    CHGCURLIB  CURLIB(PDMFIL)                      
               
    ENDDO                                          
               WHEN       COND
    (&CNUM '72'THEN(DO)         
               
    CHGCURLIB  CURLIB(GMCFIL)                      
               
    ENDDO                                          
               OTHERWISE  CMD
    (DO)             
               
    ENDDO                          
               ENDSELECT 
    KV
    I'm here to chew bubble gum and kick @#%@#%@#%.....and I'm all outta bubble gum !
    Yes I'm talking to you squirrel nuts.
Working...
X