AS/400 QUERY ; how can I calculate the month and year of 3 months ago in define result fields?
I am using an AS/400 query in which I need the month and year of 3 months ago based on today's date. To get today's date I use current(date) but I need to know the month/year 3 month ago and the month/year of previous month undepending which day of the current month it is. Is that possible? I...
I am using an AS/400 query in which I need the month and year of 3 months ago based on today's date. To get today's date I use current(date) but I need to know the month/year 3 month ago and the month/year of previous month undepending which day of the current month it is. Is that possible? I...
AS400 query print landscape/legal?
How do you get Query to print in landscape on legal sized paper? I tried adjusting the paper size but that didn't seem to help. Software/Hardware used: AS400
How do you get Query to print in landscape on legal sized paper? I tried adjusting the paper size but that didn't seem to help. Software/Hardware used: AS400
What is the proper syntax for using the RANGE test in select records?
I am trying to test for a date range in my query. I dont know what the proper syntax is for testing range. Any ideas? Thanks
I am trying to test for a date range in my query. I dont know what the proper syntax is for testing range. Any ideas? Thanks
AS400 QUERY-Beginning of year date
How can I create a date field with the 1st day of the current year ie: 01/01/2009 using WRKQRY. Thanks!
How can I create a date field with the 1st day of the current year ie: 01/01/2009 using WRKQRY. Thanks!
How to see records in ALL Files to an OutFile
I have a programmer that wants to see all Files in a specific library that have 0 records. I know I can do a dspfd on all files in a specific library but I can't display it to an outfile. I wanted to run a query over the outfile. Can someone offer any suggestions on which command or program I could...
I have a programmer that wants to see all Files in a specific library that have 0 records. I know I can do a dspfd on all files in a specific library but I can't display it to an outfile. I wanted to run a query over the outfile. Can someone offer any suggestions on which command or program I could...
AS/400 Query - Current date -1
Is there a quick and easy way to calculate yesterdays date by using "Define result fields"
Is there a quick and easy way to calculate yesterdays date by using "Define result fields"
print 1st 20 records of the file
I need to dump the 1st record of a file using runqry is this possible
I need to dump the 1st record of a file using runqry is this possible
subtotal and average
Can anyone tell me how/if I could using query400 take a list of records, subtotal and create a file with only the subtotals for export to excel? My file is all orders, with line items and $$ for each line. I need to subtotal the orders by order # and create a file listing only the customer #,...
Can anyone tell me how/if I could using query400 take a list of records, subtotal and create a file with only the subtotals for export to excel? My file is all orders, with line items and $$ for each line. I need to subtotal the orders by order # and create a file listing only the customer #,...
AS400 Query Security
How can I secure an AS400 query allowing only two individuals the ability to change or delete the query?
How can I secure an AS400 query allowing only two individuals the ability to change or delete the query?
Qry Mgmt losing edit word specs
My 400 query has edit words specified for proper printing of the dates in my report, but I am passing parameters to select the correct data using STRQMQRY. My output is ignoring the edit words specified in the query
My 400 query has edit words specified for proper printing of the dates in my report, but I am passing parameters to select the correct data using STRQMQRY. My output is ignoring the edit words specified in the query
AS/400 All Object Authority
I'm trying to get a list of all users who have the all object authority. Does anybody know of a good way to do that? I could create an IQ Query, but is there something faster?
I'm trying to get a list of all users who have the all object authority. Does anybody know of a good way to do that? I could create an IQ Query, but is there something faster?
AS/400 Query - How to combine 2 fields but delete the null space?
fields a: School , in the fileld a there are 3 null space after school, field b: I choose , now I want to combine filed a and field b by using "||" as a new field, how to delete the null space
fields a: School , in the fileld a there are 3 null space after school, field b: I choose , now I want to combine filed a and field b by using "||" as a new field, how to delete the null space
AS400
how do you make a query of all the listed printers and display terminals in the system with the following columns: Device Type, Device Name, Description, Status, Last Used.
how do you make a query of all the listed printers and display terminals in the system with the following columns: Device Type, Device Name, Description, Status, Last Used.
How do I modify the value returned from current(time)
I have an AS/400 query that requires me to search records with a timestamp from 20 mins prior to the current system time. If I use the current(time) value in the query, how do I modify it to return a time 20 minutes earlier?
I have an AS/400 query that requires me to search records with a timestamp from 20 mins prior to the current system time. If I use the current(time) value in the query, how do I modify it to return a time 20 minutes earlier?
AS400 Profile Change Query
Hey guys, can anyone provide me with information to query and produce a report that shows the date and time when a user profile was changed.
Hey guys, can anyone provide me with information to query and produce a report that shows the date and time when a user profile was changed.
AS/400 Query
How can I Define a query to run only Monday thru Friday not using WRKJOBSCDE (we have a customised WRKQRY) scheduler and doesn't have an option to input the schedule day e.g. *Mon *Tues =, etc....I'll like to see if any one knows how to Define the query using the DEFINE RESULTS FIELDS e.g....
How can I Define a query to run only Monday thru Friday not using WRKJOBSCDE (we have a customised WRKQRY) scheduler and doesn't have an option to input the schedule day e.g. *Mon *Tues =, etc....I'll like to see if any one knows how to Define the query using the DEFINE RESULTS FIELDS e.g....
How to get a Lastname from a field that contains the Full Name? (RPG-ILE)
Hi Guys, I need your suggestions.... I have to extract data from our AS400 box and convert it into text file. For a client's name we have 3 particular fields. 1. FirstName, 2. LastName and 3. FullName. The problem is there are records where First Name and LastName fields are empty. Thats why I...
Hi Guys, I need your suggestions.... I have to extract data from our AS400 box and convert it into text file. For a client's name we have 3 particular fields. 1. FirstName, 2. LastName and 3. FullName. The problem is there are records where First Name and LastName fields are empty. Thats why I...
How do I disable the query timeout property?
I'm calling a stored procedure on the AS/400 from Visual Basic .Net. When the stored procedure executes, I get the SQL0666 message (query exceeds specified time limit or storage limit). The query timeout property on the box is set to *NOMAX and I've Reorg'd the files too. The message appears to...
I'm calling a stored procedure on the AS/400 from Visual Basic .Net. When the stored procedure executes, I get the SQL0666 message (query exceeds specified time limit or storage limit). The query timeout property on the box is set to *NOMAX and I've Reorg'd the files too. The message appears to...


