SAP NPL 7.52 does not start

This time I will show you how to fix the issue with your SAP ABAP Developer instance which don’t want to start. This article is about the license issue, which has expired 1.04.2021. In this case, the command starts ALL, will stick on: The database is not available via R3trans ------------------------------------------- starting database NPL ... Log file: /sybase/NPL/startdb.log Or Stop returns modlib.jslib.caughtException We have to download a new license file from https://developers.sap.com/trials-downloads.html?search=ABAP under the section SAP NetWeaver AS ABAP Developer Edition 7.52 SP04 ...

April 2, 2021 · 1 min

SQL ON conditions in left join

Even if you use SQL for your daily work, it is possible that you might don’t know about two ways to set a condition: using “where” and .. put the condition into the join. The main issue is that they can return different results. Let me explain more. 1.Let’s assume that you have 2 tables. Content of first one 2.Content of the second one Now let’s get only this employees with salary bigger than 4 000 select * from employees emp left join salaries sal on emp.id = sal.employee where sal.salary > 4000 ...

April 14, 2019 · 3 min