JDE with Robot/Schedule
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
iSeries, JDE
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
iSeries, JDE
Display the scheduler on iSeries system
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 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
Change the language for a user
How to change the language for user in iSeries?
Answer Question
| March 4, 2013 1:47 AM
AS/400, iSeries
How to change the language for user in iSeries?
Answer Question
| March 4, 2013 1:47 AM
AS/400, iSeries
QBatch subsystem Monitoring
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, 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
Replace failed disk
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
iSeries, RAID
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
iSeries, RAID
Twinax to LAN
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
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
AS/400 Query – how do you split names in field into seperate fields
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
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
iSeries-client access
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
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
SAVSECDTA authorization list
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
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
About an OPCODE EVAL-CORR
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
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
FTP from AS/400 to PC procedure
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
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
iSeries printing
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
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
QTEMP file not removed
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
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
New record can not be added
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
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
iSeries query: Compare two fields in one file
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
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
Determine if a submitted job has completed
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
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
WRKOUTQ CMD key F20
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
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
User space size
Hi, is the size of user space auto resizable? I tested creating a user space with the initial length to 1 QUSCRTUS(userSpace, /* User space name and library */ “temporal “, /* Extended attribute (QUSLOBJ) */ 1, /* Size of the user space */ &spaceInit, /* Space initialization */ “*ALL “, /* Public authority to [...]
Answer Question
| January 9, 2013 4:38 PM
AS/400, iSeries, QUSCRTUS
Hi, is the size of user space auto resizable? I tested creating a user space with the initial length to 1 QUSCRTUS(userSpace, /* User space name and library */ “temporal “, /* Extended attribute (QUSLOBJ) */ 1, /* Size of the user space */ &spaceInit, /* Space initialization */ “*ALL “, /* Public authority to [...]
Answer Question
| January 9, 2013 4:38 PM
AS/400, iSeries, QUSCRTUS
Object use
Is there a way to identify who is using any type of object (example a DSPF, PGM, FILE) even though the object is not locked or journaled ?
Answer Question
| January 8, 2013 5:17 PM
AS/400 V6r1m0, iSeries
Is there a way to identify who is using any type of object (example a DSPF, PGM, FILE) even though the object is not locked or journaled ?
Answer Question
| January 8, 2013 5:17 PM
AS/400 V6r1m0, iSeries
rslvsp function returns null
Documentation for rslvsp points: “A null pointer value means the object was found in a machine context.” But I verified that my user space was created successsful rslvsp(_Usrspc,”userspace”, “QTEMP”, _AUTH_ALL) If it is found in machine context, how can I resolve to it (Have a pointer to the user space)? if is not in a [...]
Answer Question
| December 21, 2012 9:41 PM
API, iSeries, rslvsp function, V6R1
Documentation for rslvsp points: “A null pointer value means the object was found in a machine context.” But I verified that my user space was created successsful rslvsp(_Usrspc,”userspace”, “QTEMP”, _AUTH_ALL) If it is found in machine context, how can I resolve to it (Have a pointer to the user space)? if is not in a [...]
Answer Question
| December 21, 2012 9:41 PM
API, iSeries, rslvsp function, V6R1
