• Command Prompt Override for CL Commands

    Hi, I am managing a very large project that has morphed time and time again. Presently a new release of a third-party application that requires tight coupling with various aspects of the primary application was introduced. Instead of the Jr. Programmers going back time and time again to substitute...

    Doogen0 pointsBadges:
  • triggers

    i know you can attach a trigger to a physical file, but can you attach one to a print file or even a display file. thanks in advance

    Cowboypgmr0 pointsBadges:
  • OVRDBF in JAVA

    I am trying to insert records to a member in a PF through JDBC. Tried with QCMDEXC in Java. But the member is not being overridden, inserting records in the First Member-always. What may bethe cause? Can any one suggest the possible solution for this?

    Cganeshh0 pointsBadges:
  • OVRDBF in Java

    I am trying to insert records to a member in a PF through JDBC. Tried with QCMDEXC in Java. But the member is not being overridden, inserting records in the First Member-always. What may bethe cause? Can any one suggest the possible solution for this?

    Cganeshh0 pointsBadges:
  • To retrieve data from a remote system

    Hi, I have to retrieve data from a remote system (May be of any operating system) and shall put into AS/400. This process should be automated and there can't be any manual intervention. We can not use FTP commands here. Is there any other way this can be achieved. Can?t go for MQ Series either as...

    Helbert0 pointsBadges:
  • Additional options for spool files

    I would like to add an option to the Work with Job Spooled Files and Work with All Spooled Files screens that will perform exactly like option 2, except that the default for the DUPLEX parameter is (*YES). TIA for all replies.

    HowieK0 pointsBadges:
  • Source for a the DSPPGMMSG command

    Dan wrote in with this question recently: "I'm trying to find the source for a command called: DSPPGMMSG. I have version 3.2 RPG & CL. I'm trying to run on a 5.2 box and this command is used extensively throughout the CL's. Any info would be greatly appreciated." Can you help Dan out? -- Debra...

    DebraTart0 pointsBadges:
  • Time Stamp Issues

    Two questions about time stamp: 1. Is there a way to copy members/files etc so that the new member/file will still have the original time stamp (change date etc.) 2. Is there a way to update the member/file change date/time to a specific date/time (without actually saving it) ? thanks !!

    GonenSho0 pointsBadges:
  • verify data file

    Hi everyone! I've a CL program that copies a spool file into a PF file. Is there any way to compare both files, in order to assure they have the same information? Thanx in advance :) Meli

    MelissaG20 pointsBadges:
  • SNDDST with .csv or .xls attachment

    Can someone tell me how to send an attachment with a .csv or .xls? When I try, it sends it as .txt and when you open it up, it's all garbage! Also, how can I add headings to an .xls or .csv when using cpytoimpf. All I'm getting now is just data. Thanks!

    Carolh0 pointsBadges:
  • STRSEU a member and display a message while edit is starting.

    how can I run the command STRSEU and display a message to the user when the source is displayed. the message can be displayed in the TOP command line or anywhere else on the screen. thanks !

    GonenSho0 pointsBadges:
  • How to operating with Multiple Member PF in RPG ?

    I have a multiple member physical file and I want to operate(read/update/delete) with specific member in RPG. The member name for that PF need to be set at runtime depending upon from which program this rpg program is called. I am writing the sample code that I was trying, but it ends up with...

    Inlog10 pointsBadges:
  • STRSEU macro – how to run Repetitive tasks on source members

    I want to run few CHANGE commands on list of source members and add some logic to the CHANGE commands - e.g. if a source line contains 'AAA' then do CHANGE 'BBB' to 'CCC' I want to be able to run it in Foreground and Batch. For those of you who understand z/VM or Z/os - I am looking for something...

    GonenSho0 pointsBadges:
  • rpg

    We just upgraded to an iSeries box with 5.3. We were running 4.6. My RPG programs function properly until I recompile the program. Then I get an compile error 7073 regarding the length of a key field not equal. The compile shows BIN2 (and sometimes multiples) after the other key fields and I can't...

    Kahenry0 pointsBadges:
  • AS/400 Program To List Physcial Files with Deleted Records

    We currently have a program to list Physical Files with Deleted Records. The CLP utilizes the DSPFD command to build an out-file. The parameter for 'Type of Information' is *MBRLIST and 'File Attributes' is *PF. However, the out-file lists the data at the member level. Also, teh job takes TOO LONG...

    Jmnram40 pointsBadges:
  • Best way to retrieve values, SQL or Queries and how?

    Hello everybody, my problem is, in a iseries i have ia file and in this file exist one field with 10000 lenght (character) and i want retrieve a value like (  60F: ) but i don´t know in what position, after i find this value i need the follow values. ex: this is a part of one record  {4: ...

    BUG68235 pointsBadges:
  • Job Log

    I am attempting to have the Job Log for a specific CLP end up in a specific output queue that is different from where we want the rest of the Job Logs to go. I have attempted to use OVRPRTF, CHGJOB and even set up a unique JOBD to no avail. Does someone have an idea as to what will work for a...

    wpoulin2,480 pointsBadges:
  • How Can I pass multiple USER ID’s to QEZSNDMG

    Does anyone have an example of passing multple user id's to the API QEZSNDMG?  I have a CL that calls QEZSNDMG and it works fine with one user or *ALLACT.  I need to supply a list of multiple users that I can pass to it.  Anyone have an example of that?

    GaryT50 pointsBadges:
  • FTP through CLP program

    Hello, I have a script written for 'INPUT' file during the FTP process. The user-id and the password are being hardcoded in the script.To maintain the security I want to encrypt the password alone in the script.May be when the FTP is in action, the password can be retrieved from a file or data area...

    Sris198655 pointsBadges:
  • Database Creation using CLP

    Hello Everybody, I have a small question. First I will explain my requirement. Requirement: I have a database file let’s say “PF1”; I am fetching some records from this file based on some criteria. This fetched record I have to write to one database file “PF2” (This contain six fields)....

    BibinGeorge130 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