C – Get Ini File name from application name

Background I think back to my time down south. Straight out of College first job was C on an IBM OS/2 box; writing Insurance software for a company down in Australia. Get the Ini File name based on the executable file name filename.h filename.c Sharing Sharing here filename.h Link filename.c Link Dedicated Dedicating to my … Continue reading C – Get Ini File name from application name

Sharing Code Online – IBM.COM – “SQLDriverConnect() – Use a connection string to connect to a data source”

Background One of the interesting things about blogging is the headache of sharing code online. It is just cumbersome. Sample Courtesy of IBM, here is how teary eye things can be. SQLDriverConnect() - Use a connection string to connect to a data source Link Items Display failure return code Display "completed connection string"; which is … Continue reading Sharing Code Online – IBM.COM – “SQLDriverConnect() – Use a connection string to connect to a data source”

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] )