• 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:
  • iSeries SQL0904 Resource limit exceeded

    I have written RPG/ILE stored procedures to validate and write data to various physical files with data extracted from MSSQL tables using SSIS and MS Visual Studio 2013 and utilizing the Native OLE DBIBM DB2 for i IBMDA400 OLE DB Provider. My problem the extract job fails when trying to import...

    JustJamesG5 pointsBadges:
  • List jobs from iSeries JobScheduler

    How do I list all jobs in iSeries JobScheduler?

    gh2808hoc5 pointsBadges:
  • CWBDB0036 / SQL0204 Error when using data transfer to IBMi

    A single user gets the error; CWBDB0036 - Server returned SQL error SQL0204 - "filename" in *CURLIB type *FILE not found. We recently upgraded our OS to V7R1 and since the upgrade we have a user that is unable to run a .dtt to transfer a .csv into an existing file / member on the 400. I even...

    MWeales25 pointsBadges:
  • SMTP Verification fails

    I am using Gumbo Spoolmail in my v7r1 iSeries and got this message: SMTP verification/set up failed. Can't send emails.

    mildredas4005 pointsBadges:
  • Windows icon path to iSeries IFS

    V7R1. I have icons on my desktop that point to the iSeries IP address IFS. i.e. \\10.0.0.12\home. These no longer work after changing my network password, same but with the first letter as a capital. I get a message window from Windows Security to Enter Network Password. On one AS/400, I see...

    NickHutcheson11,415 pointsBadges:
  • IFS Authority for symbolic links

    I have a problem with IFS security, I’m allowing users to create symbolic links to IFS files which they then cannot remove. I try to use CHGAUT on the link after creating it so the user have sufficient authority but this does not work, I am guessing this is because if you create a symbolic link...

    TMcNeil5 pointsBadges:
  • Edit Client Access TFR

    I'm trying to upload a multiple Excel sheets to iSeries, Getting warning message: Multiple sheets exist in PC file. Do you want to send data from sheets other then first. I don't want to use other sheets. Is there a way I can edit the TFR and change it so it does not ask? Where can I find...

    polsh5 pointsBadges:
  • List of companies migrated from iSeries to some other platform

    Hi all, Can someone have list of some major companies which migrated from iSeries to any other platform? Regards,

    hunshabbir72,820 pointsBadges:
  • RPG III Validation

    Hello, I'm a beginner on AS/400. I'm developing a Supply Maintenance program that have three fields for three supplys but each supply has to match for an existing Vendor Number from another physical file, my question is how can I do that validation. Thanks.

    k3v1N2435 pointsBadges:
  • How to find the reclaim parameter set in Dataqueue object

    What is the command to check the parameters defined for a Data queue?

    JohnsonMumbai1,425 pointsBadges:
  • What is the difference between dataqueue and Userqueue.

    What is the difference between dataqueue and Userqueue objects?

    JohnsonMumbai1,425 pointsBadges:
  • How do I find the objects secured by an authorization list?

    I created an authorization list and secured few objects against it. But I forgot the objects which I had secured. How can I find them?

    JohnsonMumbai1,425 pointsBadges:
  • Can we send/copy spool files from one outqueue of first server to another outqueue of 2nd server without losing the spool files on the first server?

    Can we send spool files from one outqueue of first server to another outqueue of 2nd server without losing the spool files on the first server, by using AS/400 commands and not through replication software like MIMIX? Both being iSeries servers on the same network. Is there any procedure to...

    JohnsonMumbai1,425 pointsBadges:
  • How to lock FTP user out of the rest of the IFS

    I have an FTP user that will upload files onto our box. When they connect they start in their /home/ folder. I want to make sure they can't get back to root '/' or anywhere else in the IFS. Preferably without creating a massive security maintenance workload as this expands.

    GregManzo780 pointsBadges:
  • iSeries mapped drive security

    I would like to set up a number of drives where user A can access folder A and User B can access folder B. Neither user can access the other users folder. I have tried making the folder authority specific to a user with public exclude. This has made not prevented access. I assume this is the...

    Fignon5 pointsBadges:
  • IBM DB2 Rows-Records Limits

    IBM DB2 allows up to a maximum of 4.2 Billon rows or records in a table. (In AS/400, iSeries). MS SQL, Sybase SQL, Oracle, MySQL all allow way more. We know that with clusters IBM can handle more, but this doesn’t solve the problem in many cases (Requires Embedded SQL)… DB2/400 was supposed to...

    Florenjm180 pointsBadges:
  • Email notifications

    Has something happened to stop the email notifications regarding new & updated issues under the AS400 tag? I don't think I've received one in weeks.

    Splat10,195 pointsBadges:
  • iSeries sending emails to a group

    We would like to emails sent from the iSeries to a group when a job that runs at midnight unattended has an error message. How do we set this up?

    bwb1011115 pointsBadges:
  • How can I find to what program my iSeries Module was bound?

    I am trying to clean up a system (new contract) worst control of source that I have ever seen, buy I digress. My question is, If I have a module object on the iSeries, how do I find what program the module was bound?

    SicRob5 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