RE: Disabled User Profiles -- MIDRANGE-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

You can also invoke QShell in a CL to run a SQL statement. Note you
need to use SQL style syntax (e.g. library.file not library/file) and it
has some issues (such as handling $ characters well I hear):

QSH CMD(DB2 "sql statement") and those are double quotes ( shift + ' )
not single quotes.

Jeff Carey, MSIT, MBA
Senior Technical Support Specialist

SXC Health Solutions, Inc.
2441 Warrenville Road, Suite 610
Lisle, IL 60532-3642
T: 630-577-4705
M: 630-450-1727

Jeffrey.Carey@xxxxxxx

COMMON members - Board elections end 5/3/11
http://www.common.org/elections
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Buck
Sent: Thursday, April 28, 2011 02:56 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: Disabled User Profiles

On 3/14/2011 9:41 AM, Vern Hamberg wrote:

You can't directly run a SELECT statement with QCMDEXC - the latter is
for running CL commands.

You CAN write a CL command that lets you enter an SQL statement to be
executed, not just SELECTs. Google for RUNSQLSTM for an example that
works quite nicely.

One example is here:
http://wiki.midrange.com/index.php/SQL#SQL_via_QM_Query
--buck

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.