• ODBC Library list

    Dear users, If we are using Excel to get External data from iSeries, can we add a library temporary to a predefined Data source such as we can do during File transfer Properties?

    chalenger455 pointsBadges:
  • 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...

    ToddN20006,360 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:
  • What is ovrdbf?

    Hi all, Actually I know OVRDBF is used to override database file. After OVRDBF, we have to use OPENQRY command. But my question is: What purpose this OVRDBF file created and after creation it will be accessible to all the programs at a single time? Meaning can we access OVRDBF file in multiple...

    Sms121185 pointsBadges:
  • Retrieving data from AS/400 tables with PHP?

    I think I will die! Does anyone know how to get data from a table on AS/400 displayed with PHP through ODBC? I'm starting to go mad. I tried ODBC drivers (iSeries Access client, Client Access). Nothing helps. I have Apache server as localhost on my machine and PHP installed and that works fine. The...

    Avrelivs80 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:

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