Joins can be categorized as:
•    Inner joins (the typical join operation, which uses some comparison operator like = or <>). These include equi-joins and natural joins.
Inner joins use a comparison operator to match rows from two tables based on the values in common columns from each table. For example, retrieving all rows where the student […]

• 1 Comment

Single row SELECTs.

a2a_linkname=”Apart from cursor, what other ways are available to you to retrieve a row from a table in embedded SQL?”;a2a_linkurl=”http://itquestions.info/apart-from-cursor-what-other-ways-are-available-to-you-to-retrieve-a-row-from-a-table-in-embedded-sql/”;

• 0 Comments

Use DECLARE CURSOR statement either in working storage or in procedure division (before open cursor), to specify the SELECT statement.  Then use OPEN, FETCH rows in a loop and finally CLOSE.

a2a_linkname=”How do you specify and use a cursor in a COBOL program?”;a2a_linkurl=”http://itquestions.info/how-do-you-specify-and-use-a-cursor-in-a-cobol-program/”;

• 0 Comments

If there is an ORDER BY clause, rows are fetched, sorted and made available for the FETCH statement. Other wise simply the cursor is placed on the first row.

a2a_linkname=”What happens when you say OPEN CURSOR?”;a2a_linkurl=”http://itquestions.info/what-happens-when-you-say-open-cursor/”;

• 0 Comments