Query/400

Best way to retrieve values, SQL or Queries and how?

Hello everybody, my problem is, in a iseries i have ia file and in this file exist one field with 10000 lenght (character) and i want retrieve a value like (  60F: ) but i don´t know in what position, after i find this value i need the follow values. ex: this is a part of one record  {4: ...

Finding Files used by Query/400

Somewhere I know I had notes and maybe code to do this, but the clock is ticking, so does anyone have the way to extract what files are being used in exisiting (old!) queries - *QRYDFN type I have an extract utility written, but it's old stuff, and iteratively prints and reads the output. this...

Using 'IF' statements in query/400

I need to create a work field that will be populated differently, dependin on a series of 'If' statements. Ex: If TMRPER = 'M', use TMRFRQ value. If TMRPER = 'D', then use TMRFRQ divided by 30, rounded to the nearest whole number. Any idea how to do this?

Auto-Generated Serial Numbers?

I want to know that how do i generate serial numbers by using Query/400.For eg a database named employlist having name,address and phno.Now i want to add one another column which is serial. How???????? Can anyone please tell me the solution by using Query/400. I've done it from SQL. Name Address ...

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 #,...

How do I print dates in range selection on headings?

Have query setup for user to enter selection date range when running query...how do I print the date range selected by the user on the headings?

prob with sndbrkmsg

Hi I need to send a failure notice to a user.I have used the SNDBRKMSG for this but the problem is if the user is that the job is scheduled to run in the night and if the user has logged of his session he may not be able to view it the next day. The basic purpose is to alert the user the moment...

Userprofiles with creation date

Please can any one provide me the information how to get the report the list of all userprofiles with creation date. Thanks

OPNQRY and WRKQRY

In wrkqry there is an option to save the selected records to an output file.Similarly is there a way to use OPNQRY in a CL or in an SQLRPG to directly move the selected records to another file?

AS400 Query Dates

How do you computed dates in Query

iSeries RPG Embedded SQL Performance

Hi, I'm trying to replace some long running Query/400 jobs with RPG and embedded SQL. Some of the existing jobs run for almost 24 hours on our machine. I've already successfully managed to reduce a few of these jobs to a matter of minutes using embedded SQL. So far, so good. My problem is when...

How do I parse out a timestamp ISO format into a date field

How do I parse out a timestamp ISO format into a date field? This is how the field looks: Timestamp ISO Format 2008-10-08-12.13.52.412000 Here is the description of the field: Field From To Length Type Description XXXXXXX 57 82 0 Z ...

I want to reterive all users list with last logon date inculuded(help me with the query)

am running with AS400 iseries system V4R5.