Questions tagged [db2-11.5]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
149 views

How to set or grant SELECTINAUTH for a schema in DB2 11.5

I'm running DB2 11.5 and want to grant select, insert, update or delete rights for all tables in a specific schema. SELECTINAUTH etc. seems to be perfect for this. When I'm looking to the SYSCAT....
0
votes
1answer
29 views

date variable manipulation

I'm working on DB2 stored procedure, which will be called by the Korn Shell (.ksh). My DB2 version is 11.5 and it is running on AIX. I was stuck in TIMESTAMP to DATE conversion. Below is my ...