SQL Trim around should be enough.
SELECT CAST(PATH_NAME AS
VARCHAR(500)) AS PATH_NAME, OBJECT_TYPE,CREATE_TIMESTAMP FROM TABLE(QSYS2.IFS_OBJECT_STATISTICS(TRIM(:directory) ,'YES'))
Or you define your variable as Varchar and %Trim() off the Blanks before.
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
Modernization – Education – Consulting on IBM i
Database and Software Architect
IBM Champion since 2020
"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!"
"Train people well enough so they can leave, treat them well enough so they don't want to. " (Richard Branson)
"Learning is experience … everything else is only information!" (Albert Einstein)
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Art Tostaine, Jr.
Sent: Thursday, 25 January 2024 20:39
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Make this SQL statement work with a variable name for PATH
Maybe: Do I put a %trim around :Directory or do I have to manipulate the variable before I use it?
On Thu, Jan 25, 2024 at 2:10 PM Birgitta Hauser <Hauser@xxxxxxxxxxxxxxx>
wrote:
Coud it be the variable is fixed length and your path has trailing *BLANKS?
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.
midrange.com
