ISeries

iSeries Emulator works on most 400s

I am running Vista Home Premium and can connect to 15 of the 16 AS400s I have access to. However, this one lucky one will connect, but will just have a blank screen. I have a colleague that can connect to the same 400 on an XP machine with the I-Series emulator. I have tried to search Google...

How to pause execution of a macro to allow user input of variable data in iSeries

I am exploring the possibilities to speed up input when testing by taking advantage of macros. The problem is when variable data has to be keyed into a field in the middle of the sequence. Reading the help-topics on WAIT I thought I could use the WaitForCursor-option, but it does not change the...

iSeries RPG Embedded SQL Performance

Hi, I'm trying to replace some long running Query/400 jobs with RPG and embedded SQL. Some of the existing jobs run for almost 24 hours on our machine. I've already successfully managed to reduce a few of these jobs to a matter of minutes using embedded SQL. So far, so good. My problem is when...

AS/400 to Excel

Hi Someone, I am using FTP to send a data file fromthe iseries to the server as a .txt file usint put statement. Can anyone suggest how I would sent the file direct to an Excel spreadsheet, preferable to a pre-formatted sheet. Thanks.

How to add CRLF to a CL Message

I would like to add a CRLF so part of a message in a CL command will go to a new line.

Using Access Codes with iSeries

We are using Access Codes to keep track of our color printing, but when we have that feature activated we cannot print from the AS400. Has anyone been able to print to AS400 and keep the Access Code feature activated?

PC5250 License Error return code 9052 2751

We added NetMotion to our network and have it acting as a type of "fire wall". Laptops running iSeries Access for Windows (v5r3) are getting this error periodically - around every 30 days. Much older versions of CAE do not present this error. We have found that by taking the user out of their ...

iSeries Navigator V5.4 automatically reset monitor triggers

I have created a message monitor in ISeries Navigator V5.4 and I want to trigger a command whenever a message appears on the QSYSOPR log. The trigger command is working properly; however, the "Automatically reset after trigger command has run" does not work. How do I get the trigger to reset so...

Cannot get PTF group SF99540 to status Installed

Hi Gyus. Been searching all over for the answer to this including Assist but with no joy. PTF group SF99540 remains at 'Not installed' because there is a special handling PTF MF41210 for product 5722999 V5R4M0 Type 'Pre-apply permanently'. Now this is for a product which is not installed on...

Getting wildcard results from OPNQRYF

Hi all, I am trying to query a PF to get back all records where fields OWNER1 and OWNER2 have an entered user value (ie; JOHN - I would want to return JOHN, JOHNATHON, JOHNS, ARJOHNS, etc) The best so far I have been able to come up with is: DCL VAR(&CF03) TYPE(*CHAR) DCL VAR(&INOWN)...

Start Journaling of PF.

How do I Start Journaling on 2200 Physical Files together instead of using STRJRNPF for every file.

Create a window on the iSeries

Hi all, I know I have seen it done, where the user requests a list of codes while in an inquiry and a "window" pops up with the desired information. Can anyone guide me to where I can see how the window program is created? Thank you, George

Special character in a PF

Hi, Is there any way to know if a file has any carriage return on any of the records? I have a file which is populated bby front end users and sometimes when they copy paste an item it also picks up the carriage return. any way to find out if file is having any of these in iseries

WRKQRY - V5R4

Are there any issues concerning an upgrade from V5R2 to V5R4 with regard to WRKQRY?

iSeries

what is the difference between *MAP and *DROP?what type of commands use these two keywords?why we are use this?Please explain?

iseries user profile name

I need to create user profile names with a symbol in the middle like JOE%ABC, is that posible?

How to delete a user's spoolfile in batch by date range?

Would like to know is there a way to delete a user's spool file in batch by date range? Is there any CL I can refer to.Please help. FYI, my iSeries model = 20 running on OS/400 V5R3M0. Thank you in advance for your help. Mod Note: This question was submitted to our Moderator mailbox.

AS/400 WebDAV to remote Sharepoint server

Does anyone have successful experience working on using WebDAV from an AS/400 to a Microsoft SharePoint website? Our developers would like to place content from the AS/400 on the Sharepoint website but they are having lots of issues getting this to work. I am going to look at the network traffic to...

Retrieving system name using a CLP

How to retrieve the iseries or AS400 SYSTEM NAME USING A clp program?

iSeries

what is mean by "CHANGEMANAGEMENT TOOL"?where we can use this and why we want to use this?Please give me with example?