• Multi-member file in AS/400 (SQL query)

    On my AS/400 in an interactive SQL (5250 session),select * from myfileonly returns rows from one member when "myfile" has more than one member. But how can I get rows from a specific member? Thanks for the help!

    ITKE54,755 pointsBadges:
  • How do you do LIMIT in DB2 for iSeries?

    We currently have a table of more than 50,000 records and we're trying to return records of 0 to 10,000 / records of 10,000 to 20,000. We already know that in SQL, if you write "LIMIT 0,10000" at the end of the query, it will bring you that record. How can you do it in DB2 for iSeries? Thanks!

    ITKE54,755 pointsBadges:
  • Cobol/AS400 – Copy DDS Replacing Fields Names

    Language: Cobol Platform: iSeries (AS/400) Is there a way to replace in Cobol the first two characters of all fields from a file by other two characters? What I mean is this: I have a copy-dds from a file that all the fields have TRxxxx (where 'xxxx' is different from field to field). What I want...

    ITTechPT95 pointsBadges:
  • Using RPGLE to create data structure definitions

    I'm looking to build a data structure. Let's use the following for an example d Cat           DS                  qualified d   name                        20 d   breed                       20 d  ...

    ITKE54,755 pointsBadges:
  • Can you run Entitiy framework with a DB2 iSeries AS/400?

    We're looking to upgrade to Entity framework to work with our DB2 iSeries AS/400. The DB2 iSeries AS/400 is not a new technology. Does anyone know of any problems we should look for in the upgrade or later performance; and whether this configuration will work at all.

    ITKE54,755 pointsBadges:
  • BRMS Audit

    Someone changed a control group. Is there a BRMS audit file somewhere? V7R1M0

    ppalmeri5 pointsBadges:
  • iDOC to RPG

    I need to write a RPG program interface using iDOC data. How can I do that?

    fbarrett5 pointsBadges:
  • Analyzing Security Audit Journal

    Hello, could you please tell me where can I find a book, guide or course about Tracking and Analizing Security Audit Journal on iSeries?  I have tried Appendix F on Security Guide but there are not all entries and it does not explain how to analize records in journal.  Thanks a lot

    Fabypaumc15 pointsBadges:
  • Interpreting security audit information

    Have switched auditing on for a specific directory in the IFS, information is being collected in the audit journal. Now, how do I actually interpret when a file is deleted? I gleaned I need to look for an LD journal type - when I do a test delete of a file is generates numerous LD types, but I...

    Tinast35 pointsBadges:
  • AS/400 query security

    I have a library we will call liba. In liba i have files for different companies. For eg: files aa01.itm is an inventory file for co# 01 and bb01.cms is a customer file for co# 01. I also have files aa07.itm and bb07.cms. These files are for co# 07.I want to grant someone access to only the files...

    Lougoalie5 pointsBadges:
  • As400 security

    Hi, This is kinda urgent. Is there any way to restrict an user from viewing, writing, deleting anything from my AS400 library... I dont want unknown users to delete, change, create anything in my library or any of the source in the library.. Please help.....

    Nutangujar895 pointsBadges:
  • as400 printing issues

    I have a ta 3501 kyocera mfp! My customer is trying to print a report say 150 page report but they only want pages 5-20 and they select that but it prints the whole report?? ideas?

    isurferdude5 pointsBadges:
  • CL Commands with Independent Auxiliary Storage Pools.

    I have a CL program that errors out with a CPF1080 on the command STRSBS SBSD(MYLIB/MYSUBS). Are there other commands that will have this same problem and is there a list of these commands somewhere ?

    Dcarney115 pointsBadges:
  • after IPL the server is slow for hours

    I have Iseries , and after it finish count from 1 to 48, a black empty screen stayed for about 30 minutes .. and after it start working the server always become very very slow for about 3 hours ... is there any solution to that

    abar1425 pointsBadges:
  • Clearing qsysopr message queue

    When we IMPL the operator message queue (QSYSOPR) is clear. Is there a way to prevent this from happening.

    AS400PCFileTransfer16115 pointsBadges:
  • OVRDBF and OPNQRYF

    Can we write OPNQRYF then OVRDBF with SHARE(*YES) and then call a program. Will this program will process only selected records from OPNQRYF or process all records?

    sunnygupta35 pointsBadges:
  • SQL and OPNQRYF

    What we can do in SQL which we cannot do in OPNQRYF

    sunnygupta35 pointsBadges:
  • Security Level Change from 20 to 30

    I'm being asked to change our QSURITY level from 20 to 30. I do not have much iSeries OS background. What are the major issues with changing this level to 30? Is there any object level access changes that I need to be aware of? Can this be done with relatively little impact on the users?

    BuffaloTrace5 pointsBadges:
  • Duplicate IP addresses?

    How can two laptops have the same IP address? We have a wireless connection to our home computer and somehow we both ended up with the same IP address. This strikes me as infinitely impossible, but it happened, so clearly there is something I don't understand about how IP addresses are distributed....

    Madagaluna5 pointsBadges:
  • iSeries/AS/400 any problems with iseries access in a VDI environment

    Are there any issues with using iSeries access in a VDI environment. Would it work without any special configurations?

    SuzzyQ5 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