• 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:
  • Restore files from old machine and migrated tape

    Hi, I am having a hard time restoring data from migrated tapes to our current system. Tapes were migrated from series of media to our current media system; when we try to display (iSeries V5R3 on TS3500) we encounter error:

    iNewbie215 pointsBadges:
  • Controlling Client Access screen colours

    Contrary to popular wisdom, its possible, and pleasant, to set your client Access screen colours to be, say Black on a white background - or to have a session with a red background when accessing a produciton box, and (blue's my favourite) a different colour for a development box. The colour...

    Yorkshireman5,520 pointsBadges:
  • AS/400 BRMS

    Receiving a BRM1934 error on a DUPMEDBRM when the receiving tape drive is locked protected, the system is auto responding with "D" but I do not have an auto response for this error in my reply list so where does it come from? My operators are not catching the issus since there is no break message...

    HowIGetHere20 pointsBadges:
  • How to trace JOB?

    Hello All, Let’s say a user tried to access a screen and this screen got crashed due to some reason. He logged off the system and called support team to look into this issue. The user simply gave his user id only to the support team. How can the support team trace his problem? Thanks In Advance...

    BibinG20 pointsBadges:
  • CPYF and CRTDUPOBJ

    What is the actual difference between CPYF and CRTDUPOBJ

    MAGIC205 pointsBadges:
  • Client Access: IP or DNS?

    Can I tell by looking on the system if my users are accessing the box via IP or DNS or do I have to vist each PC to check config?

    Guy553435 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