About Frank-Martin

Frank-Martin

In various previous blogs, I described how to access ABAP CDS view entities that are exposed by an SQL service in SQL queries using the ODBC driver for ABAP. (If you are not familiar with this topic, I recommend that you read the blog post Consuming ...

Frank-Martin

In this blog post, we will show how you can build up an Azure Data Factory (ADF) pipeline to load data from an SAP system using the ABAP SQL Service and the ODBC driver for ABAP. We will describe how we used a simplified Azure Data Factory pipeline s...

Frank-Martin

In this blog post, I’m going to explain the Insert Time Clustering (ITC) table type in Db2 for Linux, UNIX, and Windows (Db2 LUW) and show its major benefit: easy space reclamation. I’ll also show you how you can convert regular tables to ITC tables...

Frank-Martin

In my introductory blog post related to ABAP SQL services (Consuming CDS View Entities Using ODBC-Based Client Tools | SAP Blogs), I described how to expose CDS objects in a SQL Service, how to install the ODBC driver for ABAP on Windows, and how to ...

Frank-Martin

In previous blog posts, we showed you how you can access CDS view entities in an ABAP system using SQL via Open Database Connectivity (ODBC). The ODBC interface has the advantage that it allows unrestricted SQL access to all exposed ABAP CDS view ent...

Frank-Martin

You do not have to create a SICF entry. However on On Prem systems you have to make sure that all profile parameters are set correctly. This is mentioned in the On Prem documentation but you may have missed it. The required parameters are:wssql/activ...

Frank-Martin

Hi Michael,we believe that ALSM can provides a benefit and we received feedback from other customers that they would prefer to have it switched ON as a default. However it is just the new default and you can still explicitly switch it off even in Db2...

Frank-Martin

CLIENT=100 worked in my DSN example although I connected to an SAP BTP ABAP Environment system.In general you should not specify this parameter for an ABAP cloud system. On OnPrem systems it is required.

Frank-Martin

Hi Joachim,we decided to change the Db2 V11.5 parameter note 2751102. The note now requiresACT_SORTMEM_LIMIT=100and we added a comment that the value 100 and NONE are synonyms for this parameter.This is in line with the IBM documentation and should s...

Frank-Martin

Hi Joachim,yes, this is somewhat strange. For this parameter the value is displayed differently via "get db cfg" and by the corresponding table functions.We will need to check and discuss this.Regards Frank> db2 get db cfg for FMH | gre...

User Statistics

User Activity

Expose and Use ABAP-Managed Database Procedures (AMDPs) in SQL Services

Build an Azure Data Factory Pipeline with the ODBC Driver for ABAP

Simplified Space Reclaim Using Insert Time Clustering (ITC) Tables

Access CDS Objects Exposed as SQL Services Using Microsoft SQL Server

SQL Queries on CDS objects Exposed as SQL Service

Re: Consuming CDS View Entities Using ODBC-Based Client Tools

Re: Advanced Log Space Management (ALSM) as of Db2 for LUW Version 11.5

Re: Consuming CDS View Entities Using ODBC-Based Client Tools

Re: Paramter Check in Db2 (db6)

Re: Paramter Check in Db2 (db6)