• How many parameters can be used in as400 wrkqry?

    how many parameters can be used in as400 wrkqry

    Urband5 pointsBadges:
  • SQLCODE = 1077952576

    All- I'm getting the above error code from an RPGSQL program. This is just after a DECLARE statement. Other fields in the SQLCA are blank. I can run the statement in Interactive SQL w/o errors. I should be getting a small subset. I get 0 records. Any Ideas?  It's not in the SQLCODE finder. Phil

    MurrayInfoSys940 pointsBadges:
  • Multiple session on the iSeries

    One of our as400 users lost the ability to get multiple session on the iseries. When she tried to get a second session, she is getting a blank screen. I looked at the history log, but I cannot see anything there. Can someone please tell me what the problem could be and where to look, if any, for...

    Amazing015 pointsBadges:
  • Clear leading zeros

    I have a 10A character field which hold a numeric value. Problem is that it contains leading zeros. How can I remove them? Many thanks.  

    NeilD570 pointsBadges:
  • Using API QC3ENCDT in encryption using RSAalgorithm under a Public key, error CPF9DDB !

    Hi I have been working on Encryption/Decryption of data on AS400 v5R4. I have already done the Encryption of data using QC3ENCDT API on COBOOL. Now, I want to use the RSA Public key to encrypt my encryption key. For that I had written a test program but it is throwing one error and I m unable to...

    Syedmohsin455 pointsBadges:
  • AS/400 error MCH4429 – automatic storage overflow

    We have an iSeries 9406-525 V5R4. We have a job that runs in the evening submitted by ROBOT. It loops back and forth between 2 clp's. It builds small files, encasing the files, and emailing them to our branches, and then back to do the next file. Max number of files could be a couple of hundred. A...

    Brenger170 pointsBadges:
  • Does anyone know of a way to scan a barcode entrys into an AS/400 display file, but not allow the scan ID to be manually entered from the keyboard?

    Hi all, I am developing a new application that scans vendor bar-codes into our system and translates the Scan ID into the part#'s used by our business.  My business has a requirement that the only method of entry is via a bar-code scanner.  The scan ID cannot be manually entered into the...

    jaydc40045 pointsBadges:
  • Convert to PDF

    Please guide on how do we use Convert to PDF from i series navigator. We are on V5R4. Need the steps to be followed in order to convert a spool file to a pdf. What needs to be done in order to save it to a location on the PC.      

    JohnsonMumbai1,480 pointsBadges:
  • Local F specs in V5R4

    How does one simulate local F specs in V5R4 in a SRVPGM procedure?

    ITKE1,152,335 pointsBadges:
  • Analyzing Security Audit Journal

    Hello, could you please tell me where can I find a book, guide or course about Tracking and Analizing Security Audit Journal on iSeries?  I have tried Appendix F on Security Guide but there are not all entries and it does not explain how to analize records in journal.  Thanks a lot

    Fabypaumc15 pointsBadges:
  • Security issues going from V5R2 to V5r4

    we upgraded from V5R2 to V5r4 and now I am getting authority problems on any update programs in our custom programing library. User authorities were copied over. That seems fine. Were there any know security problems going from R2 to R4? I get around each instance by changing program to use Adopted...

    Kroeter5 pointsBadges:
  • AS400 online cobol program that needs to get data dynamically from a vendor systems SQL server database.

    I have a AS400 online cobol program that needs to get data dynamically from a vendor systems SQL server database. Is there a API or some method for doing this. Help.

    Theraven35 pointsBadges:
  • How to configure to receive an SMS alert from AS/400 V5R4 Servers?

    Hi, I wanted to know How can I receive an SMS when ever there is a message in MSGW in AS/400 V5R4 system? I have a BlackBerry phone is there a possibility for me to configure my phone with the system?

    Sagarvs5 pointsBadges:
  • Setup Operations Console on LAN connected PC

    How do you setup a LAN connected PC as operations console. PTF MF44882 and MF44894 are they required? What PTF group are they in? I have a iSeries 270 V5R4

    jmar45 pointsBadges:
  • Import XML files and run RPG ILE

    I do not have the XML toolkit package on my i5 525. We are running V5R4. Is there still a way for me to import XML files and run in RPG ILE? I have a customer that wants to send us orders via email and XML is one of the formats they could provide for us.

    Fraser5 pointsBadges:
  • iSeries and JetDirect

    Recently upgraded to an iSeries 520 running V5R4 from an 810 running V5R4, I now have an issues with a number of Jetdirects connect to line printers (Lexmark) that sometimes will not print unless you first send a plain text document to the printer (I use a JOBLOG). I have checked the PTF levels on...

    rcpilot5 pointsBadges:
  • Running RUNRMTCDM from AS/400 v5r4 to v5r3

    I am running RUNRMTCMD from AS/400 v5r4 to another AS/400 v5r3 and get this: A remote host refused an attempted connect operation. Command did not complete successfully. What could be the problem? Thank you!

    lena5 pointsBadges:
  • Which job serve the IFS conection?

    Hi, I know that the SQL connection is managed by the job QZDASOINIT, I would like to know which is the job that manage the IFS connection through UNC path ? I mean if my server name is : server050.domain.lab and I put that UNC path into a windows which is the job that actually receives the request...

    GraceP415 pointsBadges:
  • Importing a .dbf file into IBM DB2 table

    I have a .dbf database file I want to upload to our IBM i5 and into a DB2 table. Is there an easy way to do this or am I going to need to convert the .dbf file into a .csv file? I\'ve tried using the CPYFRMIMPF command, but have had no such luck. Any help would be greatly appreciated.

    msoucy25 pointsBadges:
  • how to add make available an exit format in a exit point?

    Hi, how can I make available an extra exit format for an exit point, by example the QIBM_QSY_CERT_APPS has the exit format CERT0100, but also allow the CATR0100 format , how can I add the CATR0100 for this exit point ?

    GraceP415 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