• Adding a field when using SQL to copy a file on iSeries

    My company is upgrading some applications and I need to copy the data from current files into the new files. In some cases the new files have additional fields. Is there a way with sql to copy the current data and at the same time add either a default value or a running sequentional value to the...

    CLK35 pointsBadges:
  • SETLL & DOU

    When I use SETLL and DOU , the loop is being executed only once. I am not able to process the next records. My actual code is @Key Setll File1 DoU %EoF Read File1 If ......... EndIf Enddo After reading 1st record it is coming out of loop. Please anyone help me.

    NAN4AS40095 pointsBadges:
  • How to use a file in a program with 2 key fields so that we can access the file using single key

    I am working on a project where I need to delete old transactions from a particular file in a particular library. The file has 2 keys. For deleting the older records, a particular logic flow is followed. The actual delete process is written in a Cobol program. The cobol program is called inside a...

    sanras12330 pointsBadges:
  • Reading records from a file (No Key Field) in reverse order through CL.

    Hi, I just want to know how to read a PF in reverse order through CL. File has no key field. I am trying this using OPNQRYF but I'm unable to get. Kindly let me know the code. Thanks

    HABBIE820 pointsBadges:
  • conditional calculation

    want to create new field e.g. DATE2 = CURRENT DATE - EXPIRY DATE. how would I represent current date in my formula

    jharding5 pointsBadges:
  • AS/400 Spool file not printing

    We have Panasonic DP-8020P LAN printer connected with network and working fine on windows environment. Now we want to use it for printing reports from AS/400 spool files. We have created device using CRTDEVPRT command and using PC5250 printer session with same workstationID but when we print spool...

    hunshabbir71,440 pointsBadges:
  • Upgrading IBM Integrated Web Services server to Axis 1.5

    Does upgrading IBM i from V6R1 to V7R1 also upgrade the IWS server from Axis2 1.3 to 1.5? or does it leave the configuration as is and you still have an option to upgrade it yourself?

    JediK45 pointsBadges:
  • Download data from iSeries to Excel

    How do I download data from iSeries to Excel?

    lr538615 pointsBadges:
  • Fetching Duplicate records from a file

    Hi,I have file EMP: with ID,name,Department columns. Id as key field. There are more than a billion records with 50,000 duplicate records .I just want to fetch only those duplicate records on a single query. Thanks

    HABBIE820 pointsBadges:
  • FTP from AS/400 (iSeries) – NO RECORD SEPARATORS

    Is it possible to FTP a file FROM AS/400 (iSeries) to Windows with no record separtors (no carriage returns or line feeds)? I am able the transfer the file to a Window folder with a fixed record length by using LOCSITE TRIM 0, but I also want to not have any record sepators.

    BUEHLER20 pointsBadges:
  • How to convert RPG to a .txt file

    How do you take a regular source member and convert it a .txt file?

    Joe9455340 pointsBadges:
  • How to define HELP with control options in RPG

    I am new to RPG. I want to define HELP with the options I have given with my application, so that user presses F1 over options (e.g F8 etc) and a help window appears and show him what F8 do? Thanks in advance.

    hunshabbir71,440 pointsBadges:
  • Create a CLP program script

    Hi All, Can anyone help me in resolving the below issue. Requirement: Want a CLP program script in which i can send the user profile objects from one LPAR to another LPAR. We will schedule that in our job schedule entries.  Once initiated the job it should ask for a user profile name to enter it.,...

    mn9831220 pointsBadges:
  • Regular expression for the IP address fails

    hi all, I'm trying to validate the IP address with the most accurate regular expression that I found in internet, I have fail in every try that I have , so , below is the first part of the regular expression and should not fail with a single number between 0 - 255, but fails , it looks to me that...

    GraceP415 pointsBadges:
  • AS/400 user ID login to different subsystem

    By default all the users login to QINTER, I want to login my profile in QCTL, please advice, Thanks.

    Syedm180 pointsBadges:
  • Flashcopy error message ADR316W when backing up target volume

    I'm new to DFSMS Flashcopy and would like advice. I used the following JCL step to backup a source volume to target volume. //STEP901A EXEC PGM=IKJEFT01, // REGION=0K //SYSTSPRT DD SYSOUT=* //SYSUADS DD DSN=SYS1.UADS, // DISP=SHR //SYSLBC DD DSN=SYS1.BRODCAST, // DISP=SHR //SYSTSIN DD * FCESTABL...

    Liberty5 pointsBadges:
  • Minolta Drivers for AS/400

    Hi, where can I find drivers for b43 minolta drivers for AS/400 printing? Devan

    devan390 pointsBadges:
  • Migrating DFSMS COMMDS at DASD migration

    At DASD migration how to migrate DFSMS COMMDS ?

    Trf0 pointsBadges:
  • Interform400 printing on dot matrix printer

    I use interform400 and want to know if anyone else is using this useful tool. What I really hunting is for the overlays to be wriiten on a dot matrix

    devan390 pointsBadges:
  • Execute start macro in AS/400 session in a CL PROGRAM

    How to execute start macro in AS/400 session in a CL program?

    Messam40 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