File transfer to the iSeries problem.
I am trying to transfer an excel speadsheet file to my AS/400. I have tried setting up a file transfer through client access and tried sending the file directly from Excel. Both times I get the following error cwbtf0023 – pc file description file was not specified or is empty The file is not empty. [...]
Answer Question
| December 9, 2011 10:11 AM
AS/400, Backup & recovery, Hardware, i5, Installation, Integration/Connectivity, iSeries, Logical partitions, OS/400, PC/Windows Connectivity, Performance/Tuning, Printing, PTFs, Security, Server consolidation, System monitoring, tips and tricks, Tools
I am trying to transfer an excel speadsheet file to my AS/400. I have tried setting up a file transfer through client access and tried sending the file directly from Excel. Both times I get the following error cwbtf0023 – pc file description file was not specified or is empty The file is not empty. [...]
Answer Question
| December 9, 2011 10:11 AM
AS/400, Backup & recovery, Hardware, i5, Installation, Integration/Connectivity, iSeries, Logical partitions, OS/400, PC/Windows Connectivity, Performance/Tuning, Printing, PTFs, Security, Server consolidation, System monitoring, tips and tricks, Tools
iSeries configuration for a DeskJet 940C
I’m trying to set up a networked DeskJet 940C using a *RMT (LPR/LPD) OUTQ. Per IBM doc, I’m using *HP500 for the MFRTYPMDL, but I can’t seem to get the remote outq right. I’ve tried ‘text’, ‘raw’, ‘prt1′, ‘pr1′, and ‘lpt1′ in both lower and upper case with no success. I would want to set [...]
Answer Question
| October 25, 2010 10:30 AM
i5, iSeries, OS/400, Printing
I’m trying to set up a networked DeskJet 940C using a *RMT (LPR/LPD) OUTQ. Per IBM doc, I’m using *HP500 for the MFRTYPMDL, but I can’t seem to get the remote outq right. I’ve tried ‘text’, ‘raw’, ‘prt1′, ‘pr1′, and ‘lpt1′ in both lower and upper case with no success. I would want to set [...]
Answer Question
| October 25, 2010 10:30 AM
i5, iSeries, OS/400, Printing
Is *JOBCTL needed to view job logs?
I have read IBM’s Security manual and Work Management manual and I know that *JOBCTL is needed to change job priorities and other things for jobs on the system, but I do not see any statements that say *JOBCTL is needed to view the job logs of other user’s jobs on the system. Does anyone [...]
Answer Question
| October 25, 2010 2:09 PM
Backup & recovery, Hardware, i5, Installation, Integration/Connectivity, iSeries, Logical partitions, OS/400, PC/Windows Connectivity, Performance/Tuning, Printing, PTFs, Security, Server consolidation, System monitoring, tips and tricks, Tools
I have read IBM’s Security manual and Work Management manual and I know that *JOBCTL is needed to change job priorities and other things for jobs on the system, but I do not see any statements that say *JOBCTL is needed to view the job logs of other user’s jobs on the system. Does anyone [...]
Answer Question
| October 25, 2010 2:09 PM
Backup & recovery, Hardware, i5, Installation, Integration/Connectivity, iSeries, Logical partitions, OS/400, PC/Windows Connectivity, Performance/Tuning, Printing, PTFs, Security, Server consolidation, System monitoring, tips and tricks, Tools
Spooled files cannot be displayed
When I try to display the spooled files, I get the “File no longer in the system” prompt.I cannot move the file, etc…I know my CL and RPGLE have to be somewhat in sync or I would not be getting the spooled files to even show up in the queue. I only have 1 year [...]
Answer Question
| July 12, 2005 8:55 AM
RPG
When I try to display the spooled files, I get the “File no longer in the system” prompt.I cannot move the file, etc…I know my CL and RPGLE have to be somewhat in sync or I would not be getting the spooled files to even show up in the queue. I only have 1 year [...]
Answer Question
| July 12, 2005 8:55 AM
RPG
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
