• AS/400 Query – Timestamp of entry to char field

    Hi friends, I am creating an account file with the command below: DSPJRN JRN(QSYS/QACGJRN) FROMTIME('26/09/2009') TOTIME('25/10/2009') ENTTYP(SP) OUTPUT(*OUTFILE) OUTFILFMT(*TYPE4) OUTFILE(QTEMP/QAPTACG4) How can I convert the Timestamp field called JATSTP to a new char field with the first four...

    RBDSILVA550 pointsBadges:
  • Converting date values in AS/400 database

    How do I convert a date value 20/09/1231 for 31st Dec 2009 in the database to be able to use a query of checking this date against current(date)?

    Bonbon7830 pointsBadges:
  • Can a nested query be run in AS/400?

    There are multiple lines (sequenced) of my records in a table with the same Key. Example of the table Student No.     Name         Grade      1001              Michelle       Fail 1001              Michelle       Fail...

    Bonbon7830 pointsBadges:
  • Message Queue

    Lets say a user "accidently" sends the wrong message to a user. How can an administrator go into that message queue while its being used and delete it. This can be done when the user is signed off but now while in use. A sensitive message was sent and it needed to be deleted. I told them not to use...

    RonKoontz1,780 pointsBadges:
  • How do I disable the query timeout property?

    I'm calling a stored procedure on the AS/400 from Visual Basic .Net. When the stored procedure executes, I get the SQL0666 message (query exceeds specified time limit or storage limit). The query timeout property on the box is set to *NOMAX and I've Reorg'd the files too. The message appears to be...

    JasonWV5 pointsBadges:
  • AS/400 QUERY ; how can I calculate the month and year of 3 months ago in define result fields?

    I am using an AS/400 query in which I need the month and year of 3 months ago based on today's date. To get today's date I use current(date) but I need to know the month/year 3 month ago and the month/year of previous month undepending which day of the current month it is. Is that possible? I...

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

    Abbey120 pointsBadges:
  • What is the proper syntax for using the RANGE test in select records?

    I am trying to test for a date range in my query. I dont know what the proper syntax is for testing range. Any ideas? Thanks

    Bmatts1410 pointsBadges:
  • test value of list in AS/400

    What is the definition of the test value list?

    Qwerty545 pointsBadges:
  • Diverting messages from a given message queue to QSYSOPR

    Hi, Can anyone know how to divert messages from a given message queue to Qsysopr. Thanks Siddharth

    Sangay635 pointsBadges:
  • AS400 QUERY-Beginning of year date

    How can I create a date field with the 1st day of the current year ie: 01/01/2009 using WRKQRY. Thanks!

    TB2G35 pointsBadges:
  • How to see records in ALL Files to an OutFile

    I have a programmer that wants to see all Files in a specific library that have 0 records. I know I can do a dspfd on all files in a specific library but I can't display it to an outfile. I wanted to run a query over the outfile. Can someone offer any suggestions on which command or program I could...

    Alison88380 pointsBadges:
  • print 1st 20 records of the file

    I need to dump the 1st record of a file using runqry is this possible

    crasherrider25 pointsBadges:
  • 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 #,...

    Amaries45 pointsBadges:
  • AS400 Query Security

    How can I secure an AS400 query allowing only two individuals the ability to change or delete the query?

    Clhalfa30 pointsBadges:
  • AS/400 All Object Authority

    I'm trying to get a list of all users who have the all object authority. Does anybody know of a good way to do that? I could create an IQ Query, but is there something faster?

    mshen27,385 pointsBadges:
  • 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

    Milahuang995 pointsBadges:
  • AS400

    how do you make a query of all the listed printers and display terminals in the system with the following columns: Device Type, Device Name, Description, Status, Last Used.

    Eldridge10205 pointsBadges:
  • Trying to use AS/400 as a new employee

    I've been hired by a retailer that uses AS 400 for just about everything, but provides almost no instructions or procedures to use the computers. As an older salesman (abt. 60), I have little experience with old DOS programs, but am now required to enter and edit sales orders, financing contracts,...

    DoubleM5 pointsBadges:
  • How do I modify the value returned from current(time)

    I have an AS/400 query that requires me to search records with a timestamp from 20 mins prior to the current system time. If I use the current(time) value in the query, how do I modify it to return a time 20 minutes earlier?

    Morticia00110 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