V5 Global Services Electrical Engineer Interview Questions and Answers

Sort two unsorted PS files into three different PS files with unique and common records.

• Use SORT utility to sort the two input files individually.

• Use JOINKEYS to join the two sorted files on a common key.

• Use OUTFIL to direct the output to three different files based on the record type.

• Ensure that the output files have unique records and common records as required.

To search a string from a ps file, use the grep command with the string and file name as arguments.

• Open the ps file in a text editor or use the command line to navigate to the file location.

• Use the grep command followed by the string you want to search and the file name as arguments.

• If the string is found, the command will return the line(s) containing the string.

• If the string is not found, the command will return noth...read more

Handling overflow condition of an array and backing up GDG versions in one step in JCL

• For overflow, check array bounds before accessing elements

• For SB37, increase primary/secondary space allocation

• For SD37, increase directory blocks

• For SE37, increase primary/secondary space allocation for PDS

• For S0C4, check for null pointers or uninitialized variables

• For S0C7, check for invalid data types or out-of-bounds array access

• T...read more

Equivalent of varchar(20) in COBOL and SQL error codes 805 and 922

• In COBOL, the equivalent of varchar(20) is PIC X(20)

• SQL error code 805 indicates program not found or not authorized

• SQL error code 922 indicates memory allocation failure

COBOL DB2 compilation process, CS vs RR, and Restart logic in COBOL program.

• COBOL DB2 compilation process involves precompilation, compilation, and linkage editing.

• CS (Change Strategy) and RR (Release Strategy) are two different methods of implementing DB2 changes.

• Restart logic in COBOL program is used to resume program execution from a specific point after an interruption.

• Restart logic can be implemented using checkpo...read more

Demonstrate joining duplicate records in tables using different types of joins.

• Inner join will only return the matching records (1,1 and 2,2) from both tables.

• Left outer join will return all records from Table1 and matching records from Table2 (including Null values).

• Right outer join will return all records from Table2 and matching records from Table1 (including Null values).

• Full join will return all records from both ...read more

SCD stands for Slowly Changing Dimensions. It is a technique used in data warehousing to track changes in data over time.

• SCD is used to maintain historical data in a data warehouse

• There are three types of SCD: Type 1, Type 2, and Type 3

• Type 1 SCD overwrites old data with new data

• Type 2 SCD creates a new record for each change and maintains a history of changes

• Type 3 SCD adds new columns to the existing record to track ...read more