Re: Determining if a particular objet exists in the ifs

[Kevin Bucknum <Kevin@xxxxxxxxxxxxxxxxxxx>]

https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_74/rzajq/rzajqudfifsobjstat.htm

On Mon, 2021-02-08 at 13:52 +0000, Alan Shore via MIDRANGE-L wrote:

Hi folks

We are on V7r3

Does anyone know of any methods (SQL, api'setc.) to determine if an object exists in the ifs

This has to be inserted into an SQLRPGLE program

My google search is displaying a lot of older methods using CLP, but I would prefer using something more modern

I will keep looking through my search - but as always, all answers gratefully accepted


Alan Shore

Solutions Architect

IT Supply Chain Execution


[cid:

<mailto:image003.png@01D6FDF7.BF921660>

image003.png@01D6FDF7.BF921660

]


60 Orville Drive

Bohemia, NY 11716

Phone [O] : (631) 200-5019

Phone [C] : (631) 880-8640

E-mail :

<mailto:ASHORE@xxxxxxxxxxxxxxxxxxxx>

ASHORE@xxxxxxxxxxxxxxxxxxxx



'If you're going through hell, keep going.'

Winston Churchill




The Nature’s Bounty Co. is now The Bountiful Company! Our email address will be changing from @nbty.com to @bountifulcompany.com. Please update your email address book so that important communications are not interrupted.



[https://www.medtronsoftware.com/img/MedtronMinilogo.bmp]  Kevin  Bucknum
                   Senior Programmer Analyst
                   MEDDATA / MEDTRON
                   120 Innwood Drive
                   Covington LA 70433
                   Local: 985-893-2550
                   Toll Free: 877-893-2550
                 https://www.medtronsoftware.com



CONFIDENTIALITY NOTICE

This document and any accompanying this email transmission contain confidential information, belonging to the sender that is legally privileged.  This information is intended only for the use of the individual or entity named above.  The authorized recipient of this information is prohibited from disclosing this information to any other party and is required to destroy the information after its stated need has been fulfilled.  If you are not the intended recipient, or the employee of agent responsible to deliver it to the intended recipient, you are hereby notified that any disclosure, copying, distribution or action taken in reliance on the contents of these documents is STRICTLY PROHIBITED.  If you have received this email in error, please notify the sender immediately to arrange for return or destruction of these documents.