×
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.
SQL Workbench will sometimes reformat statements that way. I was always surprised that it sill worked.
Roger Harman
COMMON Certified Application Developer - ILE RPG on IBM i on Power
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of Rob Berendt
Sent: Friday, June 26, 2020 12:35 PM
To: Midrange Systems Technical Discussion
Subject: Extra spaces not an issue
Just found out that you can have extra spaces in qualified statements like this
SELECT FSXCMD
FROM gdi . QUSRBRM . QA1AFS
WHERE FSNAME = 'QLNKOMT';
The above will work as well as
SELECT FSXCMD
FROM gdi.QUSRBRM.QA1AFS
WHERE FSNAME = 'QLNKOMT';
In fact, when you run the generate_sql procedure it will put the extra spaces in there. That's what got me started. I thought it was a bug.
Just something to know.
Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com
midrange.com
