Recent content by lkmalee

What query product are you using?

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...

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

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...

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.

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

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

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...

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...

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...

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.

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.

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...

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.

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...