What is the correct type of an sql function that uses an external rpg function?
------------------------------
Thejwal Pavithran
Rocket Forum Shared Account
------------------------------
Page 1 / 1
What is the correct type of an sql function that uses an external rpg function?
------------------------------
Thejwal Pavithran
Rocket Forum Shared Account
------------------------------
------------------------------
Thejwal Pavithran
Rocket Forum Shared Account
------------------------------
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
------------------------------
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.