What is the maximum number of allowed BRMS configuration objects (Classes, Media Policy’s, Locations, Devices)?
SAP on IBM i Webcast on June 23rd, 2021: Technical Monitoring Cockpit
Earlier this year in March, we have informed you in a blog entry about the IBM i Platform Enablement for SAP’s new Technical Monitoring Cockpit (TMC) 2.0. In our next SAP on IBM i Webcast, Edgardo Gildo König and Dr. Thomas Obermeier, two of the TMC developers, will give you …
Table with self-incrementing primary key and current time field
How to get a primary key field that increments itself and a time field that updates itself?
Look at LGID00 and LGDTTM fields.
Create a table:
CREATE TABLE LGCUS00F
(
LGID00 INTEGER GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
LGDTTM TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
LGNAME CHAR(50),
LGSURN CHAR(50))
RCDFMT LGCUS
Now try to add a record:
INSERT INTO LGCUS00F (LGNAME, LGSURN)
VALUES (‘Aldo’, ‘Succi’)
Let’s see the result:
SELECT * FROM LGCUS00F
As you can see, LGID00=1 and LGDTTM=2018-04-01-10.01.49.781922
That’s it!
RT @Sever_i: Heads up to all #IBMi users using an ILE C++ applications Be careful with the latest Cumulative PTF package. There is a change…
Liam barry Allan (@notesofbarry) retweeted:
Heads up to all #IBMi users using an ILE C++ applications
Be careful with the latest Cumulative PTF package. There is a change of the C++ runtime in it. Yesterday IBM has recognized this change as an official defect.
– Severin Romanov (@Sever_i)11:49 – 2021/05/18
How to Use WebSphere Application Server startServer/stopServer Scripts Without *ALLOBJ Authority
This document describes the explicit authorities required to invoke the startServer and stopServer WebSphere Application Server Administration QShell scripts with an IBM i user profile without *ALLOBJ authority.
