When you select Fields by Profile Search this screen is displayed:

 
 DC@P410008       Add FIELD Entry by Profile Search                    
                                                                       
 Run in Batch  YES     Enter Operation and Value/s for search criteria 
 Field name        _ _________                                       
 Description       _ ____________________________________            
 Field type        _ _____       Length   _      Decimals    
 Reference Field   _ _______ _______ _______ _______ ________
                      ________ _______ _______ _______ ________
 Label             _ _________       Col Hdg 1   _______________ 
 Col Hdg 2         _ ___________      Col Hdg 3   _______________
 O/P attribute     _ __ __ __ __ __ __ __ __ __ ___
 I/P attribute     _ __ __ __ __ __ __ __ __ __ ___
 Edit code         _        Edit word  _ ________________          
 Default      _ _______________ _______________ ________________ 
 value           ________________ _______________ ________________ 
                 ________________ _______________ ________________ 
                 _________________                                     
 Alias name        _ _________________          System field   __
 Prompt Pro/fun    _ ______ / _____                                
 Help Text         _ ________________________                        
 Rules/Trigger     _          _                    
 Last Action       _ ______ _  (YYYYMMDD Action)                   
                                                                       
 Fnn=Help  Fnn=Exit  Fnn=Cancel  Fnn=Messages                          
 

The Run in Batch option can be YES or NO. For details of Run in Batch see 5.14.9 Run Impact List searches in Batch.

Entries for Field Profile search:

Attribute

Operation

Value

Field name

EQ,= ,NE,blank
LK

blank, full or partial name
Pattern example:
%DATE%%%%%
_ MM _

Description

EQ,= ,NE,IN, blank


Field type

EQ,= ,NE,blank


Length

EQ,= ,GT,> , GE,>=,LT,< , LE,<=,NE,blank

must be numeric or blank

Decimals

EQ,= ,GT,> , GE,>=,LT,< , LE,<=,NE,blank

must be numeric or blank

Label

EQ,= ,NE,IN, blank


Col Hdg 1

EQ,= ,NE,IN, blank


Col Hdg 2

EQ,= ,NE,IN, blank


Col Hdg 3

EQ,= ,NE,IN, blank


Reference Field

EQ,= ,NE,LS, blank


O/P attribute

EQ,= ,NE,LS, blank


I/P attribute

EQ,= ,NE,LS, blank


Edit code

EQ,= ,NE,blank


Edit word

EQ,= ,NE,blank


Default value

EQ,= ,NE,LS, blank


Alias name

EQ,= ,NE,blank


System field

EQ,= ,NE,blank

blank, YES, NO

Prompt Pro/Fun

EQ,= ,NE,blank

The value consists of two parts, a Process and a Function. Possible combinations are : both blank (no search), both entered (search on Process and Function), Process entered with blank Function (search on Process only), Function entered with blank Process (search on Function only).

Help Text

EQ,= ,IN, blank


Rule/Trigger

EQ,= ,NE,LS, blank

blank, RV(range of values), LV(list of values), CF(file lookup), SL(evaluate expression),   CL(call program), DC(date check), TR(trigger)

Last Action

EQ,= ,GT,> , GE,>=,LT,< , LE,<=,NE,blank

The value consists of two parts, a date in YYYYMMDD format and an action. Possible combinations are: both blank (no search), both entered (search on date and action), date entered with blank action (search on date and any action).
Possible values for action: blank, AE(exported to IBM i), CI(checked in), CM(compiled), CO(checked out), CR(created), DI(Deliver To), IM(imported), MD(modified), WE(exported to workstation), MC (modified by checkin), MI (modified by import).

  • No labels