Twenty years ago these are the kind of things you had to know to work on the old AS400 systems. I found these on an old dusty corner of my homeserver. Enjoy the trip down memory lane or to use old RPG lingo AS400NERD CABEQ ‘1’ START
How do you combine two record formats in RLU ?
How do you split record formats in RLU?
What is the use of SDA?
Screen Design Aid is used to create display files interactively.
How do you define overlapping fields in SDA ?
They can be defined through condition indicators.
Mention different ways of specifying user help.
Through SDA and Panel Group.
To which member type does help text for panel belong ?
Can Printer files be externally described or program described ?
What are the valid file operation codes for a PRINTER file ?
WRITE, OPEN, CLOSE, FEDO.
If you use INDARA keyword for a program-described PRINTER file, what will be the result ?
You will get run-time error.
What is PRTCTL, and where will you define it ?
The PRTCTL (Printer Control) option allows you to change forms control information and to access the current line value within the program for a program-described PRINTER file. PRTCTL option will be specified on a F specifications continuation line for the PRINTER file.
What is the function of RLU ?
To design & prototype a report.
What are the three types of keywords associated with printer file?
File level, Record level & Field level.
What are the three line types in RLU ?
Report line, Filler line & Sample line.
Which option number is used to invoke RLU ?
What are the different commands used in RLU ?
DR – Define Record, CLC – Change Line for Continuation, CLR – Change Line for Record, SD – Create Sample Data, VF – View Fields, NP – New Page, DC – Define Constants, DF – Define Fields, CF – Centre Fields & SP – Space Fields evenly.
What is the command used to invoke RLU ?
What are different record spacing keywords in RLU ?
SKIPA, SKIPB, SPACEA & SPACEB.
What is job description ?
A job is an unit of work on the AS/400. Jobs run in a subsystem using system resources viz. memory, disk, etc. A job can be either interactive or batch. For interactive jobs JOD in User profile is used and for batch jobs JOBD along with SBMJOB is submitted with an object type of job description is *JOBD. Job description is a set of characteristics that define how the system handles a job. It contains: Job queue (only for batch), job priority, printer to be used, OUTQ & its priority, time slice & run priority. If none of the above is specified the system used the default job description.
Define a sub system?
Sub system is an operating environment, defined by a sub system description. All user jobs are processed in the sub system. Eg.QBASE, QBATCH, QCTL, QINTER, etc. Sub system description defines the characteristics of a sub system. ROUTING ENTRY: Specifies the program to be called to control a routing step. WORK ENTRY: Source from which jobs can be accepted. WORK STATION ENTRY: Display stations from which users can log into the sub system.
Open query file [OPNQRYF]?
Open query file (OPNQRYF) selection can be on:
* Dynamic record selection
* Dynamic keyed sequence
* Dynamic join
* Unique key processing
* Group processing
* Final total processing
* Improve performance
Query access path will be implemented through the following objects
* CL program containing an OPNQRYF to open access path at runtime
* OS/400 physical file used to compile programs [dummy PF] used at runtime
* OS/400 logical file defines the key to OPNQRYF command
Override database [OVRDBF] ?
Override database [OVRDBF] lets to override the filenames or attributes of file selected when we compile/run program. Overrides can be used to change most of the attributes. To cancel the override database command we shall have to give delete override databases DLTOVR.
How do you pass numeric parameters for submit job?
Convert numeric parameters to character and pass, or.pass in hexadecimal format(x’0nf’ if ‘n’ contains odd number of digits x’nf’ if ‘n’ contains even number of digits)
IBM i Software Developer, Digital Dad, AS400 Anarchist, RPG Modernizer, Alpha Nerd and Passionate Eater of Cheese and Biscuits. Nick Litten Dot Com is a mixture of blog posts that can be sometimes serious, frequently playful and probably down-right pointless all in the space of a day. Enjoy your stay, feel free to comment and in the words of the most interesting man in the world: Stay thirsty my friend.
How to Install IBM Access Client Solutions (ACS)
IBM i Data Obfuscation – Making Data Foggy Murky and Squinty
How to rename Fresche (BCD) Presto Library – XL_PRESTO
What is AS400 modernization?
IBM i ACS 5250 EMULATOR FONT – and other ridiculous mumbo jumbo
IBM i SQL statement to convert or compare hundred year date format
How to compare ‘100 Year Date’ to a Timestamp – aka – Weird AS400 iSeries Date formats
Modernize AS400 iSeries Queries – Convert to IBM i SQL
Use IBM i SQL to validate email addresses in Customer Master File