Printing from AS/400 to Canon iR3235
Hi, I am having problems printing from AS/400 running v5r4 to a Canon iR3235. Prints seem to be coming off out of order. But only happening half way through each batch of around 100 prints. The first half is fine, but then all comes off wrong. IBM have recommended setting up printer over LPR and using [...]
Answer Question
| February 27, 2013 3:36 PM
AS/400, Canon
Hi, I am having problems printing from AS/400 running v5r4 to a Canon iR3235. Prints seem to be coming off out of order. But only happening half way through each batch of around 100 prints. The first half is fine, but then all comes off wrong. IBM have recommended setting up printer over LPR and using [...]
Answer Question
| February 27, 2013 3:36 PM
AS/400, Canon
Block access of Operational ASSIST Menu
Hi ! How can I block the users for the use of Operational Assistance Menu(Esc Key)?
Answer Question
| February 27, 2013 6:03 AM
AS/400, AS/400 Menus
Hi ! How can I block the users for the use of Operational Assistance Menu(Esc Key)?
Answer Question
| February 27, 2013 6:03 AM
AS/400, AS/400 Menus
About EVAL-CORR opcode
Could any one let me know what is the use of this EVAL-CORR opcode with a sample program
Answer Question
| February 27, 2013 4:27 AM
AS/400, EVAL-CORR
Could any one let me know what is the use of this EVAL-CORR opcode with a sample program
Answer Question
| February 27, 2013 4:27 AM
AS/400, EVAL-CORR
How to easily perform date conversions in RPGLE (Including Substringing!)
Over the years I have had to modify my fair share of outdated code, especially when it comes to Date Conversions. Not every system uses an 8 position numeric date field. The place I’m currently at still has a number of files with a 6 position numeric date field. I was wondering if anyone else [...]
Answer Question
| February 26, 2013 5:30 PM
RPG, RPGIV, RPGLE
Over the years I have had to modify my fair share of outdated code, especially when it comes to Date Conversions. Not every system uses an 8 position numeric date field. The place I’m currently at still has a number of files with a 6 position numeric date field. I was wondering if anyone else [...]
Answer Question
| February 26, 2013 5:30 PM
RPG, RPGIV, RPGLE
Subfile with scroll bar.
I’m creating a simple program for subfile with scroll bar. I am able to see the scroll bar in the display file but the scroll bar is not working. It isn’t scrolling up or scrolling down. Please suggest what can be the solution.
Answer Question
| February 26, 2013 7:52 AM
AS/400, AS/400 Subfiles
I’m creating a simple program for subfile with scroll bar. I am able to see the scroll bar in the display file but the scroll bar is not working. It isn’t scrolling up or scrolling down. Please suggest what can be the solution.
Answer Question
| February 26, 2013 7:52 AM
AS/400, AS/400 Subfiles
Error in position while printing variable
I have a variable xyz as7P 2.This variable is defined in a file. I am using this in my program to be populated on printed on report defined in O spec. Problem is – I am just using edit code ‘L’ and mentioned ending position as 71. but when printed or spooled, it’s being generated [...]
Answer Question
| February 26, 2013 6:00 AM
AS/400, AS/400 Printer File
I have a variable xyz as7P 2.This variable is defined in a file. I am using this in my program to be populated on printed on report defined in O spec. Problem is – I am just using edit code ‘L’ and mentioned ending position as 71. but when printed or spooled, it’s being generated [...]
Answer Question
| February 26, 2013 6:00 AM
AS/400, AS/400 Printer File
AS/400 – User Profile
Hi; What is the name of the file that stores the value for the “Password verification not valid” field on the User Profile. I created the User Profile file using the DSPUSRPRF command but it shows only a value. I need this information for auditing purpose. Thanks, Ruth.
Answer Question
| February 26, 2013 4:27 PM
AS/400, AS/400 user profiles
Hi; What is the name of the file that stores the value for the “Password verification not valid” field on the User Profile. I created the User Profile file using the DSPUSRPRF command but it shows only a value. I need this information for auditing purpose. Thanks, Ruth.
Answer Question
| February 26, 2013 4:27 PM
AS/400, AS/400 user profiles
About CRTPGM command
I have a module which has a copy book in it and when I am creating a main PGM with the command CRTPGM by giving the module name itself as the PGM name and binding the service programs, I am getting an error which says that the procedures which are defined in the copy book [...]
Answer Question
| February 25, 2013 7:04 AM
AS/400, CRTPGM
I have a module which has a copy book in it and when I am creating a main PGM with the command CRTPGM by giving the module name itself as the PGM name and binding the service programs, I am getting an error which says that the procedures which are defined in the copy book [...]
Answer Question
| February 25, 2013 7:04 AM
AS/400, CRTPGM
Code review checklist for AS/400 application
Hi, As part of Unit Testing process documentation, I need to prepare ‘Code review checklist’ for AS/400 application. Request the members to please share the same.
Answer Question
| February 25, 2013 6:17 PM
AS/400, AS/400 applications
Hi, As part of Unit Testing process documentation, I need to prepare ‘Code review checklist’ for AS/400 application. Request the members to please share the same.
Answer Question
| February 25, 2013 6:17 PM
AS/400, AS/400 applications
Query in subfile with SFLNXTCHG
I have a subfile with an option F8 to clear all the records. When F8 is taken, I will clear all the fields and will update the SFL record format. After F8, if an enter is taken, I want to update the file with the blank values. But the problem is since am not typing [...]
Answer Question
| February 25, 2013 4:34 AM
AS/400, AS/400 Subfiles
I have a subfile with an option F8 to clear all the records. When F8 is taken, I will clear all the fields and will update the SFL record format. After F8, if an enter is taken, I want to update the file with the blank values. But the problem is since am not typing [...]
Answer Question
| February 25, 2013 4:34 AM
AS/400, AS/400 Subfiles
Why limit CLI access on AS/400?
A little background… I am new to the compliance and auditing field and recently introduced to the AS/400 system and I am constantly seeing in best practice environments that the CLI be restricted from most users and or at least limited capabilities set to *YES. To the point… The system administrator for the AS400 is [...]
Answer Question
| February 25, 2013 12:13 AM
AS/400, AS/400 - CL Command, AS/400 security
A little background… I am new to the compliance and auditing field and recently introduced to the AS/400 system and I am constantly seeing in best practice environments that the CLI be restricted from most users and or at least limited capabilities set to *YES. To the point… The system administrator for the AS400 is [...]
Answer Question
| February 25, 2013 12:13 AM
AS/400, AS/400 - CL Command, AS/400 security
Window keyword in display file
I have a program that displays a list of items and when one is selected it pops a window with detailed information. When I select an item, my window will not display. Is there a configuration/setting somewhere on the AS/400 that would keep the window from displaying ?
Answer Question
| February 25, 2013 10:18 PM
AS/400, AS/400 Display File
I have a program that displays a list of items and when one is selected it pops a window with detailed information. When I select an item, my window will not display. Is there a configuration/setting somewhere on the AS/400 that would keep the window from displaying ?
Answer Question
| February 25, 2013 10:18 PM
AS/400, AS/400 Display File
RPGLE SETLL / READE for update getting record lock on different key
We are encountering sporadic unexpected record locks with update files using: setll (Key1) MasterFile; // Partial key. dou %eof(MasterFile); reade (Key1) MasterFile; if not %eof(MasterFile); // [Stuff] update MasterFmt; endif; enddo; Looking at the problem record by RRN, its key does not match Key1. It’s not even the next sequential key value in the file. [...]
Answer Question
| February 22, 2013 8:59 PM
READE, Record lock, RPGLE
We are encountering sporadic unexpected record locks with update files using: setll (Key1) MasterFile; // Partial key. dou %eof(MasterFile); reade (Key1) MasterFile; if not %eof(MasterFile); // [Stuff] update MasterFmt; endif; enddo; Looking at the problem record by RRN, its key does not match Key1. It’s not even the next sequential key value in the file. [...]
Answer Question
| February 22, 2013 8:59 PM
READE, Record lock, RPGLE
AS/400 Query – how do you split names in field into seperate fields
Trying to separate a field into three separate fields. The field is a name field, with lastname firstname mi with spaces in between each name. Is there a way to do this? I’ve tried everything I can think of, am out of ideas. Thanks in advance for your help
Answer Question
| February 22, 2013 3:56 PM
AS/400, AS/400 Query, iSeries
Trying to separate a field into three separate fields. The field is a name field, with lastname firstname mi with spaces in between each name. Is there a way to do this? I’ve tried everything I can think of, am out of ideas. Thanks in advance for your help
Answer Question
| February 22, 2013 3:56 PM
AS/400, AS/400 Query, iSeries
How to display total of all the records that contain the same primary key in RPG4?
How to display total of all the records that contain the same primary key in RPG4? e.g… Transaction number :4458 product no: name [...]
Answer Question
| February 22, 2013 11:17 AM
RPG, RPG Code
How to display total of all the records that contain the same primary key in RPG4? e.g… Transaction number :4458 product no: name [...]
Answer Question
| February 22, 2013 11:17 AM
RPG, RPG Code
Data migration from AS/400 DB2 to SQL Server
Any cheap and best tools available for data migration from AS/400 DB2 to SQL Server?
Answer Question
| February 22, 2013 6:56 AM
AS/400, SQL Server
Any cheap and best tools available for data migration from AS/400 DB2 to SQL Server?
Answer Question
| February 22, 2013 6:56 AM
AS/400, SQL Server
How to find the copybook?
Hi, I need to make few changes to a copybook in COBOL/400. I know the name of the copybook. Please let me know how to locate it? Regards, M
Answer Question
| February 22, 2013 4:05 AM
AS/400, COBOL/400
Hi, I need to make few changes to a copybook in COBOL/400. I know the name of the copybook. Please let me know how to locate it? Regards, M
Answer Question
| February 22, 2013 4:05 AM
AS/400, COBOL/400
Related to move array opration
I have following example in rpg Movea ex1(1940) ex2(1920) here ex1 is an array of length 1940 and ex2 is a data structure of length 1920, if the move array operation performed, Is there any loss of information was there?
Answer Question
| February 21, 2013 3:25 PM
MOVEA, RPG
I have following example in rpg Movea ex1(1940) ex2(1920) here ex1 is an array of length 1940 and ex2 is a data structure of length 1920, if the move array operation performed, Is there any loss of information was there?
Answer Question
| February 21, 2013 3:25 PM
MOVEA, RPG
How do I convert a date in text format to a proper date with AS/400 Query
I have a date 20/02/2013 which is in text format but I need to convert it to a date format with a length of 10 and decimal of L (a normal date format). Basically I need to convert 20/02/2013 which is currently in text format to an ISO date format with Query using iSeries access [...]
Answer Question
| February 21, 2013 11:22 AM
AS/400, AS/400 Query
I have a date 20/02/2013 which is in text format but I need to convert it to a date format with a length of 10 and decimal of L (a normal date format). Basically I need to convert 20/02/2013 which is currently in text format to an ISO date format with Query using iSeries access [...]
Answer Question
| February 21, 2013 11:22 AM
AS/400, AS/400 Query
Change the user of a JOB
Hello, I would like to know if it is possible to assign a running job to a different user than the one who ran it? Thanks.
Answer Question
| February 21, 2013 10:13 AM
AS/400, AS/400 commands
Hello, I would like to know if it is possible to assign a running job to a different user than the one who ran it? Thanks.
Answer Question
| February 21, 2013 10:13 AM
AS/400, AS/400 commands
