Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. lkmalee

    AS400 combineing results work query

    What query product are you using?
  2. lkmalee

    windows 7 and cllient access

    Client Access straight off the V5R3 disk works for me under Windows 7 (beta version). The V5R3 Client may work with your V5R2 OS/400. As for a free (open-source) alternative, I've used TN5250 from SourceForge. It's not as complete as PC5250, but is far better then regular telnet...
  3. lkmalee

    No sectools

    tcsbiz's advice is good. Make sure your user profile is authorized to the sectools.
  4. lkmalee

    DSPUSRPRF USRPRF(*ALL) OUTPUT(*PRINT)

    It appears to me that you cannot successfully run this command as written (at lease, you can't on V5R3). It appears that you can only use the *PRINT parameter on a single user profile name i.e. DSPUSRPRF QPGMR OUTPUT(*PRINT) You can see the fields generated if you use the *OUTFILE parameter...
  5. lkmalee

    some users can only open one client access session

    Assuming you are using PC5250 (iSeries Access), check under Communication>>Configure... and make sure "Avoid duplicate names on this workstation" is checked. In addition, you can check the "Avoid duplicate names with other workstations" if multiple workstations use the same workstation ID.
  6. lkmalee

    AS400 - how to load a file into cache

    You may be looking for the 'Set Object Access' ( SETOBJACC )command.
  7. lkmalee

    "Connected" to the iSeries but no 5250 emulation Screen

    This is worth trying at the client: CWBPING systemname This is a special 'ping' command that verifies the various services can be reached.
  8. lkmalee

    Help with Twin-Ax printer issue

    Delete the printers: WRKCFGSTS *DEV printername Select option 2=Vary off Select option 8=Work with description Select option 4=Delete Check systen value QAUTOCFG is turned on: WRKSYSVAL QAUTOCFG Select option 2=Change Make sure value is '1' for 'On' Connect your printers and power them on...
  9. lkmalee

    Trying to add new IP on AS400

    As I understand it, you are creating a new IP interface and attempting to give it the name ETHLINE1. Is ETHLINE1 being added for the Line description parameter? The Line Description parameter refers to the already defined ethernet line. Try this command: WRKCFGSTS *LIN ETH* This will list the...
  10. lkmalee

    DDS BOX() shading - not printing

    Does anyone know how to print a shaded box from iSeries DDS using AFPDS and the BOX keyword. IBM online docs show this example: A R BOX4 BOX(1.2 0.5 5.1 6.3 0.2 + A (*SHADE 50)) but it doesn't work. The outline prints...
  11. lkmalee

    RSTOBJ command

    Is your SAVLIB parameter indeed a library called "CMS.CUS15" (all nine characters)? You aren't intending library CMS and file CUS15, correct? You may want the RSTLIB parameter to specify what library you want to put the restored file into.
  12. lkmalee

    Strangest AS400 printing thing I have ever seen, Why?

    I have seen this behavior when attempting to print a spool file containing AFP data on a printer not capable of AFP. If the printer cannot support some attribute of the spool file, the system will put it on hold when it is released. What I find unusual with your problem is that it is every printer.
  13. lkmalee

    Get data from past 5 days

    I tried your SQL in the Run SQL Scripts in Operation Navigator and I got the same error message. Some research showed that the syntax for current date is incorrect. Try: char(CURRENT DATE - 5 DAYS) The DAYS notation is required. To your original question: I have found that there is no easy way...
  14. lkmalee

    Get data from past 5 days

    I assume by now you've found the response by flapeyre. Based on my limited knowledge of your version of SQL, it looks like that may the answer you are looking for. That is, taking into consideration any invalid dates values in your field.
  15. lkmalee

    Get data from past 5 days

    We use ASC's SEQUEL product for SQL queries so the syntax and abilities are similar but probaly not the same. In SEQUEL, this would cause a problem because you are trying to compare a date data type to a numeric data type. You need to find a way to convert one or the other so the data types...
  16. lkmalee

    compare printer files

    I am assuming you are trying to compare iSeries objects of type *FILE and attribute *PRTF vs. spooled output sitting in an output queue. The following command will create a file of *PRTF attributes: DSPFD FILE(*ALL/*ALL) TYPE(*SPOOL) OUTPUT(*OUTFILE) FILEATR(*PRTF) OUTFILE(QTEMP/PRTF01)...
  17. lkmalee

    Scheduling an IPL on i5

    Here is my two-cents worth. We currently IPL our i5 on Sunday mornings. We started this practice back on V3 and a CISC box - mostly to reduce temporary address space usage. The main reason I have continued is our users are used to and expect the system to go down for a few minutes each Sunday. I...
  18. lkmalee

    AS400 Telnet

    If you want to start telnet on an ad-hoc basis , try the follwing cmd: STRTCPSVR SERVER(*TELNET). To end the server, use the following command: ENDTCPSVR SERVER(*TELNET).
  19. lkmalee

    does v5r2 still support the original ibm http server?

    We just 'jumped' from V4R5 to V5R3 (AS/400e-720 to i520 upgrade). I was using the Orginal HTTP Server on V4R5 and was able to migrate it to Apache HHTP Server on V5R3. There is an option to migrate an Original HTTP Server to Apache if you use the ADMIN instance. I was pleased to find it worked...
  20. lkmalee

    AS/400 Twinax controller device limit

    We have never used 5251's. Most of the terminals still in use are 3487's. The nice thing about twinax is you set one address and plug it in and you are ready to go. Try that with a PC. The answer about anything over 40 causing degredation of response times seems likely. As I said in my original...

Part and Inventory Search

Back
Top