Describe the elements of the SELECT query syntax. SELECT element FROM table WHERE conditional statement?
Joins, unions and nested selects are used to retrieve data.
Latest Answer : The two tables has to be linked.EXEC SQL
SELECT A.EMP_ID, B.WAGE FROM Table1 A, Table2 B WHERE A.EMP_ID = B.EMP_ID
AND A.EMP_ID = ...
What is the cascade rule and how does it relate to deletions made with a subselect. The cascade rule will not allow deletions based on a subselect that references the same table from which the deletions are being made?
A31. The self-referencing constraint limits in a single table the changes to a primary key that the related foreign key defines. The foreign key in a self referencing table must specify the DELETE CASCADE
Static sql is hard-coded in a program when the programmer knows the statements to be executed. For dynamic sql the program must dynamically allocate memory to receive the query results.
A Cartesian product results from a faulty query. It is a row in the results for every combination in the join tables.
Latest Answer : IF YOU CREATE A PRIMARY KEY IT IS MANDATORY THAT YOU SHOULD CREATE AN INDEX FOR THAT TABLE ON THAT PRIMARY KEY,WITHOUT WHICH YOU CAN NOT ACCESS THE TABLE ...
I'm looking out for some solution or website that can lead me to the following issues that i currently face. Could some one please help me out on these. Loading of ‘DB2 Unload with packed Decimal’ data to Oracle environment Loading of Cobol Data streams with HEX Character data to Oracle environment Are there any tools, mechanisms in Oracle or any other third party product? (Prefer an Oracle solution).
Latest Answer : group :- is used to find the sum and orderby is like checking the condition .furter explansion will be provided upon req! ...
What is a collection ID? What is its significance? How to execute the different versions of a Cobol-DB2 programs (different regions) from a single jcl?
