RE: How to get "System Name" for columns in a cursor when using SQL-CLI -- MIDRANGE-L

Subject: RE: How to get "System Name" for columns in a cursor when using SQL-CLI
From: Rob Berendt <rob@xxxxxxxxx>
Date: Thu, 5 Aug 2021 13:47:07 +0000
List-archive: <https://archive.midrange.com/midrange-l/>
List-post: <mailto:midrange-l@lists.midrange.com>
List-subscribe: <https://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@lists.midrange.com?subject=subscribe>
List-unsubscribe: <https://lists.midrange.com/mailman/options/midrange-l>, <mailto:midrange-l-request@lists.midrange.com?subject=unsubscribe>

You may not even have to use the AS. I believe SQL will allow you to use either the system column name or the long name on the select. However I still see what you are saying.

With DDS you can use both the long name and the short name. That's what the ALIAS keyword in DDS is for.

Rob Berendt

As an Amazon Associate we earn from qualifying purchases.

This mailing list archive is Copyright 1997-2025 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.