• Locked Records

    Is there an easy way to trap a Record Lock in RPGLE

    Doc135 pointsBadges:
  • RPGLE Record Lock Data

    I have a program that get a Record Lock. I have captured the *status, however, I need the Program & User that initially read the record first.

    Doc135 pointsBadges:
  • AS400 subsystem listings

    Not too sure specifically how subsystems are listed in the AS/400. I know there are startup programs and subsystems need to be 'pointed' there in order to autostart? Questions is: Is there a way to list the current autostarted programs and how I can remove them. If there isn't a way to list what is...

    Gramicci65 pointsBadges:
  • AS/400 opcodes

    What is the difference between LOOKUP and XFOOT opcodes? Where can we use these opcodes?

    Icc10 pointsBadges:
  • iDB2 connection String permenant solution

    I have a DB2 connection string to our i-Series that works. "DataSource=10.10.10.10;userid=LIVEXML;password=LIVE1;DefaultCollection=DATALIB031;" We have been developing a lot of apps and web services that use this type of connection. My problem is when our i-Series software is upgraded (about every...

    ToddN200059,990 pointsBadges:
  • How do I check members list for a specific user group in iSeries (AS/400)

    What is the command to request system to list out member of a particular group profile with the assumption that my user ID is just a normal user ID (without SECADM function). Please help.

    Grpprfmbr20 pointsBadges:
  • French accent

    Hi everyone, SAP put a flat file in an AS/400 folder. The format is .csv (with UTF8 specification). When I use the command FTP in AS/400 to get it (User,passw,cd,get.....), every french accent is garbage. I changed the CCSD file, but nothing. I really need help.

    hewitt10 pointsBadges:
  • Convert C Prototypes to RPG

    I need to interface our payroll progam to Vertex Q Series payroll tax software. Vertex is written in C and our payroll programs are in RPGLE. Does anyone know what the RPG prototype to this function would be? PREFIX tVprtConn POSTFIX VprtOpenPRT (char *pDataSource, char *pServerName, char *pUserID,...

    moolar20 pointsBadges:
  • Error in Data fetching

    Hi all, My requirement is i have a CL program which is calling RPG Program R1, which writes data to an Output file PF1. Now i need to Change the RPG program R1 in such way that it should write data to PF0 instead of PF1, and i need to create another RPG program R2 which reads data from PF0 and...

    Sai4AS4001,420 pointsBadges:
  • WRKSPLF options

    Is it possible to add an option to the WRKSPLF screen? Options 1-9 are used but could I add an option 0?

    filuphaze475 pointsBadges:
  • How to Create a new OPTION in the Work With Spool Files screen

    We have a command we want to employ for spooled files, that will utilize the Job Name/Number/User of the spool file, to execute a task. How can I make a NEW Option, so User's can simply put the option (like a "P") on a spool file, to execute the task?

    Grant5 pointsBadges:
  • Authority for all abjects in the library.

    If I'm owner of some libraries, how can I setup the authority to have full access to all objects that will be created in the libraries by the different users. I don't have *ALLOBJ and can't apply group profile for all profiles which will create  the objects. Is it possible to apply individual...

    iSeries9925 pointsBadges:
  • How can view the source of QSYS commands

    Like If I want to see source of 'WRKMBRPDM'(object type both cmd and *pgm) command what should I have to do?.

    Alicsc370 pointsBadges:
  • How to connect to an AS/400 database from a remote PHP script

    Hello. I have a requirement to use a PHP script running under Windows to access a remote DB2/400 on an iSeries. Can anyone please assist in what PHP coding would be needed, thank you! Regards Paul

    PaulTaylor15 pointsBadges:
  • CL program entery missing in JOBLOG

    Hi all, I have a CLP program C1 which is using SBMJOB inside the program to run 5 different batch jobs, and when i submit C1. I am getting Spool entries only for the internal submit jobs submitted by C1, but there is no entry for C1. But I want to get the starting time and ending time of my batch...

    Sai4AS4001,420 pointsBadges:
  • DLYW / DLY-5

    Hi all, When i submit a job, it is straight away going to DLYW status, Some times to DLY-5 status. What could be the problem.. please answer me. Thanks.

    Sai4AS4001,420 pointsBadges:
  • Date calculation using a variable

    This is the original standard date calculation I was using. I need to change the number of months to a variable that I'm getting from a DTAARA. Value is zoned. The error I get isDate, Time or Timestamp value is not valid. I can't find a way to change the one or two digit value to a 'date' field...

    badspeller30 pointsBadges:
  • Difference between RPG & RPGILE

    What is the difference between RPG & RPGILE?

    Ambrish 82310 pointsBadges:
  • How to Clear AS/400 810 drives of data before sending back to vendor

    Need to send a rented machine back to the vendor, but want to format or scrub our data off before I do it. What command can I use to do this?

    JacKieG5 pointsBadges:
  • AS/400 Query: Current Date

    Is there a quick way of running a query to select records based on current sysdate. I know you can get current date using Current command but I can't use it in selection.

    Gerrib150 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