Sir Tom: I somehow perceived that it’s kinda related to restoring journal receivers so i decided to just attached my concern to Leah Rosin’s “Restoring journal receivers”. Well, going back to the issue, my question was ” i’m able to restore previous journal receivers to the library but after a short time, the restored journal…

I HAVE TO DO THE BELOW STEPS USING SQLRPG,PLZ HELP TO HANDLE THE UNIQUE RECORDS : 1. Delete records from Production LFPRIPMH/D file and those policy numbers are available in LFPS402S (unique policy number) 2. Insert into Production LFPRIPMH/D files from Before migration image (LFPRIPMH/D), where policy numbers are available in LFPS402S (unique policy number)

Has anyone implemented a Data Access Layer in RPG-ILE, similar to what is discussed in these articles: http://www.itjungle.com/fhg/fhg072104-story01.html and http://www.itjungle.com/fhg/fhg011205-story01.html If so, can you share some of the positives and negatives of the experience? In hindsight, would you do it again? What would you do differently? Our organization is in the beginning stages of a…

I need to import tis .dat file into sql database table having four column client-007092~WITCO clname-CORPORATION ,matter-0005,mattername-LAZY OIL V. WITCO

Has anyone implemented a Data Access Layer in RPG-ILE, similar to what is discussed in these articles: http://www.itjungle.com/fhg/fhg072104-story01.html and http://www.itjungle.com/fhg/fhg011205-story01.html If so, can you share some of the positives and negatives of the experience? In hindsight, would you do it again? What would you do differently? Our organization is in the beginning stages of a…

I have 2 System i 570 connected to 2 x DS8100 in 2 different locations and replicating with PPRC. No internal disks, IPL from SAN. We will run a switch test : stop production server, end PPRC and start backup server on the “PPRC copy” (more steps indeed). Does anyone has information about the action…

Is there a way from within the FTP script to check for successful GET without exiting FTP session ?

one physical file have 6 key fields,now i want to retrive the 10th record based on one key field,how to retrive in cobol/400 with without using logical file ex:- emp pf have 6 key fields,and emp have records,now i want to retrive particular record in emp(10 th record only),in my cobol pgm some times use…

I have several LPAR’s that collect peerformance data. In one LPAR I can see all Performance Collections with DSPPFRDTA *SELECT in QMPGDATA. On the others only the current collection is shown although the *MGTCOL objects are in QMPGDTA. How can I force these to be shown on the other LPARs as well ? iSeries V5R4M0…

We currently have a BPCS system, you can create items with a type 4 for kitting. You have a parent item with children, and have a planning bill. How you can check stock on the children in ONE place to see stock or get a lead time for the children?

[em]-configure SSH on the AS400 [/em] [em]-connect via a VPN from the desktop of a PC for a Client Access green screen session.  [/em] [em]Ian, they will probably want to connect 400 to 400, so as to transfer compiled objects across ie no source code for ‘restricted’ modules (only a guess). They could use FTP…

i hav code   STRQMQRY QMQRY(SQLPROC) OUTPUT(*OUTFILE) + OUTFILE(QTEMP/SQLDT)   In SQLProc txt file i am callin a sql procedure , developed using i series navigator and return data set using cursor. i want this cursor output in qtemp/sqldt file. in sqlproc if i mentioned SELECT statment , then it will work fine, but i want…

We have a new web app that we want to be able to run 24/7. My question from our web staff is  “when the data is available? “. There are 2 situations I can think of that will pose an issue. 1. when we are running file back ups, it most likely will not be…

We have a WAS Job using 95% of our CPU ( got it from wrkactjob) we tried to tunning garbage collection and appeared that worked cause it (after restart) the job went down and was working with 25% OF cpu.Suddenly it started to use amonge 95 to 99 % of CPU again, any solution to…

I have posted this question as part of an old discussion but have not seen an answer so please forgive the second posting but I can really use some help on this one. I am doing a complete restore to a I515 backup system which is identical to our main system. After finishing research I…

Hi folks: I have a V6R1 question that that deals with IFS placement I thought I would throw out there for the real gurus! My customer is moving from a V5R4 model 550 to a new V6R1 box and will be implementing a shared IASP storage pool for multiple partitions. They use Vision Solutions for…

I wont to use PL/I comman like for using same structure twice. Compiler returns error : IBM7043I S 4.1 SQL0314N The host variable “xxxxxxxx” is incorrectly declared. SQLSTATE=00000 IBM7043I S 9.1 SQL0117N The number of values assigned is not the same as the number of specified or implied columns. SQLSTATE=42802 Is there eny way to…

Here are the 10 most watched questions on ITKE: There’s some great discussion going on. Go answer a question now! 1. Pushan1234 asks about Returning string value from a stored procedure in sql server 2005 to vc# ide code at runtime. CarlosDL and MrDenny provide some pointers. 2. Bonbon78 runs into trouble Converting date values…

CAN I HAVE ACCESS, FROM AN ISERIES TO A BASE OF DATA ORACLE? AS I CAN MAKE IT?

I would like to display error message in red color using ERRMSG or ERRMSGID.[Br style=”padding: 0px; margin: 0px;” />[Br style=”padding: 0px; margin: 0px;” />Is it possible?