iseries see what lf are tied to a pf
Ans: Application organisation. Ans: Bone/400 Version four, introduced a feature LPAR (Logical PARtitioning) which facilitates running multiple operating systems simultaneously on one IBM System i unit ensuring that one OS doesn't interfere other's system resources/retentivity. Ans:When we execute a command or call a program, the AS/400 must know where to discover the command or program and the respond is library. A Library is a collection of objects. QSYS is the only library that contains other library. QSYS is the root library where the entire user defined/ system defined library is created. System supplied libraries brainstorm with the letter "Q" or "#". Library list types: Organisation library: All IBM supplied library due east.thou. QSYS, QHLPSYS, QUSRSYS… Production Library: Whenever Ibm product is used it is added to the library automatically and is removed itself when the job completes. Electric current Library: Current library is the working library i.eastward. all the piece of work done by you is stored in current library. User Library: Non-IBM supplied i.east. created by the user. Ans: QSYS Ans: It's a user library. Ans: Past using the control DSPLIB. Example:DSPLIB IROBO1 It gives you the data of all objects that resides in the library with it size. Brandish Library Library . . . . . . : IROBO1 Number of objects . : 8 Type . . . . . . . . : PROD Library ASP number . : 1 Create authority . . : *EXCLUDE Library ASP device . : *SYSBAS Blazon options, press Enter. five=Display full attributes 8=Display service attributes Opt Object Blazon Attribute Size Text PRINT1PGM *PGM RPGLE 131072 rpgle plan for pri Business relationship *FILE PF 49152 ACCOUNT RELATED INFOR PRINT1 *FILE PRTF 4096 PRINTER DDS RLU GENER QCLSRC *FILE PF 8192 Sources CL-Programs QDDSSRC *FILE PF 8192 DDS-Sourcen QRPGLESRC *FILE PF 69632 QRPGLESRC2 *FILE PF 65536 QRPGSRC *FILE PF 8192 SOURCE PHYSICAL FILE Lesser F3=Exit F12=Cancel F17=Meridian F18=Bottom Ans: Source concrete file is a file which contains the sources of unlike types of objects. There can be up to 32768 members. Source physical file is an object. But the source member is non an object. When we compile the member, the object is created for that source. Command used is CRTSRCPF. CRTSRCPF FILE(IROBO1/QRPGSRC) RCDLEN(112) TEXT('SOURCE PHYSICAL FILE') Ans: By using the command shown beneath: DSPFD FILE(IROBO1/QRPGLESRC) Type(*MBRLIST) Ans: By using the command shown beneath: DSPFD FILE(IROBO1/QRPGLESRC) TYPE(*RCDFMT) Ans: By using the command below: CHGPF FILE(AMITNEM/OBJ) SRCFILE(AMINEM/QDDSSRC) SRCMBR(OBJ_SRC) We change the highlighted part to change the size of a file. Change Physical File (CHGPF) Type choices, press Enter. Physical file . . . . . . . . . Name Library . . . . . . . . . . . *LIBL Proper noun, *LIBL, *CURLIB System . . . . . . . . . . . . . *LCL *LCL, *RMT, *FILETYPE Source file . . . . . . . . . . *NONE Name, *NONE Library . . . . . . . . . . . Proper name, *LIBL, *CURLIB Fellow member size: Initial number of records . . *SAME one-2147483646, *NOMAX, *SAME Increment number of records . *Same 0-32767, *Aforementioned Maximum increments . . . . . . *SAME 0-32767, *Aforementioned Ans: For this we will use file level keywords FIFO/LIFO/FCFO in the physical file. FIFO: The duplicate key records will retrieved in offset in first out social club. Ans: below is an case, we are going to use the file REFER to get the field definition for new file. USE OF REFERENCE Columns . . . : ane 71 Browse AMINEM/DDSSRC SEU==> REFER FMT PF .....A..........T.Name++++++RLen++TDpB......Functions++++++++++++++++++ *************** Beginning of information ************************************* 0002.00 A R REF 0003.00 A RAC1 2P 0 COLHDG('LEVEL ID') 0004.00 A RAC2 3P 0 COLHDG('ORG Lawmaking') 0005.00 A RAC3 12P 0 COLHDG('Account NUM') 0006.00 A RAC4 3A COLHDG('Business relationship CURRENCY') 0007.00 A RPOSTCODE 2P 0 COLHDG('Mail service Lawmaking') 0008.00 A RCOUNTRY 3P 0 COLHDG('COUNTRY CODE') 0009.00 A RNAME 20A COLHDG('NAME') 0010.00 A RDATE 3P 0 COLHDG('Appointment') ****************** Finish of data **************************************** Now we tin can refer the file 'REFER' to take the field definition in the new file. Columns . . . : 1 71 Scan AMINEM/DDSSRC SEU==> USEREF FMT PF .....A..........T.Name++++++RLen++TDpB......Functions++++++++++++++++++ *************** First of data ************************************* 0002.00 A REF(REFER) 0003.00 A R USEREF 0004.00 A ACCLVL R REFFLD(RAC1 REFER) >>>>>> field proper name and 0005.00 ALIAS(ACC_LVL_ID) referred file proper name 0007.00 A ACCORG R REFFLD(RAC2 REFER) 0008.00 Allonym(ACC_ORG_CODE) 0009.00 A ACCNUM R REFFLD(RAC3 REFER) 0010.00 ALIAS(ACC_NUM) 0011.00 A ACCCUR R REFFLD(RAC4 REFER) 0012.00 ALIAS(ACC_CUR) 0013.00 A ACCNAME R REFFLD(RNAME REFER) 0014.00 Alias(ACC_NAME) ****************** End of data **************************************** Ans: It depends on the value that nosotros have set up for LVLCHK (Record format level cheque) attribute.If its value is *Yes then the record format level identifier is checked when the file is opened and if it doesn't friction match it throws the error. If its value is *NO, then the record format level identifier is non checked, hence no error. Ans: Logical file Ans: Logical file Ü Types of Logical file In that location are two types: 1)Non-join logical file 2)Join logical file ane) Non-join logical file Non-join logical files can either be a unproblematic logical file, which contains only ane record format or a multiple tape format logical file, which contains more than ane Record format. Logical files can exist derived from ane to 32 physical files and then a logical file tin can have a maximum of 32 record formats. i)Unmarried record format Non-join logical file: If a logical file is derived from unmarried physical file it is called uncomplicated logical file. Columns . . . : 1 71 Browse AMINEM/DDSSRC SEU==> MULTIFRMT FMT LF .....A..........T.Proper noun++++++.Len++TDpB......Functions++++++++++++++++++ *************** Kickoff of information ************************************* 0002.00 A R Business relationship PFILE(AMINEM/ACCOUNT) 0003.00 A K ACCOUNTNUM 0005.00 A K ACCURRENCY ü)Multiple record format Non-bring together logical file: Columns . . . : 1 71 Browse AMINEM/DDSSRC SEU==> MULTIFRMT FMT LF .....A..........T.Name++++++.Len++TDpB......Functions++++++++++++++++++ *************** Beginning of data ************************************* 0002.00 A R Account PFILE(AMINEM/Account) 0003.00 A K ACCOUNTNUM 0005.00 A Thou ACCURRENCY 0006.00 A R TRANS PFILE(AMINEM/TRANS) 0007.00 A Grand TACCOUNT 0008.00 A K TCURRENCY ****************** End of data **************************************** Ans: DYNSLT: Utilize this file-level keyword to signal that the selection and omission tests specified in the file (using select/omit specifications) are done at processing time. This keyword specifies dynamic select/omit rather than access path select/omit. Only a Concrete file contains data. Logical files but incorporate pointers for processing the data in a specific sequence and/or subset of data. Ans: Dynamic select occurs whenever the program reads file. Simply admission path occurs before the file is read (but non necessarily). Ans: JDUPSEQ This join–level keyword is used to specify the order in which records with duplicate bring together fields are presented when the JLF is read. The format for this keyword is: JDUPSEQ (Sequencing field-name [*DESCEND]) i) This keyword has no outcome on the ordering of records with unique keys. ü)If *DESCEND is non specified then the default is sequencing in ascending order. Bottom of Form Ans: JDFTVAL Ans: [teaserbox type="4" img="2803" title="Interested in Learning Devops" subtitle="Join Us at present!" link_url="http://www.mytectra.com/devops-training-in-bangalore.html" target="bare"] Ans: Ans:Record format field mapping (FMT) *MAP Fields with the same name in the from-file and to-file record formats are copied, and any fields in the to-file that practice not exist in the from-file format are set to the default value specified on the DFT keyword for the data description specification (DDS) of the to-file or nothing for numeric fields, blanks for graphic symbol fields, current date/time for date/time fields, or nada value for nothing-capable fields. If *MAP is specified, *DROP can likewise be specified. *Driblet This value must exist specified for field-level mapping if any of the field names in the from-file record format exercise not exist in the to-file format. If *Driblet is specified, *MAP can as well be specified. When *DROP is specified, all the field names that exist in both tape formats must have the same attributes and relative positions in the from-file and to-file tape formats, or *MAP must also exist specified. Null values are copied. *NOCHK If the tape formats of the database files are dissimilar, the copy functioning continues despite the differences. Record data is copied directly (left to right) from one file to the other. FMTOPT (*NOCHK) is required when copying all tape formats from a logical file with multiple formats (when RCDFMT (*ALL) is specified) to a physical file that is of the same type (source or data) as the from-file. *CVTSRC This value is used to copy between database files, from a source file to a information file, or from a data file to a source file. It is valid only when the from-file and to-file are different types (source and information). Ans: In CRTDUPOBJ for a logical file the created duplicate file will be also logical file and for a concrete file the created file will also be a concrete file. Even the record format identifier volition also be the same. While in case of COPYF, if we are copying a logical file then the created file be a concrete file not a logical file. Ans: Access path i) Admission path describes the order in which records are to be read. ii) Access paths can exist kept on the organisation permanently (such as physical or logical file) or temporarily. üi) OPNQRYF command may create a temporary access path for use one fourth dimension, and so discard the admission path. Ans: Types of Access Path i) Sequentially, where each record is taken from the next sequential physical position in the file. ü)Directly by relative records number, where the record number is identified past its position from the outset of the file. i) It is based on the contents of the central fields equally defined in DDS. This type of access path is updated in the contents of a key field is inverse. ü) There arethree ways of bounding the access path: Immediate Rebuild Delayed Ans:If y'all practise non specify the type of maintenance for a file, thedefault isfirsthand maintenance. Ans: Maximum no of fields included in a PF is 8000. Ans: Maximum no of parameter passed in RPG is 255. Ans: Maximum no of parameter passed in CL is forty. Ans: Compile fourth dimension array DIM() represents the size of the array. CTDATA() represents that it is compile time assortment. PERRCD() represents the number of entries in one assortment record. Dim = row i* col j e.g. PERRCD=2, NO. OF ROWS=three, Then DIM = PERRCD*NO. OF ROWS=6 [teaserbox blazon="4" img="2802" title="Interested IN Learning Hadoop through Experts!" subtitle="We are There to atomic number 82 You... to Excellence..." link_url="http://www.mytectra.com/hadoop-preparation-in-bangalore.html" target="blank"] Ans:Array is drove of elements of same data type. Types of Assortment ane) Compile time array 2) Pre-runtime array three) Run fourth dimension array Ans: Pre-runtime array length of record = Perrcd *size of ane element Ans: Data STRUCTURE Ans: Below are the types of data structures in as/400: Ans:A program condition data structure (PSDS) can be divers to brand program exception/mistake information bachelor to the program so that the necessary action can be taken for the unhandled exception. The exception /errors can beDivide by nothing, array index out-of-bound, Invalid Appointment, Time or Timestamp value. The PSDS must be defined in the main source section; therefore, there is simply one PSDS per module. Ans:A file information data structure (INFDS) can be divers for each file to make file exception/mistake and file feedback data available to the programme. Ans: Steps of creating the subsystem i)Create Subsystem description (CRTSBSD) First of all nosotros create subsystem description as below: CRTSBSD SBSD (AMINEM/MYSBSD) POOLS ((two *BASE)) MAXJOBS(2) TEXT('My subsystem description') ii)Create Job queue (CRTJOBQ) So we create a job queue as below: CRTJOBQ JOBQ (AMINEM/MYJOBQ) TEXT('My job queue') 3)Add Job Queue Entry (ADDJOBQE) Once the job queue is created, then we attach the (ADDJOBQE) command, every bit follows: ADDJOBQE SBSD (AMINEM/MYSBSD) JOBQ (AMINEM/MYJOBQ) MAXACT (one) MAXACT denotes the number of the jobs that can be procedure at the aforementioned time. 4)Create Class (CRTCLS) Class defines the run time aspect e.k. Run priority, Time slice, Default wait time, Maximum temporary storage etc. CRTCLS CLS(AMINEM/MYCLS) RUNPTY(40) five)Add Routing Entry (ADDRTGE) ADDRTGE SBSD(AMINEM/MYSBSD) SEQNBR(9999) CMPVAL(*ANY) PGM(SYS/QCMD) CLS(AMINEM/MYCLS) vi) Start Subsystem (STRSBS) STRSBS SBSD(AMINEM/MYSBSD) Ans: Compiler directive (one) /Gratis... /End-FREE (2) /TITLE (3) /Eject (4) /Infinite (v) /COPY or /INCLUDE (vi) /IF……/ELSEIF…. /ELSE…… /ENDIF (7) /EOF Ans: Data Queue Past using this command sent data same / another program. QSNDDTAQ PARM (QUEUE-Proper name LIB &LEN &DAT) By using this command receive data aforementioned /another program QRCVDTAQ PARM (QUEUE-NAME LIB &LEN &DAT &WAIT) Ans: Nosotros are using FTP in as400 to transport and receive data from/to remote organisation. Below are the basic FTP commands in the transfer: east.k. LCD Library-name LCD C:\binder\onpc\where\stuffis LCD "C:\Program Files" due east.g. CD Library-name CD C:\binder\onpc\where\stuffis CD "C:\Program Files" east.m. GET AMINEM/QRPGLESRC.DSPPGM This can be used to fetch relieve-file also: GET SAV005 If Member SAV005 in file SAV005 in library QGPL already exists. Specify Replace every bit a subcommand option equally shown beneath. Go SAV005 (Supervene upon e.yard. MGET aminem.* aminem1.* due east.thou. PUT RPGSRC.ADDCL RPGSRC11.ADDCL1 It is used to fetch multiple file from remote system, GENERIC IS ALLOWED. e.g. MGET aminem.* aminem1.* i)For working with standard library objects ü)File identifiers accept 3 components: Library, File and member. üi)Library and file components are separated by the / delimiter. four)File and fellow member components are separated by the . delimiter. v)Syntax: Library/file.member Example PUT something.txt QGPL/QCLSRC.Examination CD QGPL PUT something.txt QCLSRC.Test i)For working with IFS objects (ie. All objects) ü)Directory levels separated past the / delimiter. üi)Database files utilise format: /QSYS.lib/Libname.lib/Fname.file/Mname.mbr iv)Documents (files) stored in folders use format: /QDLS/folder/document.ext v)CD / (puts y'all in the root IFS folder) Ends the FTP session with the remote computer and exits ftp. Ends the FTP session with the remote computer and exits ftp. i) It Sets the file transfer way to ASCII (Notation: this is the default manner for most FTP programs) ü)ASCII is a character-encoding scheme originally based on the English alphabet. ASCII codes represent text in computers, communications equipment, and other devices that use text. Well-nigh modern character-encoding schemes are based on ASCII, though they support many additional characters. east.yard. ftp> ascii ftp> put d:\path1\filename1.txt 200 PORT control successful. Opening ASCII style information connectedness for filename1.txt 226 Transfer complete i) It Sets the file transfer mode to Binary ü) the binary way transfers all eight $.25 per byte and must exist used to transfer non-ASCII files or non-standard files e.g. zip file, tar file, paradigm file, .DAT file, save file, executable files, sound files, graphic files etc. e.g. ftp> binary ftp> put d:\path1\filename1.naught 200 PORT command successful. Opening BINARY style data connexion for filename1.cypher It volition transport an argument to the remote FTP Server. This statement is similar in purpose as the "LITERAL" statement. This parameter is used at the client organisation to transfer a part (via the LITERAL or QUOTE argument) to the host site. e.k. Nosotros tin change the naming format to 0 with the command as shown below. It opens a new FTP connection with some other organisation. e.g. Open system-name[teaserbox blazon="5" img="2803" championship="Interested in Learning IOT" subtitle="Join myTectra" link_url="http://www.mytectra.com/iot-grooming-in-bangalore.html" target="blank"] Ans: APYJRNCHG: Uses the journal entries to use changes that take occurred since a database file was saved or another specified fourth dimension. CHGJRN: Employ this command to change the attributes of a journal or to adhere new journal receivers to a periodical. CMPJRNIMG: This command compares and lists the difference between the earlier-prototype and afterward-image of a record, or between the current later-image of a record and the previous after-prototype of the record. CRTJRN: Use this control to create a journal. CRTJRNRCV: Utilize this command to create a journal receiver. DLTJRN: Use this command to delete a journal. DLTJRNRCV: Use this command to delete a journal receiver. DSPJRN: This control displays or prints the journal entries that are in the journal receivers associated with the specified periodical. This command has outfile back up so you can list the journal entries to a database output file for further processing or assay. DSPJRNRCVA: Use this command to display the attributes of a journal receiver. ENDJRNPF: This command ends journaling for the specified physical file. RCVJRNE: This command allows a specified user program to continuously receive periodical entries one at a fourth dimension as they are written to the journal. The beliefs is like to an exit program. RMVJRNCHG: Use this control to remove changes that have occurred to a database file from a specified indicate in time to some previous bespeak in time (allowed but if earlier-images were recorded during the time). RTVJRNE: Utilize this control to think a journal entry and place it in CL program variables. SNDJRNE: Use this control to write user-defined entries to a journal (i.e., journal receiver). STRJRNPF: Use this command to beginning journaling for the physical file. WRKJRN: This command displays a menu from which you lot can perform many journal-related functions, such every bit organization-assisted recovery of journaled files. WRKJRNA: This command displays the attributes of a journal and the associated receivers. Q1. What does 'Every bit' in AS400 stands for?
Q2. What is 'LPAR'?
Q3. What is library is AS400? What are the types of library?
Q4. Which library gets first loaded into the system when nosotros login?
Q5. Is QGPL a user library or organization library?
Q6.How tin nosotros run into all the objects and its sizes in a library?
Q7. What is source physical file?
Q8. How to come across all members of a file?
Q9. How to see all record formats used in a file?
Q10. How to modify the record size of a concrete file?
Q11. How can we adapt duplicate records in a file?
LIFO: The duplicate key records volition retrieved in last in first out order.
FCFO: The duplicate fundamental records will retrieved in first inverse first out society. Q12. How to refer another file to define a new field in a physical file?
Q13. Can LEVEL Cheque ERROR occur if we exercise CHGPF?
Q14. What is logical file in AS400? What are the types of logical file?
Q15. What is logical file in AS400? What are the types of logical file?
Q16. What is DYNSLT?
When a record is added/changed/deleted in a physical file, the system has to put a lock on information technology and then get out to bank check and update whatever logical files earlier it can release the lock. While the corporeality of time to exercise this is hardly measurable, it tin can be meaning if massive batch updates are done to a file.
If you are using the Select/Omit option in your DDS and using DYNSLT, the above process does not need to be done attape update fourth dimension.
Where this is beneficial is when your option procedure includes nearly all the records in the file. Now when yous process using DYNSLT, it volition read all the records in the file, but do the selection of which recordsto process at that time rather than having done all the maintenance ahead of time. Q17. What is the Difference between access path and Dynamic select?
Q18. What is the use of JDUPSEQ in AS400?
Q19. What is the employ of JDFTVAL in AS400?
Q20. What is the difference between non-join logical files and bring together logical files?
Non join logical file Join logical file Nosotros can insert or delete or update records using non-logical file. Insertion, updating or deletion of records is non possible in join logical files. DFU can be used to display non-join logical file. DFU is non available 1-32 tape format is specified Just 1 tape format can exist specified Commitment command is used Commitment command cannot be used. Q21. What is the difference betwixt physical file and logical file?
Concrete file Logical file 1. Occupies the portion of memory. It's containing information. Does not occupy any memory space. Does not contain any data. 2. A physical file contains one record format A logical file tin can contain up to 32 record formats. iii.Tin be exist even without LF Tin't exist without PF four. If you lot delete a LF, the PF tin't be deleted If you delete a LF, the PF tin't be deleted v.CRTPF command is used to create such object CRTLF command is used to create such type object Q22. What are the record format field mapping options in CPYF?
Q23. What is the Difference betwixt CRTDUPOBJ and COPYF?
Q24. What is admission path in AS400?
Q25. What are the types of access path? How to change the admission path of a file?
Q26. What is the default access path of a file?
Q27. What is the maximum number of fields that tin be in a file?
Q28. Maximum no of parameter passed in a RPG?
Q29. Maximum no of parameter passed in a CL?
Q30.What is compile fourth dimension array in AS400? Give instance of compile time array.
Q31. What is assortment in AS400? What are the types of array?
Q32.What is Pre run time array in AS400? Give example of Pre run fourth dimension assortment.
Q33. What is data construction in AS400? What is the use of data structure?
Q34 . What are the types of data structure in AS400? Requite example of data structure?
Q35. What is program status data structure(PSDS) in AS400? Requite example if PSDS.
Q36. What is file data data structure(INFDS) in AS400? Requite example if INFDS.
Q37. How tin we create subsystem in AS400?
Q38. What is compiler directive in AS400? Give instance of compiler directive.
Q39. What is data queue in AS400? Requite example of data queue.
Q40. What is FTP in AS400? What are the FTP commands in AS400?
Q41. What are the journaling commands?
Source: https://www.mytectra.com/interview-question/as400-interview-questions-and-answers
0 Response to "iseries see what lf are tied to a pf"
Post a Comment