Managing multiple diverse database platforms and hybrid environments has become the new norm for DBAs. But the evolving database landscape comes with its challenges. In this video, Computer Weekly Edi...
Introduction PostgreSQL database is one of the leading open source databases, with unique features such as support for advanced datatypes including multidimensional arrays and user0defined types, comm...
In the last entry posted to this blog , I described the mechanisms (including PUNC bits and commit log sequence numbers, aka CLSNs) used by Db2 for z/OS for lock avoidance purposes (lock avoidance her...
This video shows users how to view and work with Group Execute in Toad for SQL Server....
Oracle R Enterprise Server Overview Oracle R Enterprise includes several components on the server. Together these components enable an Oracle R Enterprise client to interact with Oracle R Enterprise S...
I recently read a blog post where the writer was talking about importing a spreadsheet into their database. As I was reading this, I asked myself “why”? Why not just connect to your database and you...
Oracle recently announced their Oracle Intelligent Bot application just before Oracle Open World, coming as part of the Oracle Cloud Enterprise Suite cloud service. Chatbots are part of our future in...
Hi, This article will discuss some timings from last month’s FORALL load times. I had a student from a class share his timings using newer syntax that he learned in my class. I will talk about some ...
Toad DB2 Expert, Jeff Podlasek, demonstrates z/OS features in Toad for DB2 that can assist you to optimize performance of your DB2 environments....
Toad DB2 Expert, Jeff Podlasek, demonstrates features in Toad for DB2 z/OS and DB2 LUW that can help you optimize performance of your DB2 environments....
This zip file contains a Word doc that explains how you can use a backend API call in the my_codetester package to use Code Tester with a centralized code schema (summary: you need to tell Code Tester...
Tips for testing attributes of object types Suppose my code is this: CREATE OR REPLACE PROCEDURE qctod#out_object ( firstname_in IN VARCHAR2 , lastname_in IN VARCHAR2 , name_object_out OUT qctod#na...
