IBM AS400 Interview Questions
Questions Answers Views Company eMail

Why we cannot call a service program? If I add a PEP can i call the service program?

DELL,

1 6734

1. How can I create a LF using crtlf command based on a particular member in a multimember PF? Where I have to specify the member name? 2. How to differentiate between the types of join from a Join logical file DDS. Is it possible to have different types of Join Logical files? 3.Any performance difference between Opnqrf and Embedded SQL? When I should prefer Opnqryf and when SQL? 4. I know access path is the path chosen by the program to retrieve data. It can be of keyed access path or arrival sequence. *IMMED- *IMMED description says access path is updated each time record is added or deleted from a member. - What is updating here? *REBLD - The access path is completely rebuilt each time a file member is opened. The access path is maintained until the member is closed, then the access path is deleted. - I am not able to understand this completely. Could anyone explain these more clearly? 5.What is the purpose of using activation group. I know it is a resource allocator, but other than this any other benefits of using an activation group?

IBM,

2 10069

1.Suppose my file has 10 fields and I want to make the 2nd field Zeros in all records. And assume I have millions of records and I dont want to read each record and update the desired field with 0. Any other way to do this in one step operation? 2. Assume my file has 100 records and I want to see only first 10 records. Is this possible through LF? 3.I have 3 jobs A B and C. I want to submit B after successful completion of A and want to submit C after successful completion of B. Without using job scheduler or job queue, how can i do that through CL program? 4.What is difference between Bind by copy and bind by reference?

Virtusa,

4 9498

1. If my rpg program has a date field, What extra care I have to take while compiling that RPG program? 2. If the file is keyed and I have declared the file as well as Key list properly in my program. Still am getting an error message like "Chain/reade operation is not allowed" What may be the case?

Virtusa,

6 9537

WHAT IS MENT BY RECORD LEVEL IDENTIFIER ? WHAT IS THE PURPOSE OF THIS?

1 6760

WHAT IS MEANT BY SIGNATURE VAILOTION ERROR

IBM,

1 5705

Need a sql query: retrive all duplicate records in table

3 10008

how can we know running job is batch or intractive ? i need all the possibilites.........plz help me

HSBC, IBM,

3 8599

can any one help in hawkeye and turnover or any change management system plzzzzz or send the documents to my mail id :gvsp.as4@gmail.com

1973

what is importance of 'MAPFLD' IN OPNQRYF FILE ?

2 9626

this is rpg3 code W0RTN IFEQ @CN,002 what is the means @CN,002

1 4520

without logical file we cannot access the data in physical file.but we specify physical file in the program(ie:- Ffile IF E k disk).how can it be accessed?

HSBC, TCS,

3 8324

while i am using the dspmsg command on comman line in Mocha am getting error like Not authorized to message queue message my messagequeue Name? can anybody help me how to change my message queue Am anable to see my messages in message queue

1 2538

how to know total no of records in pf with out using sql??????

3 11420

Errors in Sql query will be in which state?

1 4655


Un-Answered Questions { IBM AS400 }

which are the string manipulation opcodes?

635


thanks mr.Harshad R Suryawaunshi,i'm new to as400 i think you are telling in rpgile i know only rpg400 if possible can you tell in rpg400

1898


Please tell me how to read the records from a file with load an array of size with error conditions(The logic answer for this question is ARR is array of 99 elements Z-ADD 0 IDX *LOVAL SETLL FILE READ FILE 99 *IN99 DOWEQ *OFF IDX ANDLT 99 ADD 1 IDX MOVE FIELD ARR,IDX READ FILE 99 ENDDO).So,Please give me the complete of this code.

2056


if we tried to move year part of *iso date into a field of length 3, what will happen ?

658


How to index LF by relative record no (RRN)

2833






How to Define a Procedure in RPG?

1226


how to pick up the changed records every time in a subfile after the first change made ?

1023


How to convert a spool file to PDF file in AS400?

741


How to select highest score of each subject or how to select highest income of every month?

1299


How can we override a file during runtime in rpg?

690


How Chain operation copies the record's data to the input buffer for the program?

1084


what is maximum number of arrays allowed in rpg?

1189


what is message subfile?

1053


which of the cl command can be used to determine which logical files are dependent on a specific file?

595


What is diff between EVAL & MOVE?

976