AS/400 transfer to iSeries
How can I transfer a report from AS/400 to iSeries?
Answer Question
| June 3, 2013 3:28 PM
AS/400, AS/400 Reports, iSeries
How can I transfer a report from AS/400 to iSeries?
Answer Question
| June 3, 2013 3:28 PM
AS/400, AS/400 Reports, iSeries
From mirror to RAID
Hi there folks, A client’s system has disks with mirror protection. The goal is to stop the mirror protection and start RAID5 with hot spare. I’m going to enter DST, stopr mirror and then start RAID with hot spare. Do I need anything else? Thank you all for your help.
Answer Question
| June 3, 2013 10:25 AM
iSeries, RAID, RAID 5
Hi there folks, A client’s system has disks with mirror protection. The goal is to stop the mirror protection and start RAID5 with hot spare. I’m going to enter DST, stopr mirror and then start RAID with hot spare. Do I need anything else? Thank you all for your help.
Answer Question
| June 3, 2013 10:25 AM
iSeries, RAID, RAID 5
iSeries library restore error
I have two iSeries machines both running v6r1. One is our production box (Model – E4A w/internal tape drive) and the other is a cold backup (Model 520 with external Transberg 3503-lto 4 tape drive). I am trying to restore libraries from our production box to the backup. I can browse the the tape data [...]
Answer Question
| May 28, 2013 1:51 PM
AS/400, AS/400 backup, iSeries
I have two iSeries machines both running v6r1. One is our production box (Model – E4A w/internal tape drive) and the other is a cold backup (Model 520 with external Transberg 3503-lto 4 tape drive). I am trying to restore libraries from our production box to the backup. I can browse the the tape data [...]
Answer Question
| May 28, 2013 1:51 PM
AS/400, AS/400 backup, iSeries
Creation and dump of a user space iSeries
Hi all, I’m trying to recreate an old user space with the next code: QUSCRTUS(qname, "LSTOBJS ", 64000, "", "*EXCLUDE ", "Text decription ", "*YES ", &zero, "*USER " , 16 , optimum ) When I dump the old one there is a -extended data- section but that section does not exist in the dump [...]
Answer Question
| May 17, 2013 5:03 PM
AS/400, iSeries
Hi all, I’m trying to recreate an old user space with the next code: QUSCRTUS(qname, "LSTOBJS ", 64000, "", "*EXCLUDE ", "Text decription ", "*YES ", &zero, "*USER " , 16 , optimum ) When I dump the old one there is a -extended data- section but that section does not exist in the dump [...]
Answer Question
| May 17, 2013 5:03 PM
AS/400, iSeries
Transferring data between iseries without using DDM/FTP
Is there any better way of transferring data between iSeries without using DDM/FTP?
Answer Question
| May 16, 2013 1:04 PM
DDM, iSeries
Is there any better way of transferring data between iSeries without using DDM/FTP?
Answer Question
| May 16, 2013 1:04 PM
DDM, iSeries
Dynamic operator on WHERE statement
I have a file that has 2-fields that will be used to select records from file B. File A, field 1 = date_a & field 2 = Operator. I want to select records from File B and based on the value within the operator ( EQ, LT, LE, GT, GE) and the date_a. Ex: If [...]
Answer Question
| May 16, 2013 9:54 PM
iSeries, SQLRPGLE
I have a file that has 2-fields that will be used to select records from file B. File A, field 1 = date_a & field 2 = Operator. I want to select records from File B and based on the value within the operator ( EQ, LT, LE, GT, GE) and the date_a. Ex: If [...]
Answer Question
| May 16, 2013 9:54 PM
iSeries, SQLRPGLE
How to run JSP with Tomcat on OS/400 V6R1
I’m replacing an iSeries by an I5 V6r1 but it appears that I cannot use Tomcat any longer to run JSP applications. What should I do?
Answer Question
| May 14, 2013 4:03 PM
iSeries, OS/400, Tomcat
I’m replacing an iSeries by an I5 V6r1 but it appears that I cannot use Tomcat any longer to run JSP applications. What should I do?
Answer Question
| May 14, 2013 4:03 PM
iSeries, OS/400, Tomcat
Regarding iSeries journaling
Can we copy the journals in iSeries from one library to other library?
Answer Question
| May 8, 2013 6:39 AM
iSeries, iSeries Journalling
Can we copy the journals in iSeries from one library to other library?
Answer Question
| May 8, 2013 6:39 AM
iSeries, iSeries Journalling
Upgrade/migrate from 720 v4r5 to i5 520 v5r4
Can a SAVLIB on a 720 v4r5 and a RSTLIB on an I5 520 v5r4 be accomplished, or do we have to upgrade to v5r2 and then to v5r4?
Answer Question
| May 7, 2013 3:25 PM
AS/400, iSeries, RSTLIB, SAVLIB
Can a SAVLIB on a 720 v4r5 and a RSTLIB on an I5 520 v5r4 be accomplished, or do we have to upgrade to v5r2 and then to v5r4?
Answer Question
| May 7, 2013 3:25 PM
AS/400, iSeries, RSTLIB, SAVLIB
Transferring data from iSeries V5R4 to Windows 7 PC
We are getting an error message (sys3827) when we try to transfer data from an RPG2 program on an iSeries 800 running V5R4 to a Windows 7 (64bit) PC running iSeries Access V6R1 (data to be used by Filemaker Pro 11). Any suggestions?
Answer Question
| May 2, 2013 5:31 PM
iSeries, RPG Program, Windows 7
We are getting an error message (sys3827) when we try to transfer data from an RPG2 program on an iSeries 800 running V5R4 to a Windows 7 (64bit) PC running iSeries Access V6R1 (data to be used by Filemaker Pro 11). Any suggestions?
Answer Question
| May 2, 2013 5:31 PM
iSeries, RPG Program, Windows 7
AS/400
Hello, Does anyone know how to step into and through the code in the macro customization window of AS/400? Thank you, Carissa
Answer Question
| April 30, 2013 8:50 PM
AS/400, AS/400 macros, iSeries
Hello, Does anyone know how to step into and through the code in the macro customization window of AS/400? Thank you, Carissa
Answer Question
| April 30, 2013 8:50 PM
AS/400, AS/400 macros, iSeries
iSeries WorkStation v5.9 on Surface Pro
I’m not an IT guy, just a frustrated Outside Sales Rep. I recently BYOD a Surface Pro for work. A HUGE improvement over the 15″ 6# monster I had before. The company that handles our AS/400 iSeries Access had issues installing it on my Surface Pro. They rolled back the graphics driver to Intel HD3000, [...]
Answer Question
| April 26, 2013 8:50 PM
AS/400, iSeries, Surface Pro
I’m not an IT guy, just a frustrated Outside Sales Rep. I recently BYOD a Surface Pro for work. A HUGE improvement over the 15″ 6# monster I had before. The company that handles our AS/400 iSeries Access had issues installing it on my Surface Pro. They rolled back the graphics driver to Intel HD3000, [...]
Answer Question
| April 26, 2013 8:50 PM
AS/400, iSeries, Surface Pro
WRKQRY query
In WRKQRY, while selecting the collating sequence, what is option 2-Query for iSeries English? I am trying to learn the options in WRKQRY and came across this. F1 help details are not digesting. Please help.
Answer Question
| April 23, 2013 10:44 AM
AS/400, iSeries, WRKQRY
In WRKQRY, while selecting the collating sequence, what is option 2-Query for iSeries English? I am trying to learn the options in WRKQRY and came across this. F1 help details are not digesting. Please help.
Answer Question
| April 23, 2013 10:44 AM
AS/400, iSeries, WRKQRY
iSeries native job scheduler -QJOBSCD
I had heard that the job QJOBSCD is related to native job scheduler and it is responsible for the job submission to JOBQ but when I had given command WRKACTJOB JOB(QJOBSCD), I could not find the job. It’s still active and the job scheduler is working fine.
Answer Question
| April 22, 2013 1:41 PM
AS/400, AS/400 jobs, iSeries
I had heard that the job QJOBSCD is related to native job scheduler and it is responsible for the job submission to JOBQ but when I had given command WRKACTJOB JOB(QJOBSCD), I could not find the job. It’s still active and the job scheduler is working fine.
Answer Question
| April 22, 2013 1:41 PM
AS/400, AS/400 jobs, iSeries
SFTP
I need to transfer a file using SFTP. It’s a PF with a 180 character field. When I try the put command from an iSeries library, the file goes over as binary. If I copy it to the IFS and transfer from there, it goes over as text. But, I cannot have this unencrypted file [...]
Answer Question
| April 22, 2013 12:36 AM
ASCII, iSeries, SFTP
I need to transfer a file using SFTP. It’s a PF with a 180 character field. When I try the put command from an iSeries library, the file goes over as binary. If I copy it to the IFS and transfer from there, it goes over as text. But, I cannot have this unencrypted file [...]
Answer Question
| April 22, 2013 12:36 AM
ASCII, iSeries, SFTP
Is there a way to backup iseries partition without using a tape
I am using zipseries to backup libraries one by one >> Is there a way to backup the whole iSeries partition without using a tape device? That is to take a backup on PC or laptop. We have IBM 9406-520…is there a way to backup the whole server to a laptop?
Answer Question
| April 15, 2013 3:29 PM
Backup & recovery, IBM Servers, iSeries
I am using zipseries to backup libraries one by one >> Is there a way to backup the whole iSeries partition without using a tape device? That is to take a backup on PC or laptop. We have IBM 9406-520…is there a way to backup the whole server to a laptop?
Answer Question
| April 15, 2013 3:29 PM
Backup & recovery, IBM Servers, iSeries
Spool file info
I need to capture spool file information from a job within that job. I can get most of the info from using RTVJOBA but how do I get the file number?
Answer Question
| April 4, 2013 1:58 PM
iSeries, Spool file
I need to capture spool file information from a job within that job. I can get most of the info from using RTVJOBA but how do I get the file number?
Answer Question
| April 4, 2013 1:58 PM
iSeries, Spool file
How to read MS SQL tables using iSeries RPG
Has anyone found a technique for reading data directly from MS SQL using an iSeries RPG program?
Answer Question
| April 4, 2013 9:27 PM
iSeries, RPG Program, SQL 2008
Has anyone found a technique for reading data directly from MS SQL using an iSeries RPG program?
Answer Question
| April 4, 2013 9:27 PM
iSeries, RPG Program, SQL 2008
iSeries SQL Cobol
In my COBOL SQL select statement that was previously running on V5R4, I was able to extract a date field defined with “date” as the data type. We are now on V7R1 and we get a data mapping error. No clue as to why? Any ideas? thanks
Answer Question
| April 2, 2013 6:59 PM
COBOL, iSeries, SQL statement
In my COBOL SQL select statement that was previously running on V5R4, I was able to extract a date field defined with “date” as the data type. We are now on V7R1 and we get a data mapping error. No clue as to why? Any ideas? thanks
Answer Question
| April 2, 2013 6:59 PM
COBOL, iSeries, SQL statement
Sending Japanese characters from Websphere Message Broker to iSeries
We have a requirement to send data from WebSphere Message Broker to an iSeries via MQ. The message triggers a call to an RPGILE program which will process the message and write the data out to JD Edwards database files. The messages on the broker are encoded as CCSID 1208. The iSeries OS has a [...]
Answer Question
| March 28, 2013 4:37 PM
CCSID, iSeries, WebSphere
We have a requirement to send data from WebSphere Message Broker to an iSeries via MQ. The message triggers a call to an RPGILE program which will process the message and write the data out to JD Edwards database files. The messages on the broker are encoded as CCSID 1208. The iSeries OS has a [...]
Answer Question
| March 28, 2013 4:37 PM
CCSID, iSeries, WebSphere
