Sumit goyalDB2 SQL GLOBAL TEMPORARY TABLEDECLARE GLOBAL TEMPORARY TABLE gives you a handy option to create a table in QTEMP lib with some handy options.Jul 21, 2021Jul 21, 2021
Sumit goyalDB2 SQL BASIC — 1Structured Query Language aka SQL is the industry standard to talk to Relation database management systems (RDBMS). RDBMS and SQL are like…Jul 21, 2021Jul 21, 2021
Sumit goyalDB2 SQL CURSOR : POSITIONED UPDATE & DELETEWhen processing a CURSOR, DB2 SQL gives the option to update or delete data in the base table based on CURSOR's current position in the…Jul 21, 2021Jul 21, 2021
Sumit goyalDB2 SQL CURSORThe result of a SELECT Statement which returns more than one row, is easy to view on an SQL interface like STRSQL. But How can we handle…Jul 21, 2021Jul 21, 2021
Sumit goyalDB2 SQL FIND nth HIGHEST NUMBER.We can use a very simple correlated query to find the nth highest or lowest record in a table.Jul 21, 2021Jul 21, 2021
Sumit goyalDB2 DYNAMIC SQLThere are two ways to write SQL: Static SQL, which gets the job done in most cases, and the second one is Dynamic SQL for the rest of the…Jul 21, 2021Jul 21, 2021