User profile disabled
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
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
Help with a simple script
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
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
Transferring data from iSeries V5R4 to Windows 7 PC
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 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
IFS object in use
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
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
Sequel IF and Else statements
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
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
Excel to AS/400 VBA – SETTEXT not working
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
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
Trailing the blanks which come in the middle of a string
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
AS/400, RPGLE
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
AS/400, RPGLE
AS/400
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
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
Deleting SAVED journal receivers
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 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
ASP Utilization
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
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
Object is currently in use
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
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 logs
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
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
Unable to obtain lock on device
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
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
AS/400
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
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): no display
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
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 to find members of a group profile
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
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
iSeries WorkStation v5.9 on Surface Pro
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
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
AS/400 Trace Report
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, 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
Defaults the Physical file with ‘%’ for Character fields and -9999 for Numeric fields.
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
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
CPF5011 COBOL subfile error
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
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
