• Domino on the iSeries and MS Excel

    We have a LotusScript agent running on a Domino Windows server that opens an Excel spreadsheet and then processes each line of the file against data in the Domino DB. If we move our Domino platform from Windows to IBM iSeries, what additional considerations do we need in order for this process to...

    Signman5 pointsBadges:
  • Calling External Procedure from Java Web based Application

    Below given is a procedure to access a CL Program in iSeries from a Java web based program. create procedure libxxx/proc_name LANGUAGE CL FENCED EXTERNAL NAME 'libxxx/clprogram' PARAMETER STYLE GENERAL The external CL program has other calls to Cobol programs in the same library.The procedure is in...

    TOKNOWIT0 pointsBadges:
  • Member Level ID

    Every evening we create Save Files of our Production Libraries on our Production System. The next morning we FTP these Save Files to our Development System and do Restores to our Production Libraries on our Development System. We use TurnOver to handle the changes to our SQL Tables, Indexes, and...

    wpoulin2,480 pointsBadges:
  • RPGLE. cpytopcd

    I have tried to create a file where every record is 80 characters long. Every record should be filled with spaces if the record is shorter than 80 char. In my program I use cpytopcd and this command seems to cut every record if there aren't any more characters. If you look at it in hexadec...

    Kasten15 pointsBadges:
  • SQLRPG and LVLCHK *no

    We have numerous programs on our system (iSeries...V5R2) that are SQLRPG. We recently changed one of the large physical files that one of the SQLRPG's run over. We changed the physical via a compile of the with LVLCHK *no. (fields added to the end of the file) We started to experience some issues...

    NJShoreBob0 pointsBadges:
  • trigger programs

    Is there a way to determine which program/job updated the file from a trigger program?

    Hllane0 pointsBadges:
  • Generating a Report on AS400

    Is there any good way to determine the number of pages a report will print without actually generating it first? I would like to have my report print as part of it's headings : Page 1 of 50, Page 2 of 50 etc.

    Rigger0 pointsBadges:
  • Restoring a dtaq in iseries.

    I need to know if there is a way to save a data queue with some entries in it, and then restore the data queue in the same or other library with its entries included. When i do that, the dtaq is empty. If someone knows how to do that, please tell me. Thanks.

    Moreira0 pointsBadges:
  • AS/400 System Saves and Journals

    We use the following commands to do our weekly system save: SAVSYS, NONSYS, SAVDLO, SAV. Will this save system journals as well? Thanks in advace for your help.

    BaughOper0 pointsBadges:
  • How to reply to message in DSM?

    How to reply to message in DSM (with ENTER automatic)

    coopjer10 pointsBadges:
  • Convert/Supress non UTF-8 to UTF-8 on as/400 while CPYTOSTMF

    Hi, I am generating XML from AS/400. I am doing following steps: Creating Flat File wiht RCDLEN (260) and CCSID 65535 (Default). I am reading data from some other Physical File. Putting data in between XML tags in required XML format and writing this record into Flat File. Now flat file contains...

    NarasimhaReddy225 pointsBadges:
  • CPIB687 conflicting announcement for domain

    In Qsysopr we get a CPIB687 message reason code 3. It references a conflict announcement for the domain that it is in along with our AS400. WE know how to disable the master browser settings on windows clients. This is a MAC client and we do not know how to disable it. IBM set we can change our...

    Mpoweleit10 pointsBadges:
  • iSeries Navigator message monitor failing on endpoint system

    After years of working very well, iSeries Nagivator (Ops Nav) refuses to monitor messags on an endpoint iSeries.  This is a recent development.  Its been working just fine on the endpoint in question for the last 3+ years.  The QYPSJSVR job log shows CPFB904 and CPFB905.  Both are running V5R4...

    WoodEngineer6,955 pointsBadges:
  • Upload Spreadsheet to AS400 using Excel addin – creates graphic fields for alpha fields

    I am using the Excel addin to transfer excel files to our AS400.  The file does not exist on the AS400 and when the transfer runs, the field created for the alpha fields is 'Graphic' when I display the file field definitions.  I cannot read these fields in my RPG program - they are only text...

    PaulClemens25 pointsBadges:
  • How do I disable the query timeout property?

    I'm calling a stored procedure on the AS/400 from Visual Basic .Net. When the stored procedure executes, I get the SQL0666 message (query exceeds specified time limit or storage limit). The query timeout property on the box is set to *NOMAX and I've Reorg'd the files too. The message appears to be...

    JasonWV5 pointsBadges:
  • Calculation of (num) 1/n (square root) using RPG

    Do any one know how to handle below formula using RPG or else method which can be implement on AS400 RPG program : The formula is (number ) 1/n 1/n = mean 1 over n square root N= certain number and with decimal digit eg. 1.21 Please send me some suggestion about this . Many thanks Beside you can...

    Vlui000 pointsBadges:
  • How to copy source code of Pgm into Flatfile in COBOL

    I want to read the one of the pgm's source code through my another program. So anyone plz suggest me how can i read the source code?

    Promodhss50 pointsBadges:
  • PTFs

    What are the SINGLGE,GROUP and CUMULATIVE ptfs?

    qmaster1,675 pointsBadges:
  • Users having Access to run DTF’s.

    Steps to generate report of List of Users having Access to Transfer Data from iSeries Server (DTF Access).

    Haaiderali215 pointsBadges:
  • Return compared to Set on LR

    What is the difference between RETURN and SET on LR indicators? What exactly each one of them does?

    A1b2c3335 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