Hi again, first off, thanks for your help in my other quests. New problem - Subsystem QSYSWRK disabled user profile USER on device *N. This happens constantly for just this one user. I have changed the PWDEXPITV to *NOMAX but it still happens. I don’t know if this is is because of the new version [...]
Answer Question | May 3, 2013 6:09 AM
AS/400, Client Access
Firstly I should mention that my profession is controlling, not IT, but I assume my problem is rather simple. Unfortunately, I have not even basic knowledge how to solve my problem on an AS/400. I copy data from the AS/400 to the AS/400 notepad. Sometime I have longer lists, so I copy to the notepad, [...]
Answer Question | May 2, 2013 6:53 PM
AS/400, AS/400 scripts
We are getting an error message (sys3827) when we try to transfer data from an RPG2 program on an iSeries 800 running V5R4 to a Windows 7 (64bit) PC running iSeries Access V6R1 (data to be used by Filemaker Pro 11). Any suggestions?
Answer Question | May 2, 2013 5:31 PM
iSeries, RPG Program, Windows 7
We have a job which run on a specific time. However this job is failing because of one of the objects in IFS in use. Below is the message ————————— Message . . . . : Object in use. Object is /ACBC/XYZC_BCACAC/ABCDWC_20130502031504.txt. Cause . . . . . : An operation attempted to use object [...]
Answer Question | May 2, 2013 12:15 PM
AS/400, IFS objects
I’m a newbie to Sequel and I’m trying to recreate some old Crystal Reports using Sequel. My question is: how does the IF, Else statement work in Sequel? This is the statement for Crystal, for a Termination report, we have six companies and if an employee transfers to one of our other companies, we need [...]
Answer Question | April 30, 2013 2:40 PM
AS/400, Crystal Reports
Hello, I am using Excel VBA to try to process a simply gettext/settext function. I am able to return a value using gettext, but nothing happens using settext…no error..nothing. I’ve pasted the code below. Any help is appreciated. Sub AS400_Test2() [PCOMM SCRIPT HEADER] Language = VBSCRIPT [PCOMM SCRIPT SOURCE] ‘ Initiate access to system Dim [...]
Answer Question | April 30, 2013 11:13 AM
AS/400, iSeries AS/400
Could anyone please let me know how I can trail the blanks that come in the middle of a string? For example, a field contains a name like ‘hello hai’ I want to trim the blank which came in the middle of hello and hai. Please help me with a piece of sample code.
Answer Question | April 30, 2013 4:37 AM
Hello, Does anyone know how to step into and through the code in the macro customization window of AS/400? Thank you, Carissa
Answer Question | April 30, 2013 8:50 PM
AS/400, AS/400 macros, iSeries
I want to delete journal receivers in a library that have the the status of SAVED. Can anyone offer some CL code to do this in a program? Each receiver begins with AMQA and followed by 6 numerics. I guess I would write out to an outfile then read the outfile to delete the receivers.
Answer Question | April 30, 2013 7:11 PM
AS/400, AS/400 journaling, CL Program
I am new to AS/400. Can anyone suggest the command or STEPS to know which file or library is utilizing maximum space.
Answer Question | May 2, 2013 4:39 PM
AS/400, ASP Utilization
We have a RBO job which failed and when checking in the log, we could see the object currently in use. What can I do?
Answer Question | April 29, 2013 10:22 AM
AS/400, AS/400 jobs
iSeries AS/400 is integrated to RSA envision successfully but unable to get logs from iSeries to RSA envision. Please help. Thanks, Niketan
Answer Question | April 29, 2013 6:01 AM
AS/400 logs, iSeries AS/400, RSA envision
I have messages ” unable to obtain lock on device xxx” lots of times for each device I am using VRYCFG to obtain lock on device but I don’t know what is the reason of these messages.
Answer Question | April 29, 2013 12:17 AM
AS/400, iSeries AS/400, VRYCRG
Hi, I need a CL program to display a record from a file in a loop condition. If a file exists, then it should display the records or else it should display the message file does not exists. Please help me. The program should contain dcf,monmsg,rcvf. Now I’m learning AS/400 basics.
Answer Question | April 28, 2013 5:15 AM
AS/400, AS/400 commands, CL Program
AS/400 (8203-E4a) cannot display console. We were forced to IPL. The AS/400 stops on code B150B10C.
Answer Question | April 29, 2013 11:08 PM
AS/400, AS/400 IPL
How do I find members of a group profile in AS/400?
Answer Question | April 29, 2013 5:32 PM
AS/400, AS/400 administration, AS/400 group profiles
I’m not an IT guy, just a frustrated Outside Sales Rep. I recently BYOD a Surface Pro for work. A HUGE improvement over the 15″ 6# monster I had before. The company that handles our AS/400 iSeries Access had issues installing it on my Surface Pro. They rolled back the graphics driver to Intel HD3000, [...]
Answer Question | April 26, 2013 8:50 PM
AS/400, iSeries, Surface Pro
Hi, I ran the command TRCCNN in AS/400 to trace the connection between our AS400 and Tandem. I was able to generate a report but I don’t know how to read if there’s a lost connection or unnecessary event with the network. Can you help me what are the key or code when searching at [...]
Answer Question | April 29, 2013 6:20 PM
AS/400, AS/400 Reports, Tandem
Hi all, I have requirements in which I have to pass the file as parameter to another program with defaulting the field value as, If character field default the first character as ‘%’ and if Numeric default till the length of the field with -9999. As per now I’m getting two options. 1. Create the [...]
Answer Question | April 26, 2013 4:53 PM
AS/400, DB2, RPG, RPGILE
I have not written a subfile program in a while, but am having trouble when errors are encountered. As this is COBOL and the code can be lengthy to weed through on a forum, let me first spell out the scenario. I have 32 records in a COBOL subfile, 11 per page. There is one [...]
Answer Question | April 26, 2013 2:09 PM
AS/400, AS/400 Subfiles, COBOL