Identifying output files in query definitions
How can one identify all/only output files in a list of query definitions (the list has over 1000 queries in it)? Executing in batch RUNQRY with parameter PRTDFN(*YES), in a loop for each query, then scanning the collective result, might theoretically do the job but doesn't work for queries in...
How can one identify all/only output files in a list of query definitions (the list has over 1000 queries in it)? Executing in batch RUNQRY with parameter PRTDFN(*YES), in a loop for each query, then scanning the collective result, might theoretically do the job but doesn't work for queries in...
65 pts.
Editing invalid calculations into zeros
How do I change a invalid calculated value (due to some zero quantities) into a value of ZERO? I need to save this in a file for later pulling into a spreadsheet.
How do I change a invalid calculated value (due to some zero quantities) into a value of ZERO? I need to save this in a file for later pulling into a spreadsheet.
Query Xref to file
The other day I added a field to the DDS of a file. I recompiled all of the RPG programs and display files that use the physical file. But I got burned when I found that I neglected to include all of the queries that used the file. Is there a way to query all of the query definitions to find if my...
The other day I added a field to the DDS of a file. I recompiled all of the RPG programs and display files that use the physical file. But I got burned when I found that I neglected to include all of the queries that used the file. Is there a way to query all of the query definitions to find if my...
Profiles not signed on in 180 days
How do I get a query to show me AS400 profiles not signed on in 180 days?
How do I get a query to show me AS400 profiles not signed on in 180 days?
Simple question about AS/400 query
Maybe for you that will be a stupid question, but I'm taking the first steps and I don't know what exactly I have to do in the "Specify how to join files" screen. If I put more joints in more rows it is how there was an "and" before every new row? I mean, all the rows are conditions that have to be...
Maybe for you that will be a stupid question, but I'm taking the first steps and I don't know what exactly I have to do in the "Specify how to join files" screen. If I put more joints in more rows it is how there was an "and" before every new row? I mean, all the rows are conditions that have to be...
AS 400 Query File Reference
How would you go about identifying file, field and output references of a group or *all AS400 queries? I need to be able to identify files where used in queries.
How would you go about identifying file, field and output references of a group or *all AS400 queries? I need to be able to identify files where used in queries.
Calculate date in future
How can I ad an day to the current systemdate ? So that I only see the records of tomorrow (for example)?
How can I ad an day to the current systemdate ? So that I only see the records of tomorrow (for example)?
Is there a quick way of running a query to select records based on" current sysdate - 1" i.e yesterday.
Is there a quick way of running a query to select records based on current sysdate - 1 ie yesterday. Using Martin Gilbert's suggestion I get the current date & it works perfectly CD CHAR(CURRENT(DATE)) CURDAT SUBSTR(CD, 1, 2) || SUBSTR(CD,...
Is there a quick way of running a query to select records based on current sysdate - 1 ie yesterday. Using Martin Gilbert's suggestion I get the current date & it works perfectly CD CHAR(CURRENT(DATE)) CURDAT SUBSTR(CD, 1, 2) || SUBSTR(CD,...
as400 Query : Current Date
Is there a quick way of running a query to select records based on current sysdate. I know you can get current date using Current command but I cant use it in selection.
Is there a quick way of running a query to select records based on current sysdate. I know you can get current date using Current command but I cant use it in selection.
Using LIKE in AS/400 Cobol
How to use 'LIKE' in Cobol similar to query/400(example Field_A LIKE '%777%')
How to use 'LIKE' in Cobol similar to query/400(example Field_A LIKE '%777%')
RPG %SCAN Question
I am unable to get all the scanned records for a string in a file. For example, my file itemmast has 1000 records in it. When I use Query 400 and search for 'cable' I get 50 records with the word cable in various positions of a 30 character field. When I use the statement "x = %scan (xcust_pn :...
I am unable to get all the scanned records for a string in a file. For example, my file itemmast has 1000 records in it. When I use Query 400 and search for 'cable' I get 50 records with the word cable in various positions of a 30 character field. When I use the statement "x = %scan (xcust_pn :...
Find # days between 2 dates in Query 400
I have never used this function but it looks like the startdate and enddate must be alpha expressions for this to work. Is that correct?
I have never used this function but it looks like the startdate and enddate must be alpha expressions for this to work. Is that correct?
Find # days between 2 dates in Query 400
How do I find the # of days between 2 dates. I'm trying to do this in AS/400 Query 400. I'm looking to do this in the Results area where you do calculations. Can anyone help??? Thanks!!!!!
How do I find the # of days between 2 dates. I'm trying to do this in AS/400 Query 400. I'm looking to do this in the Results area where you do calculations. Can anyone help??? Thanks!!!!!
Number of days between 2 dates
How do I find the number of days between 2 dates? Julian or MM/DD/YY?
How do I find the number of days between 2 dates? Julian or MM/DD/YY?
converting character to numeric in query/400
Hello, Is there a way of converting character to numeric data in WRKQRY? I've read Query/400 manuals and found no simple way of data conversion. Thanks in advance!
Hello, Is there a way of converting character to numeric data in WRKQRY? I've read Query/400 manuals and found no simple way of data conversion. Thanks in advance!
Passing parms to Query400
Has anyone ever come across a method of passing a parm into a query run - such as a date?
Has anyone ever come across a method of passing a parm into a query run - such as a date?
changing qpquprfil in query
how do i change the qpquprfil in as/400 query. i have doone it before and i know it is doabe but ican't rember how. i mean thesystem one not the one at the user level??
how do i change the qpquprfil in as/400 query. i have doone it before and i know it is doabe but ican't rember how. i mean thesystem one not the one at the user level??
Query Question
okay, first let me apologize for my general lack of knowledge about my computer system. We don't have anyone in house that can help so I turn to this site for hopefully an answer. I am not sure I can even communicate effectivey my question but here goes: I am trying to write a query with our...
okay, first let me apologize for my general lack of knowledge about my computer system. We don't have anyone in house that can help so I turn to this site for hopefully an answer. I am not sure I can even communicate effectivey my question but here goes: I am trying to write a query with our...
