Can you show the CREATE TABLE Statement?
Can you post the complete SELECT Statement?
You are really using case sensitive column names?
In your WHERE Condition is only the LIKE condition?
The following SQL Statements work for me in ACS Run SQL Scripts (even with
prompting and selecting from the list)
Create Table HSCOMMON05.TestCust
("customerNo" For CustNo Integer Not NULL Default 0,
"customerName" For CustName VarChar(50) Not NULL Default '');
Insert into HSCOMMON05.TestCust
Values(1, 'Hauser'), (2, 'Meier'), (3, 'Schmidt'), (4, 'Müller');
Select * from HSCOMMON05.TestCust
Where "customerName" Like '%aus%';
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!"
?Train people well enough so they can leave, treat them well enough so they
don't want to.? (Richard Branson)
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Jon
Paris
Sent: Samstag, 6. Februar 2021 00:29
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Weird (?) Run SQL Scripts behavior
I'm guessing I'm missing a setting somewhere but ...
In Run SQL scripts I entered:
select * from partner400.customers where
And then promoted for column names.
I picked the column customerName from the list and it was inserted as
"customerName"
I added the entry:
LIKE '%beer%';
And ran the statement.
It gives an error saying that no such column could be found. Tried removing
the double quotes but to no avail.
Anyone got any ideas on what I'm doing wrong here? The ACS version I'm
using is current I think (version 1.1.8.6).
Jon Paris
--
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.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
midrange.com
