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
Is there any better way of transferring data between iSeries without using DDM/FTP?
Answer Question | May 16, 2013 1:04 PM
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
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
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 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
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
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
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
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
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 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 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 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
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
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
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 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 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 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