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
Hi All, Our new E1 interface to Robot seems to have created an issue where previous EDI react jobs are not finishing in the OS and so Robot Schedule continues to think they are still running. After looking at the job log for the hung job I noticed it only created a data queue in [...]
Answer Question | March 7, 2013 4:00 PM
How can I remove access to WRKJOBSCDE,CHGJOBSCDE, ADDJOBSCDE and leave a user with access to a browse command?
Answer Question | March 5, 2013 4:24 PM
AS/400, iSeries, iSeries Access
How to change the language for user in iSeries?
Answer Question | March 4, 2013 1:47 AM
Hi Guys, I have requirements, I need the Job details like( Job Number, name , user) of any job as soon as they entered in Qbatch Subsystem. Do we have any API or some commands to fetch that… The only solution i m thinking is of take the *Print of WRKACTJOB command for QBATCH every [...]
Answer Question | March 1, 2013 8:01 PM
AS/400, CLLE, iSeries, iSeries AS/400, QBATCH, RPGLE, Subsystems
Hi guys, need your help once more. I need to replace a failed disk (RAID 5). I’m not shore how to do it, should I use navigator or DST? Need to stop RAID first? I already have the document with the steps to rebuild data on the new disk, just don’t know what to do [...]
Answer Question | March 1, 2013 1:16 PM
Hi there experts, in need of your help once more. I have an old 800, which has been turned off a long time ago. Now, I can´t get to operations console because, I believe, the console configured is Twinax. How can I force the system to LAN console? Thank you very much.
Answer Question | March 1, 2013 1:04 PM
iSeries, LAN, twinax
Trying to separate a field into three separate fields. The field is a name field, with lastname firstname mi with spaces in between each name. Is there a way to do this? I’ve tried everything I can think of, am out of ideas. Thanks in advance for your help
Answer Question | February 22, 2013 3:56 PM
AS/400, AS/400 Query, iSeries
I am running 5250 emulation on a PC. It was running fine until today because now I receive an error remote address could not be resolved.
Answer Question | February 11, 2013 8:53 PM
5250 emulation, iSeries
When restoring SAVSECDTA (240 user profiles) on iSeries, 220 profiles restored and 20 authorization lists were restored. This obviously equals my total number of saved profiles but I don’t see the total number of profiles on the restored system. Any idea why this is happening?
Answer Question | February 11, 2013 2:18 PM
AS/400, iSeries, SAVSECDTA
I would like to have sample code on the OPCODE LIKEREC with all its parameters like with *All and *KEY and *INPUT and *OUTPUT. Also, I want to know whether OPCODE EVAL-CORR in iSeries or not because when I want to transfer data from one DS (Data Structure) to another DS using EVAL-CORR, I’m getting [...]
Answer Question | February 8, 2013 4:27 AM
Data structures, iSeries
in Windows, Start, Programs, Accessories, Command prompt, type: ftp your_system_name press enter, type: your_userid press enter, type: your_password press enter, type: get your_library/your_filename C:your_folderyour_filename.csv or .txt press enter, type: quit, done!
Answer Question | February 6, 2013 8:20 PM
AS/400, FTP, iSeries
I am sending print file using a output queue setup to a zebra printer but when looking at the status of the print file on the AS/400, it showing in the status filed a 1*. This is causing the printer to print two copies of the same print file. What could be causing this? Could [...]
Answer Question | February 5, 2013 4:40 PM
iSeries, iSeries printing
In my CLP I created a file in QTEMP using CRTDUPOBJ. I then use this file in a few CL programs and a couple of RPG programs. Also, in OPNQRYF in the CL programs. At the end of the job stream my file is not removed. I have used QTEMP before without a problem; I’m [...]
Answer Question | January 31, 2013 1:23 PM
AS/400, iSeries, QTEMP
We a have ticketing system application but it has stop adding new records. No new message to expand files. Does anyone have any help?
Answer Question | January 31, 2013 12:30 AM
iSeries, Norwat system
Try to do a multiple select statement and then compare the results of that statement. See below: SELECT “T16.APAR”.P._PARCEL_NR FROM QS36F.”T16.APAR” WHERE “T16.APAR”.P_PARCEL_NR NE “T16.APAR”.P_PARCEL_NR (SELECT “T16.APAR”.P_PARCEL_NR FROM QS36F.”T16.APAR” AS “T16.APAR” WHERE “T16.APAR”.P_YEAR = 2012 AND “T16.APAR”.P_ROLL_TYPE = ‘R’ AND “T16.APAR”.P_EXCLUSION_VALUE > 1; (SELECT “T16.APAR”.P_PARCEL_NR FROM QS36F.”T16.APAR” AS “T16.APAR” WHERE “T16.APAR”.P_YEAR = 2013 AND “T16.APAR”.P_ROLL_TYPE [...]
Answer Question | January 21, 2013 3:11 PM
AS/400, AS/400 queries, iSeries
Hello ALL — I have a CL program that executes a command which calls a CL utility program. The utility program submits a job that involves the building of a save file. The original CL program will then restore the contents of the save file into a library and obviously must wait until the submitted [...]
Answer Question | January 18, 2013 3:56 PM
CL Program, iSeries, QUSRJOBI
A user has a menu option to display an output queue. When I hit F20 in this option, it displays the Work with All writers screen. When she hits F20 it displays the work with printers screen (like F22 also does). She confirmed that the same thing occurs on different PCs. She also checked the [...]
Answer Question | January 10, 2013 5:48 PM
AS/400, iSeries, WRKOUTQ