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

    NeilD450 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:
  • Logical files – V5R4

    HI we all know DSPDBR command on a PF will fetch all the dependent logical files. Can anybody tell me with a logical file's name only known is it possible to fetch the Physical files's name on whom it is dependent?   happy new year n best wishes to all Ram

    ten20081,150 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,160 pointsBadges:
  • Local F specs in V5R4

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

    ITKE344,995 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:
  • 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...

    SteveLane70 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:
  • 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:
  • Upgrading system from V5R3 to V5R4

    Hi, I need to upgrade the system from V5R3 to V5R4. I need to know that are there any RPG , iLE, CL, Cobol commands that have changed. Which would require code change to incorporatte the upgraded version. Can someove help me out how to find such commands.

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

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