Wednesday, 18 March 2009

AS400 Interview Questions

Some RAPID FIRE Questions ..

Q1. How to use signature in service program and ILE.?
Q2.what is use of signature and binder language and what is the relation between them?
Q.3 how to implement the commitment control.
Q.4 how to control commitment control from external program.
Q.5Can anybody please tell me what is difference between SQL (STRSQL ) and WRKQRY .....?
Q.6Write a logic program for knowing the repeated number of a vowels in a given program?
Q.7What is primary file? How many primary file can be declared in a RPG program?
Q.8What is left outer join?
Q.9 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?
Q.10 How can u create a temporary file in CLP @ how to access that temporary file in RPG program?
Q.11 How to know the number of records in a pf through clp program?
Q.12Suppose you have 3 members in a database file. How to read records from all the members Without using CL (OVRDBF) i.e. it should be handled exclusively in an RPG program?
Q.13 how we retrieve records without using key field (ex:name) from Physical File through RPG in as/400?
Q.14 Can anybody tell me, does CL/400 handle LEVEL check while running the CL program....? plz share your experience
Q.15 how we lock a pf???? what are the parameters used in this command.how we understand whether an object is locked or not?? using command .....we have to use *PSSR? and trough *status..how??.
Q.16How to check which are the pgms using 1 perticulate file.? I know there is many tool available for X-reference...but need to know is there any command available in the system...?
Q.17 what are the parameters of jobd?give in detail.&what are the parameters of subsystem...????
Q.18how do u find whether a record is locked or not??
Q.19 In which journalling which attributes are necessary??
Q.20what will happen two jobs have same name are submitted
Q.21 what is post opcode do ?
Q.21 How to change the name of physical members Dynamically?
Q.22 steps involved in debugging and types of debugging modes?
Q.23 Difference between creating a report using Printer file and WRKQRY(Query Report) ?
Q.24Write 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?
Q.25How to find d key field of a pf that doesn’t have source physical file?
Q.26Q. HOw can read multimember file through RPG/400 and CL/400 Actully i know that we can Read multimember file in RPG through EXEFILE and EXEMBR and in cl through OVRDBF and MEMBER(3)....But i want to read 3 members by CL Program And RPG/400 program.Please write the coding(Program) for both RPG/400 and CL/400 programs? 2.What are the full forms(stands) of EXEFILE and EXEMBR?
Q.27how to change job priority when it is running in sub system ?
Q.28how to check on which PF , the LF is dependant ?
Q.29Suppose one job is running in a batch mode for a long time now i want to kill this batch job. how you achive this?
Q.30 How to insert more than one record to a pf at a time?(Bulk insert to a pf)

& many more Coming Soon .....

31 comments:

  1. can u provide solutions for those question

    ReplyDelete
  2. It'll be nice if answers are also provided.

    ReplyDelete
    Replies
    1. If u want to know answers of all the above questions , share us ur email id and my email id @ anil.se400@gmail.com

      Delete
    2. Can you please send answers to lakshmikomatineni@gmail.com

      Delete
    3. HI Anil,

      Please help to share the answers at:
      arora.deepgagankaur@gmail.com
      Thanks

      Delete
    4. Hi Anil,
      Please share answers at swekrishiseries@gmail.com

      Delete
  3. Hi this is Anil, if any one wants To Know the answers of all above questions,just
    Share with me ur email id"s, my email add : anil.se400@gmail.com

    ReplyDelete
    Replies
    1. This comment has been removed by the author.

      Delete
    2. Can u please send answers for the above questions to dilu.29670@gmail.com

      Delete
    3. hey anil ,please share the answers of the above questions my email-id is pswapnali2008@gmail.com

      Delete
    4. Can u please send me answers for the above questions to atulccna12@gmail.com

      Delete
  4. anil please send answer of these question on my mail id
    sumitporwal26@gmail.com

    ReplyDelete
  5. This comment has been removed by the author.

    ReplyDelete
  6. Anil, pls snd the answers to sujanindian@yahoo.co.in

    ReplyDelete
  7. Could you plz send in d answers to sharma.r.ipsita@gmail.com

    ReplyDelete
  8. Hi Anil,Pls send me the answers mishraji996@gmail.com

    ReplyDelete
  9. anil please send answer of these question on my mail id dilu.29670@gmail.com

    ReplyDelete
  10. Anil,

    Please share the answers with me!

    dbarakos@gmail.com

    Thanks,
    Dennis

    ReplyDelete
  11. This comment has been removed by the author.

    ReplyDelete
  12. This comment has been removed by the author.

    ReplyDelete
  13. anil could you please share your answers to this mail id baluas400@gmail.com

    ReplyDelete
  14. anil could u plz share answers to my mail id rowf.abdul@gmail.com

    ReplyDelete
  15. Please share answers to my mail id lakshmigora@gmail.com

    ReplyDelete
  16. Hi, please share the answers of the above questions.
    my email-id is yuvi87raja@gmail.com

    ReplyDelete
  17. Please share answers to my mail id avdhesh1472@gmail.com

    ReplyDelete
  18. please share ans to my mail id:manijaya1989@gmail.com

    ReplyDelete
  19. please share ans to my mail id:sivanagarajuchilakala@gmail.com

    ReplyDelete
  20. Can you share answers in as4003@gmail.com Thank you.

    ReplyDelete
  21. Can you also share the answer to me. senod_hpesoj@yahoo.com

    ReplyDelete
  22. Please send the answers of above questions on sachinarya@live.com

    ReplyDelete