AS/400 Queries

SQL/400 Query to update one field in File1 with other field in File2

Hi All, I want to update one field(PCUSR6) in NBSPCNTR file for all records with MCUSR6 field from CASCNTRM file. I tried below combinations, but i couldn't do it. Can any one please help to update whole file with another file field. Please find below queries i tried: i have to update NBSPCNTR...

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

AS/400 date format

How do format a date field to MM/DD/YYYY?

AS/400 Query - Current date -1

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

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

Iseries Queries.

Hello, I have a query schedule that runs Daily and looks for events for the previous day and, it's access in access database, but on Mondays I don't get anything because is set for previous day and Sat and Sunday overwrite the query so I get ZERO results. I've set for YESTERDAYX. How can I change...

CL Program

Hello, I have these queries on a job schedule now and, I want to export them to excel using CL.. PGM RUNQRY MYENTRIES1 RUNQRY MYENTRIES2 COPYTOIMPF FROMFILE(MYLIB/MYFILE1) (MYLIB/FILE2) ENDPGM Where do I send these two file to? and can I run both queries this way? thanks,

AS400 QUERYS

How can I add one of my querys to print daily using schedule job command (step by step).

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

am running with AS400 iseries system V4R5.

Converting Julian date to Gregorian in WrkQry

I work on an Iseries AS/400 and when I do a wrkqry for reports I need to convert the date ccyyyddd(julian) to mmddyyy(gregorian)

Notes in AS400 query

How do you add notes to a AS400 query?