I have 2 identical programs sending data to 2 remote systems. The only difference is the the DDM file points to a different box. Program A works fine to state A. Program B fails daily to state B. The error I am getting sending to state B is a CPI9161. Database TCP/IP or local socket [...]
Answer Question | March 31, 2012 4:04 PM
CPI9161, DDM, DSPJOBLOG, JOB SCHEDULER, Joblogs
Hi! can any one give me sample code of cobol/400 program which loads a subfile records page by page. My problem here is I am able to code page by page records loading from a PF but when the Subfile is dispalyed it is not properly displaying the pages. Fro example after loading and displaying [...]
Answer Question | March 31, 2012 8:10 AM
COBOL, COBOL/400, iSeries, Subfile, V5R3
We work with the mapping program of the Ibm redpaper Printing VII. Everything works without problems (creating PDF and respool PDF) except the AFP respool does not work. We get no error messages en there are no joblogs. The AFPOUTQ keeps empty. Who can help us please with this problem. Albertus Land
Answer Question | March 31, 2012 7:10 AM
AFP, AS/400, i5, InfoPrint Server, iSeries, Mapping Program
Hi, Currently We are getting a Report on Monthly Basis using Macro script which runs manually on next day to monthend. Now, We have requirement for generating the Report on Monthend Date itself as part of over night process. Is there anyway to automate the Macro Scripts in AS400. Please suggest. Pradeep.
Answer Question | March 31, 2012 5:56 AM
AS/400, AS/400 macros, Macros
There’s always something new and improved, especially in something as complex as a data center. What are some recent technologies you’ve seen that strike you more as fads rather than essential additions to the data center? Share your opinion, and we’ll share 75 Knowledge Points!
Answer Question | March 31, 2012 2:49 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Data center design, Data center design and infrastructure, Data Center management, Data center operations, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Learn concepts, design and deployment for Cisco Stateful Firewall solutions with this week’s free IT book. To win, simply answer one of five questions and post the link to your answer below. Windows Server 2003 user locked Windows 7 Professional permissions Offline folder issue in Windows Server 2003 Outlook 2007 inbox mail cannot read for [...]
Answer Question | March 31, 2012 2:28 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Our current V4R4 box contains our data files and in-house written rpg, cl, service pgms, binded directories, etc. We have all our source code. We have no 3rd party software, all is in-house code. We are about to buy a used V6R1 box. I know there is some sort of costly 3 step migration for this. But I need to ask. Can [...]
Answer Question | March 31, 2012 8:43 AM
AS/400, AS400 V4R4 to V6R1, RPG Code, V4R4, V6R1
Hi Group, In COBOL/400 PGM the file has been declared with ACCESS as SEQUENTIAL and ORGANIZATION as SEQUENTIAL. How to delete a record from such file? Regards, M
Answer Question | March 31, 2012 4:42 AM
COBOL, COBOL statements, COBOL/400, PGM
Hi, some help me. I want to write data to SQL Server from AS400 in RPGLE. Some have code for make this. Thanks for advance.
Answer Question | March 31, 2012 5:16 PM
AS/400 SQL, RPGLE, SQL Database, SQL Server
I want to email notification of our daily backup result. Using the SNDDST command I can successfully send email to embarqmail.com, but not to aol.com (and possibly others). I am using the entries in the QZMF journal to see which emails are successful and which ones fail. What do I need to do so all [...]
Answer Question | March 31, 2012 3:03 PM
AS/400, iSeries, SMTP, SNDDST
i have 2 different datatransfer files to get data from an AS/400 to excel. one is version 1.2 and the other has version 2.0 in the description what is the difference, cause i now got an other version of client access installed and the 1.2 version is not working anymore
Answer Question | March 31, 2012 2:03 PM
AS/400 data transfer, Client Access Express, Exporting AS/400 to Excel
Usually increamental backup using BRMS takes half hour where as the check point reaches in 4 or 5 mins….but last 3 days backup took more than 2 hours and check point reaches after one hour of delay, anyone pls suggest what would be the issue and how to resolve it?
Answer Question | March 31, 2012 2:36 PM
Backup, BRMS, BRMS Backup, V5R4
I need to know LOGIC using OPAL within ROBOT job Schedulerto validate if the BRMS console is active or not active before I can shut the systems down to perform a full system save.
Answer Question | March 31, 2012 12:30 AM
AS/400 BRMS, AS400 Data Definitions, BRMS, ROBOT, Robot Job Scheduler
On OS400, Is there a way to manage limitation for permissible librairies when they use the command WRKQRY? And for those limited librairies can we assign a limit or quota to the storage usage per user id ou user group to avoid creation of enourmous files? Thanks in advance for reply on that,
Answer Question | March 31, 2012 3:55 PM
AS/400, AS/400 commands, AS/400 Library, OS/400, WRKQRY
Hi All we are getting issue in as400 cpu utilisation. qzdasoinit jobs is getting killed after closing connection but after when we initiate a fresh connection it utlises cpu from where previous connection was closed. Suppose if previous connection was closed at cpu usage 10%, job would disappear from wrkactjob but when fresh connection is [...]
Answer Question | March 31, 2012 3:34 PM
AS/400 jobs, CPU Utilization, JDBC, WRKACTJOB
What are some of the key factors the enterprise should consider when building a data center that can last? We’d love to hear stories from your own experience, or see lists of your own must-haves when it comes to a new data center. Share your thoughts and we’ll share 100 Knowledge Points!
Answer Question | March 31, 2012 2:18 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Data Center Build, Data center design and infrastructure, Data Center management, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
I work for a travel company whose Inventory file uses a unique field for each day of the month, e.g. LGRA1 is the first, LGRA2 is the second etc. The month and the year are single fields. Is there a way of converting these fields to concatenate the date to be able to link easily [...]
Answer Question | March 31, 2012 9:20 PM
AS/400, AS/400 Query, AS/400 Records, Date concatenation
How can I lock records in a simple Access database after updates? And, how do I set up the user interface to include only the form I would like for the user to complete?
Answer Question | March 31, 2012 8:48 PM
Access 2007, Access Database, Record lock, User Interface
We have moved 15 of 20 AS400 / iSeries to a new business DMZ. The five systems that fail range from OS level V4R5M0 to V5R4M0 and system types 50S to 520. Some failed systems are LPARs where half the systems of the LPAR are functioning with their new IPs while the other half fail. [...]
Answer Question | March 31, 2012 8:27 PM
DMZ, Ethernet, STRTCP, TCP/IP, V4R5M0
We are converting to an iSeries v6.1 and want to eliminate our track-feed printers. We have been told we can create overlays in Microsoft Publisher and have this “merge” with the spool file (invoices, purchase order, etc). I need step by step instructions in how to set this up. Your help is greatly appreciated.
Answer Question | March 31, 2012 5:38 PM
iSeries printing, iSeries V6R1, V6R1