• Embedded SQL using SUM or some other method to total up qty and display 1 unique record

    I have an sqlrpgle pgm setup, I want to add another sql select statement. I have a file that contains barcode label data, where multiple records can be assigned to the same Master serial #. My sqlrpg pgm is display various sorts in a screen inquiry. I want to setup my select, to display one record...

    Dobie80 pointsBadges:
  • AS/400 Model Number

    How can i know the model number of my AS400. I am doing DSPSYSVAL SYSVAL(QMODEL)and it shows me FHA. What is FHA

    now225 pointsBadges:
  • Key on DDS Join Logical File

    I have created a join logical file. On the second file there is a field that has to be a part of the key. But I get the following error message "Key field not from first file on JFILE keyword." Is there way to get past this, or another way of doing this than using a Join file?

    Steyn15 pointsBadges:
  • Subfile code for AS/400

    In Subfile, OPT   ShipQuantity   QuantityToShip   Item#   CustomerOrder#        ___     ____________   100                  ABC1     CO100010                 ___     ____________   10                    WQE1   ...

    22917510 pointsBadges:
  • V6R1 on web box

    Are there any known issues for going V5R4 to V6R1 on a web server 400 ? We did the update on our "normal" 400's already with no major issues. Next week we do it on the 400 that hosts many of our web sites ... so fear of the unknown that we might find trouble due to non-standard stuff like CGI...

    aceofdelts1,930 pointsBadges:
  • Opening Domino backups of an AS/400 tape on a Windows PC and converting the

    Can anybody help us, please? We have the following problem: We received a backup tape of an AS/400 which contains some session with (presumably) save files containing Lotus Domino mailboxes. First question is: are these boxes nsf files and can they be opened by a Windows Notes client? The second...

    Amann5 pointsBadges:
  • Want to delete objects of type ‘File’ except ‘source physical file’

    I have taken output of DSPOBJD in a database file. Now I want to delete all the objects having type '*FILE' and object attribute 'PF' but the problem is I don't want to delete 'Source physical files'. I just want to delete files except 'Source physical file'. can anybody suggest how to do that ?

    pankaj2r100 pointsBadges:
  • Default Font Name in AS/400

    Hi All,  Can Anyone tell me that which Font we use in As400, i mean default font nmae for As400. Thanks

    Rpgle400tech145 pointsBadges:
  • Port filtering to Map folders

    IN V5R4 Which ports need to be open to map folders in windows

    4444415 pointsBadges:
  • Announcing the Symantec Endpoint Protection 12 Scavenger Hunt (sponsored)

    Want the chance to win an iPad 2 or Amazon.com gift cards? The Symantec Endpoint Protection 12 Scavenger Hunt is your opportunity to learn about all of the new features of Symantec Endpoint Protection 12 while getting in the running to earn great prizes. Think you know about all of the new features...

    ITKE346,375 pointsBadges:
  • Free IT Book: The Data Warehouse Mentor

    The Data Warehouse Mentor by Robert Laberge will show you how to plan, design, construct, and administer an integrated end-to-end DW/BI solution. He'll explain how to choose appropriate components, build an enterprise data model, configure data marts and data warehouses, establish data flow, and...

    MelanieYarbrough6,345 pointsBadges:
  • How to speed up AS/400 SQL?

    We have SQL on our Data Warehouse written using SHOWCASE. The SQL could be better, it is not SO bad for something writen with a drag and drop gui, but the execution is far too slow - 12 minutes to extract data from the main 3.5 million record file, with several left outer joins. So, we created...

    Sloopy2,195 pointsBadges:
  • AS/400 symatrax telnet

    how can i make as400 symatrax telnet system display the sign on srceen

    Zesa5 pointsBadges:
  • Display Performance Data in AS/400

    I have several LPAR's that collect peerformance data. In one LPAR I can see all Performance Collections with DSPPFRDTA *SELECT in QMPGDATA. On the others only the current collection is shown although the *MGTCOL objects are in QMPGDTA. How can I force these to be shown on the other LPARs as well ?...

    pdraebel2,895 pointsBadges:
  • Compare files in AS400

    When i compare two files using CMPPFM command, i am getting message as request failed. This is because files were having huge volume of data. It was showing file exceeds 112498 records. Is there any other way to compare files of large volume of data in AS400. Please let me know.

    Thotts45 pointsBadges:
  • Hard drive formatting

    When formatting a hard drive of a server that is going to be donated how can I be certain that the data is gone? Is there a program or application I can run? Is there a standard procedure for this? Or does everyone remove the hard drives?

    NewnanIT1,110 pointsBadges:
  • Delete contents of a folder tree with a kill statement

    Would anyone know of a code, or be able to point me to one, that will delete all files and folders under a given location.  I am looking to schedule the empting of temp folders and would like it to be all inclusive.  If a kill statement is needed also to force delete folders and there content...

    ConFlicker210 pointsBadges:
  • How to direct program in *PPSR

    Hi All, In a program, a loop doing some operations... and I got some program error/file error and in *PSSR I want to handle the error then to resume the program to flow with the next record. But, how to pass the control to the loop to read from the next continution record. In Main routine, MAIN...

    Kar425 pointsBadges:
  • Best way to pull Windows security logs remotely

    If we need to pull Windows security logs remotely what is the best and easiest way using a domain administrator account?

    NewnanIT1,110 pointsBadges:
  • Free IT Book: Building Applications in the Cloud

    This week's free IT book, Building Applications in the Cloud: Concepts, Patterns, and Projects, is Christopher Moyer's guide to help you not just migrate to the cloud, but "use cloud architectural patterns that deliver superior performance, scalability, and availability." Whether you're building a...

    MelanieYarbrough6,345 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