Re: Help with SQL Procedure

Am 09.08.2024 um 16:27 schrieb Greg Wilburn <gwilburn@xxxxxxxxxxxxxxxxxxxxxxx>:

Charles... thanks.

The view still works... And regenerating the SQL source for the view is where I got the syntax below.
My user profile has *ALLOBJ.
I tried RCLDBXREF OPTION(*FIX) for that library.

I will post the question in midrange.

-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Charles Wilt
Sent: Friday, August 9, 2024 10:04 AM
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Help with SQL Procedure

One of the columns selected in my view is
ASTHHOBJ.TBF_SHIPBYDATE(PIK_DATE, PIK_TIME,PTY_CODE),

That show's it's definitely being used as a Function, so I'd be looking at the function node.

Does the view still work? When you generate the source for the view, does it show the above invocation ?

(WAG)
Does your user ID have *ALLOBJ? If not, maybe you can't see it?
Could try issuing GRANT or ALTER FUNCTION commands to see if you get a NOT ALLOWED or NOT FOUND.

Otherwise, I seem to recall an old issue where objects would fail to show in iNav..
Might try a RCLDBXREF OPTION(*FIX) for just that library.

This question is probably more appropriate for MIDRANGE-L rather than RPG-L.

Charles
--
This is the RPG programming on IBM i (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.

Greg Wilburn
Director of IT
301.895.3792 ext. 1231
--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.