Display Field - or 'table column' info to you SQL boys

Q: Tired of using the very unfriendly DSPFFD command to find out what is the layout of that pesky file?

A: Yes I am.

Solution: Use DSPFLD and glory at the beautiful GUI that shows you all the information you could possibly want to know about that pesky file. Pour yourself a nice cup of tea and mutter to yourself about all those wasted hours sifting through DSPFFD when you could have been using this.

                             Display Fields   (DSPFLD)                         
                                                                               
 Type choices, press Enter.                                                    
                                                                               
 File Name  . . . . . . . . . . .                 Name                         
   Library name . . . . . . . . .     *LIBL       Name, *LIBL, *CURLIB         
 Output Format  . . . . . . . . .   *             *, *PRINT, *OUTFILE          
 File to receive output . . . . .                 Name                         
   Output File Library  . . . . .     *LIBL       Name, *LIBL                  
 Member to receive output . . . .   *FIRST        Name, *FIRST                 
 Replace or Add to member . . . .   *ADD          *ADD, *REPLACE               
 System . . . . . . . . . . . . .   *LCL          *LCL, *RMT, *ALL             
 Remote location name . . . . . .                 Name                         
 Remote network ID  . . . . . . .   *NETATR       Name, *LOC, *NETATR, *NONE   
                                                                               
                                                                               
                                                                               
 F3=Exit   F4=Prompt   F5=Refresh   F12=Cancel   F13=How to use this display   
 F24=More keys                                                                 
                                                                               

So, almost every IBMi shop in the world has its own version of this command. This is my version. Obviously I think this one is the best because I wrote it and it has some useful little features that I like - search for field name, sequence by alphabetical field name, show all the logicals at the press of a button and a few others.

Suck it and see:

I'm not going to write anything else about this command. Because if you cant figure it out then you should be using IBMi at this level.

Nana-na-boo boo.