Re: anyone have an SQL FUNCTION like this they can share? -- MIDRANGE-L

Subject: Re: anyone have an SQL FUNCTION like this they can share?
From: Jon Paris <jon.paris@xxxxxxxxxxxxxx>
Date: Mon, 15 Jun 2009 16:08:08 -0400
List-archive: <http://archive.midrange.com/midrange-l>
List-help: <mailto:midrange-l-request@midrange.com?subject=help>
List-id: Midrange Systems Technical Discussion <midrange-l.midrange.com>
List-post: <mailto:midrange-l@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=unsubscribe>

On 15-Jun-09, at 3:45 PM, midrange-l-request@xxxxxxxxxxxx wrote:

I should have clarified this. Even though the query is being executed as
embedded SQL in the COBOL program, the program is depending on SQL to return
the data already formatted and concatenated as a single string.

Um - I'm confused. That's _exactly_ what my suggestion does. Wrap a few lines of COBOL as an SQL User Defined Function and you get what you want - and the code will be obvious to any COBOL coder.

Jon Paris

www.Partner400.com
www.SystemiDeveloper.com

As an Amazon Associate we earn from qualifying purchases.

Follow-Ups:

Re: anyone have an SQL FUNCTION like this they can share? , rob

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.