• Convert data to character string in AS/400 query

    I use Query400 to output negative temperatures to a database file. The output file is currently created by the query at run time. The data is output as packed but I need the sign separate. I can't see how to convert the temperature to a character string either as the sign is ignored. Any other...

    Jubal5 pointsBadges:
  • Select code within AS/400 query

    I have to run a Query based on PF without DDS with record length 2997. I have to select Company Code '01' which is the 925-927 positions in the file. How do I do select in the Query? Please advice. Thank you.

    Larisagas265 pointsBadges:
  • Define query without WRKJOBSCDE

    How can I Define a query to run only Monday thru Friday not using WRKJOBSCDE (we have a customised WRKQRY) scheduler and doesn't have an option to input the schedule day e.g. *Mon *Tues =, etc....I'll like to see if any one knows how to Define the query using the DEFINE RESULTS FIELDS e.g....

    Querys100 pointsBadges:
  • IBM TXSeries and AS/400

    The customer is using custom gateway using IBM TX series (multiplatform v6) on AIX platform and the client's all IVR related transactions are available through LU 0 protocol only and we should not use any other in order to intract with AS 400 host (CICS). Please clarify the below: 1. The IBM TX...

    Srinivas naikk115 pointsBadges:
  • Query products

    What are the different query products in AS/400? How do they function?

    Durgesh813370 pointsBadges:
  • Search in QRYDFN

    I am looking for an utility which will search for the sources of QRYDFN and tell me which query is using the string that I am looking for.

    RamvishakRamesh2,505 pointsBadges:
  • AS400 query detailed note

    How can you add a detailed note in AS/400 Query? I want to add the note to a file not a report.

    RoRo10 pointsBadges:
  • AS/400 query on all user profiles

    I ran query of all user profiles. I need to change the UPPWCD UPPSOD field from YYMMDD to MMDDYY. You cannot change it in Specify report column formatting. That only handles numeric. Can someone get back to me ASAP? Thanks!

    Gww2445 pointsBadges:
  • QMQRY!

    How can we run multiple select/update query via a single QMQRY?

    sgautam11105 pointsBadges:
  • How to extract a range of variable from a list in PF where the variable is in the middle of a string. Ex: A12LO to A25LO.

    Hi All, Please help me. I have a physical file with a list of objects that are in a library. The object names ranges from A80395LO to A80635LO and B80395LO to B80635LO and so on... I want to filter out only the object names with range from 80400 to 80410. Is it possible using query? Please let me...

    IASSAI10 pointsBadges:
  • Length of the entered value

    Hi group, How to get the length of the entered value using WRKQRY? I am querying a file, the name field is defined as 15 characters. I need to get all those records whose name is greater than 10 Characters. Could anyone please help me how to write a query? Regards, M

    mvrkrishna555 pointsBadges:
  • AS/400 Query – how do you split names in field into seperate fields

    Trying to separate a field into three separate fields. The field is a name field, with lastname firstname mi with spaces in between each name. Is there a way to do this? I've tried everything I can think of, am out of ideas. Thanks in advance for your help

    sueshe4me5 pointsBadges:
  • How do I convert a date in text format to a proper date with AS/400 Query

    I have a date 20/02/2013 which is in text format but I need to convert it to a date format with a length of 10 and decimal of L (a normal date format). Basically I need to convert 20/02/2013 which is currently in text format to an ISO date format with Query using iSeries access for Windows.

    PhilipX25 pointsBadges:
  • Date minus 1 month in January

    AS/400 query, when I have TODAY = current(date), then when today - 1 month, If  the current date is Jan 1, 2013, will it be Dec 1, 2013 or Dec 1, 2012?  I assume Dec 1, 2012, but want to be sure.  Likewise, on Mar 1, 2013 current, it would give Feb 1, 2013, correct (again, I only really care if...

    iseriesuser15 pointsBadges:
  • Query in AS/400

    I want to know how I can use the query in the AS/400?

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

    sivakesava280 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:

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