× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. RPG400-L
  3. June 2023

Re: SQL Embedded in RPG

On Fri, 30 Jun 2023 at 16:07, Mohan Eashver <mohankva@xxxxxxxxx> wrote:

I must be making a rookie mistake while composing the SQL string & I cannot
identify what it is.

MY_RAW_SQL_STR =
....5...10...15...20...25...30...35...40...45...50...55...60
1 'Select Path_Name From Table(Qsys2.IFS_Object_Statistics(Star'
61 't_Path_Name => '/i3pl/CD/arc/', Subtree_Directories => 'YES''
121 ', Object_Type_List => '*ALLSTMF')) X Where Lower(Get_Clob_Fr'
181 'om_File(Path_Name)) like '%00353970985316338146%' '
241 ' '
301 ' '
361 ' '
421 ' '
481 ' '

https://www.ibm.com/docs/en/i/7.4?topic=constants-literals
The first paragraph describes how to include an apostrophe in a
character literal.

--buck

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.