• How to retrieve the “created by user” attribute for IFS objects ?

    Hi, I'm writing a program in RPGLE to fetch certain attributes of IFS objects (directories, folders and libraries), attributes like date created, date last accessed, etc. I've found an IFS API (Qp0lGetAttr) which retrieves all of the attributes I need, except one - the user who created the object....

    ShantanuBiswas0 pointsBadges:
  • How to see the source for the AS/400 objects?

    I am having a server at my office which has a project application running on it.I need to access the Cl/RPG/CMD/PNLGRP and file objects on it to modify them and restore.I tried for the DSPOBJD and *SERVICE to find the source library and file but couldn't retrieve from that combination. I think the...

    ten20081,150 pointsBadges:
  • RSTOBJ *SAVF authority issue – AS400 – JBA

    We had weekly job that submits to Batch from our JBA MENUS and the CLP pgm does a rstobj from *SAVF that used to work because the User profile on the external AS400 was the same Userid as the object on our AS400. They deleted that userid on their system because of SOX requirements and so now it's a...

    FrenchyinCT10 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:
  • lock out access to communications drop down menu in client access emulator

    We need a way to prevent users from changing or creating .WS files.  The reason is that we have an external application that prints the patient arm bands to a printer based on an external table which uses the WorkstationID to Map printer.  Users are always modifying this and breaking the...

    KatanaBeach115 pointsBadges:
  • If Function

    is there ONE multiple IF function formula to inclue all of the below if INS = nd and order is less than 5000 then 0% - - if INS = nd and order is 5000 to 11999 then 70% - if INS = nd and order is 12000+ then 8400/order if INS has a value then INS/order

    Newinfrance15 pointsBadges:
  • embedded sql update

    I have a prog that should update all KY cust master records with the new code AR. I run the program but nothing happens. The file remains unchanged. I am new to embedded sql so what am I doing wrong ?? D OLDWH           S              2    INZ('KY')    D...

    ToddN200092,795 pointsBadges:
  • STRPCO ERROR

    My test program uses STRPCO and then STRPCCMD PCCMD("C:test.bat").When I call the program twice,it will ocurse error.Error message likes "Client access AS400 Oganizer already active in device XXXXXXXXX".I don't know why.Thanks.

    AS400STRPCOERROR5 pointsBadges:
  • Any Better substitue for RCLRSC?

    We are getting error message when we change the libraries in succession in AS400 (libl rpl command is used). Our AS400 systems were upgraded from V5R3 to V5R4 last year. We did not face such issues previosuly in V5R3 version. Could someone please let me know if this error msg is due to Version...

    Charanya5 pointsBadges:
  • client access problems with v5r0m0 & windows vista

    i have problems for connect my pc windows vista with pc5250 and transfer with as/400 os V5R0M0. can you help me, i know that this version is very old, but i don't have other option of comunication.

    Capelo5 pointsBadges:
  • How to make a batch job run faster (excpet for the run priorty), Code changes?

    HI, I have a batch RPG programs used to do some updataions and reporting, currently the job takes around 1 sec to process a record. We want to further reduce this time. Changing the run Priorty may make the job run a bit faster, are there any other parameters that can be used? also am looking at...

    Caprius0 pointsBadges:
  • How can you get the replace option on the as400 DBU to work?

    I needed to massage a file to change a field from 1 to 001. It would of been an easy excersise if I could of got the replace option of as400 DBU application to work. The online instructions have a large amount of intell about how to search but nothing I could find about the replace utility. thanks

    nitzinger385 pointsBadges:
  • how to load client express on window 7

    how to load client express on window 7

    Zman10 pointsBadges:
  • Message Monitoring

    My manager wants me to be able to monitor messages for our two AS/400s. Is there a way to send break messages to my desktop for the qsysopr messages. I have to remember to display messages every hour to see if there are any messages requiring a reply.

    TRFCTL20 pointsBadges:
  • AS/400 Query – Timestamp of entry to char field

    Hi friends, I am creating an account file with the command below: DSPJRN JRN(QSYS/QACGJRN) FROMTIME('26/09/2009') TOTIME('25/10/2009') ENTTYP(SP) OUTPUT(*OUTFILE) OUTFILFMT(*TYPE4) OUTFILE(QTEMP/QAPTACG4) How can I convert the Timestamp field called JATSTP to a new char field with the first four...

    RBDSILVA550 pointsBadges:
  • need a process to obtain set of records updated/added out of 100million records

    Hi, We need you suggestion in the following design. We have a file with 100 million records.This file is updated on daily basis by more than 50 jobs.We would like to obtain the set of records from those 10 millions records, which are either updated or created on that day.Since we don't have any...

    Sugaar0 pointsBadges:
  • Date Keyfield in a Physical File

    Hi, Is it possible to have a Date as one of the Keyfield in a Physical File and access the same in a RPG/RPGLE Program using the KeyList?

    Cganeshh0 pointsBadges:
  • WRKJOBSCDE every *other* week

    Does anyone know how to use the IBM scheduler to submit something every *other* week or every third week, etc? Thanks, Kevin

    TylerDurden0 pointsBadges:
  • SNDDST TYPE(*DOC) not working for big files

    We are using SNDDST to send reports via internet e-mail. It works for small reports (text files) but not for larger ones. No error is shown when issuing the command. QSYS/SNDDST TYPE(*DOC) + TOINTNET((sbchenry@hotmail.com *PRI)) + DSTD('Sending a Text') + MSG('Find the report attached.')+...

    SBCHenry30 pointsBadges:
  • Stored Procedures on AS/400

    Greetings, I understand SQL stored procedures on the AS/400 generate C source code which is compiled to create a C ILE program object. I could use the same SQL statements in an RPGLE with embedded SQL program and use that to create a RPG stored procedure. Which of the two is more efficient? Thanks...

    Ashnirody100 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.

Thanks! We'll email you when relevant content is added and updated.

Following