• Query400 authorizations

    We have used a generic user ID for our support persons to sign on to a data center. Due to audit requirements we were forced to elimiate the Generic User. Many queries were created over the years for customers and were saved with *CHANGE auhority instead of *ALL. Now that the generic user is no...

    Kellyd100 pointsBadges:
  • i5 Query Security

    Are there any commercial security programs that will secure the query function on the as400? We have user menus that keep users from viewing and changing critical files. However, we also have users who go into query and save the results of the query anywhere on the system.  I'm concerned that...

    Amauer5 pointsBadges:
  • t-sql and AS400

    I want to develop a TSQL query. First I need to determine if all the numbers in one of the fields are in numerical order and also find the missing holes in the number sequence. Secondly I need to sort by another field and by a particular criteria.  The words that I need to sort-by would be...

    CompEng1,185 pointsBadges:
  • AS/400 users profile changed

    Can anyone provide me with information to query and produce a report that shows who was changed the user profile ?

    as400tarek105 pointsBadges:
  • Query Administration

    Is there a way to get the last date a query was run?

    Dmojares5 pointsBadges:
  • IBM I-series Data Download

    I run a query in query/400 and tried to download that file using IBM Iseries. in the downloaded file, the column headers are in field ids and not the descriptions i have given in Query/400 report column formatting. Is there any way to download a file with column descriptions given in query?...

    VJayashree185 pointsBadges:
  • AS/400 Query – wild card for LIKE test

    When I select records usinf the LIKE test, what wild card character do I use? LIKE 'air%'?

    CooperDuper5 pointsBadges:
  • 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.

    Lilarose95 pointsBadges:
  • Exporting a query in AS/400

    How do I export a query that I'm currently viewing?

    HIM30 pointsBadges:
  • AS/400 query join

    I have 2 files I am joining. The primary file is an employee master. The secondary is a history file with the employees time punches. Using a type 1 join it works fine. The user wants a change to the query to show the employees who did not punch in for a specific day as well, which would be a type...

    ToddN20008,785 pointsBadges:
  • AS400 – Queries

    Hi I have one query Which is a join of table A and Table B. select store,sum(amt) from table A and table B where A.fld1 = B.fld1 A.fld2 = B.fld2 A.fld3 = b.fld3 AND A.fld3 between date range group by Store order by store. I need to run this query in a batch mode,just by changing the date range.how...

    iiiiiiiiiiiii335 pointsBadges:
  • Select only updates/deletes/changes to files using query

    How can I Only select updates/deletes/changes to files and dont want  I/O type access  using query

    carlosdl68,710 pointsBadges:
  • AS/400 Query Job Log

    Dear all, Its my first time I submit a question so, please forgive me if I do something wrong. My question is if it possible to have a detail job log from a query. I mean if I can see what files I have used or what criteria I have used. Thank you Lambros

    Lambros25 pointsBadges:
  • 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.  

    Hf30 pointsBadges:
  • AS/400 Query – Current date -1

    Is there a quick and easy way to calculate yesterdays date by using "Define result fields"

    Soren5 pointsBadges:
  • AS400 Retrieve QUERY Print Definitions inside of CL procedure.

    Inside of a CL procedure, I want to retrieve the printer name being used by the designated query. I need to do this without any prompting, therefore using WRKQRY, option 6 to print definitions will NOT work. What is the alternative. I simply need to know the printer name used in all of the queries...

    MeAndCL50 pointsBadges:
  • Signed field to a packed field in AS/400 query

    Does anyone know of a way to move a signed numeric to a packed numeric in query? Is it even possible?   Been playing with it and can't find a way.  Any answer appreciated. 

    Lilarose2260 pointsBadges:
  • How can I concatenate files for transfer from the iseries

    I have 3 files with a common layout in a common library on the i5. The source files (query results) have different definitions so I am unable to append the result of query2 to query1. So what I want is to perform a UNION or concatenate them into a single download file. I have tried a UNION but...

    Mgaylard5 pointsBadges:
  • AS400 Query – div by zero

    Hi I have a query as follows:- I want to define the following:- Field       Column                                 Heading     Len     Dec PERCENT (t01.amtdol/t02.pvsddl)*100 When I run the query it displays the above field but it converts the percent...

    devan390 pointsBadges:
  • 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...

    ZETA5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following