Changing the font on AFP printer file
This user is having trouble changing the font on a DDS-described AFP printer file (with overlay). He says the FONTNAME keyword appears to do nothing, and the FONT keyword changes the size of the text but not the font itself. Do you know how to handle this? – Michelle Davidson, editor, Search400.com
Answer Question
| October 5, 2005 10:12 AM
AS/400, Printers
This user is having trouble changing the font on a DDS-described AFP printer file (with overlay). He says the FONTNAME keyword appears to do nothing, and the FONT keyword changes the size of the text but not the font itself. Do you know how to handle this? – Michelle Davidson, editor, Search400.com
Answer Question
| October 5, 2005 10:12 AM
AS/400, Printers
Question about iSeries Full Save
Graham has a question about modifying his use of the SAVLIBBRM command. He writes: “If I decide to omit objects from the SAVLIBBRM command for a FULL save of a library, would BRMS regard this library as the ‘last full save’ of the library if doing a restore from a *CUML save?” What do you [...]
Answer Question
| September 27, 2005 10:09 AM
AS/400, Backup & recovery, IBM
Graham has a question about modifying his use of the SAVLIBBRM command. He writes: “If I decide to omit objects from the SAVLIBBRM command for a FULL save of a library, would BRMS regard this library as the ‘last full save’ of the library if doing a restore from a *CUML save?” What do you [...]
Answer Question
| September 27, 2005 10:09 AM
AS/400, Backup & recovery, IBM
Need help sending email with attached document directly from iSeries
Alan has an existing application that uses the SNDDST command to send an e-mail with a document attached. He’s been asked to modify the document name to include more information. The problem is, the document parameter allows only 12 characters in the document name. Is there a way to use a longer document name with [...]
Answer Question
| September 27, 2010 10:05 AM
AS/400, Exchange
Alan has an existing application that uses the SNDDST command to send an e-mail with a document attached. He’s been asked to modify the document name to include more information. The problem is, the document parameter allows only 12 characters in the document name. Is there a way to use a longer document name with [...]
Answer Question
| September 27, 2010 10:05 AM
AS/400, Exchange
How to convert characters to numeric in CSV file?
Roy wrote the editors of Search400.com recently, looking for help with a CSV file. He said: “I’m using CRTCSVF to create a csv file. My problem is that my customer number is alphanumeric, but they want it to be numeric (without the quotes) in the CSV file and with the leading zeros intact. “Is there [...]
Answer Question
| November 14, 2009 9:58 AM
AS/400, RPG
Roy wrote the editors of Search400.com recently, looking for help with a CSV file. He said: “I’m using CRTCSVF to create a csv file. My problem is that my customer number is alphanumeric, but they want it to be numeric (without the quotes) in the CSV file and with the leading zeros intact. “Is there [...]
Answer Question
| November 14, 2009 9:58 AM
AS/400, RPG
Error message in window subfile
i have window subfile. Error message is showing behinde the window. It should show within the window. Following is my coding A R SFLMSGW SFL A SFLMSGRCD(15) A MSGKEY SFLMSGKEY A PGMQ SFLPGMQ(10) A R SFLMSGWC SFLCTL(SFLMSGW) A OVERLAY A PUTOVR A 97 SFLDSP A 97 SFLDSPCTL A 97 SFLINZ A 98 SFLEND A SFLSIZ(0010) [...]
Answer Question
| October 28, 2009 9:47 AM
AS/400, Database, DB2 Universal Database, RPG
i have window subfile. Error message is showing behinde the window. It should show within the window. Following is my coding A R SFLMSGW SFL A SFLMSGRCD(15) A MSGKEY SFLMSGKEY A PGMQ SFLPGMQ(10) A R SFLMSGWC SFLCTL(SFLMSGW) A OVERLAY A PUTOVR A 97 SFLDSP A 97 SFLDSPCTL A 97 SFLINZ A 98 SFLEND A SFLSIZ(0010) [...]
Answer Question
| October 28, 2009 9:47 AM
AS/400, Database, DB2 Universal Database, RPG
AS400 to the Excel
I need to split the city and state. I can do it once the results are in Excel but I would like to do it on the way from the AS400 to the Excel spreadsheet.
Answer Question
| November 12, 2009 8:08 PM
AS/400
I need to split the city and state. I can do it once the results are in Excel but I would like to do it on the way from the AS400 to the Excel spreadsheet.
Answer Question
| November 12, 2009 8:08 PM
AS/400
Wireless connection to an iSeries. What are the choices?
I need to be able to login to an iSeries remotely utilizing; Palm, cell phone, etc. Based on our network setup there are parms to consider: ability to pass Cisco VPN, or dial-in directly into the iSeries. Is there any solution available out there and what software/hardware would be required? Your help is greatly appreciated. [...]
Answer Question
| September 28, 2005 4:07 PM
AS/400
I need to be able to login to an iSeries remotely utilizing; Palm, cell phone, etc. Based on our network setup there are parms to consider: ability to pass Cisco VPN, or dial-in directly into the iSeries. Is there any solution available out there and what software/hardware would be required? Your help is greatly appreciated. [...]
Answer Question
| September 28, 2005 4:07 PM
AS/400
List of users with password expiration lvl/date
I need to gena report or file to list all users on our AS/400 (V4R5) and display their password expiration level and expiration date. Suggestions?
Answer Question
| September 23, 2005 9:33 AM
AS/400
I need to gena report or file to list all users on our AS/400 (V4R5) and display their password expiration level and expiration date. Suggestions?
Answer Question
| September 23, 2005 9:33 AM
AS/400
Printing Summary Information From The SAV command
I am trying to print a summary report from the SAV command. Using OUTPUT(*PRINT) INFTYPE(*SUMMARY)creates a 500+ page report (which to me is not a summary). When I try using a stream file OUTPUT(FSAV), and then CPYFRMSTMF to an AS/400 file, I get mostly unreadable data in the AS/400 file. I am not very familar [...]
Answer Question
| November 12, 2009 11:50 AM
AS/400
I am trying to print a summary report from the SAV command. Using OUTPUT(*PRINT) INFTYPE(*SUMMARY)creates a 500+ page report (which to me is not a summary). When I try using a stream file OUTPUT(FSAV), and then CPYFRMSTMF to an AS/400 file, I get mostly unreadable data in the AS/400 file. I am not very familar [...]
Answer Question
| November 12, 2009 11:50 AM
AS/400
Financial Calculations in RPG
Does anyone have sample code of the following calculations (Excel Equivalent in brackets): 1. Net Present Value (NPV) 2. Payment (PMT) 3. Principal Payment (PPMT) Any form of RPG to run on an iSeries would be great.
Answer Question
| September 24, 2005 10:13 AM
Corporate Financial Applications, Data analysis, Financial services applications, RPG
Does anyone have sample code of the following calculations (Excel Equivalent in brackets): 1. Net Present Value (NPV) 2. Payment (PMT) 3. Principal Payment (PPMT) Any form of RPG to run on an iSeries would be great.
Answer Question
| September 24, 2005 10:13 AM
Corporate Financial Applications, Data analysis, Financial services applications, RPG
Sharing folders
We have recently upgraded from V5R1 to V5R3. For some reason I can see the shared folders on the iSeries with OpsNav but can’t access them or map to them from windows. NetServer is running and the permissions are correct. Can anyone help?
Answer Question
| September 29, 2005 3:02 PM
AS/400
We have recently upgraded from V5R1 to V5R3. For some reason I can see the shared folders on the iSeries with OpsNav but can’t access them or map to them from windows. NetServer is running and the permissions are correct. Can anyone help?
Answer Question
| September 29, 2005 3:02 PM
AS/400
Looking for Good References for iSeries Navigator & Java
Can you refer me to some good references? We are running OS400 V5R2, but in the next month or two, we will be running V5R3. Thank You, in advance!
Answer Question
| September 26, 2005 12:46 PM
AS/400
Can you refer me to some good references? We are running OS400 V5R2, but in the next month or two, we will be running V5R3. Thank You, in advance!
Answer Question
| September 26, 2005 12:46 PM
AS/400
Menus
Is there an easy way to find out what source file was used when creating a menu with SDA?
Answer Question
| September 21, 2005 11:53 AM
AS/400
Is there an easy way to find out what source file was used when creating a menu with SDA?
Answer Question
| September 21, 2005 11:53 AM
AS/400
Trigers
Can anyone give me an example of using a trigger when a record is inserted into a file? I am using RPGLE.
Answer Question
| November 11, 2009 9:27 AM
AS/400, DB2 Universal Database, RPG
Can anyone give me an example of using a trigger when a record is inserted into a file? I am using RPGLE.
Answer Question
| November 11, 2009 9:27 AM
AS/400, DB2 Universal Database, RPG
For those familiar with AS400 web development
I am attempting to create an internet accessible webpage from the AS400 using the IBM http server powered by Apache. We are running V5R3. Now, I assume that I would use virtual hosting in order to obtain this result. When using virtual hosting, I would like to create a name-based server. I can create an [...]
Answer Question
| September 21, 2005 8:56 AM
AS/400, Web site design & management
I am attempting to create an internet accessible webpage from the AS400 using the IBM http server powered by Apache. We are running V5R3. Now, I assume that I would use virtual hosting in order to obtain this result. When using virtual hosting, I would like to create a name-based server. I can create an [...]
Answer Question
| September 21, 2005 8:56 AM
AS/400, Web site design & management
Create aceess database(MDB) from iseries
I need to create mdb’s from iseries through RPG or CL program. Can somebody give me some information around this. TIA
Answer Question
| November 11, 2009 4:35 PM
AS/400
I need to create mdb’s from iseries through RPG or CL program. Can somebody give me some information around this. TIA
Answer Question
| November 11, 2009 4:35 PM
AS/400
AS/400 Simulation
Hi, I am trying to locate software that will allow us to simulate an AS/400 for training and demonstration. Do you know of anything that will fit the bill? Thanks in advance for your help. Regards PJ
Answer Question
| November 11, 2009 6:52 AM
AS/400
Hi, I am trying to locate software that will allow us to simulate an AS/400 for training and demonstration. Do you know of anything that will fit the bill? Thanks in advance for your help. Regards PJ
Answer Question
| November 11, 2009 6:52 AM
AS/400
How to find last RUN date of a Query on AS/400?
My system currently has 2000+ queries defined. Not all are active. Is there a way to determine the LAST RUN DATE of a query as opposed to the LAST CHANGE date. Most of our queries are not resaved (ie ‘changed’) each time they are run. Thanks in advance for your help.
Answer Question
| November 11, 2009 3:00 PM
AS/400
My system currently has 2000+ queries defined. Not all are active. Is there a way to determine the LAST RUN DATE of a query as opposed to the LAST CHANGE date. Most of our queries are not resaved (ie ‘changed’) each time they are run. Thanks in advance for your help.
Answer Question
| November 11, 2009 3:00 PM
AS/400
Problems with Stored Procedures
Hi, I have written a stored procedure in SQLRPGLE. I used option 15 to create a module, then CREATE PROCEDURE to define it. When I go into SQL to call it, it says External program SVLBR in V64BPCSUSR not found. This is where my module & stored procedure is located. Any ideas on what I [...]
Answer Question
| November 11, 2009 2:28 PM
DB2 Universal Database, RPG
Hi, I have written a stored procedure in SQLRPGLE. I used option 15 to create a module, then CREATE PROCEDURE to define it. When I go into SQL to call it, it says External program SVLBR in V64BPCSUSR not found. This is where my module & stored procedure is located. Any ideas on what I [...]
Answer Question
| November 11, 2009 2:28 PM
DB2 Universal Database, RPG
echo in qsh
I’m getting strange results from the echo command in qsh. When I run qsh interactivly, I can pipe the output of the echo command to a file (of the “Yes, you can print to a file in CL” fame). I can echo as many lines as I want to while interactive. When I try to [...]
Answer Question
| November 11, 2009 12:10 PM
AS/400
I’m getting strange results from the echo command in qsh. When I run qsh interactivly, I can pipe the output of the echo command to a file (of the “Yes, you can print to a file in CL” fame). I can echo as many lines as I want to while interactive. When I try to [...]
Answer Question
| November 11, 2009 12:10 PM
AS/400
