• Join files using OPNQRYF

    I'm not much familiar with complex OPNQRYF statements. I need to select records from a file say FileA which has a field AccNo. I need to select those accounts whose country code ='002'. Country code comes from another file say FileB. FileB has account number as key. I know this is simple, but I am...

    RamvishakRamesh2,505 pointsBadges:
  • WRKOBJPDM license?

    I have a new AS/400 V7R1 and each time I use WRKOBJPDM, it gives a CPF9E72 message in *SYSOPR (Usage limit exceded) in product 5770WDS feature 5103! What's wrong?

    Apalma15 pointsBadges:
  • Dynamic operator on WHERE statement

    I have a file that has 2-fields that will be used to select records from file B. File A, field 1 = date_a & field 2 = Operator. I want to select records from File B and based on the value within the operator ( EQ, LT, LE, GT, GE) and the date_a. Ex: If in File A, the value of the field Operator...

    ibBusy4sure50 pointsBadges:
  • Convert time stamp to dd/mm/yy

    How can I convert a timestamp field(declared with type 'Z' in database) to dd/mm/yy format in RPG?

    RamvishakRamesh2,505 pointsBadges:
  • Transferring data between iseries without using DDM/FTP

    Is there any better way of transferring data between iSeries without using DDM/FTP?

    Sv2250 pointsBadges:
  • Sessions disconnecting from AS/400

    I have 10 users accessing a remote AS/400 using Windows PCs via Client Access. We have been connecting without problems since 2006. Last 2 months we are having many disconnections. PCs are setup OK Time out is set up as unlimited Broad band is stable Cisco firewall is OK Cat 5 cabling is OK At a...

    CUK5 pointsBadges:
  • 3812 printer fonts

    Is there a way to change the font thru the override print file command. The printer emulation is 3812, I am looking for a "softer" font. The font that is being used looks too much like a typewriter.

    Piano520 pointsBadges:
  • COBOL/400 – Time stamp

    Hi, could anyone please advice me how to use time stamp in COBOL/400?

    Anu143525 pointsBadges:
  • How to run JSP with Tomcat on OS/400 V6R1

    I'm replacing an iSeries by an I5 V6r1 but it appears that I cannot use Tomcat any longer to run JSP applications. What should I do?

    JPPLOU125 pointsBadges:
  • How to send mails to group when error receives in QSYSOPR

    We have 5 admin users, So We need to get an email when system will reach threshold or system jobtable nearing capacity. For that how to monitor the messages, and when it reaches the error point How to send mails to a group.

    venkatktata285 pointsBadges:
  • Trigger removed

    How to know if some one had removed the trigger from the file? We have a situation like this so how to know who did that? Shall we get the data from journaling?

    Anu143525 pointsBadges:
  • Trigger

    Guys, we got a problem here...our file is associated with Insert and delete trigger. So will an SQL delete query execution trigger the job attached?

    Anu143525 pointsBadges:
  • FTP a file from AS400 to VOS Stratus

    Need to transfer an AS400 physical file to VOS Stratus operating system and store file in a library on the remote system (Stratus0. I would like to seutp a CL program on the AS400 server to initiate this file transer to the VOS Stratus operating system. What would be the commands to use for my CL...

    harpsk95 pointsBadges:
  • AS/400 batch commands – make changes to user profiles

    We are supporting OS/400 V7 R 1 and we need to know the commands to make the following type of change. (We are new to AS/400). We need to know how to change the OWNER field to *GRPPRF for all user profiles that belong to the group profile of (DEVUSERS). There are over 1,000 user profiles that...

    harpsk95 pointsBadges:
  • How can we add monitoring of messages in SDMC and send emails to particular group?

    Hi, How can we add monitoring of messages in SDMC and send emails to particular group. for example...CPI1468(System job tables nearing capacity) and system threshold. Thank you, GK

    venkatktata285 pointsBadges:
  • Why there is a partial library backup?

    Hi , Greetings for the day, The backup job went in to MSGW state with CPF3777 (800 libraries saved, 1 Partially saved, 0 not saved) We used to take backup using Flash copy as we are using V7R1 OS with backup cluster. Kindly understand me what happened in that backup. Why there is a partial library...

    venkatktata285 pointsBadges:
  • Using pointers

    I need to update a lot of fields in a record testing on an internal array if that field is "updatable". This should be: FILEFIELD001 = DSFIELD001  for each updatable field. I wonder if could be possible to use pointers to change values in a record and then update that record? In other words,...

    Luca195715 pointsBadges:
  • CPYF alternative

    Hi, One of out Auto start job is locking a file (A). (triggers are used and it is designed like that only) And another program which copies the file (B) in to (A) by CPYF is going to MSGW, telling the object is locked. How we can overcome this...are there any alternate solutions to copy that file?

    Anu143525 pointsBadges:
  • SQL server native webservices and PHP

    Hi, I have a SQL server 2008 database and I need to query it from PHP running in a Linux box. I thought that using webservices was our best option. I am trying to use native HTTP SOAP in SQL server. Following some tutorials, I made first an SP USE [Basededatos] GO /****** Object: StoredProcedure...

    Claubolson35 pointsBadges:
  • CPF511D error message in second ReadE while passing parameter

    I have an external DS defined on my program. I am doing a READE operation on this file and am passing it as parameter to another program. After returning from the called program, my program again does a READE where it is failing with CPF511D error. Joblog says Parameter integrity error occurred...

    RamvishakRamesh2,505 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