Technology Questions

PHP: Hypertext Preprocessor is open source server-side scripting language that is widely used for web development. PHP scripts are executed on the server. PHP allows writing dynamically generated web pages efficiently and quickly. The syntax is mostly borrowed from C, Java and perl. PHP is free to download and use.

main() method is called by the JVM even before the instantiation of the class, hence it is declared as static.

UNION selects only distinct values whereas UNION ALL selects all values and not just distinct ones

Customer Information Control System (CICS) is an online transaction processing monitor from IBM that acts as an interface between the operating system and application programs to provide rapid high-volume online transaction processing.

DB2 use the multiple indexes to satisfy multiple predicates in a SELECT statement that are joined by an AND or OR.

PCT (Program Control Table) - Defines each transaction containing a list of valid transaction identifiers (transid) where each transaction is paired with its matching program.

PPT (Program Processing Table) - Contains a list of valid program names and maps and whether a current version is in the CICS region or needs to be brought in as a new copy.

FCT (File Control Table) - Contains a list of files known to CICS, the dataset name and status (closed/open, enable/disabled)

TCT (Terminal Control Table)- A list of the terminals known to CICS.