IBM AS400 Interview Questions
Questions Answers Views Company eMail

What is the interactive job? What is the batch job? How to change the batch job to interactive job?

822

How to find the list of source physical files in a library?

861

How to change the batch job to interactive job?

772

What is open data path? And what is the difference between access path and open data path?

1 1441

How to retrieve a physical file after deleting that?

799

Suppose I have a pf,it contains 5 members,how to access particular member data from logical file ?and what is the use of member in pf?

851

What is the interactive job?

799

Can we concatenate fields in physical file? If yes how can we do?

819

What is the batch job?

786

How to know logical file belongs to which physical file without source?

1 1962

When we create a pf and did not fill up maint parameter, then by default which access path will the system take & why?

822

How can we know running job is batch or interactive?

899

What is the purpose of record level identifier?

926

Need a sql query: retrieve all duplicate records in table?

1 1952

What is the difference between iter and do?

973


Un-Answered Questions { IBM AS400 }

How to create a login screen using a command instead of display file.... intention is to get a password field on a command..... how do you achieve this...

1554


how will you find a string using pdm?

940


what the purpose of ovrdta, ovrata keywords?

1604


what are the different commands used in rlu ?

1974


how you will find an error which is not in the first page of the subfile without using rolldown key?

778


What is the interactive job? What is the batch job? How to change the batch job to interactive job?

822


Suppose we have one database file and it is used by 5 programs and in 3 program we have to add some records in datbase file s what is the impact on other program?

1701


how many printer files can be defined in f specs ?

1309


how do handle file exception/error?

899


what are the different types of variables available in cl?

1410


I have created a command that display Source file and library. Now i want that when i enter library name and press f4 on Source file, pgm should display all the PF- SRC's in that Library. For F4 option i have used Choice program but since only limited paramters are passed in Choice pgm i am not able to paas library name and further can't call a pgm that will display list of Source files. Below is the Code snippet for CMD type object :- CMD PROMPT('Source Scan for HUB Standard') PARM KWD(SOURCE) TYPE(*CHAR) LEN(1) RSTD(*YES) + VALUES(N A) MIN(1) + CHOICE('N,A') PARM KWD(SRCFILE) TYPE(FILE) RSTD(*NO) + PROMPT('SOURCE FILE') FILE: QUAL TYPE(*NAME) LEN(10) RSTD(*NO) EXPR (*YES) + CHOICE(*PGM) + CHOICEPGM (XXXXXLIB/YYYPGM) QUAL TYPE(*NAME) LEN(10) DFT(*LIBL) + SPCVAL((*LIBL)) EXPR(*YES) PROMPT ('Library') Below is the Choice pgm:- PGM PARM(&PARM1 &PARM2) DCL VAR(&PARM1) TYPE(*CHAR) LEN (21) DCL VAR(&PARM2) TYPE(*CHAR) LEN (2000) IF COND(%SST(&PARM1 1 10) = 'CHOICE ' *AND + %SST(&PARM1 11 10) = 'SRCFILE ' *AND + (%SST(&PARM1 21 1) = 'C' *OR %SST (&PARM1 + 21 1) = 'P')) THEN (DO) /* (%SST(&PARM1 21 1) = 'C' *OR %SST (&PARM1 + */ CHGVAR VAR(&PARM2) VALUE('Name, F4 for List') ENDDO IF COND(%SST(&PARM1 1 10) = 'CHOICE ' *AND + %SST(&PARM1 11 10) = 'SRCFILE ' *AND + %SST(&PARM1 21 1) = 'P') THEN (DO) CHGVAR VAR(&PARM2) VALUE('Name, F4 for List') CALL PGM(GTSQL) PARM ('XXXXLIB') return ENDDO Thanks in Advance for looking into.

3281


There is one string as A B C and wanted to display string as Shri A Shri B Shri C, how we can do this in sql? If we have around 100 values in string like this, each value should be displayed with initials as Shri.

981


define the purpose of the *bcat function?

1208


can you display a empty subfile?

1012


how to read database records without locking them?

1525