Using command cpytomimpf
I am trying to use the command…I have pf that I need to copy to the IFS directory pcfiles. I can ge the file copied but receive òðñð`ññ`ðñ�@@�ð÷ööôôó�ùð@@�@@�ñóöõöô÷…. Operation system is V5R4MO. Any ideas why the ebcdic to ascii is not working, If I use client access to export the file,it works fine, but wanting [...]
Answer Question
| December 16, 2010 4:35 AM
CPYTOIMPF, IFS Directory, IFS Directory to iSeries Folder, Physical Files, V5R4
I am trying to use the command…I have pf that I need to copy to the IFS directory pcfiles. I can ge the file copied but receive òðñð`ññ`ðñ�@@�ð÷ööôôó�ùð@@�@@�ñóöõöô÷…. Operation system is V5R4MO. Any ideas why the ebcdic to ascii is not working, If I use client access to export the file,it works fine, but wanting [...]
Answer Question
| December 16, 2010 4:35 AM
CPYTOIMPF, IFS Directory, IFS Directory to iSeries Folder, Physical Files, V5R4
Using API QC3ENCDT in encryption using RSAalgorithm under a Public key, error CPF9DDB !
Hi I have been working on Encryption/Decryption of data on AS400 v5R4. I have already done the Encryption of data using QC3ENCDT API on COBOOL. Now, I want to use the RSA Public key to encrypt my encryption key. For that I had written a test program but it is throwing one error and I [...]
Answer Question
| December 13, 2010 8:27 AM
AS/400, COBOL, Data Encryption, RSA Adaptive Authentication, V5R4
Hi I have been working on Encryption/Decryption of data on AS400 v5R4. I have already done the Encryption of data using QC3ENCDT API on COBOOL. Now, I want to use the RSA Public key to encrypt my encryption key. For that I had written a test program but it is throwing one error and I [...]
Answer Question
| December 13, 2010 8:27 AM
AS/400, COBOL, Data Encryption, RSA Adaptive Authentication, V5R4
AS/400 Data Queue being deleted
We have 5 data queues that work fine, but one queue is being randomly deleted by QZHQSSRV. OS400 Version is 5.4. All queues are FIFO and in the same library/ASP
Answer Question
| December 10, 2010 5:04 PM
AS/400 Data Queue, Data Queue, OS/400, QZHQSSRV, V5R4
We have 5 data queues that work fine, but one queue is being randomly deleted by QZHQSSRV. OS400 Version is 5.4. All queues are FIFO and in the same library/ASP
Answer Question
| December 10, 2010 5:04 PM
AS/400 Data Queue, Data Queue, OS/400, QZHQSSRV, V5R4
iSeries V5R4 Function 24? Scratch Install
Where can I find the steps to scratch a system to the point of ready to reload from entire system save? I believe it is a control panel Function 23 or 24 but I have not found the correct document. Thanks, Nick
Answer Question
| April 27, 2011 3:39 PM
iSeries, V5R4
Where can I find the steps to scratch a system to the point of ready to reload from entire system save? I believe it is a control panel Function 23 or 24 but I have not found the correct document. Thanks, Nick
Answer Question
| April 27, 2011 3:39 PM
iSeries, V5R4
Can’t Set different Activation group in ILE SQL COBOL.
Does anyone know why when I compile an ILE SQL COBOL program it shows it going to Activation Group QILE but in the COMPILE prompts I don’t see any option to change the group to something else like our company name? In a Cobol ILE program the option is there but not in COBOL SQL ILE program? [...]
Answer Question
| December 8, 2010 3:45 PM
AS/400, AS/400 SQL, COBOL ILE, SQLCBLLE, V5R4
Does anyone know why when I compile an ILE SQL COBOL program it shows it going to Activation Group QILE but in the COMPILE prompts I don’t see any option to change the group to something else like our company name? In a Cobol ILE program the option is there but not in COBOL SQL ILE program? [...]
Answer Question
| December 8, 2010 3:45 PM
AS/400, AS/400 SQL, COBOL ILE, SQLCBLLE, V5R4
Regd: PTF Installation
We are using Iseries 550 Model with V5R4M0 Installed The current PTF level in my server is PTF Group SF99540 level 10117 Installed. I need to install the PTF Group SF99540 level 10292. My question is are there any PTF’s need to be installed(i.e.Hyper…) before installing Group SF99540 level 10292
Answer Question
| December 8, 2010 9:23 AM
IBM System i 550, PTF Group Installation, PTF Upgrade, PTFs, V5R4
We are using Iseries 550 Model with V5R4M0 Installed The current PTF level in my server is PTF Group SF99540 level 10117 Installed. I need to install the PTF Group SF99540 level 10292. My question is are there any PTF’s need to be installed(i.e.Hyper…) before installing Group SF99540 level 10292
Answer Question
| December 8, 2010 9:23 AM
IBM System i 550, PTF Group Installation, PTF Upgrade, PTFs, V5R4
Converting AS/400 negative numeric to character with leading zeros
I need to convert numeric values to character keeping the leading zeros and when the value is a negative, I need to prepend the negative sign in rpgle. Example: Positive Amount : 00005679.05 = 5,769.05 Negative Amount: 00000-500.25 = -500.25 I’ve tried the editc with the ‘X’ edit code but i need the negative sign. [...]
Answer Question
| December 4, 2010 5:11 PM
AS/400, AS/400 numeric fields, Numeric conversion, V5R4
I need to convert numeric values to character keeping the leading zeros and when the value is a negative, I need to prepend the negative sign in rpgle. Example: Positive Amount : 00005679.05 = 5,769.05 Negative Amount: 00000-500.25 = -500.25 I’ve tried the editc with the ‘X’ edit code but i need the negative sign. [...]
Answer Question
| December 4, 2010 5:11 PM
AS/400, AS/400 numeric fields, Numeric conversion, V5R4
RPG Free Array Processing Problem
If you’ve seen this question before it’s because when I add my code and submit and view it, it is unreadable. I’m trying to get a “clean” representation of my question. Thanks for your patience. I have loaded a data structure from a database file with three 3 byte fields, i.e. 100101102. It loads into [...]
Answer Question
| December 4, 2010 3:21 PM
iSeries, RPG arrays, RPG ILE, V5R4
If you’ve seen this question before it’s because when I add my code and submit and view it, it is unreadable. I’m trying to get a “clean” representation of my question. Thanks for your patience. I have loaded a data structure from a database file with three 3 byte fields, i.e. 100101102. It loads into [...]
Answer Question
| December 4, 2010 3:21 PM
iSeries, RPG arrays, RPG ILE, V5R4
Retrieve the file names in IFS folder to a physical file
I got one scenario, in that I need to retrieve the file names including the Dates from IFS folder to a Physical File. From that PF, I need to delete the files older than 15 days. Is there any way to do that? Thanks Saravanan
Answer Question
| December 21, 2010 8:59 AM
IFS, IFS Directory, IFS Folder, Physical Files, V5R4
I got one scenario, in that I need to retrieve the file names including the Dates from IFS folder to a Physical File. From that PF, I need to delete the files older than 15 days. Is there any way to do that? Thanks Saravanan
Answer Question
| December 21, 2010 8:59 AM
IFS, IFS Directory, IFS Folder, Physical Files, V5R4
RPG Free Array Processing
I am loading a DS from a database file into an array nine length with three elements, i.e. 100101102. I want to increment the array to load each element one at a time and save it to a standalone variable ( 3 bytes long). In another forum, someone said the receiver must be a %subarr [...]
Answer Question
| December 7, 2010 3:28 PM
iSeries, RPG arrays, RPG ILE, V5R4
I am loading a DS from a database file into an array nine length with three elements, i.e. 100101102. I want to increment the array to load each element one at a time and save it to a standalone variable ( 3 bytes long). In another forum, someone said the receiver must be a %subarr [...]
Answer Question
| December 7, 2010 3:28 PM
iSeries, RPG arrays, RPG ILE, V5R4
Deleting unmatched records from a file in iseries SQL
I’m trying to delete unmatched records from file A based on file B. The files are matched by ListNo. Code: DELETE FROM DVMURRAY/INSRP100 WHERE SHListNo = ALL ( SELECT SHListNo FROM DVMURRAY/INSRP100 Left Outer Join DVMURRAY/INSRP200 on SHListNo = SDListNo WHERE SDListNo is Null ) Row not found for DELETE. [...]
Answer Question
| November 24, 2010 5:31 PM
iSeries SQL, iseries v5r4, RPGSQL, SQL, V5R4
I’m trying to delete unmatched records from file A based on file B. The files are matched by ListNo. Code: DELETE FROM DVMURRAY/INSRP100 WHERE SHListNo = ALL ( SELECT SHListNo FROM DVMURRAY/INSRP100 Left Outer Join DVMURRAY/INSRP200 on SHListNo = SDListNo WHERE SDListNo is Null ) Row not found for DELETE. [...]
Answer Question
| November 24, 2010 5:31 PM
iSeries SQL, iseries v5r4, RPGSQL, SQL, V5R4
RPG /Free Local Data Area definitions
I am trying to define the LDA with an external definition in RPG /free. Any help?
Answer Question
| December 1, 2010 3:11 PM
ILE RPG, iSeries, RPGLE, V5R4
I am trying to define the LDA with an external definition in RPG /free. Any help?
Answer Question
| December 1, 2010 3:11 PM
ILE RPG, iSeries, RPGLE, V5R4
T-SQL with Recursion – Display top ID on all levels below (To: Kent Milligan)
Hell Kent, I read through “V5R4 SQL Packs a Punch” http://www-03.ibm.com/systems/resources/systems_i_software_db2_pdf_rcte_olap.pdf I would need the query in figure 20 and the result in figure 21 which do not show up in the article. I have a query similar to the example (parts of an iSeries Power5 server) that shows all the levels correctly, however, [...]
Answer Question
| November 29, 2010 1:36 PM
Recursion, SQL Query, T-SQL, V5R4
Hell Kent, I read through “V5R4 SQL Packs a Punch” http://www-03.ibm.com/systems/resources/systems_i_software_db2_pdf_rcte_olap.pdf I would need the query in figure 20 and the result in figure 21 which do not show up in the article. I have a query similar to the example (parts of an iSeries Power5 server) that shows all the levels correctly, however, [...]
Answer Question
| November 29, 2010 1:36 PM
Recursion, SQL Query, T-SQL, V5R4
Get AS/400 FTP session to echo back data and time
Frequently our AS/400 sends data to our bank via FTP. The bank returns a 220 welcome message in the FTP log which includes the time. We would like to also see the date from the bank’s UNIX computer recorded in our log. I’ve tried a couple of things in our FTP script but the commands [...]
Answer Question
| November 15, 2010 6:42 PM
AS/400, AS/400 FTP, FTP, V5R4
Frequently our AS/400 sends data to our bank via FTP. The bank returns a 220 welcome message in the FTP log which includes the time. We would like to also see the date from the bank’s UNIX computer recorded in our log. I’ve tried a couple of things in our FTP script but the commands [...]
Answer Question
| November 15, 2010 6:42 PM
AS/400, AS/400 FTP, FTP, V5R4
Retrieve AS/400 Printer definition
I would like to let my users override the printed output to a printer of their choice but I need to protect them from themselves. Is there a way that I can determine if the name they enter is a valid print device? I would like to be able to do this in an RPG [...]
Answer Question
| November 9, 2010 8:28 PM
AS/400 print errors, AS/400 printing, AS400 printing issue, RPG Program, V5R4
I would like to let my users override the printed output to a printer of their choice but I need to protect them from themselves. Is there a way that I can determine if the name they enter is a valid print device? I would like to be able to do this in an RPG [...]
Answer Question
| November 9, 2010 8:28 PM
AS/400 print errors, AS/400 printing, AS400 printing issue, RPG Program, V5R4
iSeries Net Time
We are going through a PCI audit and it was suggested that we implement NET Time on the AS400. How do I do that?
Answer Question
| November 9, 2010 8:16 PM
AS/400, Auditing, iSeries, PCI, V5R4
We are going through a PCI audit and it was suggested that we implement NET Time on the AS400. How do I do that?
Answer Question
| November 9, 2010 8:16 PM
AS/400, Auditing, iSeries, PCI, V5R4
iSeries Syslogging
We are going through a PCI audit. It was recommended that we look into iSeries Syslogging. What is it and how do I do it?
Answer Question
| November 9, 2010 8:14 PM
AS/400, iSeries System Log, Syslog, V5R4
We are going through a PCI audit. It was recommended that we look into iSeries Syslogging. What is it and how do I do it?
Answer Question
| November 9, 2010 8:14 PM
AS/400, iSeries System Log, Syslog, V5R4
RPG and Service Programs
I’m getting into the “MVC pattern” experience of RPG programming, thanks to Scott Klement’s hints (see “A pattern for reusable code” on his site http://www.scottklement.com and “Binder Language and the Signature Debate” at http://systeminetwork.com/print/64029). After some initial difficulties, I have made an application based on a collection of procedures in a service program (SP) and [...]
Answer Question
| October 29, 2010 10:44 AM
AS/400, MVC pattern, OS/400, Service program, V5R4
I’m getting into the “MVC pattern” experience of RPG programming, thanks to Scott Klement’s hints (see “A pattern for reusable code” on his site http://www.scottklement.com and “Binder Language and the Signature Debate” at http://systeminetwork.com/print/64029). After some initial difficulties, I have made an application based on a collection of procedures in a service program (SP) and [...]
Answer Question
| October 29, 2010 10:44 AM
AS/400, MVC pattern, OS/400, Service program, V5R4
Sending iSeries spool files to a network printer
I have a problem whereby my network printer is printing multiple copies of a spool file I have sent to it – it just keeps churning them out. The printer in question is an OCE’ re-branded multi-function printer. I believe it’s a VL2822C VarioPrint machine. Has anyone used these to print from an iSeries system? [...]
Answer Question
| November 1, 2010 6:35 AM
iSeries networking, iSeries printer output, iSeries printing, Network printing, Print Spool File, V5R4
I have a problem whereby my network printer is printing multiple copies of a spool file I have sent to it – it just keeps churning them out. The printer in question is an OCE’ re-branded multi-function printer. I believe it’s a VL2822C VarioPrint machine. Has anyone used these to print from an iSeries system? [...]
Answer Question
| November 1, 2010 6:35 AM
iSeries networking, iSeries printer output, iSeries printing, Network printing, Print Spool File, V5R4
Map spool file data to overlay
Please excuse the length of the post but I am new here and not quite sure how to get across what I need. We have a spool file that we do not have source for, it’s from our financial application and cannot be changed. I need to take data from that spool file and place [...]
Answer Question
| February 16, 2011 12:51 AM
map spool data, OS/400, Spool files, V5R4
Please excuse the length of the post but I am new here and not quite sure how to get across what I need. We have a spool file that we do not have source for, it’s from our financial application and cannot be changed. I need to take data from that spool file and place [...]
Answer Question
| February 16, 2011 12:51 AM
map spool data, OS/400, Spool files, V5R4
