AS/400 Trace Report
Hi, I ran the command TRCCNN in AS/400 to trace the connection between our AS400 and Tandem. I was able to generate a report but I don’t know how to read if there’s a lost connection or unnecessary event with the network. Can you help me what are the key or code when searching at [...]
Answer Question
| April 29, 2013 6:20 PM
AS/400, AS/400 Reports, Tandem
Hi, I ran the command TRCCNN in AS/400 to trace the connection between our AS400 and Tandem. I was able to generate a report but I don’t know how to read if there’s a lost connection or unnecessary event with the network. Can you help me what are the key or code when searching at [...]
Answer Question
| April 29, 2013 6:20 PM
AS/400, AS/400 Reports, Tandem
Extract start date and end date from a file field
I have a requirement like this. I need to generate a report which has 2 fields start date and maturity date. I have FileA which has a date field and has some values say 12/31/2012, 01/05/2013, 10/01/2013,25/01/2013 and so on. I need to generate a report which has a field start date and maturity date. [...]
Answer Question
| January 7, 2013 1:17 AM
AS/400, AS/400 Reports
I have a requirement like this. I need to generate a report which has 2 fields start date and maturity date. I have FileA which has a date field and has some values say 12/31/2012, 01/05/2013, 10/01/2013,25/01/2013 and so on. I need to generate a report which has a field start date and maturity date. [...]
Answer Question
| January 7, 2013 1:17 AM
AS/400, AS/400 Reports
Compare 2 reports
How can I compare 2 spool files? I have tried QShell command CATSPLF, and it showed the report interactively. But am not able to proceed further. Please share your thoughts on this
Answer Question
| September 25, 2012 10:47 AM
AS/400 Reports
How can I compare 2 spool files? I have tried QShell command CATSPLF, and it showed the report interactively. But am not able to proceed further. Please share your thoughts on this
Answer Question
| September 25, 2012 10:47 AM
AS/400 Reports
How can i search spool files fast?
my user have so many spool files that are not been deleted. i was wondering if there is a way to search for a specific file or a different way for me to search? i only use the page up and down to see everything.
Answer Question
| June 12, 2012 6:34 PM
AS/400 Reports
my user have so many spool files that are not been deleted. i was wondering if there is a way to search for a specific file or a different way for me to search? i only use the page up and down to see everything.
Answer Question
| June 12, 2012 6:34 PM
AS/400 Reports
How to call a report from another report in JDE?
Hi All, Is it possible to call a AS400 report(RLU) from JD Worldsoft report(RDA)?
Answer Question
| April 24, 2012 10:39 AM
AS/400, AS/400 Reports, OS/400
Hi All, Is it possible to call a AS400 report(RLU) from JD Worldsoft report(RDA)?
Answer Question
| April 24, 2012 10:39 AM
AS/400, AS/400 Reports, OS/400
Email AS/400 report
User is executing a world writer, and I need to automaticlly email the report to someone else. How can this be archived ?
Answer Question
| October 18, 2011 4:21 PM
AS/400, AS/400 administration, AS/400 Reports
User is executing a world writer, and I need to automaticlly email the report to someone else. How can this be archived ?
Answer Question
| October 18, 2011 4:21 PM
AS/400, AS/400 administration, AS/400 Reports
Report size(spooled file size)
How do I determine a report size from a spool file in CL(using a CL command) Thanks
Answer Question
| April 9, 2012 5:20 PM
AS/400, AS/400 Reports, AS/400 Spool Files, Spool files
How do I determine a report size from a spool file in CL(using a CL command) Thanks
Answer Question
| April 9, 2012 5:20 PM
AS/400, AS/400 Reports, AS/400 Spool Files, Spool files
AS400 report issue
Hi, RPG36 programs which generates reports wherein I can some blank lines printed , but the program as such does not print the blank line separately through the program. Am not getting any clue why this blank line is printed , verified the Printer where other similar reports are printed without any blank lines between [...]
Answer Question
| April 5, 2012 5:26 AM
AS/400 reporting, AS/400 Reports, RPG36
Hi, RPG36 programs which generates reports wherein I can some blank lines printed , but the program as such does not print the blank line separately through the program. Am not getting any clue why this blank line is printed , verified the Printer where other similar reports are printed without any blank lines between [...]
Answer Question
| April 5, 2012 5:26 AM
AS/400 reporting, AS/400 Reports, RPG36
AS/400 query
Is there a way to create a query that gives you a report with an average price, but does not include the zero prices in the count of the average? Those “zero price records” must be included in the report for other info.
Answer Question
| June 16, 2011 5:30 PM
AS/400, AS/400 Query, AS/400 Reports, Query/400
Is there a way to create a query that gives you a report with an average price, but does not include the zero prices in the count of the average? Those “zero price records” must be included in the report for other info.
Answer Question
| June 16, 2011 5:30 PM
AS/400, AS/400 Query, AS/400 Reports, Query/400
How can I list users whose status is disabled on AS/400 ?
Hello everybody ! I have to make a cl program in order to list users whose status is disabled. I wanted to know if someone had tips for me. Thanks
Answer Question
| May 17, 2011 4:50 PM
AS/400 programming, AS/400 Reports, AS/400 user profiles, CL programs
Hello everybody ! I have to make a cl program in order to list users whose status is disabled. I wanted to know if someone had tips for me. Thanks
Answer Question
| May 17, 2011 4:50 PM
AS/400 programming, AS/400 Reports, AS/400 user profiles, CL programs
AS/400 Scratched System Report
How may I get a report that the AS/400 system was scratched for the Auditors.
Answer Question
| March 24, 2011 1:48 PM
AS/400 audit, AS/400 Reports, AS/400 system administration
How may I get a report that the AS/400 system was scratched for the Auditors.
Answer Question
| March 24, 2011 1:48 PM
AS/400 audit, AS/400 Reports, AS/400 system administration
Using Query on 4 different files
Hi i have four different files each containing a Customer name ,number and sales amounts ,each file is for a different quarter of the year ,i would like to join the four files so that i can produce a report which lists across the page by quarter the sales for each customer,however not all the customers [...]
Answer Question
| February 7, 2011 1:02 AM
AS/400 File Sharing, AS/400 Query, AS/400 Reports, Query
Hi i have four different files each containing a Customer name ,number and sales amounts ,each file is for a different quarter of the year ,i would like to join the four files so that i can produce a report which lists across the page by quarter the sales for each customer,however not all the customers [...]
Answer Question
| February 7, 2011 1:02 AM
AS/400 File Sharing, AS/400 Query, AS/400 Reports, Query
How to view unique entry of record in collumn?
I have table containing same multiple records in collumn, when I goes into ‘Define Query’ and ‘Select Records’ of ‘Query Definition Option’, it shows me all record list, but I like to view only a single entry of each record. How could be querry in ‘Select Records’ of ‘Query Definition Option’ or do I need [...]
Answer Question
| September 9, 2010 9:11 AM
AS/400 database, AS/400 Query, AS/400 Reports
I have table containing same multiple records in collumn, when I goes into ‘Define Query’ and ‘Select Records’ of ‘Query Definition Option’, it shows me all record list, but I like to view only a single entry of each record. How could be querry in ‘Select Records’ of ‘Query Definition Option’ or do I need [...]
Answer Question
| September 9, 2010 9:11 AM
AS/400 database, AS/400 Query, AS/400 Reports
OUTPUTQUE with CHGSPLFA
I have 2 users, one *USER and another *SECOFR When the user *USER change the spoolfile, the options was displayed Additional Parameters Output queue . . . . . . . . . . QPRINT Name, *SAME, *DEV Library . . . . . . . . . . . QGPL Name, [...]
Answer Question
| June 4, 2010 9:34 PM
AS/400 Query, AS/400 Reports, Output Queues
I have 2 users, one *USER and another *SECOFR When the user *USER change the spoolfile, the options was displayed Additional Parameters Output queue . . . . . . . . . . QPRINT Name, *SAME, *DEV Library . . . . . . . . . . . QGPL Name, [...]
Answer Question
| June 4, 2010 9:34 PM
AS/400 Query, AS/400 Reports, Output Queues
getting source from object on AS400
I have a customer who has no source for a program but has a object and is at 4.5 of the os. Is there a tool or way that I can get the source back on the cle or rpg program?
Answer Question
| November 23, 2010 12:51 PM
AS/400 Reports
I have a customer who has no source for a program but has a object and is at 4.5 of the os. Is there a tool or way that I can get the source back on the cle or rpg program?
Answer Question
| November 23, 2010 12:51 PM
AS/400 Reports
Printer file query
Hi Guys, can we able to define variable detail heading in printer file. For an example..lets take one Employee table which has Employee name, Age and Country. I want to set country as variable in printer file and output should be one column for each country find. like this…. Employee Name Age India USA UK [...]
Answer Question
| January 27, 2010 1:40 PM
AS/400 Reports
Hi Guys, can we able to define variable detail heading in printer file. For an example..lets take one Employee table which has Employee name, Age and Country. I want to set country as variable in printer file and output should be one column for each country find. like this…. Employee Name Age India USA UK [...]
Answer Question
| January 27, 2010 1:40 PM
AS/400 Reports
AS/400:RLU report printing
I want to print a spool file with Page format ( Page no./total number of pages) in header. Plz share how can i get this in RLU..(ex : 1/10)
Answer Question
| December 21, 2009 4:47 AM
AS/400 print jobs, AS/400 printing, AS/400 reporting, AS/400 Reports, AS/400 RLU, RLU, RLU reports
I want to print a spool file with Page format ( Page no./total number of pages) in header. Plz share how can i get this in RLU..(ex : 1/10)
Answer Question
| December 21, 2009 4:47 AM
AS/400 print jobs, AS/400 printing, AS/400 reporting, AS/400 Reports, AS/400 RLU, RLU, RLU reports
Disk Tip: This will enable you to create disk reports on the fly.
Setup the Weekly Collection of Disk Space Information
Answer Question
| October 9, 2009 8:40 PM
AS/400, AS/400 reporting, AS/400 Reports
Setup the Weekly Collection of Disk Space Information
Answer Question
| October 9, 2009 8:40 PM
AS/400, AS/400 reporting, AS/400 Reports
AS/400 RLU
I need to declare a character field in Report with length of 280. But when given the length greater than 249, it throws the error message as “Field deleted by changes. Press Enter to confirm. ” Is there any way to declare a Field of length greater than 249 in RLU.
Answer Question
| September 14, 2009 8:02 AM
AS/400 Reports, AS/400 RLU
I need to declare a character field in Report with length of 280. But when given the length greater than 249, it throws the error message as “Field deleted by changes. Press Enter to confirm. ” Is there any way to declare a Field of length greater than 249 in RLU.
Answer Question
| September 14, 2009 8:02 AM
AS/400 Reports, AS/400 RLU
Printing Image In RPGLE
I have never had to do this in all my years but how can I print an image whil Im generating my reports? I’m using a laser printer and want to include out logo at the top. Anyways of doing this.. Thanks
Answer Question
| September 10, 2009 4:19 PM
AS/400, AS/400 printing, AS/400 Reports
I have never had to do this in all my years but how can I print an image whil Im generating my reports? I’m using a laser printer and want to include out logo at the top. Anyways of doing this.. Thanks
Answer Question
| September 10, 2009 4:19 PM
AS/400, AS/400 printing, AS/400 Reports
