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

    22917515 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:
  • printing barcodes on *ipds printer from cobol version i6.1

    Upgraded to i6.1 from v5R3M0.  Very old cobol programs exist that print barcodes on *ipds printer using PRTBAR in QSSP. Getting MCH3601 error:  Pointer not set for location referenced.   When I call it from the command line, I get MCH3602  Boundary alignment of pointer or template not valid. I...

    Modiyooch540 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:
  • Message status

    Hi, Can any one please tell me what are all the different job statuses in as400 like MSGW,CNDW,EVTW,DEQW,DLYW and what do they actually stand for?

    Knowledgeseekerone30 pointsBadges:
  • MQ Series for AS/400

    I would like to know which version of MQ series is best suited for AS/400 V5R3.

    AS10 pointsBadges:
  • AS400 Barcode

    Hello, When I used apw(ADVANCE PRINT WRITER)to create a barcdoe in cdoe39 style,if the field have the blank on the end of the field,the right mark '*' will be print output,but the mark '*' is used to show the end of field in the code39 style. Would someone can tell me the reason and how to deal...

    jackli95 pointsBadges:
  • Problem with Barcode for AS400

    Hi Srs, Im an AS400 developer currently having problems with a Report that contains barcode generated via AS400. I've generated a barcode in RPG and is working fine in 7 of the 9 printers that the enterprise where I work has (The report prints fine) , the problem is that in those 2 remaining...

    DTOVAR5 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