• How to validate data in RPG

    How to validate data (if it is numeric or character or both) in RPG? I have customer file(cus1) and field length of CID is 05. I want to display numeric data only. I don't know how to use indicators, please correct the below code. .............. CID  .  CNAME .............. 1201    chow...

    chowas400620 pointsBadges:
  • Java 7.0 install onto iSeries

    I have followed instructions from IBM and downloaded both the 32-bit and 64-bit versions of Java 7.0 but have not been able to find out how to actually install these .ISO files. I have them loaded into an image catalog and have attempted to install via the GO LICPGM, option 11 but to no avail.  I...

    Camgin55 pointsBadges:
  • Execute SQL SELECT via RUNSQLSTM error

    Trying to execute SQL-statement "SELECT * FROM mylib/myfile" give errormsg SQL9010. Some say that SELECT is not supported with RUNSQLSTM, but IBM command parameter text indicates otherwise. Is SELECT supported and what am I doing wrong?

    DanTheDane2,555 pointsBadges:
  • SQL Connect to remote system, run retrieved data on local system problem

    I need some help with the syntax required to build the SQL commands (embedded into an RPGLE program) that will do the following: Connect to a remote system (using a userID & password passed into the program as parameters). Dynamically build ALTER commands based on data SELECTed from a table on...

    mikechance8126325 pointsBadges:
  • Special characters in COBOL

    Hi everyone, I have a program in cobol400, which is using SQL to remove the special characters with "select replace( "description", "@" , " "). Is there anyway I can remove characters like , ' , and " with the program? Thanks and regards, Vinod.

    MyDataTransfer20 pointsBadges:
  • AS/400 general ledger

    How do I delete / add entries in a closed period in AS/400?

    MelodyAS4005 pointsBadges:
  • AS/400 program object

    Dear AS/400 experts, Is there any mean for me to check if there is any of change/update in my application like, comparing to Windows application, checking the execution file modified date on any specific PGM objects?

    srithea250 pointsBadges:
  • JTOpen jar (any listener) to check for changes to a user profile

    Hi, is there any Listener provided by the JTOpen jar to detect changes on a user profile?

    Pranav0712110 pointsBadges:
  • DFU no show first register in a file

    DFU no longer shows first register in a file. What should I do?

    samgo3055 pointsBadges:
  • File transfer from AS/400

    We need to send a file from AS/400 to address //....com. How can we do that?

    Sroytman15 pointsBadges:
  • Calling RPG Proc from COBOL ILE

    This article was very helpful. I have coded and compiled my CBLLE program. Now when I call it, I am getting error RNX0115 'Length of varying length variable is out of range.' Here is my COBOL call statement: CALL PROCEDURE "ENT002_RMVBADCHAR" USING BY VALUE C86D1, GIVING RETURN_VALUE. This is the...

    CLMccarthy5 pointsBadges:
  • Convert spool file to .PDF with overlay

    Why is my overlay changed when I convert the file to .pdf? This is my code: OVRPRTF FILE(BOLPRT) DEVTYPE(*AFPDS) PAGESIZE(11 8.5 + *UOM) RPLUNPRT(*YES '-') DRAWER(1) + PAGRTT(0) UOM(*INCH) FRONTOVL(MXBOL) + SPOOL(*YES) OUTQ(*DEV) COPIES(4) + HOLD(*YES) WSCST(*PDF)Call the program.... CPYSPLF...

    mdawson65 pointsBadges:
  • Deleting selected AS/400 spool files by date range

    Is there a way to delete all spool files from an OUTQ for a specific date range or leaving all files after a specified date?

    EGibson15 pointsBadges:
  • Read selective file in CL by using OVRDBF

    How do I read selective file in CL by using OVRDBF by positioning to from particular record till selective record? Lets say I have Emp (record format is REC) file which is having 10 records (rrn or key field). Now I want to read file from 2nd record till 8th  record, how can we do this with...

    hndajad195 pointsBadges:
  • Transferring a ZIP file from local PC drive to save file on AS/400

    Hi, I need to transfer a ZIP file from local PC drive to save file on AS/400. I tried using FTP but was unable to do so. Can any one please tell me how to do it?

    Niladri20155 pointsBadges:
  • HTTP/1.1 400 bad request consuming .NET webservice via AS/400

    Does anyone know the OS/400 requirements for connecting to .NET web service? I need to know how to resolve HTTP/1.1 400 Bad Request. The XML request is correct when I run it thru SOAPUI - I don't believe the request is making it out of the AS/400 and I cannot determine why.

    angelafrye30 pointsBadges:
  • Consuming .NET webservice from AS/400 using RPGLE example

    I am trying to connect to a .NET webservice via AS/400 using RPGLE and am getting the 400 Bad Request error yet the XML is correct if I run it thru SOAPUI.  I can't find the problem. Does anyone have an example of code that works correctly or can tell me what I'm missing on the AS/400 side?

    angelafrye30 pointsBadges:
  • How to use in two physical files using in KLIST

    I'm using two physical files in a KLIST program. I'm looking for the MVR opcode. Can someone help me?

    baluyadav1435 pointsBadges:
  • AS/400 user profile usage

    How can I tell if a user is using another user profile in AS/400?

    GinaSarroino15 pointsBadges:
  • I want to move data from files into a folder in AS/400

    The problem is represented by the names of files, because on my pc files have file 111-10-2005.txt(name=name+data) and in AS/400 files are just file1 file 2 and so on. I don't know how to manipulate this problem.

    obretingeorge10 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