BRMS on iSeries Multiple LPARs
How do I get BRMS to perform backups from multiple LPARs to a single LTO3 tape, on the same day?
Answer Question
| April 2, 2010 1:07 PM
AS/400, Backup & recovery, IBM
How do I get BRMS to perform backups from multiple LPARs to a single LTO3 tape, on the same day?
Answer Question
| April 2, 2010 1:07 PM
AS/400, Backup & recovery, IBM
passing array as parameter
Hi all How can we pass a character array as parameter from one RPG program to another ? Regards Skapoor
Answer Question
| October 28, 2009 9:28 AM
RPG
Hi all How can we pass a character array as parameter from one RPG program to another ? Regards Skapoor
Answer Question
| October 28, 2009 9:28 AM
RPG
Reclaim System Storage
I was considering doing a reclaim system storage this weekend, but was just curiuos if anyone wanted to share how long their’s took to run in the past. We have a 820 model with about 78% of 510GB being used. it has 4GB of memory and processor speed is rated at 2350CP. I was planning [...]
Answer Question
| October 28, 2009 1:02 PM
i5, iSeries, OS/400, Performance/Tuning
I was considering doing a reclaim system storage this weekend, but was just curiuos if anyone wanted to share how long their’s took to run in the past. We have a 820 model with about 78% of 510GB being used. it has 4GB of memory and processor speed is rated at 2350CP. I was planning [...]
Answer Question
| October 28, 2009 1:02 PM
i5, iSeries, OS/400, Performance/Tuning
Check for active jobs in CL
How can I check for a active job in my CL?
Answer Question
| October 25, 2010 9:47 AM
iSeries
How can I check for a active job in my CL?
Answer Question
| October 25, 2010 9:47 AM
iSeries
Convert Excel file to AS400
I have ‘n’ number of excel files . i need to convert them into AS400 and validate data . My problem is that all these files are in different formats (e.g. Excel 1 has Age, Name ,Salary fields; excel 2 has name , salary , company fields) to validate data I need these excel files [...]
Answer Question
| July 1, 2005 4:38 AM
RPG, Tech support, VBA
I have ‘n’ number of excel files . i need to convert them into AS400 and validate data . My problem is that all these files are in different formats (e.g. Excel 1 has Age, Name ,Salary fields; excel 2 has name , salary , company fields) to validate data I need these excel files [...]
Answer Question
| July 1, 2005 4:38 AM
RPG, Tech support, VBA
Printing a Signature Font
Has anyone programmed a font in a printer file that prints a signature? We have an HP4250 with a memory card containing this font. We were given by the vendor a control string to specify in the program. I think I need to customize a Work Station Customizing Object (WSCST) for the printer and for [...]
Answer Question
| July 15, 2005 11:16 AM
Development, Graphical User Interfaces, RPG
Has anyone programmed a font in a printer file that prints a signature? We have an HP4250 with a memory card containing this font. We were given by the vendor a control string to specify in the program. I think I need to customize a Work Station Customizing Object (WSCST) for the printer and for [...]
Answer Question
| July 15, 2005 11:16 AM
Development, Graphical User Interfaces, RPG
Runqry on Multi format LF
If I do a runqry on multi format logical file, will it only show me the records from the first physical file and not the combilned records??
Answer Question
| June 29, 2005 6:44 AM
RPG
If I do a runqry on multi format logical file, will it only show me the records from the first physical file and not the combilned records??
Answer Question
| June 29, 2005 6:44 AM
RPG
Logical File
I’m having 2 independent physical files. File x having ID & Name – ID is the Key. File y having Phone no and Address – Phone no is the Key. I want to create the logical file over the above 2 Physical file. Is it possible or any other way is there
Answer Question
| June 29, 2005 2:06 AM
RPG
I’m having 2 independent physical files. File x having ID & Name – ID is the Key. File y having Phone no and Address – Phone no is the Key. I want to create the logical file over the above 2 Physical file. Is it possible or any other way is there
Answer Question
| June 29, 2005 2:06 AM
RPG
how to best handle multiple level breaks for amount totals using ILE
I’m having a hard time getting my ILE program to read a record from a file in consultant number, order type, order class sequence. It is possible a consultant may have 1 or many order types and needs to break & total some fields on each different order type, and of course break on a [...]
Answer Question
| October 25, 2010 11:25 PM
Development, RPG
I’m having a hard time getting my ILE program to read a record from a file in consultant number, order type, order class sequence. It is possible a consultant may have 1 or many order types and needs to break & total some fields on each different order type, and of course break on a [...]
Answer Question
| October 25, 2010 11:25 PM
Development, RPG
Retrieving source members
I want to retrieve all the source physical files in a particular library and then in each source physical file, I want to retrieve all the members. Any pointers to this would help. Thanks
Answer Question
| October 27, 2009 7:26 AM
RPG
I want to retrieve all the source physical files in a particular library and then in each source physical file, I want to retrieve all the members. Any pointers to this would help. Thanks
Answer Question
| October 27, 2009 7:26 AM
RPG
Alternate IPL device on AS/400
I need to know how to determine the current Alternate IPL device on our AS/400 model 270, and (possibly) how to change that to a different device. We plan to use a different tape device for system backups and restores, from the original tape device that came with our system.
Answer Question
| June 27, 2005 11:37 AM
Backup & recovery, i5, iSeries, OS/400
I need to know how to determine the current Alternate IPL device on our AS/400 model 270, and (possibly) how to change that to a different device. We plan to use a different tape device for system backups and restores, from the original tape device that came with our system.
Answer Question
| June 27, 2005 11:37 AM
Backup & recovery, i5, iSeries, OS/400
dates in rpg
Hi! I’m starting to use RPG AS/400, and I’d like to know how to insert date fields in a table using strsql. Can anyone help me, please? Thanks in advance, MelissaG
Answer Question
| October 24, 2010 10:31 AM
RPG
Hi! I’m starting to use RPG AS/400, and I’d like to know how to insert date fields in a table using strsql. Can anyone help me, please? Thanks in advance, MelissaG
Answer Question
| October 24, 2010 10:31 AM
RPG
Load all subfile
Hi, I have written a simple subfile program to display a load all subfile. When I press page down which is automatically handled by O/S, it displays me another set of records. From the second screen, if I press ENTER, it comes back to the previous screen which should not happen. Only, when I press [...]
Answer Question
| October 24, 2010 7:57 AM
RPG
Hi, I have written a simple subfile program to display a load all subfile. When I press page down which is automatically handled by O/S, it displays me another set of records. From the second screen, if I press ENTER, it comes back to the previous screen which should not happen. Only, when I press [...]
Answer Question
| October 24, 2010 7:57 AM
RPG
iSeries system commands
Is there a command available that will show me my current total CPU of memory on an iSeries model 520? Thanks
Answer Question
| October 27, 2009 10:16 AM
AS/400, Hardware
Is there a command available that will show me my current total CPU of memory on an iSeries model 520? Thanks
Answer Question
| October 27, 2009 10:16 AM
AS/400, Hardware
Print Image File in iSeries
Hi, I would like to ask for help to use the data type field GRAPHIC in iSeries. Can I save an image file into this field type. If so, how do I do this? I have tried but it always shows an error of character conversion not valid. Please help. Regards, Tony Tam
Answer Question
| October 24, 2010 1:13 PM
AS/400, DB2, Development, i5, Integration/Connectivity, iSeries, OS/400, Programming Languages, RPG, tips and tricks, Tools
Hi, I would like to ask for help to use the data type field GRAPHIC in iSeries. Can I save an image file into this field type. If so, how do I do this? I have tried but it always shows an error of character conversion not valid. Please help. Regards, Tony Tam
Answer Question
| October 24, 2010 1:13 PM
AS/400, DB2, Development, i5, Integration/Connectivity, iSeries, OS/400, Programming Languages, RPG, tips and tricks, Tools
Receiving journal entries
Hi, I am new to AS400, so need some help in solving a problem. I have tried to some extent but things seem to be more complicated than I thought. Problem Goal: receiving entries from a journal and putting them into a DB2 table in a predefined format(say Type5). RCVJRNE command can be used to [...]
Answer Question
| June 24, 2005 5:55 AM
Backup & recovery, i5, Integration/Connectivity, iSeries, OS/400, Printing, Security, System monitoring, tips and tricks, Tools
Hi, I am new to AS400, so need some help in solving a problem. I have tried to some extent but things seem to be more complicated than I thought. Problem Goal: receiving entries from a journal and putting them into a DB2 table in a predefined format(say Type5). RCVJRNE command can be used to [...]
Answer Question
| June 24, 2005 5:55 AM
Backup & recovery, i5, Integration/Connectivity, iSeries, OS/400, Printing, Security, System monitoring, tips and tricks, Tools
Message subfile
I am using message subfile to load error messages. I am calling a CL program to load and clear message subfiles. While clearing, I am passing the name of the RPG program to the CL program and the code is RMVMSG MSGQ(Program Queue Name) Clear(*ALL) But I am getting the message that message queue (which [...]
Answer Question
| October 24, 2010 1:30 AM
Programming Languages, RPG
I am using message subfile to load error messages. I am calling a CL program to load and clear message subfiles. While clearing, I am passing the name of the RPG program to the CL program and the code is RMVMSG MSGQ(Program Queue Name) Clear(*ALL) But I am getting the message that message queue (which [...]
Answer Question
| October 24, 2010 1:30 AM
Programming Languages, RPG
iSeries performance question
Hello everybody, I’m trying to figure out the best way to count the number of records matching specified criteria in large PF. (The file has over 50 million records currently and with some purging we hope to bring it down to around 20 mil.) Anyway, I created the (SQL) view: create view largePF99 ( field1, [...]
Answer Question
| July 29, 2009 1:26 PM
AS/400, Performance/Tuning, RPG, SQL, tips and tricks, Tools, WebSphere Studio
Hello everybody, I’m trying to figure out the best way to count the number of records matching specified criteria in large PF. (The file has over 50 million records currently and with some purging we hope to bring it down to around 20 mil.) Anyway, I created the (SQL) view: create view largePF99 ( field1, [...]
Answer Question
| July 29, 2009 1:26 PM
AS/400, Performance/Tuning, RPG, SQL, tips and tricks, Tools, WebSphere Studio
Setup Remote printer in zOS
We have zOS v1R4 in a z900 mainframe server. I am a newly joined MVS system programmer here in this Datacenter. My requirement is as follows: 1) Currently we use TCP/IP to connect to LPARs in the mainframe 2) There is a remote laser printer in the client place(which is already networked) 3) We would [...]
Answer Question
| June 18, 2005 3:46 PM
Capacity planning, Hardware, Integration with other platforms, Logical partitions, Mainframe, MVS, z/OS, z/OS configuration
We have zOS v1R4 in a z900 mainframe server. I am a newly joined MVS system programmer here in this Datacenter. My requirement is as follows: 1) Currently we use TCP/IP to connect to LPARs in the mainframe 2) There is a remote laser printer in the client place(which is already networked) 3) We would [...]
Answer Question
| June 18, 2005 3:46 PM
Capacity planning, Hardware, Integration with other platforms, Logical partitions, Mainframe, MVS, z/OS, z/OS configuration
Transfer specific “EXCEL CELLS” to specific AS/400 DB2 fields
I have an EXCEL spreadsheet that Users enter specific information and the sheet performs numerous calculations. I need to pull information from various cells on the spreadsheet and load to an AS/400 file. There will be numerous spreadsheets created during the day. I would like to load each completed worksheet as a new record to [...]
Answer Question
| June 20, 2005 12:45 PM
DB2, RPG, SQL, XML
I have an EXCEL spreadsheet that Users enter specific information and the sheet performs numerous calculations. I need to pull information from various cells on the spreadsheet and load to an AS/400 file. There will be numerous spreadsheets created during the day. I would like to load each completed worksheet as a new record to [...]
Answer Question
| June 20, 2005 12:45 PM
DB2, RPG, SQL, XML
