1
  • MQ Triggered job takes a different library list to the predefined job description

    I have defined a MQ process with JOBD e.g. JOBD(QMQM/QMQMDEVD) JOB(MQTRGJOB) RUNMQTRM submits a batch job "TNTMQTRG", but the job's INLLIBL was not changed in accordance with the defined JOBD e.g. QMQMDEVD which has more libraries defined. RTGDTA was not changed either although I have changed to...

    bluesky21c5 pointsBadges:
  • AS/400 activation group and triggers

    Interview questions- please help me guys. I have two jobs and these jobs are accessing two different files. What is the default activation group (or activation group) is taken in these jobs? I have no idea about triggered programs, please help me. I have one triggered file and too many programs...

    chowas400225 pointsBadges:
  • Physical Files with triggers

    I am implementing existing files that have triggers. Do these triggers need to be removed from the files before implementing the file changes and then added back after the changes are implemented? Thank you,

    vrs235535 pointsBadges:
  • Hi, AS400 – SQL triggers for tables

    Hi, 1.Could any one let me know whether AS400 SQL Triggers will accept cursors. 2. DOW is also not accpeting.Instead i tried the below code, but even then i am getting SQL0104 error. Declare c1 Cursor For Select STATUS from T_RODTLS TR Where TR.COMPANY_CODE = @Company and TR.VPC_CODE = @VPC and...

    As400pgmmer305 pointsBadges:
  • TRIGGERS and commitment control

    What is the difference between TRIGGERS and commitment control?

    new40075 pointsBadges:
  • AS/400 Triggers: Batch programs don’t write to trigger file

    I have some triggers set up on our AS/400. A record gets written to a physical file each time one of the triggered files has an add, update or delete performed against it. The problem is that we have a few batch programs that do not write to the trigger file when run (and update and addes are being...

    JenniferK15 pointsBadges:
  • Validation in as400 trigger

    Hi, I am using CLLE trigger program to validate a pf. During any invalid data is inserted, i would to show a error using SNDPGMMSG SNDPGMMSG MSGID(CPF9898) MSGF(QCPFMSG) MSGDTA('ERROR') + TOPGMQ(*PRV) MSGTYPE(*ESCAPE) But when i tried to insert the invalid data, the insert operation is rejected,...

    LakNar270 pointsBadges:
  • AS400 Trigger – Old and New Fields

    I am trying to create a log file for my physical files that shows me: the file name, the program making the change, the date of change, the name of the updated field, the old value, and the new value for that field. From what I've seen triggers only give you the RECORD old and new values but not...

    Dns68965 pointsBadges:
  • Execute trigger only on update of selected fields

    We have created some trigger programs in COBOL that should be executed only if certain fields change. When creating a SQL-After trigger and -program on a file I can specify that the trigger should run only when specified fields are updated by using: AFTER UPDATE OF {fields} ON {file}. Unfotunately...

    r.otto810 pointsBadges:
  • Where is the error log of an AS/400 trigger?

    when a trigger added to a file on the iseries generate execution errors the log of the program where it is ?  if the trigger program has an internal list where I look? Gracias por su ayuda

    CRAMIREZ25 pointsBadges:
  • Create trigger using iSeries Navigator

    I am trying to ceate a simple trigger to a table to update a history file with the old rate when the rate changes in the master table. I have gone as far as creating the sql statement, but I am not able to make it to work (my sql is very limitted). Would it be possible to have some example that I...

    Myhandle5405 pointsBadges:
  • AS/400 Physical File Triggers

    I added a physical file trigger for *after and *insert. When I do an insert, the trigger does not call my program and I get a CPF502B message.                                                                              ...

    AS400X35 pointsBadges:
  • RPG/400 Trigger Program

    RPG/400 trigger program was suggested to develop a moving average computation. There's a rule that needs to be followed when posting a record in the computation. One rule is that all credit transactions be first posted in the computation - Is this possible in a trigger program? How could I...

    Elm0215645 pointsBadges:
  • ODBC and AS/400 trigggers

    Will a AS/400 physical file trigger work when the file is updated by ODBC?

    Jjjlake40 pointsBadges:
  • Tracking data changes on IBM i with triggers

    Hi I like to implemnet this tip can you share the sources files of this tip

    Ecuafruit5 pointsBadges:
  • Journaling and Commitment Control

    If I have journaled a file with After Update parameter, how will the commit/rollback work??

    Reenasudarshan65 pointsBadges:
  • AS/400 script or program needed

    I want script or a program which can be called so that i can get the specific information from the system and prints for me in Spool file. For example, i want to know all the PF which are attached to Triggers and their action and also the library. Can any one give a sample script for this or any...

    ITStarter5 pointsBadges:
1

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