• Query400 report generation

    I'm using query400 tool and using output type as printer files.. I want to generate a report format of transactions like this.. date act# amount date1 act no1 total act no2 total act no3 total date1 act no1 total act no2 total Final Total example transaction is like date act# amount 23/10/12 100...

    sivakesava285 pointsBadges:
  • Wild card search in AS/400 query

    How do I find records that actually have percent sign in them using the like '%  "%"  %' when the % is the wild card?

    tracyv2940 pointsBadges:
  • Duplicate entries on the printed report

    I have a written a query and do get results however when it populates the information it duplicates each entry X4.

    63bunnies10 pointsBadges:
  • Convert seconds into time format in QM Query

    I have one scenario where i have time field as seconds and i need to convert this into time format like HH:MM:SS in 24 hour format in query 400. I am using V6R1M0. Can anyone help me on this ASAP? Thank in advance Saravanan D 

    Dsaran2007150 pointsBadges:
  • AS/400 question

    how can we see records in a physical file without using run query?

    Ramaduguanil5 pointsBadges:
  • mixture of characters, numerics and special characters

    i have a string which is a combination of characters,numerics and special characters. how to calculate number of characters,numerics and special characters present in it?

    Xmanwolverine5 pointsBadges:
  • AS400 Query: Date Concatenation

    I work for a travel company whose Inventory file uses a unique field for each day of the month, e.g. LGRA1 is the first, LGRA2 is the second etc. The month and the year are single fields. Is there a way of converting these fields to concatenate the date to be able to link easily to other files? Not...

    Sblackshaw25 pointsBadges:
  • 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:
  • Receiving a Message from Message Queue

    I would like to receive the latest message from as400 message queue. Any one can suggest the best possible way.

    Cursorposition195 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,240 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...

    ToddN200015,605 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

    carlosdl70,220 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