Flow
Flow

Reputation: 21

DB2 for IBM i: Missing sql_function

A customer cannot use the offset-clause (https://www.ibm.com/docs/en/i/7.2?topic=subselect-offset-clause), although having V7R2.

My guess is that the sql_function isn't installed.

Is there a way a view to check for installed system functions ?

And how can you install the function/sql_package ?

Upvotes: 1

Views: 171

Answers (1)

nfgl
nfgl

Reputation: 3212

PTF SF99702 Level 19 is needed, see here.

Check installed level with

wrkptfgrp sf99702

Upvotes: 3

Related Questions