• Transfer data from iSeries RPG to Excel

    How can I transfer data from iSeries RPG to Microsoft Excel?

    Rmw10 pointsBadges:
  • ZPL Code for RFID TID in Barcode

    Hello, I'll start with what I have. I have: Labels: 4x2 RFID labels Printer: R110Xi4 (300dpi) and a scanner that ONLY reads these types of barcodes: Code 128, EAN-8, EAN-13, GS1 DataBar Expanded, GS1 128, GS1 DataBar Coupon, UPCA, Interleaved 2 of 5, UPC Coupon Code, PDF-417, and QR Codes. Here is...

    adrianh7145 pointsBadges:
  • AS/400 file to Excel with Headers and Footers

    I need to attach an Excel s/sheet to an email. I currently do that via the CPYTOIMPF as a CSV file but this doesnt give give me the true Excel Header row, which is a requirement. Is there any easy way to do this?

    NJFred35 pointsBadges:
  • 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?

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

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