Determine who’s running the job
Hi All, I would like to know how can we trace who run the program (person/job/program) running under batch. My question may seem confusing but, I would like to trace who runs a program, what time it was executed and what triggers this. What I can only see is that this job is running under [...]
Answer Question
| June 15, 2012 1:03 AM
iSeries, iSeries data center, iSeries RPG programming
Hi All, I would like to know how can we trace who run the program (person/job/program) running under batch. My question may seem confusing but, I would like to trace who runs a program, what time it was executed and what triggers this. What I can only see is that this job is running under [...]
Performance Collection
Hi, If I want to create a report on daily performance, what I do is manual copy and paste to excel and generate the 8-5PM report with graph. I’ve been collecting the Total, Interactive and Batch CPU percentage for my daily report and this I can’t see on Ops Nav. Is there a way to [...]
Answer Question
| May 16, 2012 2:02 AM
iSeries, iSeries RPG programming
Hi, If I want to create a report on daily performance, what I do is manual copy and paste to excel and generate the 8-5PM report with graph. I’ve been collecting the Total, Interactive and Batch CPU percentage for my daily report and this I can’t see on Ops Nav. Is there a way to [...]
Display all objects with Public Authorities
Hi How do you display all objects with publich authority? Thank you
Answer Question
| April 2, 2012 2:21 AM
iSeries, iSeries data center, iSeries RPG programming
Hi How do you display all objects with publich authority? Thank you
RPG Object verification
Hi, I need to verify if a RPG object on our production AS/400 is the same as on our test box. I used to to look at object size, but it doesn’t always seem to be a consistent way to determine if two objects are the same. Any other way, to determine if two RPG [...]
Answer Question
| March 17, 2012 9:36 AM
AS/400, iSeries RPG programming, RPG
Hi, I need to verify if a RPG object on our production AS/400 is the same as on our test box. I used to to look at object size, but it doesn’t always seem to be a consistent way to determine if two objects are the same. Any other way, to determine if two RPG [...]
How to define a CLOB in SQLRPGLE Stored Procedure
Trying to use SQLRPGLE to create a Stored procedure. When I use a data type of CLOB (OUT: XMLDATA CLOB (64 K)) I get SQL0451 error (Attributes of parameter 9 not valid for procedure or function AVSESPLOAD in *N) Can anyone tell me what I should be doing. I need to define a 64K output [...]
Answer Question
| March 17, 2012 1:11 PM
iSeries RPG programming, iSeries V5R4MO
Trying to use SQLRPGLE to create a Stored procedure. When I use a data type of CLOB (OUT: XMLDATA CLOB (64 K)) I get SQL0451 error (Attributes of parameter 9 not valid for procedure or function AVSESPLOAD in *N) Can anyone tell me what I should be doing. I need to define a 64K output [...]
iSeries Tool
Hi, Is there a tool to automate transfer of source and objects from one iSeries to another? Is there a tool to compare two source codes from different iSeries box? Thank you
Answer Question
| March 17, 2012 9:57 AM
iSeries, iSeries application development tools, iSeries applications, iSeries data center, iSeries programming commands, iSeries RPG programming
Hi, Is there a tool to automate transfer of source and objects from one iSeries to another? Is there a tool to compare two source codes from different iSeries box? Thank you
How secure is the Electronic Service Agent
Since data is confidential on every iSeries, how would we know if the data sent to IBM is only about error and performance logs and no data is being sent to IBM servers? What profile is used to send this logs and does it have authority over data/user libraries? Thank you
Answer Question
| March 17, 2012 5:16 AM
iSeries, iSeries applications, iSeries data center, iSeries networking, iSeries RPG programming
Since data is confidential on every iSeries, how would we know if the data sent to IBM is only about error and performance logs and no data is being sent to IBM servers? What profile is used to send this logs and does it have authority over data/user libraries? Thank you
QLMTSECOFR
If the QLMTSECOFR value is set to 1=Explicit device access needed, can you authorize an IP address of a workstation to connect to iSeries via client access and log-in a user with *ALLOBJ, *SECOFR, *SECADM profile? Normally we do is to authorize a device name for users with above said profile for them to connect [...]
Answer Question
| March 19, 2012 8:48 AM
iSeries, iSeries applications, iSeries data center, iSeries RPG programming
If the QLMTSECOFR value is set to 1=Explicit device access needed, can you authorize an IP address of a workstation to connect to iSeries via client access and log-in a user with *ALLOBJ, *SECOFR, *SECADM profile? Normally we do is to authorize a device name for users with above said profile for them to connect [...]
iSeries RPG
Hello, Is it possible to create some kind of RPG sevice program that will reseide in the memory and await for a function key pressed while another program with its own DSPF is interacting with user? For example, user is intereacting with an input screen and secret functional key will allow a popup screen to [...]
Answer Question
| March 17, 2012 1:22 PM
AS400. RPG, iSeries RPG programming, RPGIV
Hello, Is it possible to create some kind of RPG sevice program that will reseide in the memory and await for a function key pressed while another program with its own DSPF is interacting with user? For example, user is intereacting with an input screen and secret functional key will allow a popup screen to [...]
QSECURITY
Hi, I would like to know if there is a security loophole on QSECURITY 30? What is the difference of QSECURITY 30 and 40? Thank you. JL
Answer Question
| March 19, 2012 8:03 AM
iSeries, iSeries applications, iSeries Cobol programming, iSeries data center, iSeries RPG programming
Hi, I would like to know if there is a security loophole on QSECURITY 30? What is the difference of QSECURITY 30 and 40? Thank you. JL
iSeries Default Password
Is there a way to block or prevent user from using default password on iSeries.
Answer Question
| March 31, 2012 5:13 AM
Default password, iSeries, iSeries data center, iSeries RPG programming
Is there a way to block or prevent user from using default password on iSeries.
Adding multiple library on User profile
What command is used to add multiple/several libraries on a single user profile? So that when the user logs to the system, only the listed library will be his default plus the global default (from system values). Thank you
Answer Question
| March 31, 2012 3:45 AM
iSeries, iSeries applications, iSeries data center, iSeries RPG programming
What command is used to add multiple/several libraries on a single user profile? So that when the user logs to the system, only the listed library will be his default plus the global default (from system values). Thank you
Help with AS/400 array
hi evryone, i’m a beginner with Java and i try this: try{ AS400Array txtarr =new AS400Array(AS400PackedDecimal(55,0),100); parmList[0] = new ProgramParameter(txtarr.toBytes(new BigDecimal(0)),55); ProgramCall pgm = new ProgramCall(sistem,”/qsys.lib/xxx.lib/….pgm”,parmList); in my RPG program i have this: D numcli s 55 0 dim(100) C parm numclie i need get this array from rpg, how can i make this happening, i [...]
Answer Question
| April 8, 2011 9:02 PM
AS/400, iSeries RPG programming, Java, Java classes, RPG ILE, RPG IV, V5R4
hi evryone, i’m a beginner with Java and i try this: try{ AS400Array txtarr =new AS400Array(AS400PackedDecimal(55,0),100); parmList[0] = new ProgramParameter(txtarr.toBytes(new BigDecimal(0)),55); ProgramCall pgm = new ProgramCall(sistem,”/qsys.lib/xxx.lib/….pgm”,parmList); in my RPG program i have this: D numcli s 55 0 dim(100) C parm numclie i need get this array from rpg, how can i make this happening, i [...]
how to convert RPG to document
Ihave a rpg program ,my requirement is how to copy all rpg program source code to micro soft word document,please give any camands or cl programs or rpg programs
Answer Question
| February 7, 2011 2:13 PM
AS/400, iSeries RPG programming, RPG Program
Ihave a rpg program ,my requirement is how to copy all rpg program source code to micro soft word document,please give any camands or cl programs or rpg programs
RPG Program Files in Update Mode
One RPG program P1 opens a file FILE1 in update mode and trailing program P2 opens the same file FILE1 again in update mode. Now P1 updates a particular record (say using CHAIN). Now P2 also want to update the same record (Say using CHAIN). will P2 recieve a new data or old data from [...]
Answer Question
| January 28, 2011 12:56 PM
AS/400, iSeries RPG programming, OS/400, RPG Program
One RPG program P1 opens a file FILE1 in update mode and trailing program P2 opens the same file FILE1 again in update mode. Now P1 updates a particular record (say using CHAIN). Now P2 also want to update the same record (Say using CHAIN). will P2 recieve a new data or old data from [...]
Print MICR code on iSeries AS/400
I have the micr code fonts resident on my AS400 V5R4 but I can’t figure out how to print micr code fonts for bank checks using XOAE13. How do you call the font from a Printer file DDS and is there anything unusual about the RPG program used to print checks? I can’t find any [...]
Answer Question
| January 26, 2011 10:08 PM
AS/400 printing, AS400 printing jobs, iSeries RPG programming, MICR, MICR code
I have the micr code fonts resident on my AS400 V5R4 but I can’t figure out how to print micr code fonts for bank checks using XOAE13. How do you call the font from a Printer file DDS and is there anything unusual about the RPG program used to print checks? I can’t find any [...]
Updating an IFS member in iSeries with RPGLE
Can an IFS member be updated thru an RPGLE program in the iseries?
Answer Question
| December 9, 2010 10:27 PM
IFS, iSeries, iSeries RPG programming, RPGLE
Can an IFS member be updated thru an RPGLE program in the iseries?
What happened in the IBM RPG market?
I was active in this market for 10 years, and attained a high degree of competency – cranking out business systems on behalf of mainly blue chip clients. But it all came to a stop in 2002. Was this a political matter, an outsourcing matter? Or a technology change matter (I am now open source [...]
Answer Question
| October 15, 2010 8:37 AM
AS/400 careers, iSeries RPG programming, Open IT Forum, Open source, OS/400, RPG market
I was active in this market for 10 years, and attained a high degree of competency – cranking out business systems on behalf of mainly blue chip clients. But it all came to a stop in 2002. Was this a political matter, an outsourcing matter? Or a technology change matter (I am now open source [...]
Data sent to device DSP01 not valid. Negative response code is 10050122.
Hello. My display file crashes as it can not display the hexadecimal values in my character field. Is there an easy way to replace these values (like scan) in my 79 character long field that has valid characters mixed with hexadecimal values? (Please no APIs) Thank you in advance. Regards Steven
Answer Question
| September 30, 2010 10:47 AM
Display File, DSP01, iSeries, iSeries RPG programming, RPG
Hello. My display file crashes as it can not display the hexadecimal values in my character field. Is there an easy way to replace these values (like scan) in my 79 character long field that has valid characters mixed with hexadecimal values? (Please no APIs) Thank you in advance. Regards Steven
iSeries SQL function in a SQL procedure – error: Function Name “in *LIBL type *N not found.”
A while back, Seeker1 posted this question. Unfortuantely, he didn’t provide enough information for Tom to help. Well – I have the same problem so hopefully, this will be enough. This Select statement generates the error: SELECT UNUNIT, ITRVEHLOC(UNUNIT , 'CITY ') FROM Units Here are the supporting commands and code: Create Function ITRVEHLOC( UNIT [...]
Answer Question
| July 16, 2010 8:13 PM
iSeries, iSeries RPG programming, RPG ILE, SQL, Stored Procedures
A while back, Seeker1 posted this question. Unfortuantely, he didn’t provide enough information for Tom to help. Well – I have the same problem so hopefully, this will be enough. This Select statement generates the error: SELECT UNUNIT, ITRVEHLOC(UNUNIT , 'CITY ') FROM Units Here are the supporting commands and code: Create Function ITRVEHLOC( UNIT [...]





