IBM AS400 Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

RPG400 (448)
COBOL400 (67)
DB400 (96)
COOLPLEX (8)

IBM AS400 AllOther (736)

IBM AS400 Interview Questions

Questions Answers Views Company eMail

How to find d key field of a pf that doesn’t have source physical file?

2 7564

Write the subfile logic program for the given concept. Load the data to the subfile depends upon the designation where designation is not a key field?

TCS,

2 7608

What is the difference between inner join @ outer join

4 10161

Can anybody tell me the setps to create .csv file in IFS folder on AS/400. I also need to know how I can send this .csv file to PC in xls sheet.....?

2 9553

Difference between creating a report using Printer file and WRKQRY(Query Report) ?

3 12984

steps involved in debugging and types of debugging modes?

1 9007

steps for debugging two rpg programs????

4 12626

How to change the name of physical members Dynamically?

1 8232

Setps to create .csv file on IFS folder in AS/400( V4R3)....?

TCS,

3 13211

Anyone help me for the below question:- If problem/error occur in *PSSR subroutine,how should I handel it in RPG program.

1 6667

Please help me, I have created window subfile,I have created Footer with same lengh and postion of window SFL. When I call the pgm, first is shows only Footer and then it shows subfile records.This time Footer is not showsing ..plz hel me how can i do it...? Sameple DDS and RPG: A R WIN1 SFL A*%%TS SD 20090130 165346 MUNSHIJ REL-V4R2M0 5769- PW1 A FLD001 1Y 0B 4 3EDTCDE (Z) A ATFILE R O 4 7REFFLD (QWHFDBAS/ATFILE LIB/LIBF- A ILE) A R WINCTL SFLCTL (WIN1) A*%%TS SD 20090202 123459 MUNSHIJ REL-V4R2M0 5769- PW1 A ALTNAME ('y') A SFLSIZ (0004) A SFLPAG (0004) A WINDOW (FOOTER) A ROLLUP (27) A ROLLDOWN (28) A CF12 (12 'Cancel') A 50 SFLDSP A N51 SFLDSPCTL A 51 SFLCLR A 1 2'Select Option,Press enter' A 2 3'1= Select' A R FOOTER A* A WINDOW(8 31 9 43) A 8 4'F12 = Cancel' A R DUMMY ASSUME A 24 10' ' in RPG: Dow *IN12 = *Off Write Footer Fxfmt WInCTL

2 9716

parameters cannot be passed in which one??

CTS,

2 5703

in which journalling which attributes are necessary

CTS,

2 7195

what is post opcode do

CTS,

1 11186

how do u find whether a record is locked or not??

CTS,

4 14255

Un-Answered Questions { IBM AS400 }

What Does 'sr' In Columns 7-8 Of C Specs Mean?

1817

how can I give more performance to some selected pages?

1081

when would you prefer logical file than opnqryf?

2560

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.

3537

WHAT is STORED PROCEDURE CONCEPT IN AS400 WITH EXAMPLE?

2575

What is sort?

1021

what is a spool file?

1187

in conjunction with what other keyword must ovrdta and ovrata be used?

1611

What is a query can be displayed without saving it?

1135

how can I control from my cgis the cache of a remote browser?

1220

can you debug ile rpg program using isdb?

1332

How to handle duplicate error handling in RPG?

2347

when are the referential constraints executed?

1164

How to know the particular record in pf with out reading?

1111

what is the maximum number of parameters allowed in rpg?

1813

For More Un-Answered { IBM AS400 } Questions Click Here