• 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:
  • 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:
  • AS400 Query Dates

    How do you computed dates in Query

    Philip915 pointsBadges:
  • Timestamp InCOBOL/400

    Can we use Timestamp in COBOL/400. If we can, how?

    Michael Tidmarsh28,985 pointsBadges:
  • Emails from server

    Hi, I need to find how many mails have been sent from my server. I also need to know that address. How can I track that?

    kingstoniseries205 pointsBadges:
  • Firewall preventing NET USE drive mapping PC to iSeries.

    Does anybody know what ports are used when I run net use * \\servername\share PWD /User:USER ? The firewall is stopping it somewhere although ports 137, 139, 445, and 8471-8477 are open on the firewall. It eventually times out with "System error 53 has occurred - The Network Path was not Found"...

    stropley10 pointsBadges:
  • Call a iSeries stored proc from a SQL server 2005 stored proc

    Ok I'm missing something. I've tried entering a few examples I have found in forums but can't get past a syntax error I cannot find. I'm using a linked server as well. Here is the code for the SP. Any pointers would be great! USE [MyDB] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER...

    ToddN20008,925 pointsBadges:
  • IFS to Spool

    I want to Convert IFS PDF File to Spool. How can I do that?

    rajeshece1,215 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