ANSI Standards – Database – Substring

Background Reviewing some SQL and wanted to point out a tiny dissimilarity between database platforms. Data Our test table is Oracle's SCOTT.EMP Here is what the data looks like :- Substring/Substr The HIREDATE is the only well formatted fixed length string. Its format is DD-MMM-YY. Query Oracle SQL Output Explanation Oracle relies on Substr to … Continue reading ANSI Standards – Database – Substring

Database – Buffer Pool – Clearing

Background During Database performance stressing, data is ingested into memory and written to disk. As one tries out different database table structures and Data Manipulation Languages ( DML ) queries, one often finds it useful to clean the slate in between.   Granularity Like any other operation one can target processing against the server, database, … Continue reading Database – Buffer Pool – Clearing

IBM Divestiture – 2019

Background IBM recently completed its purchase of Raleigh's North Carolina Linux Powerhouse, Red Hat. As part of that corporate merger, it appears regulars whether here overseas are concerned of allowing too much vertical technology ( Application software, Operating System, and Integration Software ) to rest in a single entity.   Affected Product Lines HCL Software … Continue reading IBM Divestiture – 2019

Eclipse IDE – Installation On MS Windows

Background I have a need to review some of our applications configuration and interaction with our back end database. In this case we will use Eclipse as a client development tool; and use MS SQL Server as our back-end database engine. Eclipse IDE Artifacts Installer Eclipse Installer are available here :- Image Timeline As of … Continue reading Eclipse IDE – Installation On MS Windows

Db/2 – Error – The insert or update value of the FOREIGN KEY is not equal to any value of the parent key of the parent table ( SQL Error [23503] )

Background Wanted to go over an error I self generated so I can see the options available in Db/2 to address it. Error Error Image Error Text SQL Error [23503]: The insert or update value of the FOREIGN KEY "bank.transaction.FK_bank_transaction_account" is not equal to any value of the parent key of the parent table.. SQLCODE=-530, … Continue reading Db/2 – Error – The insert or update value of the FOREIGN KEY is not equal to any value of the parent key of the parent table ( SQL Error [23503] )

Db/2 – CLP – Case Sensitivity

Background Playing around with Db/2 Command Line and ended up with an interesting insight. Query Here is the query :- Error Error Text Error Image Remediation Escape Object Name Objective Please quote object names by enclosing the schema and table in double quotes. And, escape the double quotes with a back slash. SQL Output

Db/2 – SQL – Compound Statements Using Atomic Keyword

Background Wanted to provide sample code on supporting so called "Compound Statements" in Db/2 LUW. Definition Here is IBM's Definition: A compound statement groups other statements together in an SQL routine. A compound statement allows the declaration of SQL variables, cursors, and condition handlers. Outline Housekeeping Db2 CLP Revert Statement Terminator to ; Turn off auto-commit … Continue reading Db/2 – SQL – Compound Statements Using Atomic Keyword