• Maximum size of iSeries logical file

    What is the maximum size that a logical file may reach on an iSeries before is causes program access application to halt (...go boom!...bring a casino floor down...)?

    WundersW5 pointsBadges:
  • RSA & SHA-2

    We have a 'partner' who has, without notice, disabled SHA-1 & insists we now use SHA-2 for our sFTP transfers. Does anyone have any suggestions on setting up SHA-2 on the System i & tying it to RSA?

    Splat10,520 pointsBadges:
  • SQL Select for Multi Format File

    I need to select and update fields in an iSeries file with multiple formats. How do I specify the member I want to work with?

    Roycer775 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:
  • Emailing BRMS reports automatically

    I have three iSeries that use BRMS, two of the systems have Help Systems Robot applications - which I use to send BRMS reports daily. The third system doesn't have Help Systems Robot installed. Is it possible to have BRMS send the daily BRMS reports to a user through e-mail or is that pretty much a...

    JMatthews5015 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:
  • 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:
  • List jobs from iSeries JobScheduler

    How do I list all jobs in iSeries JobScheduler?

    gh2808hoc5 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.

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

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