• Duplicate key on access path.

    I have a physical file PF1 with some key fields(K1,K2,K3). PF1 has say 5 logical files with different keys(K1,K2...K5) I am trying to update only a field of PF1(that field is not a key in PF1) using SQL(stored procedures) PF1 has unique keyword mentioned.But the update is not made on key fields....

    anuppdas105 pointsBadges:
  • Problemas despues de hacer un ENDSBS

    Amigos, tengo el siguiente problema, cuando bajo los subsistemas con un ENDSBS o un ENDSYS y despues levanto los subsistemas con un STRSBS QCTL no me levantan las pantallas verdes, la solucion que encontre fue dar IPL pero necesito que me ayuden a saber como puedo solucionar este tema sin tener que...

    nahuazky5 pointsBadges:
  • Workstation Entries vs Communication Entries

    I'm lagging with a clarity between Workstation Entries and Communication Entries. Can anybody explain me about which is meant for what ?to my understanding Workstation Entries are workstation devices for logging into the system for interactive work ?Communication Entries - ? this also do similar...

    qmaster1,675 pointsBadges:
  • We have one AS/400 printer of HP model

    We have one AS/400 printer of HP model, its printing first print and then stopping, every time we have to start the printer. Can you please suggest why this is happening, and how can we fix this.

    anusuiyasingh5 pointsBadges:
  • FLOWCHART Generator for COBOL

    Does anyone know of a product for generating a flowchart for existing COBOL code on the AS/400?

    RPGCRAZY30 pointsBadges:
  • Create Excel from AS/400 with multiple sheets

    I have a requirement to generate an excel from 2 different PF as 2 sheets in a single Excel file. I have created single sheet excel using CrtCsvDta command. Please help me to figure out to generate multi-sheet Excel from AS400.

    RamvishakRamesh2,505 pointsBadges:
  • AS/400 RPGLE

    0001.00 DBXLATER1 pr 50 0002.00 Dinpstr 50a 0003.00 PBXLATER1 b 0004.00 DBXLATER1 pi 50 0005.00 Dinpstr 50a 0006.00 Doutstr s 50a 0007.00 Dwork s 1a 0008.00 Dpos s 3s 0 inz(0) 0009.00 Di s 3s 0 inz(0) 0010.00 Dlower c 'abcdefghijklmnopqrstuvwxyz' 0011.00 Dupper c 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'...

    JSDHFKJHA335 pointsBadges:
  • Retrive Day from a field which holds date

    I have a file which has a field say FieldA which is of type 10A. It holds date in Format DD/MM/YYYY. Through an RPG program, I'm reading this file and when the Day in FieldA is a Saturday/Sunday I need to perform some set of logic. How can I extract the day from FieldA?

    RamvishakRamesh2,505 pointsBadges:
  • Future of AS/400 Admin and Support Jobs

    I have been working with AS/400 for the past 4 years. I know that IBM is shutting down its support for V5R4 now, and also that V7R1 is going to be the last version of OS that a power5 box can have. I think most of the customers may not be upgrading to a new physical box, I'm not sure but I think in...

    AdminAS40015 pointsBadges:
  • Command overview

    What are the different commands to see a file/table in an AS/400 database and also some commands to update, create table, insert record (data)

    prabhat045 pointsBadges:
  • Steps to debug the batch job which is active

    If a job is in held state, we can give STRSRVJOB and STRDBG and RLSJOB to debug the PGM. But I need the steps to debug the batch job which is active?

    dinuas400510 pointsBadges:
  • ORGANISATION, DYNAMIC READ

    Can we dynamically read a database file whose organisation is sequential ..?

    Durgesh813370 pointsBadges:
  • STOPRUN, EXIT PROGRAM, GO BACK commands

    What is the difference between STOPRUN, EXIT-PROGRAM, GO-BACK in COBOL/400?

    Durgesh813370 pointsBadges:
  • Get average through WRKQRY

    I have a file which has daily balances. I need to find the Average of the daily balance as the last record. I have selected the report summary functions from WRKQRY and have given (2=Average) on the desired field. I have selected the output type as 3 = data base file. After this if I take a F5 I...

    RamvishakRamesh2,505 pointsBadges:
  • Disappearing reports

    I have a client that claims that his reports disappear over night. He runs his reports converts them to PDF and then the next morning when I check them they are in a FIN status. He claims that they are not being printed off. I can find no history of anything being done to them. I am totally stumped

    jmurfitt40 pointsBadges:
  • In place upgrade from SQL 2008 R2 DEV to SQL 2012 SQL

    I have been working with SQL Server for many iterations and from the old days I remember the mantra “Do NOT do an in-place upgrade.” I'm about to upgrade from 2008 R2 DEV and TEST systems to SQL Server 2012 using the same hardware. I want to do it this way so that I don’t have to reconfigure...

    ITKE334,795 pointsBadges:
  • DB2 HADR configuration

    Hi, wanted to check if anyone of you have experience in DB2 HADR configuration with 'reads on standby' enabled. We are looking for auto fail over between the nodes and balance the reads between the nodes. Does anyone has any prior experience with this configuration on the AIX environment? Thanks.

    kbsantosh15 pointsBadges:
  • Help with iSeries CRTLF command

    I need to create a logical file over a physical file. Can someone help me understand what I am doing wrong. The physical file is in library IDSDAYA and is called OOIORDDP. It has 6 members and I am interested in creating a file where I can access the data in three of the members at one time. I...

    mgrady15 pointsBadges:
  • Share objects between two AS/400 machines on a same network.

    Hello, I would like to know if it is possible to share a disk between two AS/400 machines. I know about DDM but I would like to know if it is possible otherwise. Thanks.

    al7iss140 pointsBadges:
  • Deleted Object not Found in Audit Log

    I found a Program object present in the system when I did a DSPOBJD for a library last week. But today, when checked the object is not present in the system. I checked the AUDIT Logs (DSPAUDJRNE, DSPJRN, CPYAUDJRNE) with DO, MO etc. But this object has not been registered anywhere in the Audit logs...

    AdminAS40015 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