• AS/400 import to Excel

    How do I import data from AS/400 to Excel?

    melindabeal15 pointsBadges:
  • Import and Export data from AS/400 using ODBC

    I imported data from AS/400 database file into an Excel sheet, using ODBC. I selected Microsoft query in order to retrieve data. How can I export data into AS/400 database file?

    Geek51185 pointsBadges:
  • Mch0601 error rc 04 within SEQUEL

    Is there a SQL cleanup or reset command that I can run to avoid this space offset error? For some reason I can not run a particular sequence of SEQUEL commands. I have two separate applications. I have a script that creates a file, and then uses that file as a view. Then I have a report definition...

    Modiyooch760 pointsBadges:
  • How do AS/400 stored procedures get output?

    I have created a CL which calls an RPG program. Now I have to create a stored procedure which calls the CL! As RPG normally sends back the output to CL! How should I send back the output to SP? Will SP normally pick it or is there any command to send back the output to stored procedure (SP). I have...

    bharathtata30 pointsBadges:
  • Synon tool in AS/400

    What is Synon? If I learn Synon, how will be my future? Is it good to learn Synon as a fresher.? Approximately how many clients would be using Synon.

    aswinisynon5 pointsBadges:
  • Re-generate report in AS/400

    How do I re-generate a report in AS/400? What are the steps? Please advise.

    kekuchi10 pointsBadges:
  • AS/400 disk DPY in error

    Hi all, I want to try to recover a disk in RAID 5 on a AS/400 System, DPY ERROR show. Can you provide me instruction to start recovery disk, I want try before replace them. Thank you.

    Nerd4Life5 pointsBadges:
  • Mimix VSP application group

    When I check the Summary on my Mimix VSP everything is green and looks good except the Application group, this is blue and when I hover over it I get the message, "Resource Group has not been built". If everything appears to be working fine, what hasn't been built?

    dazkeyte50 pointsBadges:
  • Macro for copying data from Excel to AS/400

    Hi,I'd like to create a macro (in AS/400 or Excel VBA, doesn't matter) that copies cell data from an XLS spreadsheet to AS/400. How would I do that?E.g. copying cell A1 in Sheet1 from c:\spreadsheet.xls to 10/035...Thanks in advance.

    Hanisadeq963525 pointsBadges:
  • Create a LF based on a particular member in a multimember PF

    Hi, How can I create a LF using crtlf command based on a particular member in a multimember PF? Where I have to specify the member name?

    ITKE970,620 pointsBadges:
  • SQLRPGLE: Not able to load data into subfile

    Loaded the data into subfile with SQLRPGLE - prepare statement and cursor and now if I go back and again tried to load back, not able to load the data to the subfile.

    ravula755 pointsBadges:
  • IBM iSeries MSF jobs running high CPU usage

    I have an iSeries V6.1 running our SMTP and POP3 servers. MSF jobs (3 in total) seem to build up on CPU usage and then eventually max out the CPU to 100%. Emails then are not processed, nothing can be sent or received while these MSF jobs are running at full throttle. Restarting MSF seems to...

    GazzaRoo25 pointsBadges:
  • Anynet on OS 7.2

    Does anyone know if anynet still works on 7.2? We know it's not supported from 7.1 anymore but is still working. OS currently 6.1.1 on most system. Would like to know if we have to incorporate enterprise extender into upgrade. Thanks

    Pippaki10 pointsBadges:
  • Setup SOAP message format

    I'm working in a banking domain so we are going to develop the payment gateway product so for that for a merchant site, I need to get information so that I can accept the card number from the user for the transactions. So I need to send the request to the Ru pay pay secure service with 9 digits...

    PrasannaPullamsetti15 pointsBadges:
  • Private authority QDIRSRV & length of SAVSECDTA

    SAVSECDTA has been running for nearly 12 hours. We believe it's related to private authorities in our IFS structure. The private authorities for profile QDIRSRV is 8%. There are approx. 5 million entries in the IFS. Any suggestions how to fix this? We are moving to power8 shortly and are concerned...

    Pippaki10 pointsBadges:
  • Avoid “black screen” between two processes in CL program

    Hi guys, I have my CL proc, inside it I call my PGM1 and PGM2, ..... CALL       PGM(MYLIB/PGM1) CALL       PGM(MYLIB/PGM2) ... PGM1 excpt a screen and I fill it then press F8. with F8 seton LR, end PGM1 and start PGM2 that process file data with parameters passed from PGM1 and give me print...

    Damiano20 pointsBadges:
  • File size limit in System/36 environment?

    Is there a limit on number of records in a data file ... in the System/36 environment? Sadly, we still have some applications running that way (not my fault).

    aceofdelts2,365 pointsBadges:
  • FAx From iSeries

    We have the need to notify the Healthcare Primary Care Provider via fax from our iSeries database. I need to know if there is a product that would take a file, read the fax number in the file and transmit the information to the provider. There would be multiple records in each file that would need...

    WaynePaul5 pointsBadges:
  • Using CPYFRMIMPF to copy data from a TXT file to DB file

    I am using the CPYFRMIMPF to copy data from a TXT file into a DB file.  The delimiter is a ']' character.  The command runs but no records are copied.  The error says "0 records copied from member TXT.  Copy command ended because of error".   Upon further review I found "The copy did not...

    SteveLane75 pointsBadges:
  • Send SMTP email through AS/400 server

    I need help for send SMTP email through an AS/400 server. When I send the email I received, that email sent successfully while i didn't receive any email. Can you please advise?

    Hanisadeq963525 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