AS400 Interview Questions • AS400 Question Bank

<div dir="ltr" style="text-align: left;" trbidi="on"><div class="separator" style="clear: both; text-align: center;"><h2 style="clear: both;"><span style="font-size: large;">AS400 Interview Questions • AS400 Question Bank</span></h2><div class="separator" style="clear: both;"><br /></div><div class="separator" style="clear: both;"><br /></div><h3 style="clear: both;"><span style="font-size: large;">AS-400, AS400 iSeries Interview Questions and Answers,Mainframe AS-400 Interview Questions and Answers</span></h3></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiPdiS_unrBlFtRjqXAjDC9YAoLelAxHhRsr-uZubs4kzBS-pIZfVYH6LHeiRdtKJ_WAW-y6GSXMLv0jyWN17wBgqNzAVqzcz60RHNpnP3-gT6XHk0XC7tAvYdaLEsSBlrildOeVtOCV2Y/s1600/as400_questions_answers.jpg" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="213" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiPdiS_unrBlFtRjqXAjDC9YAoLelAxHhRsr-uZubs4kzBS-pIZfVYH6LHeiRdtKJ_WAW-y6GSXMLv0jyWN17wBgqNzAVqzcz60RHNpnP3-gT6XHk0XC7tAvYdaLEsSBlrildOeVtOCV2Y/s1600/as400_questions_answers.jpg" width="320" /></a></div><br /><br /><span style="font-size: large;"><b>What the purpose of the keywords FIFO, LIFO, FCFO?</b><br />Ans: These keywords are used at file level. The purpose of each one is described below:<br />FIFO: The duplicate key records will retrieved in first in first out order.<br />LIFO: The duplicate key records will retrieved in last in first out order.<br />FCFO: The duplicate key records will retrieved in first changed first out order.<br /><br /><b>Why is AS/400 called an Object Oriented Machine ?</b><br />Ans: Everything on the AS/400 system that can be stored or retrieved is contained in an Object. Object exist to make users independent of the implementation techniques used in the machine.<br /><br /><h3 style="text-align: left;">Join logical file in as400 • Field Reference file in as400</h3><br /><b>What is the difference between regular logical file and join logical file?</b><br />Ans: Regular logical file contains more than one record format.<br />Record format name in regular logical file should be same based on the physical file.<br />Join logical file contains only one record format.<br />Record format name in join logical file should be different.<br />Through logical file we can made changes in physical file.<br />Through join logical file we can't made changes in physical file.<br /><br />Distinguish between logical file and physical file?<br />Ans: Physical file contains only one record format.<br />Logical file contains more than one record format.<br />Physical file contains actual data.<br />Logical file doesn't contains data but it provides view from the physical file.<br /><br />What is field reference file?<br />Ans: Field reference file is a file, which contains field definitions and descriptions, and it doesn't have member. Physical contains data derived by the field reference file.<br /><br />What is the difference between access path and Dynamic select?<br />Ans: Dynamic select occurs whenever the program reads file. But access path occurs before the file is read (but not necessarily). Because access path maintenance performed on the file.<br /><br />Why would you prefer OPNQRYF than logical file?<br />Ans: The main difference is : Logical file creates permanent object on the system. OPNQRYF creates temporary access path.<br /><br />What is the necessary keyword used in a physical file to refer field definitions from the field reference file?<br />Ans: REF which is a file level keyword is necessary to define at file level in a physical file. The syntax is as follows: REF(library name/name of the field reference file)<br /><br />What is purpose of declarative statement DEFN?<br />Ans: Depends on the factor 1 value it will do two things:<br />* If the factor1is *LIKE then DEFN opcode defines the new field based on the attributes old field. * If the factor 1 is *NAMVAR then DEFN opcodes defines the field as a data area.<br /><br />What is the purpose of SFLNXTCHG keyword in a subfile?<br />Ans: Which is a subfile record format keyword. If you perform read on the subfile, the<br />internal indicator MDT (modified data tag) is automatically set off by the system. If you again perform read on the<br />same records, records won't be read. Because internal indicator MDT would be off. Hence you should be explicitly set<br />on the MDT by SFLNXTCHG keyword.<br /><br />What is the difference between Array and Table?<br />Ans:<br />Array: Array is stored any where in the body of the input records.<br />Table: Table is stored at the beginning of the input records.<br />Array: We can access all the elements in array by specifying the array name.<br />Table: Only one table element can be accessed at a time.<br />Array: Array can be searched randomly.<br />Table: Table can be searched consecutively.<br /><br />What are the different types of access paths maintained on the file?<br />Ans:<br />Immediate: All the access paths (open and close) associated with a file will be updated whenever changes made to a file.<br />Rebuild- only open access paths will update whenever changes made to the file. Rebuild takes place whenever remaining access paths will be open.<br />Delay : Rebuild will not takes place.<br /><br />What is the purpose of reorganizing the physical file i. e. , RGZPFM?<br />Ans: Even if you delete the records in a physical file through the program, still the space used by the deleted records not used by the other purpose. Hence using RGZPFM command we can compress the deleted records space.<br /><br />What is the purpose of CHGPF (Change physical file) command?<br />Ans: CHGPF command is used to change the attributes of a physical file. Attributes like<br />* Maximum number of members<br />* Member size<br />* Level check enforced<br />* Open data path is shared<br /><br /><br /><br /><br />What are the communication protocols supported by AS/400 ?<br />Ans: APPC (Advanced Program to Program Communication)<br />BSCEL(Binary Synchronous Link)<br />ASYNCH(Asynchronous Communication)<br />RETAIL<br />TCP IP<br />FINANCE<br />SNUF SNA Upline facility<br />INTRA Intrasystem communication.<br /><br /><br />What are the different ways of connecting a terminal to a system ?<br />Ans: Twinnax, Workstation, ASCII and OS/2 Workstation.<br /><br /><br />How can you identify End of file in CLP program?<br />Ans: With the help of MONMSG MSGID(CPF0864) we can identify end of file in clp program.<br /><br />What is the difference between production library and test library ?<br />Ans: In debug mode, the files exists in production library not allowed to update.<br />In the other hand, the files exists in test library allowed to update.</span><br /><br /><br /><div dir="ltr" style="font-family: Helvetica, Arial, sans-serif; font-size: 14px;" trbidi="on"><span style="font-family: helvetica; font-size: large; line-height: 18.2px; text-align: justify;">Jobklix provides you recruitment notifications only you should refer official website of related department. Subscribe Free!!  for upcoming exams, job notifications, study material, latest walk-ins, latest </span><span style="font-family: helvetica; font-size: large; text-align: justify;">job fairs and more...</span></div><div style="line-height: normal;"><span style="font-family: helvetica; font-size: medium;"><br /></span></div><ul style="margin: 0px; padding: 0px; text-align: justify;"><li style="background-attachment: inherit; background-clip: inherit; background-image: inherit; background-origin: inherit; background-position: inherit; background-repeat: inherit; background-size: inherit; list-style-position: inside; list-style-type: initial; list-style: inside url(http://www.moviecinema.in/img/arrow-right.png); margin: 0px; padding: 10px 25px;"><b style="margin: 0px; padding: 0px;"><span style="color: blue; font-family: helvetica; font-size: medium;"><a href="https://www.facebook.com/jobklix" style="margin: 0px; padding: 0px; text-decoration-line: none;" target="_blank">Like us On FB Page</a></span></b></li><li style="background-attachment: inherit; background-clip: inherit; background-image: inherit; background-origin: inherit; background-position: inherit; background-repeat: inherit; background-size: inherit; list-style-position: inside; list-style-type: initial; list-style: inside url(http://www.moviecinema.in/img/arrow-right.png); margin: 0px; padding: 10px 25px;"><a href="https://twitter.com/jobklix" target="_blank"><b><span style="color: blue; font-family: helvetica; font-size: medium;">Follow us On Twitter</span></b></a></li><li style="background-attachment: inherit; background-clip: inherit; background-image: inherit; background-origin: inherit; background-position: inherit; background-repeat: inherit; background-size: inherit; list-style-position: inside; list-style-type: initial; list-style: inside url(http://www.moviecinema.in/img/arrow-right.png); margin: 0px; padding: 10px 25px;"><b><span style="color: blue; font-family: helvetica; font-size: medium;"><a href="https://www.jobklix.blogspot.com/" target="_blank">Upcoming Jobs/Job alerts/Sarkari Naukri/Latest updates</a></span></b></li></ul><br /><br /></div>

AS400 Interview Questions • AS400 Question Bank

AS400 Interview Questions • AS400 Question Bank AS-400, AS400 iSeries Interview Questions and Answers,Mainframe AS-400 Interview Questions a...

Read more »

QCMDEXC in AS400 • AS400 qcmdexc QCMDEXC • OS/400 CL Programming : Using the QCMDEXC Program

<div dir="ltr" style="text-align: left;" trbidi="on"><h1 style="text-align: left;"><span style="font-size: large;">OS/400 CL Programming : Using the QCMDEXC Program</span></h1><h2><span style="font-size: large;">OS/400 CL Programming </span></h2><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEglqpxfQwUrhyphenhyphen7vzXbpTDjuKLM48OGuW_oZHE4_yL2YeODxz3EOhy1PBCQnmSL6ZzGRd71w71ABqE2NI0ZWFddkcepbYicmJaYqpQyKffjGSAhxI4d9oc08MnsSePAVI96Kczrxsk6_1cI/s1600/control+language.jpg" style="margin-left: 1em; margin-right: 1em;"><span style="font-size: large;"><img border="0" height="213" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEglqpxfQwUrhyphenhyphen7vzXbpTDjuKLM48OGuW_oZHE4_yL2YeODxz3EOhy1PBCQnmSL6ZzGRd71w71ABqE2NI0ZWFddkcepbYicmJaYqpQyKffjGSAhxI4d9oc08MnsSePAVI96Kczrxsk6_1cI/s1600/control+language.jpg" width="320" /></span></a></div><div><span style="font-size: large;"><br /></span></div><div><span style="font-size: large;"><br /></span></div><h3 style="text-align: left;"><span style="font-size: large;">QCMDEXC in AS400 • AS400 qcmdexc QCMDEXC • OS/400 CL Programming : Using the QCMDEXC Program</span></h3><span style="font-size: large;"><br /></span><h3><span style="font-size: large;">Using the QCMDEXC Program</span></h3><span style="font-size: large;">QCMDEXC is an IBM-supplied program that runs a single command. It is used to run a command from within a high-level language (HLL) program or from within a CL procedure or program where it is not known at compile time what command is to be run or what parameters are to be used. The QCMDEXC program is called from within your HLL or CL procedure or program and the command it runs is passed to it as a parameter on the CALL command. <br /><br /></span><pre><span style="font-size: large;"> CL or HLL program QCMDEXC<br /> /---------------------------\ /------------------\<br /> | . | | |<br /> | . | /--� | PGM(PARM1 PARM2) | <br /> | . | | | . |<br /> | CALL QCMDEXC(PARM1 PARM2) |----/ | . |<br /> | . | | . |<br /> | . | �-------| RETURN | <br /> | . | | |<br /> \---------------------------/ \------------------/<br /></span></pre><span style="font-size: large;">After the command runs, control returns to your HLL or CL procedure or program. <br />The command is run as if it were not in a program. Therefore, variables cannot be used on the command; values cannot be returned by the command to CL variables; and commands that can only be used in CL procedures or programs cannot be run by the QCMDEXC program. The format of the call to the QCMDEXC program is the following: <br /><br /><br /></span><pre><span style="font-size: large;">CALL PGM(QCMDEXC) PARM(command command-length)<br /></span></pre><span style="font-size: large;">The command you wish to run is entered as a character string on the first parameter. If the command contains blanks, it must be enclosed in apostrophes. The maximum length of the character string is 6000 characters ; delimiters (the apostrophes enclosing the string) are never counted as part of the string. The length specified as the second value on the PARM parameter is the length of the character string passed as the command. Length must be a packed decimal value of length 15 with 5 decimal positions . <br />Thus, if you wish to replace a library list, the call to the QCMDEXC program would look like this: <br /><br /><br /></span><pre><span style="font-size: large;">CALL PGM(QCMDEXC) PARM('CHGLIBL LIBL(QGPL NEWLIB QTEMP)' 31)<br /></span></pre><span style="font-size: large;">This statement could be coded into the HLL or CL program, and when the program runs, the library list would be replaced. Used this way, however, the QCMDEXC program does not provide run-time flexibility. That is accomplished by substituting variables for the constants in the parameter list, and specifying the values for the variables in the call to the HLL or CL program. <br />For instance: <br /><br /></span><pre><span style="font-size: large;">CALL PGM(PGMA) PARM('CHGLIBL...' 3000)<br /> |<br /> |<br /> | /-----------------------------------------\<br /> \---�| PGM PARM(&STRING &LENGTH) /* PGMA */ |<br /> | DCL &STRING *CHAR LEN(3000) | <br /> | DCL &LENGTH *DEC LEN(15 5) |<br /> | . | <br /> | . | /----� QCMDEXC <br /> | . | | /-------------\<br /> | CALL PGM(QCMDEXC) PARM(&STRING &LENGTH)-+--/ | . | <br /> | . �-------------------------------------+---\ | . | <br /> | . | | | . | <br /> | . | | | CHGLIBL... |<br /> | END | | | . | <br /> \-----------------------------------------/ | | . | <br /> \-+-. | <br /> \-------------/<br /></span></pre><span style="font-size: large;">The command length, which is passed to the QCMDEXC program on the second parameter, is the maximum length of the command string being passed. If the command string is passed as a quoted string, the command length is exactly the length of the quoted string. If the command string is passed in a variable, the command length is the length of the CL variable. It is not necessary to reduce the command length to the actual length of the command string in the variable, although it is permissible to do so. <br />The same command could be run using the following CALL command from the CL procedure or program because numeric literals are passed as packed decimal values of length 15 with 5 decimal positions: <br /><br /></span><pre><span style="font-size: large;">CALL QCMDEXC (&STRING 3000)<br /></span></pre><span style="font-size: large;">Not all commands can be run using the QCMDEXC program. The command passed on a call to the QCMDEXC program must be valid within the current environment (interactive or batch) in which the call is being made. The command cannot be one of the following: <br />o       An input stream control command (BCHJOB, ENDBCHJOB, and DATA) <br />o       A command that can be used only in a CL program <br /><br /><br />To find the environment in which the command can be run, look at the syntax diagram for the command. The small box in the upper right corner of the diagram indicates the environment in which the command can be run. For example, JOB: I indicates that the command can be run interactively; JOB: B indicates that the command can be run in a batch job; Exec indicates that the command can be run with QCMDEXC. <br />You can precede the CL command with a question mark (?) to request prompting, or use selective prompting, when you call QCMDEXC in an interactive job. <br />If an error is detected while a command is being processed through the QCMDEXC program, an escape message is sent. You can monitor for this escape message in your CL procedure or program using the Monitor Message (MONMSG) command.<br /><br />If a syntax error is detected, message CPF0006 is sent. If an error is detected during the processing of a command, any escape message sent by the command is returned by the QCMDEXC program. You monitor for messages from commands run through the QCMDEXC program in the same way you monitor for messages from commands contained in CL procedures and programs. </span></div><div dir="ltr" style="text-align: left;" trbidi="on"><br /></div><div dir="ltr" style="font-family: Helvetica, Arial, sans-serif; font-size: 14px;" trbidi="on"><span style="font-family: helvetica; font-size: large; line-height: 18.2px; text-align: justify;">Jobklix provides you recruitment notifications only you should refer official website of related department. Subscribe Free!!  for upcoming exams, job notifications, study material, latest walk-ins, latest </span><span style="font-family: helvetica; font-size: large; text-align: justify;">job fairs and more...</span></div><div style="line-height: normal;"><span style="font-family: helvetica; font-size: medium;"><br /></span></div><ul style="margin: 0px; padding: 0px; text-align: justify;"><li style="background-attachment: inherit; background-clip: inherit; background-image: inherit; background-origin: inherit; background-position: inherit; background-repeat: inherit; background-size: inherit; list-style-position: inside; list-style-type: initial; list-style: inside url(http://www.moviecinema.in/img/arrow-right.png); margin: 0px; padding: 10px 25px;"><b style="margin: 0px; padding: 0px;"><span style="color: blue; font-family: helvetica; font-size: medium;"><a href="https://www.facebook.com/jobklix" style="margin: 0px; padding: 0px; text-decoration-line: none;" target="_blank">Like us On FB Page</a></span></b></li><li style="background-attachment: inherit; background-clip: inherit; background-image: inherit; background-origin: inherit; background-position: inherit; background-repeat: inherit; background-size: inherit; list-style-position: inside; list-style-type: initial; list-style: inside url(http://www.moviecinema.in/img/arrow-right.png); margin: 0px; padding: 10px 25px;"><a href="https://twitter.com/jobklix" target="_blank"><b><span style="color: blue; font-family: helvetica; font-size: medium;">Follow us On Twitter</span></b></a></li><li style="background-attachment: inherit; background-clip: inherit; background-image: inherit; background-origin: inherit; background-position: inherit; background-repeat: inherit; background-size: inherit; list-style-position: inside; list-style-type: initial; list-style: inside url(http://www.moviecinema.in/img/arrow-right.png); margin: 0px; padding: 10px 25px;"><b><span style="color: blue; font-family: helvetica; font-size: medium;"><a href="https://www.jobklix.blogspot.com/" target="_blank">Upcoming Jobs/Job alerts/Sarkari Naukri/Latest updates</a></span></b></li></ul><div dir="ltr" style="text-align: left;" trbidi="on">  <br /> <br /><br /></div>

QCMDEXC in AS400 • AS400 qcmdexc QCMDEXC • OS/400 CL Programming : Using the QCMDEXC Program

OS/400 CL Programming : Using the QCMDEXC Program OS/400 CL Programming  QCMDEXC in AS400 • AS400 qcmdexc QCMDEXC • OS/400 CL Programming : ...

Read more »

Advantages of DB2 CLI over embedded SQL • DB2 Advantages

<div dir="ltr" style="text-align: left;" trbidi="on"><h1 style="text-align: justify;"><span style="font-size: large;">Advantages of DB2 CLI over embedded SQL • DB2 Advantages</span></h1><div><span style="font-size: large;"><br /></span></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEihfqrQFPzeoIVEUlOjOoPMoQMDx_V1KXLZXdTy1O3V4GDou-huTWpJzK4xaxfcA6R0AsFS3Q2BoqkIYLUD4vEaaKTstjWxAf-o45-MK1UGZ8wYoj240mpTAO1yRZA7nDUxZGziaaegzhw/s1600/DB2-concepts+at+www.topnaukrialert.com.jpg" style="margin-left: 1em; margin-right: 1em;"><span style="font-size: large;"><img border="0" height="226" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEihfqrQFPzeoIVEUlOjOoPMoQMDx_V1KXLZXdTy1O3V4GDou-huTWpJzK4xaxfcA6R0AsFS3Q2BoqkIYLUD4vEaaKTstjWxAf-o45-MK1UGZ8wYoj240mpTAO1yRZA7nDUxZGziaaegzhw/s1600/DB2-concepts+at+www.topnaukrialert.com.jpg" width="320" /></span></a></div><div><span style="font-size: large;"><br /></span></div><div style="text-align: justify;"><span style="font-size: large;"><a href="https://www.blogger.com/null" name="idx301"></a><a href="https://www.blogger.com/null" name="idx302"></a>The DB2 CLI interface has several key advantages over embedded SQL. </span></div><ul type="disc"><li class="MsoNormal" style="mso-list: l1 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-align: justify;"><span style="font-size: large;">It is ideally suited for a client-server environment, in which the target database is not known when the application is built. It provides a consistent interface for executing SQL statements, regardless of which database server the application is connected to. </span></li><li class="MsoNormal" style="mso-list: l1 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-align: justify;"><span style="font-size: large;">It increases the portability of applications by removing the dependence on pre-compilers. Applications are distributed not as embedded SQL source code which must be preprocessed for each database product, but as compiled applications or run time libraries. </span></li><li class="MsoNormal" style="mso-list: l1 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-align: justify;"><span style="font-size: large;">Individual DB2 CLI applications do not need to be bound to each database, only bind files shipped with DB2 CLI need to be bound once for all DB2 CLI applications. This can significantly reduce the amount of management required for the application once it is in general use. </span></li><li class="MsoNormal" style="mso-list: l1 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-align: justify;"><span style="font-size: large;">DB2 CLI applications can connect to multiple databases, including multiple connections to the same database, all from the same application. Each connection has its own commit scope. This is much simpler using CLI than using embedded SQL where the application must make use of multi-threading to achieve the same result. </span></li><li class="MsoNormal" style="mso-list: l1 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-align: justify;"><span style="font-size: large;">DB2 CLI eliminates the need for application controlled, often complex data areas, such as the SQLDA and SQLCA, typically associated with embedded SQL applications. Instead, DB2 CLI allocates and controls the necessary data structures, and provides a <span class="italic">handle</span> for the application to reference them. </span></li><li class="MsoNormal" style="mso-list: l1 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-align: justify;"><span style="font-size: large;">DB2 CLI enables the development of multi-threaded thread-safe applications where each thread can have its own connection and a separate commit scope from the rest. DB2 CLI achieves this by eliminating the data areas described above, and associating all such data structures that are accessible to the application with a specific handle. Unlike embedded SQL, a multi-threaded CLI application does not need to call any of the context management DB2^(R) APIs; this is handled by the DB2 CLI driver automatically. </span></li><li class="MsoNormal" style="mso-list: l1 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-align: justify;"><span style="font-size: large;">DB2 CLI provides enhanced parameter input and fetching capability, allowing arrays of data to be specified on input, retrieving multiple rows of a result set directly into an array, and executing statements that generate multiple result sets. </span></li><li class="MsoNormal" style="mso-list: l1 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-align: justify;"><span style="font-size: large;">DB2 CLI provides a consistent interface to query catalog (Tables, Columns, Foreign Keys, Primary Keys, etc.) information contained in the various DBMS catalog tables. The result sets returned are consistent across DBMSs. This shields the application from catalog changes across releases of database servers, as well as catalog differences amongst different database servers; thereby saving applications from writing version specific and server specific catalog queries. </span></li><li class="MsoNormal" style="mso-list: l1 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-align: justify;"><span style="font-size: large;">Extended data conversion is also provided by DB2 CLI, requiring less application code when converting information between various SQL and C data types. </span></li><li class="MsoNormal" style="mso-list: l1 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-align: justify;"><span style="font-size: large;">DB2 CLI incorporates both the ODBC and X/Open CLI functions, both of which are accepted industry specifications. DB2 CLI is also aligned with the ISO CLI standard. Knowledge that application developers invest in these specifications can be applied directly to DB2 CLI development, and vice versa. This interface is intuitive to grasp for those programmers who are familiar with function libraries but know little about product specific methods of embedding SQL statements into a host language. </span></li><li class="MsoNormal" style="mso-list: l1 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-align: justify;"><span style="font-size: large;">DB2 CLI provides the ability to retrieve multiple rows and result sets generated from a stored procedure residing on a DB2 Universal Database (or DB2 Universal Database for z/OS and OS/390 version 5 or later) server. However, note that this capability exists for Version 5 DB2 Universal Database clients using embedded SQL if the stored procedure resides on a server accessible from a DataJoiner^(R) Version 2 server. </span></li><li class="MsoNormal" style="mso-list: l1 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-align: justify;"><span style="font-size: large;">DB2 CLI offers more extensive support for scrollable cursors. With scrollable cursors, you can scroll through a cursor as follows: </span></li><ul type="circle"><li class="MsoNormal" style="mso-list: l1 level2 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 1.0in; text-align: justify;"><span style="font-size: large;">Forward by one or more rows </span></li><li class="MsoNormal" style="mso-list: l1 level2 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 1.0in; text-align: justify;"><span style="font-size: large;">Backward by one or more rows </span></li><li class="MsoNormal" style="mso-list: l1 level2 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 1.0in; text-align: justify;"><span style="font-size: large;">From the first row by one or more rows </span></li><li class="MsoNormal" style="mso-list: l1 level2 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 1.0in; text-align: justify;"><span style="font-size: large;">From the last row by one or more rows. </span></li></ul></ul><div class="MsoNormal" style="margin-left: 0.5in; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify;"><span style="font-size: large;">Scrollable cursors can be used in conjunction with array output. You can declare an updatable cursor as scrollable then move forward or backward through the result set by one or more rows. You can also fetch rows by specifying an offset from: </span></div><ul type="disc"> <ul type="circle"><li class="MsoNormal" style="mso-list: l1 level2 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 1.0in; text-align: justify;"><span style="font-size: large;">The current row </span></li><li class="MsoNormal" style="mso-list: l1 level2 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 1.0in; text-align: justify;"><span style="font-size: large;">The beginning or end of the result set </span></li><li class="MsoNormal" style="mso-list: l1 level2 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 1.0in; text-align: justify;"><span style="font-size: large;">A specific row you have previously set with a bookmark. </span></li></ul></ul><div class="MsoNormal" style="text-align: justify;"><span style="font-size: large;"><br /></span></div><div class="MsoNormal" style="text-align: justify;"><span style="font-size: large;"><br /></span></div><div class="MsoNormal" style="text-align: justify;"><span style="font-size: large;"><br /></span></div><div class="MsoNormal" style="text-align: justify;"><span style="font-size: large;"><br /></span></div><h3 style="text-align: justify;"><span style="font-size: large;">When to use DB2 CLI or embedded SQL </span></h3><div style="text-align: justify;"><span style="font-size: large;"><a href="https://www.blogger.com/null" name="idx303"></a><a href="https://www.blogger.com/null" name="idx304"></a>Which interface you choose depends on your application. </span></div><div style="text-align: justify;"><span style="font-size: large;">DB2 CLI is ideally suited for query-based graphical user interface (GUI) applications that require portability. The advantages listed above, may make using DB2 CLI seem like the obvious choice for any application. There is however, one factor that must be considered, the comparison between static and dynamic SQL. It is much easier to use static SQL in embedded applications. </span></div><div style="text-align: justify;"><span style="font-size: large;">Static SQL has several advantages: </span></div><ul type="disc"><li class="MsoNormal" style="mso-list: l0 level1 lfo2; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-align: justify;"><span style="font-size: large;">Performance </span></li></ul><div style="margin-left: 0.5in; text-align: justify;"><span style="font-size: large;">Dynamic SQL is prepared at run time, static SQL is prepared at precompile time. As well as requiring more processing, the preparation step may incur additional network-traffic at run time. The additional network traffic can be avoided if the DB2 CLI application makes use of deferred prepare (which is the default behaviour). </span></div><div style="margin-left: 0.5in; text-align: justify;"><span style="font-size: large;">It is important to note that static SQL will not always have better performance than dynamic SQL. Dynamic SQL is prepared at runtime and uses the database statistics available at that time, whereas static SQL makes use of database statistics available at BIND time. Dynamic SQL can make use of changes to the database, such as new indexes, to choose the optimal access plan, resulting in potentially better performance than the same SQL executed as static SQL. In addition, precompilation of dynamic SQL statements can be avoided if they are cached. </span></div><ul type="disc"><li class="MsoNormal" style="mso-list: l0 level1 lfo2; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-align: justify;"><span style="font-size: large;">Encapsulation and Security </span></li></ul><div style="margin-left: 0.5in; text-align: justify;"><span style="font-size: large;">In static SQL, the authorizations to access objects (such as a table, view) are associated with a package and are validated at package binding time. This means that database administrators need only to grant execute on a particular package to a set of users (thus encapsulating their privileges in the package) without having to grant them explicit access to each database object. In dynamic SQL, the authorizations are validated at run time on a per statement basis; therefore, users must be granted explicit access to each database object. This permits these users access to parts of the object that they do not have a need to access. .</span></div><div style="margin-left: 0.5in; text-align: justify;"><span style="font-size: large;"><br /></span></div><div style="margin-left: 0.5in; text-align: justify;"><span style="font-size: large;"><br /></span></div><div style="margin-left: 0.5in; text-align: justify;"><span style="font-size: large;"><br /></span></div><ul type="disc"><li class="MsoNormal" style="mso-list: l0 level1 lfo2; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-align: justify;"><span style="font-size: large;">Embedded SQL is supported in languages other than C or C++. </span></li><li class="MsoNormal" style="mso-list: l0 level1 lfo2; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-align: justify;"><span style="font-size: large;">For fixed query selects, embedded SQL is simpler. </span></li></ul><div style="text-align: justify;"><span style="font-size: large;">If an application requires the advantages of both interfaces, it is possible to make use of static SQL within a DB2 CLI application by creating a stored procedure that contains the static SQL. The stored procedure is called from within a DB2 CLI application and is executed on the server. Once the stored procedure is created, any DB2 CLI or ODBC application can call it. </span></div><div style="text-align: justify;"><span style="font-size: large;">It is also possible to write a mixed application that uses both DB2 CLI and embedded SQL, taking advantage of their respective benefits. In this case, DB2 CLI is used to provide the base application, with key modules written using static SQL for performance or security reasons. This complicates the application design, and should only be used if stored procedures do not meet the applications requirements. </span></div><span style="font-size: large;"><br /></span><div style="text-align: justify;"><span style="font-size: large;">Ultimately, the decision on when to use each interface, will be based on individual preferences and previous experience rather than on any one factor. </span></div><div style="text-align: justify;"><br /></div><div style="text-align: justify;"><div dir="ltr" style="font-family: Helvetica, Arial, sans-serif; font-size: 14px; text-align: left;" trbidi="on"><span style="font-family: helvetica; font-size: large; line-height: 18.2px; text-align: justify;">Jobklix provides you recruitment notifications only you should refer official website of related department. Subscribe Free!!  for upcoming exams, job notifications, study material, latest walk-ins, latest </span><span style="font-family: helvetica; font-size: large; text-align: justify;">job fairs and more...</span></div><div style="line-height: normal; text-align: left;"><span style="font-family: helvetica; font-size: medium;"><br /></span></div><ul style="margin: 0px; padding: 0px;"><li style="background-attachment: inherit; background-clip: inherit; background-image: inherit; background-origin: inherit; background-position: inherit; background-repeat: inherit; background-size: inherit; list-style-position: inside; list-style-type: initial; list-style: inside url(http://www.moviecinema.in/img/arrow-right.png); margin: 0px; padding: 10px 25px;"><b style="margin: 0px; padding: 0px;"><span style="color: blue; font-family: helvetica; font-size: medium;"><a href="https://www.facebook.com/jobklix" style="margin: 0px; padding: 0px; text-decoration-line: none;" target="_blank">Like us On FB Page</a></span></b></li><li style="background-attachment: inherit; background-clip: inherit; background-image: inherit; background-origin: inherit; background-position: inherit; background-repeat: inherit; background-size: inherit; list-style-position: inside; list-style-type: initial; list-style: inside url(http://www.moviecinema.in/img/arrow-right.png); margin: 0px; padding: 10px 25px;"><a href="https://twitter.com/jobklix" target="_blank"><b><span style="color: blue; font-family: helvetica; font-size: medium;">Follow us On Twitter</span></b></a></li><li style="background-attachment: inherit; background-clip: inherit; background-image: inherit; background-origin: inherit; background-position: inherit; background-repeat: inherit; background-size: inherit; list-style-position: inside; list-style-type: initial; list-style: inside url(http://www.moviecinema.in/img/arrow-right.png); margin: 0px; padding: 10px 25px;"><b><span style="color: blue; font-family: helvetica; font-size: medium;"><a href="https://www.jobklix.blogspot.com/" target="_blank">Upcoming Jobs/Job alerts/Sarkari Naukri/Latest updates</a></span></b></li></ul></div></div>

Advantages of DB2 CLI over embedded SQL • DB2 Advantages

Advantages of DB2 CLI over embedded SQL • DB2 Advantages The DB2 CLI interface has several key advantages over embedded SQL. It is idea...

Read more »

16 Easy Quantitative Aptitude shortcut tricks for all competitive exams

<div dir="ltr" style="text-align: left;" trbidi="on"><h1 style="text-align: left;"><span style="font-size: large;">16 Easy Quantitative Aptitude shortcut tricks for all competitive exams</span></h1><span style="font-size: large;"><br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjma4KEmdEcIrvnQvZU11fhSHLl1NzDSaPU1VI3YvVeXdeG-DzpFxTGUm5D9lNTTrHUzNmj-syV4i4hAxjJ4QRNiN4ebX1X3VN_jSfURsWlLyo9oGn5rd03tajaCAkBggaJdJkr4LzLOOc/s1600/exam-tips.jpg" style="margin-left: 1em; margin-right: 1em;"><span style="font-size: large;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjma4KEmdEcIrvnQvZU11fhSHLl1NzDSaPU1VI3YvVeXdeG-DzpFxTGUm5D9lNTTrHUzNmj-syV4i4hAxjJ4QRNiN4ebX1X3VN_jSfURsWlLyo9oGn5rd03tajaCAkBggaJdJkr4LzLOOc/s1600/exam-tips.jpg" /></span></a></div><div class="separator" style="clear: both; text-align: center;"><span style="font-size: large;"><br /></span></div><span style="font-size: large;"><b><span face=""Verdana","sans-serif"" style="color: maroon;">(1) Multiplication by 5<br /></span></b><span face=""Verdana","sans-serif"">It's often more convenient instead of multiplying by 5 to multiply first by 10 and then divide by 2. For example, 137·5=1370/2=685. </span><br /><br /><b><span face=""Verdana","sans-serif"" style="color: maroon;">(2) Division by 5<br /></span></b><span face=""Verdana","sans-serif"">Similarly, it's often more convenient instead to multiply first by 2 and then divide by 10. For example, 1375/5=2750/10=275.</span><br /><br /><b><span face=""Verdana","sans-serif"" style="color: maroon;">(3) Division/multiplication by 4<br /></span></b><span face=""Verdana","sans-serif"">Replace either with a repeated operation by 2. For example 124/4=62/2=31. Also, 124·4=248·2=496. </span><br /><br /><b><span face=""Verdana","sans-serif"" style="color: maroon;">(4) Division/multiplication by 25<br /></span></b><span face=""Verdana","sans-serif"">Use operations with 4 instead. For example, 37·25=3700/4=1850/2=925. </span><br /><br /><b><span face=""Verdana","sans-serif"" style="color: maroon;">(5) Division/multiplication by 8<br /></span></b><span face=""Verdana","sans-serif"">Replace either with a repeated operation by 2. For example 124·8=248·4=496·2=992. </span><br /><br /><b><span face=""Verdana","sans-serif"" style="color: maroon;">(6) Division/multiplication by 125<br /></span></b><span face=""Verdana","sans-serif"">Use operations with 8 instead. For example, 37·125=37000/8=18500/4=9250/2=4625. </span><br /><br /><b><span face=""Verdana","sans-serif"" style="color: maroon;">(7) Squaring two digit numbers. </span></b><br /><b><span face=""Verdana","sans-serif"">You should memorize the first 25 squares:</span></b> <br /><!--[if !supportMisalignedColumns]--><!--[endif]--></span><table border="1" cellpadding="0" class="MsoNormalTable" style="mso-cellspacing: 1.5pt; mso-padding-alt: 1.5pt 1.5pt 1.5pt 1.5pt; width: 100%px;"> <tbody><tr> <td style="padding: 1.5pt; width: 7%;" width="7%"> <span style="font-size: large;"><b><span face=""Verdana","sans-serif"">1</span></b><br /> </span></td> <td colspan="2" style="padding: 1.5pt; width: 7%;" width="7%"> <span style="font-size: large;"><b><span face=""Verdana","sans-serif"">2</span></b><br /> </span></td> <td colspan="2" style="padding: 1.5pt; width: 7%;" width="7%"> <span style="font-size: large;"><b><span face=""Verdana","sans-serif"">3</span></b><br /> </span></td> <td colspan="2" style="padding: 1.5pt; width: 7%;" width="7%"> <span style="font-size: large;"><b><span face=""Verdana","sans-serif"">4</span></b><br /> </span></td> <td style="padding: 1.5pt; width: 7%;" width="7%"> <span style="font-size: large;"><b><span face=""Verdana","sans-serif"">5</span></b><br /> </span></td> <td colspan="2" style="padding: 1.5pt; width: 7%;" width="7%"> <span style="font-size: large;"><b><span face=""Verdana","sans-serif"">6</span></b><br /> </span></td> <td colspan="2" style="padding: 1.5pt; width: 7%;" width="7%"> <span style="font-size: large;"><b><span face=""Verdana","sans-serif"">7</span></b><br /> </span></td> <td colspan="2" style="padding: 1.5pt; width: 7%;" width="7%"> <span style="font-size: large;"><b><span face=""Verdana","sans-serif"">8</span></b><br /> </span></td> <td style="padding: 1.5pt; width: 7%;" width="7%"> <span style="font-size: large;"><b><span face=""Verdana","sans-serif"">9</span></b><br /> </span></td> <td style="padding: 1.5pt; width: 7%;" width="7%"> <span style="font-size: large;"><b><span face=""Verdana","sans-serif"">10</span></b><br /> </span></td> <td colspan="2" style="padding: 1.5pt; width: 7%;" width="7%"> <span style="font-size: large;"><b><span face=""Verdana","sans-serif"">11</span></b><br /> </span></td> <td colspan="2" style="padding: 1.5pt; width: 7%;" width="7%"> <span style="font-size: large;"><b><span face=""Verdana","sans-serif"">12</span></b><br /> </span></td> <td colspan="2" style="padding: 1.5pt; width: 8%;" width="8%"> <span style="font-size: large;"><b><span face=""Verdana","sans-serif"">13</span></b><br /> </span></td> <td style="padding: 1.5pt; width: 8%;" width="8%"> <span style="font-size: large;"><b><span face=""Verdana","sans-serif"">14</span></b><br /> </span></td> </tr><tr> <td style="padding: 1.5pt; width: 7%;" width="7%"> <span style="font-size: large;"><span face=""Verdana","sans-serif"">1</span><br /> </span></td> <td colspan="2" style="padding: 1.5pt; width: 7%;" width="7%"> <span style="font-size: large;"><span face=""Verdana","sans-serif"">2</span><br /> </span></td> <td colspan="2" style="padding: 1.5pt; width: 7%;" width="7%"> <span style="font-size: large;"><span face=""Verdana","sans-serif"">9</span><br /> </span></td> <td colspan="2" style="padding: 1.5pt; width: 7%;" width="7%"> <span style="font-size: large;"><span face=""Verdana","sans-serif"">16</span><br /> </span></td> <td style="padding: 1.5pt; width: 7%;" width="7%"> <span style="font-size: large;"><span face=""Verdana","sans-serif"">25</span><br /> </span></td> <td colspan="2" style="padding: 1.5pt; width: 7%;" width="7%"> <span style="font-size: large;"><span face=""Verdana","sans-serif"">36</span><br /> </span></td> <td colspan="2" style="padding: 1.5pt; width: 7%;" width="7%"> <span style="font-size: large;"><span face=""Verdana","sans-serif"">49</span><br /> </span></td> <td colspan="2" style="padding: 1.5pt; width: 7%;" width="7%"> <span style="font-size: large;"><span face=""Verdana","sans-serif"">64</span><br /> </span></td> <td style="padding: 1.5pt; width: 7%;" width="7%"> <span style="font-size: large;"><span face=""Verdana","sans-serif"">81</span><br /> </span></td> <td style="padding: 1.5pt; width: 7%;" width="7%"> <span style="font-size: large;"><span face=""Verdana","sans-serif"">100</span><br /> </span></td> <td colspan="2" style="padding: 1.5pt; width: 7%;" width="7%"> <span style="font-size: large;"><span face=""Verdana","sans-serif"">121</span><br /> </span></td> <td colspan="2" style="padding: 1.5pt; width: 7%;" width="7%"> <span style="font-size: large;"><span face=""Verdana","sans-serif"">144</span><br /> </span></td> <td colspan="2" style="padding: 1.5pt; width: 8%;" width="8%"> <span style="font-size: large;"><span face=""Verdana","sans-serif"">169</span><br /> </span></td> <td style="padding: 1.5pt; width: 8%;" width="8%"> <span style="font-size: large;"><span face=""Verdana","sans-serif"">196</span><br /> </span></td> </tr><tr> <td colspan="2" style="padding: 1.5pt; width: 9%;" width="9%"> <span style="font-size: large;"><b><span face=""Verdana","sans-serif"">15</span></b><br /> </span></td> <td colspan="2" style="padding: 1.5pt; width: 9%;" width="9%"> <span style="font-size: large;"><b><span face=""Verdana","sans-serif"">16</span></b><br /> </span></td> <td colspan="2" style="padding: 1.5pt; width: 9%;" width="9%"> <span style="font-size: large;"><b><span face=""Verdana","sans-serif"">17</span></b><br /> </span></td> <td colspan="3" style="padding: 1.5pt; width: 9%;" width="9%"> <span style="font-size: large;"><b><span face=""Verdana","sans-serif"">18</span></b><br /> </span></td> <td colspan="2" style="padding: 1.5pt; width: 9%;" width="9%"> <span style="font-size: large;"><b><span face=""Verdana","sans-serif"">19</span></b><br /> </span></td> <td colspan="2" style="padding: 1.5pt; width: 9%;" width="9%"> <span style="font-size: large;"><b><span face=""Verdana","sans-serif"">20</span></b><br /> </span></td> <td colspan="2" style="padding: 1.5pt; width: 9%;" width="9%"> <span style="font-size: large;"><b><span face=""Verdana","sans-serif"">21</span></b><br /> </span></td> <td colspan="2" style="padding: 1.5pt; width: 9%;" width="9%"> <span style="font-size: large;"><b><span face=""Verdana","sans-serif"">22</span></b><br /> </span></td> <td colspan="2" style="padding: 1.5pt; width: 9%;" width="9%"> <span style="font-size: large;"><b><span face=""Verdana","sans-serif"">23</span></b><br /> </span></td> <td colspan="2" style="padding: 1.5pt; width: 9%;" width="9%"> <span style="font-size: large;"><b><span face=""Verdana","sans-serif"">24</span></b><br /> </span></td> <td colspan="2" style="padding: 1.5pt; width: 10%;" width="10%"> <span style="font-size: large;"><b><span face=""Verdana","sans-serif"">25</span></b><br /> </span></td> </tr><tr> <td colspan="2" style="padding: 1.5pt; width: 9%;" width="9%"> <span style="font-size: large;"><span face=""Verdana","sans-serif"">225</span><br /> </span></td> <td colspan="2" style="padding: 1.5pt; width: 9%;" width="9%"> <span style="font-size: large;"><span face=""Verdana","sans-serif"">256</span><br /> </span></td> <td colspan="2" style="padding: 1.5pt; width: 9%;" width="9%"> <span style="font-size: large;"><span face=""Verdana","sans-serif"">289</span><br /> </span></td> <td colspan="3" style="padding: 1.5pt; width: 9%;" width="9%"> <span style="font-size: large;"><span face=""Verdana","sans-serif"">324</span><br /> </span></td> <td colspan="2" style="padding: 1.5pt; width: 9%;" width="9%"> <span style="font-size: large;"><span face=""Verdana","sans-serif"">361</span><br /> </span></td> <td colspan="2" style="padding: 1.5pt; width: 9%;" width="9%"> <span style="font-size: large;"><span face=""Verdana","sans-serif"">400</span><br /> </span></td> <td colspan="2" style="padding: 1.5pt; width: 9%;" width="9%"> <span style="font-size: large;"><span face=""Verdana","sans-serif"">441</span><br /> </span></td> <td colspan="2" style="padding: 1.5pt; width: 9%;" width="9%"> <span style="font-size: large;"><span face=""Verdana","sans-serif"">484</span><br /> </span></td> <td colspan="2" style="padding: 1.5pt; width: 9%;" width="9%"> <span style="font-size: large;"><span face=""Verdana","sans-serif"">529</span><br /> </span></td> <td colspan="2" style="padding: 1.5pt; width: 9%;" width="9%"> <span style="font-size: large;"><span face=""Verdana","sans-serif"">576</span><br /> </span></td> <td colspan="2" style="padding: 1.5pt; width: 10%;" width="10%"> <span style="font-size: large;"><span face=""Verdana","sans-serif"">625</span><br /> </span></td> </tr><tr height="0"> <td style="border: none;" width="52"></td> <td style="border: none;" width="16"></td> <td style="border: none;" width="37"></td> <td style="border: none;" width="30"></td> <td style="border: none;" width="23"></td> <td style="border: none;" width="44"></td> <td style="border: none;" width="9"></td> <td style="border: none;" width="51"></td> <td style="border: none;" width="9"></td> <td style="border: none;" width="44"></td> <td style="border: none;" width="23"></td> <td style="border: none;" width="30"></td> <td style="border: none;" width="37"></td> <td style="border: none;" width="16"></td> <td style="border: none;" width="51"></td> <td style="border: none;" width="51"></td> <td style="border: none;" width="16"></td> <td style="border: none;" width="37"></td> <td style="border: none;" width="30"></td> <td style="border: none;" width="23"></td> <td style="border: none;" width="44"></td> <td style="border: none;" width="16"></td> <td style="border: none;" width="59"></td> </tr></tbody></table><div class="MsoNormal"><span style="font-size: large;"><br /></span></div><div style="margin-left: 0.5in; mso-list: l0 level1 lfo1; tab-stops: list .5in; text-indent: -0.25in;"><span style="font-size: large;"><!--[if !supportLists]--><span style="font-family: Symbol; mso-bidi-font-family: Symbol; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman';">         </span></span><!--[endif]--><b><span face=""Verdana","sans-serif"">Squares of numbers from 26 through 50.<br /></span></b><span face=""Verdana","sans-serif"">Let A be such a number. Subtract 25 from A to get x. Subtract x from 25 to get, say, a. Then A²=a²+100x. For example, if A=26, then x=1 and a=24. Hence 26²=24²+100=676. Similarly, if A=37, then x=37-25=12, and a=25-12=13. Therefore, 37²=13²+100·12=1200+169=1369. Why does this work? (25+x)²-(25-x)²=[(25+x)+(25-x)]·[(25+x)-(25-x)]=50·2x=100x. </span></span></div><div style="margin-left: 0.5in; mso-list: l0 level1 lfo1; tab-stops: list .5in; text-indent: -0.25in;"><span style="font-size: large;"><!--[if !supportLists]--><span style="font-family: Symbol; mso-bidi-font-family: Symbol; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman';">         </span></span><!--[endif]--><b><span face=""Verdana","sans-serif"">Squares of numbers from 51 through 99.<br /></span></b><span face=""Verdana","sans-serif"">The idea is the same as above. (50+x)²-(50-x)²=100·2x=200x. For example, 63²=37²+200·13= 1369+2600=3969. </span></span></div><div style="margin-left: 0.5in; mso-list: l0 level1 lfo1; tab-stops: list .5in; text-indent: -0.25in;"><span style="font-size: large;"><!--[if !supportLists]--><span style="font-family: Symbol; mso-bidi-font-family: Symbol; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman';">         </span></span><!--[endif]--><b><span face=""Verdana","sans-serif"">Squares of numbers from 51 through 99, second approach (this one was communicated to me by my father Moisey Bogomolny).<br /></span></b><span face=""Verdana","sans-serif"">We are looking to compute A², where A=50+a. Instead compute 100·(25+a) and add a². Example: 57². a=57-50=7. 25+7=32. Append 49=7². <b>Answer:</b> 57²=3249. </span></span></div><div style="margin-left: 0.5in; mso-list: l0 level1 lfo1; tab-stops: list .5in; text-indent: -0.25in;"><span style="font-size: large;"><!--[if !supportLists]--><span style="font-family: Symbol; mso-bidi-font-family: Symbol; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman';">         </span></span><!--[endif]--><span face=""Verdana","sans-serif"">In general, a² = (a + b)(a - b) + b². Let a be 57 and, again, we wish to compute 57². Let b = 3. Then 57² = (57 + 3)(57 - 3) + 3², or 57² = 60·54 + 9 = 3240 + 9 = 3249. </span></span></div><span style="font-size: large;"><br /><b><span face=""Verdana","sans-serif"" style="color: maroon;">(8) Squares of numbers that end with 5.<br /></span></b><span face=""Verdana","sans-serif"">Let A=10a+5. Then A²=(10a+5)²=100a²+2·10a·5+25=100a(a+1)+25. For example, to compute 115², where a=11, first compute 11·(11+1)=11·12=132 (since 3=1+2). Next, append 25 to the right of 132 to get 13225! Another example, to compute 245², let a=24. Then 24·(24+1)=24²+24=576+24=600. Therefore 245²=60025. Here is another way to compute 24·25: 24·25=2400/4=1200/2=600. The rule naturally applies to 2-digit numbers as well. 75²=5625 (since 7·8=56). </span><br /><br /><b><span face=""Verdana","sans-serif"" style="color: maroon;">(9) Product of two one-digit numbers greater than 5.<br /></span></b><span face=""Verdana","sans-serif"">This is a rule that helps remember a big part of the multiplication table. Assume you forgot the product 7·9. Do this. First find the access of each of the multiples over 5: it's 2 for 7 (7 - 5 = 2) and 4 for 9 (9 - 5 = 4). Add them up to get 6 = 2 + 4. Now find the complements of these two numbers to 5: it's 3 for 2 (5 - 2 = 3) and 1 for 4 (5 - 4 = 1). Remember their product 3 = 3·1. Lastly, combine thus obtained two numbers (6 and 3) as 63 = 6·10 + 3. </span><br /><b><span face=""Verdana","sans-serif"">The explanation comes from the following formula: </span></b><br /></span><div class="MsoNormal"><span face=""Verdana","sans-serif"" style="font-size: large;">(5 + a)(5 + b) = 10(a + b) + (5 - a)(5 - b) </span></div><span style="font-size: large;"><span face=""Verdana","sans-serif"">In our example, a = 2 and b = 4. </span><br /><br /><b><span face=""Verdana","sans-serif"" style="color: maroon;">(10) Product of two 2-digit numbers. </span></b><br /></span><div style="margin-left: 0.5in; mso-list: l1 level1 lfo2; tab-stops: list .5in; text-indent: -0.25in;"><span style="font-size: large;"><!--[if !supportLists]--><span style="font-family: Symbol; mso-bidi-font-family: Symbol; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman';">         </span></span><!--[endif]--><span face=""Verdana","sans-serif"">If the numbers are not too far apart, and their difference is even, one might use the well known formula (a+n)(a-n)=a²-n². a here is the average of the two numbers. For example, 28·24=26²-2²=676-4=672 since 26=(24+28)/2. Also, 19·31=25²-6²=625-36=589 since 25=(19+31)/2. </span></span></div><div style="margin-left: 0.5in; mso-list: l1 level1 lfo2; tab-stops: list .5in; text-indent: -0.25in;"><span style="font-size: large;"><!--[if !supportLists]--><span style="font-family: Symbol; mso-bidi-font-family: Symbol; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman';">         </span></span><!--[endif]--><span face=""Verdana","sans-serif"">If the difference is odd use either n(m+1)=nm+n or n(m-1)=nm-n. Example 37·34=37·35-37=36²-1²-37=1296-1-37=1258. On the other hand, 37·34=37·33+37=35²-2²+37=1225-4+37=1258. </span></span></div><span style="font-size: large;"><br /><br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgx-jDjWW9SgSKuy1OU0ZRelvSwQMVnQ3k-kITDRH16eoY_9aCXHJVaESwulFk0dKomRppP_gykTI0zOAKREDwN5CHNNT4UkcEi5ISsP_iQbG4pCseqyPCYEnElgKr-Qa0LBOsbCoaxFzs/s1600/16+Easy+Quantitative+Aptitude+shortcut+tricks+for+all+competitive+exams.jpg" style="margin-left: 1em; margin-right: 1em;"><span style="font-size: large;"><img border="0" height="226" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgx-jDjWW9SgSKuy1OU0ZRelvSwQMVnQ3k-kITDRH16eoY_9aCXHJVaESwulFk0dKomRppP_gykTI0zOAKREDwN5CHNNT4UkcEi5ISsP_iQbG4pCseqyPCYEnElgKr-Qa0LBOsbCoaxFzs/s1600/16+Easy+Quantitative+Aptitude+shortcut+tricks+for+all+competitive+exams.jpg" width="320" /></span></a></div><span style="font-size: large;"><br /><br /><br /><b><span face=""Verdana","sans-serif"" style="color: maroon;">(11) Product of numbers that only differ in units.<br /></span></b><span face=""Verdana","sans-serif"">If the numbers only differ in units and the sum of the units is 10, like with 53 and 57 or 122 and 128, then think of them as, say 10a+b and 10a+c, where b+c=10. The product (10a+b)(10a+c) is given by 100a²+10a(b+c)+bc =&nbs;100a(a+1)+bc. Thus to compute 53 times 57 (a=5, b=3, c=7), multiply 5 times (5+1) to get 30. Append to the result (30) theproduct of the units (3·7=21) to obtain 3021. Similarly 122·128 = 12·13·100+2·8=15616. </span><br /><br /><b><span face=""Verdana","sans-serif"" style="color: maroon;">(12) Multiplying by 11.<br /></span></b><span face=""Verdana","sans-serif"">To multiply a 2-digit number by 11, take the sum of its digits. If it's a single digit number, just write it between the two digits. If the sum is 10 or more, do not forget to carry 1 over. For example, 34·11=374 since 3+4=7. 47·11=517 since 4+7=11. </span><br /><br /><b><span face=""Verdana","sans-serif"" style="color: maroon;">(13) Faster subtraction.<br /></span></b><span face=""Verdana","sans-serif"">Subtraction is often faster in two steps instead of one. Example: 427-38=(427-27)-(38-27)=400-11=389. A generic advice might be given as "First remove what's easy, next whatever remains". Another example: 1049-187=1000-(187-49)=900-38=862. </span><br /><br /><b><span face=""Verdana","sans-serif"" style="color: maroon;">(14) Faster addition.<br /></span></b><span face=""Verdana","sans-serif"">Addition is often faster in two steps instead of one. Example: 487+38=(487+13)+(38-13)=500+25=525. A generic advice might be given as "First add what's easy, next whatever remains". Another example: 1049+187=1100+(187-51)=1200+36=1236. </span><br /><br /><b><span face=""Verdana","sans-serif"" style="color: maroon;">(15) Faster addition, #2.<br /></span></b><span face=""Verdana","sans-serif"">It's often faster to add a digit at a time starting with higher digits. For example, 583+645=583+600+40+5=1183+40+5=1223+5=1228. </span><br /><br /></span><div class="separator" style="clear: both; text-align: center;"> </div><span style="font-size: large;"><b><span face=""Verdana","sans-serif"" style="color: maroon;">(16) Multipliply, then subtract.<br /></span></b><span face=""Verdana","sans-serif"">When multiplying by 9, multiply by 10 instead, and then subtract the other number. For example, 23·9=230-23=207. The same applies to other numbers near those for which multiplication is simplified. 23·51=23·50+23=2300/2+23=1150+23=1173. 87·48=87·50-87·2=8700/2-160-14=4350-160-14=4190-14=4176. </span><br /><br /><br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgGHj3fOlYoS3nmmNC4JDN5d1h9-hJf-xaP2SCAQncf56W-oezxZKDQkhCm-Nn74OvAIhZtgznmHkJ5IMco7X02uyKCo2Fc8NX0FAqdp1q-PKm7qrvQuuiHN5cb2qtqppiPyZxDoXBP4g/s1600/top-tips-tricks.jpg" style="margin-left: 1em; margin-right: 1em;"><span style="font-size: large;"><img border="0" height="205" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgGHj3fOlYoS3nmmNC4JDN5d1h9-hJf-xaP2SCAQncf56W-oezxZKDQkhCm-Nn74OvAIhZtgznmHkJ5IMco7X02uyKCo2Fc8NX0FAqdp1q-PKm7qrvQuuiHN5cb2qtqppiPyZxDoXBP4g/s1600/top-tips-tricks.jpg" width="320" /></span></a></div><br /><br /><br /></div><div dir="ltr" style="text-align: left;" trbidi="on"><div dir="ltr" style="font-family: Helvetica, Arial, sans-serif; font-size: 14px;" trbidi="on"><span style="font-family: helvetica; font-size: large; line-height: 18.2px; text-align: justify;">Jobklix provides you recruitment notifications only you should refer official website of related department. Subscribe Free!!  for upcoming exams, job notifications, study material, latest walk-ins, latest </span><span style="font-family: helvetica; font-size: large; text-align: justify;">job fairs and more...</span></div><div style="line-height: normal;"><span style="font-family: helvetica; font-size: medium;"><br /></span></div><ul style="margin: 0px; padding: 0px; text-align: justify;"><li style="background-attachment: inherit; background-clip: inherit; background-image: inherit; background-origin: inherit; background-position: inherit; background-repeat: inherit; background-size: inherit; list-style-position: inside; list-style-type: initial; list-style: inside url(http://www.moviecinema.in/img/arrow-right.png); margin: 0px; padding: 10px 25px;"><b style="margin: 0px; padding: 0px;"><span style="color: blue; font-family: helvetica; font-size: medium;"><a href="https://www.facebook.com/jobklix" style="margin: 0px; padding: 0px; text-decoration-line: none;" target="_blank">Like us On FB Page</a></span></b></li><li style="background-attachment: inherit; background-clip: inherit; background-image: inherit; background-origin: inherit; background-position: inherit; background-repeat: inherit; background-size: inherit; list-style-position: inside; list-style-type: initial; list-style: inside url(http://www.moviecinema.in/img/arrow-right.png); margin: 0px; padding: 10px 25px;"><a href="https://twitter.com/jobklix" target="_blank"><b><span style="color: blue; font-family: helvetica; font-size: medium;">Follow us On Twitter</span></b></a></li><li style="background-attachment: inherit; background-clip: inherit; background-image: inherit; background-origin: inherit; background-position: inherit; background-repeat: inherit; background-size: inherit; list-style-position: inside; list-style-type: initial; list-style: inside url(http://www.moviecinema.in/img/arrow-right.png); margin: 0px; padding: 10px 25px;"><b><span style="color: blue; font-family: helvetica; font-size: medium;"><a href="https://www.jobklix.blogspot.com/" target="_blank">Upcoming Jobs/Job alerts/Sarkari Naukri/Latest updates</a></span></b></li></ul></div>

16 Easy Quantitative Aptitude shortcut tricks for all competitive exams

16 Easy Quantitative Aptitude shortcut tricks for all competitive exams (1) Multiplication by 5 It's often more convenient instead of mu...

Read more »

AS/400-iSeries Concepts and Terminology

<div dir="ltr" style="text-align: left;" trbidi="on"><h1 style="text-align: center;"><b><span style="font-size: x-large;">AS/400-iSeries Concepts and Terminology  </span></b></h1><div class="MsoNormal" style="text-align: center;"><b><span style="font-size: large;"><br /></span></b></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhN_dYRMO5z_rq63_Ku4ySSyU2BggYYfUtuzRhmaLz2h5nOTrx84Gzuvp5YqwoCWkhaAyl_s0XBTHq42ljBH4mauVoPuFTmmieyZ8KdaC-sWzHKmDawitcf9j-EsY8EwyTg6Z3bXvkCojU/s1600/AS400-iSeries.png" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><span style="font-size: large;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhN_dYRMO5z_rq63_Ku4ySSyU2BggYYfUtuzRhmaLz2h5nOTrx84Gzuvp5YqwoCWkhaAyl_s0XBTHq42ljBH4mauVoPuFTmmieyZ8KdaC-sWzHKmDawitcf9j-EsY8EwyTg6Z3bXvkCojU/s1600/AS400-iSeries.png" /></span></a></div><div class="MsoNormal" style="text-align: center;"><b><span style="font-size: large;"><br /></span></b></div><div class="MsoNormal" style="text-align: center;"><b><u><span style="font-size: large;"><br /></span></u></b></div><div class="MsoNormal"><span style="font-size: large;"> The purpose of this post is to give a high level overview of the AS400-iSeries and some of the components, features,terminology, and definitions.</span></div><div class="MsoNormal"><span style="font-size: large;"><br /></span></div><h3><span style="font-size: large;">AS/400 Architecture</span></h3><div class="MsoNormal"><span style="font-size: large;">The AS/400 is a very complex integrated system that includes hardware, software, security, a database and other components. The AS/400 Advanced Architecture is unique in that it is extremely adaptable and can easily incorporate new technologies. This is important in today’s fast changing computer marketplace. The AS/400 is designed to separate the software and hardware so changes in one have little effect in the other. This is accomplished through the Machine Interface (MI) which is a software programming interface between the application, the operating system and hardware. The MI is a complete Application Programming Interface (API) set that all applications must use in order to get to the to the hardware. This is how the AS400 achieves the software independence. </span></div><h3><span style="font-size: large;">OS/400 Operating System</span></h3><div class="MsoNormal"><span style="font-size: large;">The Operating System for the AS/400 is called OS/400. The OS/400 resides above the MI. This allows the operating system to be independent from the hardware.  Most operating system components handle functions such as memory, process, program, and I/O management. On the AS/400 these lower level functions are handled by the Licensed Internal Code (LIC) which is the operating system software below the MI. The LIC protects application programs and OS/400 from hardware changes. Thus again, keeping the software separate from the hardware. </span></div><h3><span style="font-size: large;">Integrated File System</span></h3><div class="MsoNormal"><span style="font-size: large;">The AS/400 contains an integrated file system (IFS). This means applications written on other file systems, PC, Unix, etc., can access data stored on the AS/400.  The IFS integrates all file systems on the AS/400 with one interface and one set of rules. How the AS/400 developers accomplished this was to use a single root, like a PC file system, and put all other file systems under it.  From a Windows client the AS/400 would appear as a network drive. Under that drive you would have PC-like subdirectories for all the file systems the AS/400 supports. Currently there is support for PC file systems, Unix file systems, OS/400 libraries, and others.  The IFS provides access to the data. The data must be in compatible format for the requesting application. </span></div><h3><span style="font-size: large;">DB2/400 Database – The Integrated Database</span></h3><div class="MsoNormal"><span style="font-size: large;">The AS400 contains a relational database called DB2/400. DB2/400 is integrated into the AS/400 partly above the MI and partly in the LIC. Conventional databases are separate software components that reside on top of the operating system. Since DB2/400 is integrated throughout the entire system it can achieve a higher level of efficiency because it is tightly integrated with the components with which it communicates. The database management system (DBMS) is a framework for storing and retrieving data. A DBMS must have an interface so users can access and manipulate the data. There are two interfaces to the AS/400: The Data Description Specifications (DDS) and Structured Query Language (SQL).  The DDS, or the native interface, was carried over from the IBM System/38. It has a look and feel similar to IBM’s Information Management System (IMS). The second interface for the AS/400 is SQL. This is the industry standard for relational databases and is an optional product that you must purchase separately. </span></div><h3><span style="font-size: large;">Data Warehousing</span></h3><div class="MsoNormal"><span style="font-size: large;">DB2/400 supports data warehousing. The four main components that DB2/400 utilizes for data warehousing are:  transformation and propagation tools to load the data warehouse, the data warehouse database server, analysis and end-user tools, and tools to manage the information about the data warehouse. </span></div><span style="font-size: large;">Transformation and propagation tools are used to move and manipulate data into a form more appropriate for the warehouse. It transforms operational data into informational data. <br />IBM introduced special models of the AS/400 that are able to handle the types of workloads use in data warehousing applications. These database servers utilize parallel processing and multidimensional databases. The AS/400 uses parallel I/O processing (IOP). This allows parallel processing at the I/O level for a single job.  By doing this it helps increase I/O processing time. The AS/400 also can take a single query and break it down to independent queries and these are run in parallel across the multiple processors in the system. This can increase performance for the original query. <br />Most relational databases are organized as two-dimensional tables.  A multidimensional databases has one or more additional dimensions. DB2/400 can create a three-dimensional data structure. These structures have three axis’s and look like a three dimensional spreadsheet. <br />The DB2/400 uses business intelligence tools to analyze the data in the data warehouse. These include: Decision support (DSS) tools, executive information systems (EIS), and data mining tools. DSS tools allow the user to create questions, in the form of queries, to get answers to the questions. They enable the user to create ad hoc queries and build reports. EIS’s combine DSS tools with some extended analysis capabilities. Data mining tools allow for the discovery of information with little or no direction from the user. The system searches through the data to determine patterns or associations. <br /></span><h3><span style="font-size: large;">Objects</span></h3><div class="MsoNormal"><span style="font-size: large;">The AS/400 is sometimes described as an object based system because objects are a fundamental part of the design of the system. Almost everything in the AS/400 is an object. These include data files, user profiles, job queues, message queues, print queues, compiled programs, word processing documents, menus, etc. On the AS/400 objects are categorized by type, which allow the user to specify what type of objects are required for a given task. There are OS/400 objects and MI system objects. Some OS/400 objects map one to one with MI system objects, but other have a one to many mapping. This is because some OS/400 objects need to map to multiple MI system objects. All OS/400 objects map to at least one MI system object. The object is assigned an owner when it is created. The owner is either the user or the group profile that created the object. When the object is created, the owner is given all the object and data authorities to that object. </span></div><h3><span style="font-size: large;">Libraries</span></h3><div class="MsoNormal"><span style="font-size: large;">A library is an OS/400 object that is used to find other OS/400 objects in the database. <br />The library is organized as a single-level hierarchy, unlike the directory structure found on PCs which have a multilevel hierarchy. To find an OS/400 system object you need the name of the library and the name of the object.  The AS/400 identifies objects by their qualified name, which takes the form of LIBRARY/OBJECT.   For example, to find the object MONEY in the library PAYROLL you would reference this as PAYROLL/MONEY. Two or more objects can have the same name but they must be different types of objects. For example you could have a program named TEST and a data space named TEST, but not two programs named TEST. An object can exist in only one library. A library cannot reference other libraries except for the library called QSYS. This is the only library that can access other libraries. </span></div><h3><span style="font-size: large;">Physical Files</span></h3><div class="MsoNormal"><span style="font-size: large;">A physical file holds the actual data. The physical file record has a fixed set of fields. Each field can have variable lengths. A physical file has two parts. The first part contains the file attributes and field descriptions. The file attributes include the file’s name, owner, size, number of records in the file, key fields, and other attributes.  The field descriptions hold the attributes for each field in the record. The second part of a physical file contains the data. </span></div><h3><span style="font-size: large;">Logical files</span></h3><div class="MsoNormal"><span style="font-size: large;">Logical files allow a user to access data in a format that is different from the way it is stored in one or more physical files. The logical file contains no data records. It contains the corresponding record number of the data record in the physical file. The logical file will contain the index to the physical file. Logical files provide the path to the physical file. There are four types of logical files. The first is the simple logical file. This maps data from a single physical file to another logical record definition. The second is the multiple-format logical file.  This logical file allows access to several physical files. The third type of logical file is the join logical file. The join logical file defines a single record definition that is built from two or more physical files, tables, logical files, or views. The total number of physical files and tables cannot exceed 32. The forth type of logical file is the SQL view. These are similar to join logical files but SQL view logical files locate the access path at run time by use of the Query Definition Template and are not maintained by each join. </span></div><h3><span style="font-size: large;">Collections</span></h3><div class="MsoNormal"><span style="font-size: large;">A collection is a grouping of related SQL objects. This is the SQL name for a library in the native interface. </span></div><h3><span style="font-size: large;">DirectConnect Related Issues</span></h3><div class="MsoNormal"><span style="font-size: large;">NULLID Collection – The AS400 Access Service (ACS) requires certain files on the AS/400. It looks for these files in a collection called NULLID. The collection must be created before installing the service. The NULLID collection contains the service package which the system creates when the ACS submits the first request to the AS/400. It also contains a package for each AS/400 stored procedure the user creates. Finally, the NULLID collection contains the SYSPROCS and SYSPROCCOL catalog stored procedures table. </span></div><span style="font-size: large;">The script cspas4.sql creates the tables SYSPROCS and SYSPROCCOL in the NULLID collection. If you are going to use Catalog Stored Procedures against the AS/400 you will need to run this script. <br /> </span><span style="font-family: "Times New Roman","serif"; mso-ansi-language: EN-US; mso-bidi-language: AR-SA; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-US;"><span style="font-size: large;">In your DirectConnect configuration the TPName for the AS400 must be the value \x7F6DB. This is the transaction program name for the DRDA Application Server on the AS/400. <br /></span><!--[if !supportLineBreakNewLine]--><br /><!--[endif]--></span></div>

AS/400-iSeries Concepts and Terminology

AS/400-iSeries Concepts and Terminology    The purpose of this post is to give a high level overview of the AS400-iSeries and some of the co...

Read more »

Structural Engineering Research Centre (SERC) announced Scientist job posts Recruitment Notification

<div dir="ltr" style="text-align: left;" trbidi="on"><h1 style="margin: 0px; padding: 0px; text-align: left;"><span style="font-family: Helvetica, Arial, sans-serif; font-size: large;"><span style="letter-spacing: -0.25px;">Structural Engineering Research Centre (SERC) announced Scientist job posts Recruitment Notification</span></span></h1><div><br /></div><div><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjvk8WKbCNb4GwwnR5oJ0P7AgSAGnwRaWdPopD3qp3goayJCW-6hqyqPaQVH0aopi66-wCvN57lgT9Y2xLmEYLVw3iX_XBRb1tdLVOM9Mf4wFHlrFryIWYefrNpO4DoVBYElT5GZe-MP68/s1600/CSIR-Structural-Engineering-Research-Centre_thumb.jpg" style="clear: left; margin-bottom: 1em; margin-right: 1em; text-align: center;"><img border="0" height="99" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjvk8WKbCNb4GwwnR5oJ0P7AgSAGnwRaWdPopD3qp3goayJCW-6hqyqPaQVH0aopi66-wCvN57lgT9Y2xLmEYLVw3iX_XBRb1tdLVOM9Mf4wFHlrFryIWYefrNpO4DoVBYElT5GZe-MP68/s1600/CSIR-Structural-Engineering-Research-Centre_thumb.jpg" width="200" /></a></div><div><b style="font-family: Helvetica, Arial, sans-serif; line-height: 18.2px;"><span style="font-size: large;">Structural Engineering Research Centre (SERC)</span></b></div><div class="itemcontent" name="decodeable" style="font-family: Helvetica, Arial, sans-serif; line-height: 18.2px; overflow: hidden; width: 693px;"><span style="background-color: white; font-size: large;"><i>(Council of Scientific and Industrial Research - CSIR)</i><br />CSIR Campus, TTTI Taramani P.O.,Chennai - 600113<br /><br /><br />Advertisement No. : SE-1/2020<br /><br />Structural Engineering Research Centre (SERC) , Chennai, is a premier National Laboratory under the CSIR. The Centre invites Online applications from highly qualified and motivated candidates for taking up R&D activities and also for providing engineering services to solve the problems of the industry and the society besides participating in the development of laboratory facilities.</span></div><div class="itemcontent" name="decodeable" style="font-family: Helvetica, Arial, sans-serif; line-height: 18.2px; overflow: hidden; width: 693px;"><span style="background-color: white; font-size: large;"><br /><a href="https://www.blogger.com/null" name="more"></a></span><ol style="list-style-image: initial; list-style-position: initial; margin: 0px 0px 1em; padding: 0px;"><li style="margin: 0px 0px 0.5em 2.4em; padding: 0px;"><span style="background-color: white; font-size: large;"><b>Scientist </b> : 06 posts (UR-4, OBC-1, SC-1), <b>Pay Scale</b> : PB-3 Rs.15600-39100 Grade Pay Rs. 6600,<b>Age </b>: 32 years </span></li><li style="margin: 0px 0px 0.5em 2.4em; padding: 0px;"><span style="background-color: white; font-size: large;"><b>Senior Scientist </b>: 02 posts (UR-2), Pay Scale : PB-3 Rs.15600-39100 Grade Pay Rs. 7600, Age : 37 years</span></li></ol><div align="justify"><span style="background-color: white; font-size: large;"><b>Application Fee :</b> Crossed Demand Draft for Rs.100/- drawn in favour of I.R.F, SERC payable at Chennai towards application fee. No fee for SC/ST candidates.</span></div><div align="justify"><span style="background-color: white; font-size: large;"><br /><br /><b>How to Apply</b> : Apply Online at SERC website from <b>03/05/2020 to 26/05/2020</b> only and take a printout of the system generated application format, and send it with a photograph pased on it with copies of relevant documents/testimonials and application fee on or before 06/06/2014 to <b>The Administrative Officer, CSIR - Structural Engineering Reserach Centre, CSIR Campus, Post Box No. 8287, TTTI Taramani Post Office, Chennai - 600113 (TN)</b></span></div><div align="justify"><span style="background-color: white; font-size: large;"><b><br /></b></span></div><div align="justify"><span style="background-color: white; font-size: large;"><br />Please visit <a href="http://www.serc.res.in/recruitment.html" style="color: #000099; font-weight: bold; text-decoration: none;">http://www.serc.res.in/recruitment.html</a>  for detailed information and apply online.</span></div><div align="justify" style="font-size: 14px;"><span style="background-color: white;"><br /></span></div><div align="justify" style="font-size: 14px;"><span style="background-color: white;"><div dir="ltr" style="text-align: left;" trbidi="on"><span style="font-family: helvetica; font-size: large; line-height: 18.2px; text-align: justify;">Jobklix provides you recruitment notifications only you should refer official website of related department. Subscribe Free!!  for upcoming exams, job notifications, study material, latest walk-ins, latest </span><span style="font-family: helvetica; font-size: large; text-align: justify;">job fairs and more...</span></div><div style="font-family: "Times New Roman"; font-size: medium; line-height: normal; text-align: left;"><span style="font-family: helvetica; font-size: medium;"><br /></span></div><ul style="font-family: "Times New Roman"; font-size: medium; margin: 0px; padding: 0px;"><li style="background-attachment: inherit; background-clip: inherit; background-image: inherit; background-origin: inherit; background-position: inherit; background-repeat: inherit; background-size: inherit; list-style-position: inside; list-style-type: initial; list-style: inside url(http://www.moviecinema.in/img/arrow-right.png); margin: 0px; padding: 10px 25px;"><b style="margin: 0px; padding: 0px;"><span style="color: blue; font-family: helvetica; font-size: medium;"><a href="https://www.facebook.com/jobklix" style="margin: 0px; padding: 0px; text-decoration-line: none;" target="_blank">Like us On FB Page</a></span></b></li><li style="background-attachment: inherit; background-clip: inherit; background-image: inherit; background-origin: inherit; background-position: inherit; background-repeat: inherit; background-size: inherit; list-style-position: inside; list-style-type: initial; list-style: inside url(http://www.moviecinema.in/img/arrow-right.png); margin: 0px; padding: 10px 25px;"><a href="https://twitter.com/jobklix" target="_blank"><b><span style="color: blue; font-family: helvetica; font-size: medium;">Follow us On Twitter</span></b></a></li><li style="background-attachment: inherit; background-clip: inherit; background-image: inherit; background-origin: inherit; background-position: inherit; background-repeat: inherit; background-size: inherit; list-style-position: inside; list-style-type: initial; list-style: inside url(http://www.moviecinema.in/img/arrow-right.png); margin: 0px; padding: 10px 25px;"><b><span style="color: blue; font-family: helvetica; font-size: medium;"><a href="https://www.jobklix.blogspot.com/" target="_blank">Upcoming Jobs/Job alerts/Sarkari Naukri/Latest updates</a></span></b></li></ul></span></div></div></div>

Structural Engineering Research Centre (SERC) announced Scientist job posts Recruitment Notification

Structural Engineering Research Centre (SERC) announced Scientist job posts Recruitment Notification Structural Engineering Research Centre ...

Read more »

Tripura Public Service Commission (TPSC) announced Judicial Service vacancies recruitment notification

<div dir="ltr" style="text-align: left;" trbidi="on"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhYChe-oFPz7UsXhhmB_T-NrRrmg8Ad3dl1IzgfwhYkvmMhHNcuMUX_MIV5nHs0OP8YDkV5r7w-dVI9G_5SjbC1r0iZoAUk5aQbSUWnkfRgjXOaIHWiEMMdyzrN-bJqWQ5oWypAdunkGO8/s1600/TPSC+logo.jpg" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="124" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhYChe-oFPz7UsXhhmB_T-NrRrmg8Ad3dl1IzgfwhYkvmMhHNcuMUX_MIV5nHs0OP8YDkV5r7w-dVI9G_5SjbC1r0iZoAUk5aQbSUWnkfRgjXOaIHWiEMMdyzrN-bJqWQ5oWypAdunkGO8/s1600/TPSC+logo.jpg" width="200" /></a></div><h1 style="margin: 0px; padding: 0px; text-align: left;"><span style="font-family: Helvetica, Arial, sans-serif; font-size: x-large;"><span style="letter-spacing: -0.25px;">Tripura Public Service Commission (TPSC)  announced  Judicial Service vacancies recruitment notification</span></span></h1><h5 class="itemposttime" style="color: #666666; font-family: Helvetica, Arial, sans-serif; font-weight: normal; margin: 3px 0px 6px; padding: 0px;"><span style="font-size: large;"><br /></span></h5><div class="itemcontent" name="decodeable" style="font-family: Helvetica, Arial, sans-serif; line-height: 18.2px; overflow: hidden; width: 693px;"><div dir="ltr" trbidi="on"><span style="background-color: white; font-size: large;"><span style="font-weight: bold;"><span>Tripura Public Service Commission (TPSC)</span> </span><br />Agartala, Tripura    <br /><br />Advt. No. 04/2014<br /><br />Applications are invited in the prescribed form from bonafide citizens of India for selection of candidates for recruitment to Tripura Judicial Service, Grade-III (Group-A Gazetted) under the Law Department, Government of Tripura  : <br /><a href="https://www.blogger.com/null" name="more"></a></span><ul style="list-style: square; margin: 0px 0px 1em; padding: 0px 0px 0px 1em;"><li style="margin: 0px 0px 0.5em 2.4em; padding: 0px;"><span style="background-color: white; font-size: large;"><b>Tripura Judicial Service </b>: 12 posts (UR-5, ST-5, SC-02)<b>,  </b>Age : 35 years as on 20/05/2014, Pay Scale : Rs. 27700 - 44700, Qualification : Degree in Law<b><br /></b></span></li></ul><span style="background-color: white; font-size: large;"><b>How to Apply</b> : Application form will be available in all branches of Tripura Gramin Bank which should filled and should be filled-in. Out of the Tripura candidates can download the application form from the website.   The last date of submission of application form is <b>20/05/2014</b>.<br /><br />Please view <a href="http://www.tpsc.gov.in/2014/16041401.pdf" style="color: #000099; font-weight: bold; text-decoration: none;">http://www.tpsc.gov.in/2014/16041401.pdf</a> for details   and application form is available at<a href="http://www.tpsc.gov.in/Appl.%20Form.pdf" style="color: #000099; font-weight: bold; text-decoration: none;">http://www.tpsc.gov.in/Appl.%20Form.pdf</a></span></div><div dir="ltr" style="font-size: 14px;" trbidi="on"><br /></div><div dir="ltr" style="font-size: 14px;" trbidi="on"><div dir="ltr" trbidi="on"><span style="font-family: helvetica; font-size: large; line-height: 18.2px; text-align: justify;"><br /></span></div><div dir="ltr" trbidi="on"><span style="font-family: helvetica; font-size: large; line-height: 18.2px; text-align: justify;">Jobklix provides you recruitment notifications only you should refer official website of related department. Subscribe Free!!  for upcoming exams, job notifications, study material, latest walk-ins, latest </span><span style="font-family: helvetica; font-size: large; text-align: justify;">job fairs and more...</span></div><div style="font-family: "Times New Roman"; font-size: medium; line-height: normal;"><span style="font-family: helvetica; font-size: medium;"><br /></span></div><ul style="font-family: "Times New Roman"; font-size: medium; margin: 0px; padding: 0px; text-align: justify;"><li style="background-attachment: inherit; background-clip: inherit; background-image: inherit; background-origin: inherit; background-position: inherit; background-repeat: inherit; background-size: inherit; list-style-position: inside; list-style-type: initial; list-style: inside url(http://www.moviecinema.in/img/arrow-right.png); margin: 0px; padding: 10px 25px;"><b style="margin: 0px; padding: 0px;"><span style="color: blue; font-family: helvetica; font-size: medium;"><a href="https://www.facebook.com/jobklix" style="margin: 0px; padding: 0px; text-decoration-line: none;" target="_blank">Like us On FB Page</a></span></b></li><li style="background-attachment: inherit; background-clip: inherit; background-image: inherit; background-origin: inherit; background-position: inherit; background-repeat: inherit; background-size: inherit; list-style-position: inside; list-style-type: initial; list-style: inside url(http://www.moviecinema.in/img/arrow-right.png); margin: 0px; padding: 10px 25px;"><a href="https://twitter.com/jobklix" target="_blank"><b><span style="color: blue; font-family: helvetica; font-size: medium;">Follow us On Twitter</span></b></a></li><li style="background-attachment: inherit; background-clip: inherit; background-image: inherit; background-origin: inherit; background-position: inherit; background-repeat: inherit; background-size: inherit; list-style-position: inside; list-style-type: initial; list-style: inside url(http://www.moviecinema.in/img/arrow-right.png); margin: 0px; padding: 10px 25px;"><b><span style="color: blue; font-family: helvetica; font-size: medium;"><a href="https://www.jobklix.blogspot.com/" target="_blank">Upcoming Jobs/Job alerts/Sarkari Naukri/Latest updates</a></span></b></li></ul></div></div></div>

Tripura Public Service Commission (TPSC) announced Judicial Service vacancies recruitment notification

Tripura Public Service Commission (TPSC)  announced  Judicial Service vacancies recruitment notification Tripura Public Service Commission (...

Read more »