Re: Storing SQL script options -- MIDRANGE-L

Subject: Re: Storing SQL script options
From: Joe Pluta <joepluta@xxxxxxxxxxxxxxxxx>
Date: Wed, 27 Mar 2019 11:01:14 -0500
List-archive: <https://archive.midrange.com/midrange-l/>
List-help: <mailto:midrange-l-request@lists.midrange.com?subject=help>
List-id: Midrange Systems Technical Discussion <midrange-l.lists.midrange.com>
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>

REXX doesn't really take much to learn. The biggest thing is how to switch between CL commands and SQL commands (the ADDRESS statement). The rest is all basic programming. DO, IF, SELECT, CALL. I find it the easiest way to interface between SQL and OS commands, and given the ever-expanding repertoire of DB2 services, it's quite the system administration tool.

On 3/27/2019 10:49 AM, Rob Berendt wrote:

Joe,
If I'm going to learn a new language to support "cl stuff" and SQL together I'll use SPL or Stored Procedure Language. As it's probably something everyone should know anyway.

As an Amazon Associate we earn from qualifying purchases.

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