Skip to main content
What is the correct type of an sql function that uses an external rpg function?

------------------------------
Thejwal Pavithran
Rocket Forum Shared Account
------------------------------
What is the correct type of an sql function that uses an external rpg function?

------------------------------
Thejwal Pavithran
Rocket Forum Shared Account
------------------------------
Hi Thejwal,

Thank you for your enquiry.

This would be an object Type *PROC Extended attribute = EXT

This would be described to LMi as follows:
LMi Main Menu > 1. Work with objects by release > F6=Add object >
Object name  = [The system Specific name]
Object type . . . . . . *PROC
Object attribute . . . .
Extended attribute . . . EXT +
...
Source option . . . . . 2 (or 9)
Source file . . . . . QSQLSRC (or similar)
Source member . . . . *SYSOBJNAM

> On Enter, you would be prompted for:
Procedure name . . . *OBJNAME (NOTE: if the SQL Procedure name (Long Name) is different from the Specific name, it would be stated here)

Best regards

------------------------------
Jay Mikaiel
Senior Technical Support Engineer
Rocket Software
UK
------------------------------