STRHOSTSVR cmd has Disappeared ! -- MIDRANGE-L

This is a strange one. I cannot log on to my system anymore because it seems
STRHOSTSVR is not there.

Yesterday I was able to log on through 5250 without any problems, I did some
RPG work and logged off. I then started working on some HTML pages that
where being served by the AS400. I saved the changes and then realized I had
not shut down the HTTP server. So I started up Operations navigator to
stop/start the servers and I get an error message saying that I cannot
connect because the AS/400 application server is not started. I went to the
console (twinax connection) and shut down the servers AND TCP/IP.
Restarted...same problem. I even IPLed, no luck. The TCP/IP error messages
point to trying to start STRHOSTSVR and not finding it....

So how can I get STRHOSTSVR back? Reloading the OS?

Thanks in advance.
___________________________________
Mauricio Della-Quercia
Sr. Programmer/Analyst
LegendWare Systems (AS/400 Consulting)
Toronto - Canada
http://www.LegendWareSystems.com

MDellaQuercia@csi.com
Direct: (416)  919-4455
Fax:    (905)  426-5371

1725 Kingston Road
Unit 26,  Suite 206
Pickering, Ontario
L1V 4L9
Canada
__________________________________



From: Gord Royle <GRoyle@cott.com>
Reply-To: midrange-l@midrange.com
To: "'midrange-l@midrange.com'" <midrange-l@midrange.com>
Subject: RE: SQL Question
Date: Thu, 27 Sep 2001 09:33:28 -0400

I don't think that you can do it in interactive SQL (I tried "strsql" and
"wrkqry") but you can do it in a "cursor" as follows:

C/EXEC SQL DECLARE TOP10 CURSOR FOR
C+ SELECT DISTINCT THID FROM QQTEST
C+ WHERE WHATEVER = :HostVar
C+ ORDER BY THID DESC
C+ FETCH FIRST 10 ROWS ONLY

C/END-EXEC
C*

and then in your process loop

C/EXEC SQL
C+ FETCH TOP10 INTO
C+       :HostTHID
C/END-EXEC

Or conversely use a counter in your loop to stop at 10

HTH

Gord Royle
Cott Corporation


-----Original Message-----
From: Dennis Munro [mailto:DMunro@badgerminingcorp.com]
Sent: Wednesday, September 26, 2001 6:13 PM
To: Midrange List (E-mail)
Subject: SQL Question


I've got an Access database that uses the following statement & I am
wondering if there is a way to do the same with SQL from the AS/400.
Running V4R5M0 & one cum back.

"Select Top 10 QQTEST.THID From QQTEST" with a Where & Order By clause.

Thanks - Dennis.

Dennis Munro

"I love deadlines.  I especially like the whooshing sound they make as they
go flying by."  Dilbert's Words Of Wisdom:

Badger Mining Corporation
www.badgerminingcorp.com
dmunro@badgerminingcorp.com
(920) 361-2388

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


Cott - The Leader in Premium Retailer Brand Beverage Innovation.


_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.



_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp