| Subject | Date Asked |
|
| Call Stack | 11/19/2009 |
Q: I would like to know if there is a way to retrieve a list of all programs called during a certain ...
A: From V5R1 forward, IBM has offered an API called QWRCSTK that allows you to retrieve the call stack ...
|
| 'Wrong input' error on AS400 after duplicate key error | 8/24/2009 |
Q: I'm a beginning RPG programmer and have written a standard 'maintenance' style program that uses two ...
A: It's difficult for me to tell for certain what your problem is because I don't recognize 'Wrong ...
|
| AS400 (CMD Program) | 7/13/2009 |
Q: I have created a simple program in CL to add few libraries to library list. I run that program from ...
A: I am assuming that there are no parameters to be passed to your CL program. 1. Create a QCMDSRC ...
|
| 5.4 upgrade | 6/3/2009 |
Q: are there any procedures on how upgrade from one version of operating systems to another
A: Yes, there you can find support documents that explain how to upgrade operating system versions at ...
|
| Display File | 5/28/2009 |
Q: I have a 15 position field in a display file that is used to enter part numbers. In the past, user ...
A: To be certain that the alpha characters are converted to uppercase, I use my own conversion ...
|
| Report on deleted records | 4/22/2009 |
Q: How would I run a report by library to provide a listing to show only the number of deleted records ...
A: The DSPFD command has an option to create a OUTFILE, with fields that include the file and library ...
|
| Putting more records in a printer file page.. | 4/20/2009 |
Q: I have an old RPG program, which is utilising only 30 lines..i want to extend it by putting some ...
A: This is a hard question to answer without seeing both the RPG source code and the procedure that ...
|
| Error sys 400 9402 f04 | 3/11/2009 |
Q: after powering on the system after 2 minutes receives error code and attention light error code # ...
A: This is a hardware error, and you may need IBM hardware support (1-800 IBM-SERV) to help you figure ...
|
| Change User ID when sign on AS400 | 2/10/2009 |
Q: My company will change the all user ID of the AS400, Every old User ID will mapping to a new User ...
A: To my knowledge, the Program Status Data Structure is a read-only structure, and not able to be ...
|
| Match *PGM Type Object to a source member | 1/24/2009 |
Q: I try to match a compiled object to a source member with the method of recompiling source member to ...
A: The best I can suggest is that, for any given program, assume that the source with the most recent ...
|
| Match *PGM Type Object to a source member | 1/23/2009 |
Q: I try to match a compiled object to a source member with the method of recompiling source member to ...
A: If you use the DSPOBJD command, you can create a file containing information about all of your ...
|
| how to find the record which errored out while writing a duplicate record | 1/21/2009 |
Q: How can I find the record which errored out while writing a duplicate in a file? Can Journal dump or ...
A: When the duplicate key message appears, select the 'D' dump option. This will produce a report in ...
|
| Monitoring users | 11/10/2008 |
Q: Is there a way to monitor a user? I would like to find out about a user , what he has done in last 6 ...
A: Unfortunately, OS/400 offers no way to monitor the activities of a user, other than a job log, which ...
|
| logical files...or not | 10/28/2008 |
Q: I have 4 phyical files, each with a different record format. One of these files contains the header ...
A: Presuming that the detail records share a key field with the header record such as an order number, ...
|
| AS400 emulator keyboard | 9/9/2008 |
Q: Hope someone can help me. In a normal dspf if you have a numeric input/output field defined when you ...
A: The - key on the keyboard pad in most emulation software represents a "FIELD MINUS" key. The user ...
|
| Disk arm utilization | 9/3/2008 |
Q: What is an acceptable percentage over a two hour period of the percent busy in the wrkdsksts ...
A: That's a good question, and one that is commonly asked, but also one to which IBM gives no simple ...
|
| question on as400 | 7/22/2008 |
Q: by which we can call the cls .
A: To create a menu, most programmers design a DDS display file to describe the menu options, and a CL ...
|
| as400 | 6/21/2008 |
Q: what is as400
A: The AS/400 is a mid-sized business computer, although NOT PC-based or network based. It is ...
|
| as400 error message | 4/7/2008 |
Q: What does the error message: System hardware error SRC-B3014F01 mean. The system seems to be running ...
A: Hardware problems are not really my area of expertise, and I do not have access to a manual of ...
|
| Error Messages | 3/26/2008 |
Q: In a subfile, if we use SFLMSG we get a fixed error message as OPTION NOT VALID. Instead of that, I ...
A: To my knowledge, there is no way to send a variable message using the SFLMSG option. I tried ...
|
| Adv/36 model 9402 | 3/13/2008 |
Q: While trying to backup the LIC (option-5) the orange light comes on about 5 min into it and it ...
A: Typically, a software error message takes the form of CPF0001 - three letters and a four digit ...
|
| DEBUG S36 BY STRDBG COMMAND | 3/5/2008 |
Q: MY PROBLEM IS THAT WHEN DEBUGING BY STRDBU A PROGRAM (S36 PGM) THAT SBMJOB I CANT SEE THE ...
A: As I recall, DEBUG functions differently for System/36 programs. I do not have access to an AS/400 ...
|
| Barcodes from AS400 to HP Printer | 2/7/2008 |
Q: We use an AS400 in our company and have a programming staff that does all programming for the ...
A: The manual that came with your printer should indicate whether it is capable of advanced printer ...
|
| AS/400 | 2/4/2008 |
Q: Sir,Is CL is a highlevel language?why?
A: CL is a control language meant to control the processing of other jobs. It offers some of the ...
|
| AS/400 | 2/4/2008 |
Q: Sir,why we can't update join logical files?
A: I apologize for the delay in responding to your question - I have been out of the country for the ...
|
| Barcodes from AS400 to HP Printer | 1/31/2008 |
Q: We use an AS400 in our company and have a programming staff that does all programming for the ...
A: I apologize for the delay in answering your question - I have been out of the country for the past ...
|
| Download to PC | 1/29/2008 |
Q: I've read through related Q&A from this site, It's short but i'm need more details. My question is ...
A: If you can map the AS/400's drive as a network drive, then you can use the CPYTOPCD command to copy ...
|
| Record locks CPF4128 | 1/19/2008 |
Q: Other than sending a msg to the user to sign off, then back on, is there a way to stop the record ...
A: No, not without rethinking how, when or why the record gets updated. You can consider it a law of ...
|
| record locks | 1/18/2008 |
Q: i have a pgm that is accessed over and over all day long by numerous people, occasionally we get ...
A: If the message is being issued by an RPG program, it is likely coming from a CHAIN command, which ...
|
| alpha to numeric | 1/16/2008 |
Q: does this look ok? fdanserl if f 8 disk fdanserlx o f 8 disk idanserl ns 01 i ...
A: I normally avoid the use of QRY in my software, partly because it is a 'hog' when it comes to ...
|
| left adj alpha to numeric field right adj | 1/9/2008 |
Q: i want this input record ............. type 5 alpha to become to be numeric, some records have 1, ...
A: Here is an example of a subroutine to right-justify an alphameric field and move it to a numeric ...
|
| ALLOCATION ERRORS | 12/28/2007 |
Q: i need to know what AS400 file holds Authority permission. a program we run monthly says authority ...
A: No single AS/400 file holds authority permission.There is an authority option when a physical, ...
|
| conversion - data | 12/27/2007 |
Q: i have an AS400 on the west coast, and one on the East coast, and i want to transfer a file. What ...
A: There are many different options, depending on if and how the AS/400's communicate with each other, ...
|
| userprofile user/authority on a cl | 12/22/2007 |
Q: i am using the following dclf file(qaobjaut) dcl var(&usroprf) type(*char) len(10) dcl ...
A: It is the weekend, and I'm not in front of an AS/400, so I cannot check. But there may be an OUTFILE ...
|
| CL Errors | 12/21/2007 |
Q: i get a error msg on the following cl line example CPF0001 call OR5232R ' ' i have no ...
A: CPF0001 is a catch-all error message, that basically says "an error occurred". Normally there is a ...
|
| ipl disconnection abx access | 12/18/2007 |
Q: At my work, we collect labor using microsoft abx database access program which is connected to our ...
A: There is no compelling need to re-IPL an AS/400 each day, even for the sake of a nightly backup - I ...
|
| Data entry VS BOL | 12/17/2007 |
Q: we have AS400 and we are struggling with our BOL and route settlements. if we have to adjust the ...
A: Providing that your company owns source code to your software, an AS/400 programmer could change the ...
|
| cpyprtf | 12/14/2007 |
Q: i am using a system that allows very few user options, however i do use cpyprtf alot, i am reading ...
A: The CPYSPLF command tries to locate a spooled file with the name you specify, associated with the ...
|
| AS400 RPG example | 12/8/2007 |
Q: http://www.fuel-efficient-vehicles.org/pwsdb/pgm/tutorial-view.php?topic=15 On this example from ...
A: I agree that the organization of the example is confused. 1. Command PRTOBJL invokes CL program ...
|
| cmd prompt error msgs on compile | 12/7/2007 |
Q: http://www.fuel-efficient-vehicles.org/pwsdb/pgm/tutorial-view.php?topic=15 on this web site it ...
A: If you create a file TEST from DDS with record format TESTR, then copy the file to TEST2, the new ...
|
| objects storage file | 12/5/2007 |
Q: I thought object size and misc descriptions were stored in QSYS/QADSPOBJ, but it is blank. I have ...
A: The QSYS/QADSPOBJ file is the pattern file used/populated by the OUTFILE option of the DSPOBJD ...
|
| level check | 12/4/2007 |
Q: Can you change pf's from level check *no to *yes - without re-compiling your programs?
A: When you specify that a physical file is level-check *YES, you're actually saying that you want the ...
|
| create cl to change outq parameters | 12/3/2007 |
Q: I would like to know how to create a cl that will allow a user to select an option from a menu that ...
A: A full explanation of how to design the prompt screen and CL program to do what you want is beyond ...
|
| AS400 (C D I R) Replies | 11/29/2007 |
Q: and have a programming staff that programs and supports all of our users. Many times when an error ...
A: There is something you can do, but it involves a few steps and requires you to identify which users ...
|
| objects | 11/29/2007 |
Q: does anyone know a product that can create a source member from a compiled object? i have heard it ...
A: IBM provides a command to retrieve source code from a compiled CL program called RTVCLSRC. This ...
|
| Source Members of Compiled Objects | 11/28/2007 |
Q: Is there a system option on the AS400 that will match a compiled object with all like source members ...
A: The DSPPGM command should show you from which source file, library, and source member a program was ...
|
| where used | 11/22/2007 |
Q: i have a usrprf under qpgmr, yet i still have to do the level check *NO when compiling a prtf. is ...
A: IBM does not provide a tool to match object creation dates with source dates. But you can use the ...
|
| level check | 11/22/2007 |
Q: i have a usrprf under qpgmr, yet i still have to do the level check *NO when compiling a prtf. is ...
A: Level check *YES means that, before a program executes, the system verifies that the program was ...
|
| Query | 11/13/2007 |
Q: I have 1 DSPF & SFl.when i ll choose option'+' for one of the field on DSPF.i want to load dat ...
A: For easiest use, each new entry would be added to the end of the subfile by incrementing the subfile ...
|
| 5250 Mochasoft | 10/21/2007 |
Q: I am an old RPG student. I would like to get back into programming. I would like to work on my old ...
A: In the Northeast at least, iSeries shops appear to be on the wane. I have enjoyed the special ...
|
| 5250 Mochasoft | 10/21/2007 |
Q: I am an old RPG student. I would like to get back into programming. I would like to work on my old ...
A: Everyone I know who links by PC to an AS/400 does so through the auspices of a company that owns ...
|
| XML to AS400 | 10/17/2007 |
Q: I want to convert an XML file into AS400 so what steps to be followed.
A: To my knowledge, there is no automatic AS/400 function to convert an XML file to the AS/400. To ...
|
| What is the best way to download Data files from AS400 | 10/17/2007 |
Q: We would like to download AS400 data files to be used on PC (Oracle Database). Please suggest the ...
A: If you can access AS/400 folders from your network, you can copy a file to an AS/400 folder using ...
|
| rpg help | 10/11/2007 |
Q: I need the control to go back into the program without the user hitting the enter key or Function ...
A: You could assign the CHANGE keyword to the field with an indicator. The indicator comes on if the ...
|
| To write a program which will accept the Name/Address1/Adderss2/Address3 | 10/5/2007 |
Q: I want to write a small program which will accept the Name/Address1/Adderss2/Address3 and will ...
A: I apologize for the delay in answering your question - I was out of town and out of e-mail contact. ...
|
| Data transfer from AS400 to WIndows log file | 9/20/2007 |
Q: How can I transfer Hexadecimal, Zoned Decimal, Intiger type of data from AS400 to Windows? As for ...
A: Most 5250 emulation software packages that allows your PC to display an AS/400 sign-on screen also ...
|
| how to limit CPU usage | 9/20/2007 |
Q: Is there a way to limit the %cpu a job can take. I have several job which take high CPU. I have ...
A: The simplest approach is to submit the job to batch with a low run priority and timeslice, say ...
|
| Viewing job logs | 9/19/2007 |
Q: I am fairly new to the iSeries and need to find out if there is a way to view a transaction log for ...
A: Joe - Each job produces a job log at the time of sign-off that displays messages pertinent to that ...
|
| Source location for complied objects | 8/27/2007 |
Q: I have several RPGLE/CLLE objects that I need to organize. How do I determine where the source lives ...
A: The fact that DSPPGM does not give you the name of the source file and library suggests that the ...
|
| IPL from tape | 8/13/2007 |
Q: Is there a way to IPL an AS/400 from a backup tape that has a complete backup of everything on the ...
A: Yes, if you intend to restore the entire system from a full-system backup tape you can IPL from the ...
|
| client access print screen | 8/8/2007 |
Q: In client access when I use the print screen button, I get dots for each character that should have ...
A: Most 5250 emulation software packages allow the user to map keys on the keyboard to specific ...
|
| Transfering Greek data from AS400 to PC | 8/3/2007 |
Q: Actually I want to migrate some data containing English as well as Greek characters from AS400 to ...
A: This is not really my area of expertise. However, as you do the file transfer, the system tries to ...
|
| Data Transfer from iseries server | 7/12/2007 |
Q: I have use Data transfer from iseries server to my pc. But I have use manually. Can I make ...
A: If you are working with a PC network and the disk drive of your AS/400 or iSeries has been mapped to ...
|
| CL- Audit Journaling | 7/6/2007 |
Q: I am using the command DSPAUDJRNE to log all the commands. It also records the commands which a ...
A: Yes, the CDCLP flag indicates whether the command was run from a CL or REXX program. Another way to ...
|
| AS 400 | 5/30/2007 |
Q: I use the program As 400 at my job and i was wondering if you give me information on it and ...
A: The AS/400 is one of a family of IBM midrange business computers unlike a PC or PC network. It is a ...
|
| download source file to pc | 4/6/2007 |
Q: I want to download source file from a library to my pc - Can you help me?
A: I'm presuming that your PC is configured so it can 'see' the AS/400 or iSeries folders. Use the ...
|
| DDS Key field | 2/10/2007 |
Q: I have A Phisical file defined with 2 Key fields. First Keyfield is Clientnumber, second key Field ...
A: You cannot index on a portion of a field, only on the full field. However, you could create the ...
|
| Passing parms | 1/16/2007 |
Q: Call PGM(*libl/css) Parm(&BDATE &TDATE) I entere for the date parm 20060131 20061231 what am I ...
A: Call PGM(*libl/css) Parm(&BDATE &TDATE) If this is a line in a CL program, &BDATE and &TDATE ...
|
| SQL | 12/18/2006 |
Q: im wondering if i can retrive all the sql statments runed by users ( who have a commaned line), ...
A: To my knowledge, there is no place where the SQL statements are recorded. I can do some checking ...
|
| answer pls | 12/12/2006 |
Q: I Want more detail about as/400...then finish my as/400 training hows job condition...
A: The AS/400 is an IBM midrange computer - not a PC or PC network-based computer. It uses an IBM ...
|
| C/400 | 8/27/2006 |
Q: i want to know why C and C++ are not used in programing on the AS400.
A: C and C++ are available for the AS/400. You can find references to them by googling "ILE C++ ...
|
| Command Shortcuts | 6/16/2006 |
Q: What is the command you type in to create shortcuts on AS/400 Commands ? for example: To create a ...
A: Monna - You can use the 'create duplicate object command' CRTDUPOBJ and press F4 to prompt for ...
|
| User Account Reports | 5/19/2006 |
Q: In order to effectively audit user accounts created over a period of time I need to locate the date ...
A: The person who designed the file may or may not have included a field to record the date the account ...
|
| AS400 Changing Address | 4/7/2006 |
Q: I am a Network Engineer doing on site IT for a Graphics company that uses AS400 for their purchasing ...
A: David - This can vary, depending on the software they use. It might be hardcoded as a constant in ...
|
| Job to Monitor file to process records immediately when file updates | 11/4/2005 |
Q: I am looking for the best solution on the iseries to monitor a file and when records are added to ...
A: One simple way would be to write a CL program and submit it each day to run in batch. PGM DCL ...
|
| Convert text file to pyhsical file | 6/1/2005 |
Q: Currently i received some data that contain funny character(ASCII code) which cause problem when i ...
A: It may be as simple as specifing *YES on the ignore-decimal-data-errors parameter when you compile ...
|
| RPG on the AS400 | 3/9/2005 |
Q: I currently use SQL on the AS400 to manipulate data, I need to learn RPG. I learn best in a ...
A: ATS offers self-study courses in RPG; IBM used to offer actual classes - you might check with them. ...
|
| CRTLF command | 1/27/2005 |
Q: I wonder if you can help with this problem. I'm trying to create a single member logical file ...
A: My first guess would that when you key the member names on IBM's command line, IBM puts a separator ...
|
| XML to AS400 | 1/25/2005 |
Q: How can we convert an XML file into Physical Files in AS400? Could you explain me the logic of doing ...
A: To my knowledge, there is no native AS/400 function to convert an XML file. It is likely that there ...
|
| AS400 Backup | 1/23/2005 |
Q: Since storage is so cheap now,is there a way to back up the as400 to a server or an external hard ...
A: There are a number of different tape formats offered for the AS/400 - quarter inch tape cartridge, ...
|
| How to change the attributes of a Program described Printer file | 1/19/2005 |
Q: How to change the attributes of a Program described Printer file. I have a situation like this. I am ...
A: I control printer overflow by defining an INFDS for the printer file, with a field for line number. ...
|
| record locking problem | 12/19/2004 |
Q: after i use the update statement im not able to chain the same file again. Before giving the chain ...
A: The problem does not make sense. Any lock you have on a record is automatically released when you ...
|
| trivia | 10/16/2004 |
Q: What does the 400 in As400 mean?
A: The AS/400 is a line of computers within the System/3 family. IBM assigned the '4' as a way of ...
|
| Routine for reversing a NAME field | 8/19/2004 |
Q: My file has the employee name contained in one field, in this order: ...
A: I could write a routine to reverse the name order for you, but the difficulty here is determining ...
|
| CL program to check the ASP utilityon hourly basis | 5/10/2004 |
Q: I'm new to AS400 ,right now i want a CL program to check the ASP utility on hourly basis.right now ...
A: You will need to write a simple CL program called CHKSYSSTS. The commands are: CHKSYSSTS: PGM ...
|
| RPG/CL Questions | 4/15/2004 |
Q: I am fresher in the field of as/400 and want to know what questions can be asked on the junior level ...
A: If the interviewer knows that you have little background yet in AS/400 or iSeries computers, then ...
|
| Force Duplex Printing | 1/23/2004 |
Q: Is there any way to force everything that prints to a certain outq to duplex? I have a lan attached ...
A: Duplexing on the AS/400 is controlled in the spool file. You can try changing a single spooled file ...
|
| Job Logs | 1/13/2004 |
Q: How do I limit the size of job logs? I believe somewhere I can set the max number of pages for a job ...
A: Job logs use the printer file QPJOBLOG in QSYS library. Use can use the CHGPRTF command to limit ...
|
| CL Program | 12/18/2003 |
Q: I am relatively new at programing so I wasn't really sure how to accomplish this. Where I work, we ...
A: The main reason you can't write a program to handle the cancellation of your jobs is because IBM ...
|
| Create Cl to restore Libraries from a file | 10/19/2003 |
Q: Can I use a CL program to retrieve a list of libraries from a file and use the list as a parameter ...
A: Yes, if it is a file defined by DDS - use the DCLF statement at the top of your CL program to ...
|
| Refreshing displays | 1/13/2003 |
Q: One of our users want an automatic periodic refresh of a normal DDS subfile display. I have never ...
A: The AS/400 and iSeries computers are different than some other computers, in that from the time a ...
|
| how can i tell if there are open files in an as/400 library | 10/22/2002 |
Q: Is there a way to display a list of users who are currently using a file in a given library?
A: You can use the "Work with object locks" command (WRKOBJLCK). For locks on a file, the format is: ...
|
| AS400 backup | 10/11/2002 |
Q: When I am doing a SAVLIB command on the AS400 for my daily backup, I realise there is a prompt for ...
A: The expiration date parameter tells the AS/400 how long to consider the backup to be an "active" ...
|
| AS400 | 9/8/2002 |
Q: I am a new IT student. Please can you briefly explain how the AS400 supports a database? I am logged ...
A: The AS/400 is very different from PC-based systems. In what's called 'native mode' (the mode it was ...
|
| new multiplayer game idea | 4/29/2002 |
Q: I have an idea for a new role playing game idea. It is more on a concept level since I am not an ...
A: Sergei: I would contact companies that produce role-playing software and ask in a general way if ...
|
| Mid Range Computers | 3/13/2002 |
Q: I was wondering since you's are experts i was wanting some information about mid range computers ...
A: Midrange computers are a class of business computer - larger than a PC and different than a PC - yet ...
|
| rpg questions | 2/27/2002 |
Q: all any other programming in AS400 environment for that matter. I am just wondering exactly what ...
A: RPG stands for Report Program Generator. Originally it was conceived of as a kind of query tool for ...
|
| AS400 CTLCHAR? | 2/19/2002 |
Q: We moved from our old AS400 box to the iSeries box. Most reports printed are OK except for one ...
A: There are a lot of possibilities here - enough that you probably need a programmer on site to solve ...
|
| disk utilization | 11/26/2001 |
Q: how do i limit the disk storage for each objects or libraries in the AS400. is there a way i can ...
A: The easiest way to monitor disk usage is by limiting the number of records in each physical file. ...
|
| Advanced 36 | 11/7/2001 |
Q: I recently brought a advanced 36 on ebay. Allthough it came with manuals,cables etc., when I go to ...
A: Legally, under most circumstances, you must purchase a license to use IBM's operating system ...
|
| Making transition from mainframe to as400 | 9/10/2001 |
Q: I think you might be able to help me. For the last 12 years, I'm have been a Sr. Systems Analyst at ...
A: A good place to start is at www.midrangecomputing.com. You are likely to find AS/400 education ...
|
| Corrupted file | 5/29/2001 |
Q: I got a corrupted file on our AS400, I can copy off the data fine, but I can't delete the file ...
A: First, I would try to find the job that has the file locked, using the WRKOBJLCK command and if ...
|
| Authorization to printer queues | 4/5/2001 |
Q: After doing a complete system restore after a crash a few weeks ago, we've not been able to get the ...
A: There are several possibilities. First, be sure that you don't have duplicate output-queue names in ...
|
| AS/400 Performance | 3/14/2001 |
Q: Is the batch environment in the AS/400 supposed to run at 99 to ++++ % CPU usage at times? Why/Why ...
A: The CPU usage percentage on the Work With System Status (WRKSYSSTS) screen indicates what percentage ...
|
| How to create a display file | 11/1/2000 |
Q: My AS400 mod 720 has RPGIV on it. I am trying to create a CL program that will use a display file to ...
A: Roy - I apologize for the lateness of my answer to you - I was called away on a family health ...
|
| AS/400 and RPG | 9/26/2000 |
Q: I am a beginning programming student and would like basic information on these subjects.
A: There are several good sources for classroom or self-study courses on AS/400 operations and RPG ...
|
