• Printer File

    I am able generate a report using printer file.Now the concern is how to make second or more page when the records are too many.

    ankit2002770 pointsBadges:
  • can we send email through AS400

    is it possible to compose and send email to any secial network e.x (gmail, yahoo, aol... etc) using AS400

    pdsathishkumar3,790 pointsBadges:
  • CPYFRMIMP inserting quotation marks

    I am trying to use CPYFRMIMPF to copy a tab delimited file to a physical file.  The problem I have is that the file has commas (,) in the text and  CPYFRMIMPF automatically inserts quotation marks around the text whenever there is a comma in the field. For example, if my tab delimited file has 2...

    Msb90025 pointsBadges:
  • OPNDBF then CLOF – the joblog indicates that the file was closed but it still appears in dspjob #14

                                     Member/    Record     File    I/O  ----Open--- File            Library    Device     Format     Type       Count Opt Shr-Nbr B99FL161   XYZISDTA   B99FL161   B99FX161   LGL        4...

    Gzbintech5 pointsBadges:
  • Saving Spool Files, and Restoring Spool Files in AS/400 iSeries

    Hello Does anyone know if there is a utility program out there, that would serve in saving spool files on one AS400, and then restoring these spool files to a different AS400. Not sure what methods are available, but I am thinking of using CPYSPLF to database file, and then from here, saving to...

    Piano520 pointsBadges:
  • Schedule Job

    Hi I need to Run a Job daily at 11Am Except Saturday & Sunday. How I can do it. And also What is the Use of WRKJOBSCDE and ADDJOBSCDE. Lib1/Prog1  user-user1    

    22917510 pointsBadges:
  • Rational Software Development Platform

    I have version 6 of the Rational Software Development Platform (worbench) and it often fails to compile programs which compile successfully within PDM. Anyone experience this?

    NeilD450 pointsBadges:
  • What is Open Data path in OVRDBF?

    What is meaning of Share(*yes) In Ovrdbf?

    Sms121185 pointsBadges:
  • FTP and response issues in AS400

    Hi Experts, We have just finished relocating our AS400 from one site to another. Hence change of IP was done but setup remains the same machine wise. After which, some FTP and response issues started to arise. My AS400 is a two partition machine running on the same segment as my users and other...

    Jerico125 pointsBadges:
  • How to get job log for prestart jobs in AS/400

    Hi How can we get JOBLOG for prestart job. Please help me. Thanks Supriya

    iiiiiiiiiiiii335 pointsBadges:
  • how to write more than one sql statement under EXEC SQL in SQLRPGLE.

    Hi, Can anyone please help me to write more than one SQL statements under single EXEC SQL and END EXEC as below. Since i have 10 sql statements and wanted to include all those 10 statements under single block of EXEC SQL and END EXEC by using any seperator like below. C/EXEC SQL C+Insert into A...

    Mohan K695 pointsBadges:
  • Can not able to declare character field with the length of 6000 in SQLRPGLE program.

    Hi, I am declaring a stand alone character field with the length of 6000 in my SQLRPGLE program, but when i debug the program to see the the values in this character field i could find only 1024 length is allocated for this field. Could anyone please help me urgently to declare a character field...

    Mohan K695 pointsBadges:
  • ISeries Navigator

    Hi, I am a DB2 DBA coming from zSeries to iseries. I have iSeries Navigator , when I click on "Database task"  "Map the database"nothing happens. Is there somewhere I can check for an error message or do I have to load an addon?     Regards   Wendy

    WendyB95 pointsBadges:
  • AS 400 printer file shading of record format

    How do I shade (excel style) a whole record format within a printerfile? The record format may appear many times on a page and of course on different lines. Should I create an overlay, if so, how do I create  the overlay to print in variable positions?  I am using RPG to produce the report on an...

    ITDavid140 pointsBadges:
  • as400 not working in windows 2008 server

    my script is working in windows xp, but not in windows 2008 server. I just fetch the records from as400 through php. if i run that page means iy says the page is not available. if i disable the as400 odbc connection means it will run and say no connection but i enable the code means it says the...

    PHPAS40015 pointsBadges:
  • I would like to run a report on AS/400 to indentify which DB2 tables to reorg.

    Hi,  New to iSeries. I need to identify which tables need to be reorged. From manual I see that if I do a DSPFD FILE(xxx/*ALL) TYPE(MBRLIST). I get a report where the Total deleted records are more than 10% of the total records I should reorg. Is there a report similar from DB2 side a utility...

    WendyB95 pointsBadges:
  • Sorting alphanumeric field with hexadecimal values

    We have a task where we have to convert key numeric field (8,0) to alphanumeric field (8A) with hexadecimal values ('00000000' - 'FFFFFFFF'). The problem in sorting with alphanumeric is the alphabet is less than the numeric value (A-Z < 0-9). Is there a way, by LF or any AS400 utility, that can...

    Vsevilod135 pointsBadges:
  • IFS on Iseries

    After sharing a folder in the IFS i can access it via the windows network, I can paste a file in the folder but cannot delete it, I get a message "Cannot delete :There has been a sharing violation the source destination file may be in use" I have stoped & started the netserver & added my user in...

    Jungojo0 pointsBadges:
  • AS400 Trigger – Old and New Fields

    I am trying to create a log file for my physical files that shows me: the file name, the program making the change, the date of change, the name of the updated field, the old value, and the new value for that field. From what I've seen triggers only give you the RECORD old and new values but not...

    Dns68965 pointsBadges:
  • Overlay Printing Issue

    I have one overlay that two programs use. When testing I have a very simple CL program with one OVRDBF and two program calls one of which I have commented out because I swithch calls when testing. In trying to print a voucher the main voucher program works fine, I then modify the CL by commenting...

    QTRMaster30 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