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
Canon ImageRUNNER on iSeries printing to specific mailboxes
We have connected a Canon ImageRUNNER to our iSeries via the network. I have created a Workstation Customization Object to send reports to a specific mailbox and can’t get the PJL code to work. I know the system is recognizing the Workstation Customization Object because I can get it to switch drawers but I can’t [...]
Answer Question
| March 25, 2013 4:07 PM
Canon ImageRUNNER, iSeries
We have connected a Canon ImageRUNNER to our iSeries via the network. I have created a Workstation Customization Object to send reports to a specific mailbox and can’t get the PJL code to work. I know the system is recognizing the Workstation Customization Object because I can get it to switch drawers but I can’t [...]
Answer Question
| March 25, 2013 4:07 PM
Canon ImageRUNNER, iSeries
Getting DB2 data into SQL 2008 database
We have a web service for placing orders and sending them to our iSeries. Basically front ending the EDI package on the iSeries. If the data is sent over without errors on the SQL insert to the DB2 databases the job runs. If there are run time errors during order processing the errors are logged [...]
Answer Question
| March 20, 2013 7:59 PM
AS/400, DB2, iSeries, SQL 2008
We have a web service for placing orders and sending them to our iSeries. Basically front ending the EDI package on the iSeries. If the data is sent over without errors on the SQL insert to the DB2 databases the job runs. If there are run time errors during order processing the errors are logged [...]
Answer Question
| March 20, 2013 7:59 PM
AS/400, DB2, iSeries, SQL 2008
Block Crystal Reports from iSeries access
We have a user who wants to use Crystal Reports to access data on an MS SQL server. She also has access to view limited data on the iSeries using an iSeries application with built-in security. How can we prevent her from accessing data on the iSeries using Crystal Reports. Is there a service we [...]
Answer Question
| March 11, 2013 12:37 AM
Crystal Reports, iSeries
We have a user who wants to use Crystal Reports to access data on an MS SQL server. She also has access to view limited data on the iSeries using an iSeries application with built-in security. How can we prevent her from accessing data on the iSeries using Crystal Reports. Is there a service we [...]
Answer Question
| March 11, 2013 12:37 AM
Crystal Reports, iSeries
