![]() |
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
![]() Related Questions An embedded sql statement may return a number of rows while the programming language can only access one row at a time. The programming device called a cursor controls the position of the row. Latest Answer : hi friends, In DB2 actually we use CURSOR when there are more than one row to be fetched in a SELECT statement. ... SQL statements may return any number of rows, but most host languages deal with one row at a time by declaring a cursor that presents each row at a unique isolation level. It is a data structure that must be included in any host-language program using SQL. It is used to pass feedback about the sql operations to the program. Fields are return codes, error messages, handling Latest Answer : SQLCA is t communication area wher v can check t return codes, no of updated , deleted records it contains SQLCODE, SQLERRD, SQLERRM etc..... ... Latest Answer : You should use cobol defined variable RETURN-CODE in you cobol program ... Which of the following is not a purpose of a View ?a.To simplify the appearance of data to different usersb.To control access to a tablec.To show more meaningful data, such as summaryd.To store data separately Table1 has 6 rows and Table2 has 6 SELECT * FROM Table1, Table2; a.6b.12c.36d.720e.Cannot sayrows.36 Latest Answer : Bind the database to avoid the -805 error.The package was not bound or it was dropped. If attempting to run a DB2 utility or CLI application, the DB2 utilities may need to be rebound to the database.'%.pkgname' if the CURRENT PACKAGE PATH is set ... If, for a given table, the Control Center does not show the choice Generate DDL, which of the following describes the reason? A. The table is a system object. B. The table is a summary table. C. The table If, for a given table, the Control Center does not show the choice Generate DDL, which of the following describes the reason? A. The table is a system object. B. The table is a summary table. C. The table
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||