RE: AW: SQL Check If File Exists (via RPG)

From: Hauser@xxxxxxxxxxxxxxx
To: midrange-l@xxxxxxxxxxxx
Subject: AW: SQL Check If File Exists (via RPG)
Date: Tue, 3 Nov 2015 06:52:17 +0100

You may check the existence of a table or view against the SysTables-View
located in the QSYS2 schema.:

Select 1 into :Exists
From SysTables
Where Table_Name = :YourTableName and Table_Schema =:YourTableSchema

The SQL statement above checks for the long names. If you prefer the
short/system names, those can be found in the System_Table_Name and
System_Table_Schema columns.

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"

-----Ursprüngliche Nachricht-----
Von: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von
Roger Harman
Gesendet: Tuesday, 03.11 2015 00:48
An: midrange-l@xxxxxxxxxxxx
Betreff: SQL Check If File Exists (via RPG)

I have a situation where I need to update/add/delete records in a historical
snapshot file (or files) if the current live file is changed (retro-active
changes).

The historical files are named by year/month and may or may not exist for
a selected record.

Looking for suggestions on the quickest easiest way to verify a file's
existence. This will be in a trigger program.

Thanks.


Roger Harman
COMMON Certified Application Developer – ILE RPG on IBM i on Power



--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.