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
DEWQ status jobs!
How can we kill the jobs those are in DEWQ status? Is there any system parameter in AS/400 using that we can kill those statuses jobs after a specific time frame automatically?
Answer Question
| March 5, 2013 12:10 PM
AS/400, AS/400 jobs
How can we kill the jobs those are in DEWQ status? Is there any system parameter in AS/400 using that we can kill those statuses jobs after a specific time frame automatically?
Answer Question
| March 5, 2013 12:10 PM
AS/400, AS/400 jobs
How to write a CL program if SQL query is giving some record
Hi, How can a CL program can be written based on some SQL query which gives some records. If SQL query is giving some records as output then using SNDEMLMSG command, how can that CL program be written? SNDEMLMSG command will send an email to specific user based on SQL query’s output if any thing [...]
Answer Question
| March 4, 2013 2:08 PM
CL programs, SQL Query
Hi, How can a CL program can be written based on some SQL query which gives some records. If SQL query is giving some records as output then using SNDEMLMSG command, how can that CL program be written? SNDEMLMSG command will send an email to specific user based on SQL query’s output if any thing [...]
Answer Question
| March 4, 2013 2:08 PM
CL programs, SQL Query
AS/400
Please help me answer the sample question : What will be the value of IZ during the execution of the following code, when statement 09.0 is reached? (Field length 30 implies 3 byte numeric – 0 decimal). 01.0 C Z-ADD 100 IY 30 02.0 C Z-ADD 0 IZ 30 03.0 *——————————– 04.0 C IY DOULT [...]
Answer Question
| March 4, 2013 6:28 AM
AS/400, AS/400 - CL Command
Please help me answer the sample question : What will be the value of IZ during the execution of the following code, when statement 09.0 is reached? (Field length 30 implies 3 byte numeric – 0 decimal). 01.0 C Z-ADD 100 IY 30 02.0 C Z-ADD 0 IZ 30 03.0 *——————————– 04.0 C IY DOULT [...]
Answer Question
| March 4, 2013 6:28 AM
AS/400, AS/400 - CL Command
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
RPG / free command to movel 6 digit field to 8 character field
I am using RPG /free — I need to move a 6 digit numeric field to 8 character field and it needs to be left justified. How can I do this?
Answer Question
| March 1, 2013 3:58 PM
RPG, RPG field
I am using RPG /free — I need to move a 6 digit numeric field to 8 character field and it needs to be left justified. How can I do this?
Answer Question
| March 1, 2013 3:58 PM
RPG, RPG field
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
Using 2 different display sizes in a display file
I am trying to create a display file in which the subfile uses display size 27 132 and a window uses the display size of 24 80. I thought I could declare them both in the dspsiz as DSPSIZ(27 132 *DS4 - 24 80 *DS3) and use dspmod(*ds4) after the SFLPAG command and DSPMOD(*ds3) on [...]
Answer Question
| March 1, 2013 2:24 AM
AS/400, RPG, RPGLE
I am trying to create a display file in which the subfile uses display size 27 132 and a window uses the display size of 24 80. I thought I could declare them both in the dspsiz as DSPSIZ(27 132 *DS4 - 24 80 *DS3) and use dspmod(*ds4) after the SFLPAG command and DSPMOD(*ds3) on [...]
Answer Question
| March 1, 2013 2:24 AM
AS/400, RPG, RPGLE
Constant variable in SQL cursor
select gthamcode as hamcode, gtnumber as item, ‘G’ from testlib/gtinl01 where (gtnumber between 08000000000000 and 08999999999999) union all select modkey as hamcode, modndcnum as item, ‘M’ from testlib/hammodel where (modndcnum between 08000000000 and 08999999999) This works with interactive SQL but I need to use this in an COBOL embbeded SQL cursor. The ’M’ and ’G’ are constants [...]
Answer Question
| February 28, 2013 7:23 PM
AS/400, SQL Cursors
select gthamcode as hamcode, gtnumber as item, ‘G’ from testlib/gtinl01 where (gtnumber between 08000000000000 and 08999999999999) union all select modkey as hamcode, modndcnum as item, ‘M’ from testlib/hammodel where (modndcnum between 08000000000 and 08999999999) This works with interactive SQL but I need to use this in an COBOL embbeded SQL cursor. The ’M’ and ’G’ are constants [...]
Answer Question
| February 28, 2013 7:23 PM
AS/400, SQL Cursors
Synon related: Searching calling program in Synon (PRTFIL).
How can be search external program (outside Synon) which is calling print file function (PRTFIL). Actually, I know to search all function which are calling print file by the option 91 or take U at subfile selector or 95 at object usage screen but that approach can only work to identify internal function. Do you [...]
Answer Question
| February 28, 2013 12:36 PM
AS/400 Synon, Synon
How can be search external program (outside Synon) which is calling print file function (PRTFIL). Actually, I know to search all function which are calling print file by the option 91 or take U at subfile selector or 95 at object usage screen but that approach can only work to identify internal function. Do you [...]
Answer Question
| February 28, 2013 12:36 PM
AS/400 Synon, Synon
Reading XML file from RPGLE program by using XML-INTO opcode
How can I move data from XML to Data structure if data is more than 9999 in XML? The problem is I can declare the data structure with array max size 9999 where as using XML-INTO (ex: XML-INTO OrderList %XML(‘/home/orderlist.xml’) : ‘ doc=file case=any’) ). I can load first 9999 set of data but then [...]
Answer Question
| February 28, 2013 9:53 AM
AS/400, RPGLE, XML
How can I move data from XML to Data structure if data is more than 9999 in XML? The problem is I can declare the data structure with array max size 9999 where as using XML-INTO (ex: XML-INTO OrderList %XML(‘/home/orderlist.xml’) : ‘ doc=file case=any’) ). I can load first 9999 set of data but then [...]
Answer Question
| February 28, 2013 9:53 AM
AS/400, RPGLE, XML
Creating physical files
What command would I use to create a physical file?
Answer Question
| February 28, 2013 9:36 PM
AS/400, Physical File
What command would I use to create a physical file?
Answer Question
| February 28, 2013 9:36 PM
AS/400, Physical File
Printing from AS/400 to Canon iR3235
Hi, I am having problems printing from AS/400 running v5r4 to a Canon iR3235. Prints seem to be coming off out of order. But only happening half way through each batch of around 100 prints. The first half is fine, but then all comes off wrong. IBM have recommended setting up printer over LPR and using [...]
Answer Question
| February 27, 2013 3:36 PM
AS/400, Canon
Hi, I am having problems printing from AS/400 running v5r4 to a Canon iR3235. Prints seem to be coming off out of order. But only happening half way through each batch of around 100 prints. The first half is fine, but then all comes off wrong. IBM have recommended setting up printer over LPR and using [...]
Answer Question
| February 27, 2013 3:36 PM
AS/400, Canon
Block access of Operational ASSIST Menu
Hi ! How can I block the users for the use of Operational Assistance Menu(Esc Key)?
Answer Question
| February 27, 2013 6:03 AM
AS/400, AS/400 Menus
Hi ! How can I block the users for the use of Operational Assistance Menu(Esc Key)?
Answer Question
| February 27, 2013 6:03 AM
AS/400, AS/400 Menus
About EVAL-CORR opcode
Could any one let me know what is the use of this EVAL-CORR opcode with a sample program
Answer Question
| February 27, 2013 4:27 AM
AS/400, EVAL-CORR
Could any one let me know what is the use of this EVAL-CORR opcode with a sample program
Answer Question
| February 27, 2013 4:27 AM
AS/400, EVAL-CORR
How to easily perform date conversions in RPGLE (Including Substringing!)
Over the years I have had to modify my fair share of outdated code, especially when it comes to Date Conversions. Not every system uses an 8 position numeric date field. The place I’m currently at still has a number of files with a 6 position numeric date field. I was wondering if anyone else [...]
Answer Question
| February 26, 2013 5:30 PM
RPG, RPGIV, RPGLE
Over the years I have had to modify my fair share of outdated code, especially when it comes to Date Conversions. Not every system uses an 8 position numeric date field. The place I’m currently at still has a number of files with a 6 position numeric date field. I was wondering if anyone else [...]
Answer Question
| February 26, 2013 5:30 PM
RPG, RPGIV, RPGLE
Subfile with scroll bar.
I’m creating a simple program for subfile with scroll bar. I am able to see the scroll bar in the display file but the scroll bar is not working. It isn’t scrolling up or scrolling down. Please suggest what can be the solution.
Answer Question
| February 26, 2013 7:52 AM
AS/400, AS/400 Subfiles
I’m creating a simple program for subfile with scroll bar. I am able to see the scroll bar in the display file but the scroll bar is not working. It isn’t scrolling up or scrolling down. Please suggest what can be the solution.
Answer Question
| February 26, 2013 7:52 AM
AS/400, AS/400 Subfiles
Error in position while printing variable
I have a variable xyz as7P 2.This variable is defined in a file. I am using this in my program to be populated on printed on report defined in O spec. Problem is – I am just using edit code ‘L’ and mentioned ending position as 71. but when printed or spooled, it’s being generated [...]
Answer Question
| February 26, 2013 6:00 AM
AS/400, AS/400 Printer File
I have a variable xyz as7P 2.This variable is defined in a file. I am using this in my program to be populated on printed on report defined in O spec. Problem is – I am just using edit code ‘L’ and mentioned ending position as 71. but when printed or spooled, it’s being generated [...]
Answer Question
| February 26, 2013 6:00 AM
AS/400, AS/400 Printer File
