There isn't a SELECT statement.
The stored procedure does a SET RESULTS SETS.
The client does a CALL.
date: Thu, 29 Dec 2022 14:39:25 -0600
from: Javier Sanchez <javiersanchezbarquero@xxxxxxxxx>--
subject: Re: Stored procedure column names
Try forcing them to lowercase, i.e.:
SELECT COL_A as "col_a"...
Make sure to enclose them in doble quotes.
Try that and let us know.
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,
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
Help support midrange.com by shopping at amazon.com with our affiliate
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.