Hi, I am running SQLRPGLE on V7R1. The program takes entries from file and emails. The program on high level does following steps……….: 1. Fetch Record from File, ………… 2. Convert Spool file to PDF and puts into IFS, into Root/Folder1, ……… 3. Copies PDF file from Root/Folder1 to QDLS/Folder1 using command CPY, ……. 4.…

We have a print job that is created using a print file and it works great but only when printing it manually. When the job is run from batch using QSYSOPR as the user the page looks like green bar paper and for some reason it also prints very light.

We have come across some vendor supplied RPG programs that have been compiled with the FIXNBR option set to *INPUTPACKED. We would like to know if there is a way to display how a program was compiled and to see all of the options selected for it. Thanks.

Hi, I am working on a project, but have got stuck and I need expert advice. I received a flat file from another system (probably a Windows system) in AS/400. The flat file contains the data separated with hexadecimal (x’05′) . The file I am receiving is through connect direct. My requirement is to modify…

Hi, my requirement is how can I open a file from another library in RPG program … noted that I have tried to use keyword : EXTFILE(LIBRARY _Nam / FILE_Nam) but it doesn’t work. Please advise. Thanks! Tarek yaseen

Who is the objective of the user QHOD and QLAFD in AS400, and these user must have authority *ALLOBJ

Can we have two logical partitions with the same system name? What are the pros and cons of having a different system name(s) for each partition?

How to rename an alternative name(long name) in a physical file using sql or any other method.(Alternative name if present can be found using DSPFD) . No source is available for this physical file and only object is available.

After a savsys restore due to a disk crash, the FTP server won’t start. Following is the joblog entry : Message . . . . : Exception CPF3CDB occurred when trying to get information for exit point QIBM_QTMF_SERVER_REQ with format name VLRQ0100. Cause . . . . . : The QusRetrieveExitInformation API returned an exception…

I have an HTML page with NAME field. When user enter the in the page and click on the submit it should go in the PF file and add the record in the PF. Is it possible that we can map the HTML pages with AS400. Please give some link or code where I can…

Hi All, If I was on QSecurity 30 and shifted the operations to QSecurity 40, knowing that my collected audits collections (logs from QAUDLVL) are ok and passed all possible program failures. Now during operations problems occured. Boom! Can I immediately revert back to QSECURITY 30 and continue my operations? What will happen to my…

Hi all, I would like to know if there is a command to check the private authority of a user profile over all objects inside the iSeries. Thank you

Ever since we upgraded the 400 to version 6.1, I have a problem with my numeric fields. It does not appear that the Check(FE) works with the keyboard shift attribute of an ‘S” We use the ‘S’ so the employee’s do not have to enter the decimal point. If a field was entered as ________245…

How can I improve the coding of this SQLRPGLE program? 0030.00 d MoreRows s 1a 0032.00 d recn s 7 0 0033.00 d pyam s 11 2 0036.00 d 0037.00 d Seq# s 9 0 0038.00 d sds 0039.00 d usid 254 263 0046.00 /Free 0048.00 Exec sql 0049.00 declare c1 cursor 0050.00 for select…

I did RSTOBJ from a production library to a test library using and created a trigger that I did not realize existed. The next copy I tried to do to the test file that had this incorrect trigger over it caused the copy job to lock up with many “Access Plan not Updated” errors since…

I am trying to write data from one stream file to a text file. Stream file is a big file of 5000 pages and i am generating 5 text files with 1000 pages . Now when i write first 1000 pages to file1.txt it writes perfectly well . Now when 1000 pages are reached i…

Hi, Does any one know How to 1) add a condition to Synon defaul condiotion list .. 2)And how to Promote this condition list (xxVLLSR ) to Production Box.. we are using – MKS Chain Managmnt tool.. Regards Adi

We have a Work Order Create program that gets invoked by multiple users multiple times throughout the day. The jobs are submitted to a jobq that is single threaded. Within the calling CL there is a SBMJOB of a secondary job that also gets submitted to the same single threaded jobq. The problem is somehow…

I have been out of programming for a few years, and am pretty rusty. We run a system that the end users have no command line access. Their printers have occasion to go into MSGW status (ie out of paper, etc.). They then have to call to get support to answer the MSGW on the…

Our company has an AS/400 model 9402 that was manually shutdown due to an extreme storm. We cannot turn the system back on. The system attention light is lit and system will not power on. Any help would be GREATLY appreciated.