iSeries Internal Battery Power unit failure, will this impact the system ?
We have a Internal Battery power unit failure on one of our iseries boxes and the it requires downtime for replacement, but customer wants to give downtime after 15 days.Will this impact the system? is there any risk due to this?
We have a Internal Battery power unit failure on one of our iseries boxes and the it requires downtime for replacement, but customer wants to give downtime after 15 days.Will this impact the system? is there any risk due to this?
495 pts.
Field exit keyword is not working
Hi, i am trying to use the keyword CHECK(FE) in display file field. But it is not happening. Below is the way how the field is declared: CAMT R B 8 14REFFLD(CAMTW) 64 DSPATR(RI) ...
Hi, i am trying to use the keyword CHECK(FE) in display file field. But it is not happening. Below is the way how the field is declared: CAMT R B 8 14REFFLD(CAMTW) 64 DSPATR(RI) ...
Delete and Update in Query Magager
How can I use delete and update statments in Query Manager (QMQ) in OS/400. I can able to create QM Queries for Select Statment but not able to update tables using Delete and Update statment. Please help, a production project in pending for this. Software/Hardware used: OS/400 on IBM iSeries...
How can I use delete and update statments in Query Manager (QMQ) in OS/400. I can able to create QM Queries for Select Statment but not able to update tables using Delete and Update statment. Please help, a production project in pending for this. Software/Hardware used: OS/400 on IBM iSeries...
FTP a Synon edtrcd1
I made changes to the EDTrcd screen and after compiling it I FTP the new object Via *SAVF to the other server the object moves succesfully and the creation date& time of the OBJ are also same but the changes i have done are not seen inspite the oldscreen is shown.here both server use diplay in...
I made changes to the EDTrcd screen and after compiling it I FTP the new object Via *SAVF to the other server the object moves succesfully and the creation date& time of the OBJ are also same but the changes i have done are not seen inspite the oldscreen is shown.here both server use diplay in...
2 subfiles side by side
hi folks i try to create a DSPF as a window and with 2 subfiles side by side within So i create 2 several windows - once for every subfile, with all OVERLAY, INVITE, USRRSTDSP and WINDOW(..... *NOMSGLN *NORSTCSR), In RPG i wrote Write Window (Main) Write CTL01 Write CTL02 Read DspFile ...
hi folks i try to create a DSPF as a window and with 2 subfiles side by side within So i create 2 several windows - once for every subfile, with all OVERLAY, INVITE, USRRSTDSP and WINDOW(..... *NOMSGLN *NORSTCSR), In RPG i wrote Write Window (Main) Write CTL01 Write CTL02 Read DspFile ...
JDBC connection to DB2/400
Hi, We have application which runs on Java Server connects DB2/400 using JDBC connection. would like to know what is the maximumnumber of database connections supported on DB2/400 and how can I adjust this connection activity so that it is not impacting our application running on as/400 i.e. how to...
Hi, We have application which runs on Java Server connects DB2/400 using JDBC connection. would like to know what is the maximumnumber of database connections supported on DB2/400 and how can I adjust this connection activity so that it is not impacting our application running on as/400 i.e. how to...
SQLRPGLE Cursors and Recursion
I'm trying to recursively call a PI in my SQLRPGLE program. Problem is, I get an SQLCODE error of -519 and I'm sure it has to do with cursors and the prepare statement in my PI. Here's the code: pprintPrograms b dprintPrograms PI d...
I'm trying to recursively call a PI in my SQLRPGLE program. Problem is, I get an SQLCODE error of -519 and I'm sure it has to do with cursors and the prepare statement in my PI. Here's the code: pprintPrograms b dprintPrograms PI d...
The IT Blog Top 10: Nov. 19, 2009
10. The intermediate IBM i 6.1.1 version Mark Fontecchio takes a look at IBM i 6.1.1, and answers the question of how well it fills the gap for those waiting for i5/OS. 9. Using VRDP to view VirtualBox virtual machines remotely Rick Vanover explains some important adminsitration techniques for...
10. The intermediate IBM i 6.1.1 version Mark Fontecchio takes a look at IBM i 6.1.1, and answers the question of how well it fills the gap for those waiting for i5/OS. 9. Using VRDP to view VirtualBox virtual machines remotely Rick Vanover explains some important adminsitration techniques for...
PicklistStrings returning a blank view when on a local replica
I have a button on a form that allows the user to select a document's values from a view. I used uiworkspace.pickliststrings to return a category of a view for selection. It works fine if using the database on the server. However, when using a local replica, the view returned is blank and I...
I have a button on a form that allows the user to select a document's values from a view. I used uiworkspace.pickliststrings to return a category of a view for selection. It works fine if using the database on the server. However, when using a local replica, the view returned is blank and I...
as/400 query printing with DBCS data
We are having some problems printing query reports since a software upgrade. The upgrade now has DBCS file data and print files. The strange thing is the reports will print on some select printers and not on others. It is very strange, some printers and set-up as *VRT Client Access and others are...
We are having some problems printing query reports since a software upgrade. The upgrade now has DBCS file data and print files. The strange thing is the reports will print on some select printers and not on others. It is very strange, some printers and set-up as *VRT Client Access and others are...
Sequel ViewPoint
I am using Sequel ViewPoint. I have a script with variables defined. I would like to check the variable value to see the value and based on the value I would like to display different views. How would I code the script to do this? Software/Hardware used: Sequel ViewPoint
I am using Sequel ViewPoint. I have a script with variables defined. I would like to check the variable value to see the value and based on the value I would like to display different views. How would I code the script to do this? Software/Hardware used: Sequel ViewPoint
Synon - Maximum OR conditions in CASE Statement
Hi, My Synon program doesnt allows me to add more than 10 OR Conditions in one CASE Statement. C1 OR C2 OR C3 OR C4 OR C5 OR C6 OR C7 OR C8 OR C9 OR C10 OR C11 OR C12 OR C13. when given like above, it only generates the source for first 10 conditions. Remaining are ignore and even no error...
Hi, My Synon program doesnt allows me to add more than 10 OR Conditions in one CASE Statement. C1 OR C2 OR C3 OR C4 OR C5 OR C6 OR C7 OR C8 OR C9 OR C10 OR C11 OR C12 OR C13. when given like above, it only generates the source for first 10 conditions. Remaining are ignore and even no error...
Notes agent accessing attachment from IFS on another iSeries
I have a domino server running on an iSeries(Ranger). Through a scheduled agent I am trying to put an attachment from a different iSeries (Raven) in a notes document. I am having difficulties with this. When the IFS was local (on the same iSeries) it was easy, just point to the directory with...
I have a domino server running on an iSeries(Ranger). Through a scheduled agent I am trying to put an attachment from a different iSeries (Raven) in a notes document. I am having difficulties with this. When the IFS was local (on the same iSeries) it was easy, just point to the directory with...
The IT Blog Top 10: Nov. 12, 2009
10. How to use command line arguments in VBScript via the Wscript.Arguments Object Jerry Lees offers up an indispensible guide for VBScripters. 9. Standard Server 2003 Migration to SBS 2008 Part 3 Roger Crawford’s third part of his series on Server 2003 migrations. 8. Success of 64-bit Internet...
10. How to use command line arguments in VBScript via the Wscript.Arguments Object Jerry Lees offers up an indispensible guide for VBScripters. 9. Standard Server 2003 Migration to SBS 2008 Part 3 Roger Crawford’s third part of his series on Server 2003 migrations. 8. Success of 64-bit Internet...
Showcase Query 8.0 CDs or DVDs
I did an upgrade to V6R1 before I did an update to our Showcase Query Suite. I am looking for a copy of the Showcase Query CD or DVD for Showcase Query Suite 8.0 released after September 2008. If anyone has this and would be willing to send me a copy please let me know. SPSS cannot ship any...
I did an upgrade to V6R1 before I did an update to our Showcase Query Suite. I am looking for a copy of the Showcase Query CD or DVD for Showcase Query Suite 8.0 released after September 2008. If anyone has this and would be willing to send me a copy please let me know. SPSS cannot ship any...
Padding with zeros in Synon/2e
How can we implement Padding with zeros (concept in rpg) in Synon/2e?
How can we implement Padding with zeros (concept in rpg) in Synon/2e?
iSeries SQL UDF gets CPF426A
I created a SQL UDF using the iNav wizard. It created the service program for me yet when I try to use the function I get CPF426A "User-defined function &5 cannot be invoked." with a reason 2 (Either the service program is not found or the program entry point &6 does not exist.) It says the...
I created a SQL UDF using the iNav wizard. It created the service program for me yet when I try to use the function I get CPF426A "User-defined function &5 cannot be invoked." with a reason 2 (Either the service program is not found or the program entry point &6 does not exist.) It says the...
The most-watched IT questions this week: Nov. 3, 2009
Here are the 10 most watched questions on ITKE: There’s some great discussions going on. Go answer a question now and take your shot at winning a TV: 1. Problem installing Exchange 2007 Management Tools was posed by Labnuke99 and answered by Mshen. 2. What Event ID was asked by Newbiepeon and...
Here are the 10 most watched questions on ITKE: There’s some great discussions going on. Go answer a question now and take your shot at winning a TV: 1. Problem installing Exchange 2007 Management Tools was posed by Labnuke99 and answered by Mshen. 2. What Event ID was asked by Newbiepeon and...
The IT Blog Top 10: Oct. 29, 2009
10. Choosing a block size when creating VMFS datastores Eric Siebert has written a guide on how to choose the right size for VMFS datastores. 9. How to use command line arguments in VBScript via the Wscript.Arguments Object Jerry Lees explains a helpful VBScript trick. 8. Using VRDP to view...
10. Choosing a block size when creating VMFS datastores Eric Siebert has written a guide on how to choose the right size for VMFS datastores. 9. How to use command line arguments in VBScript via the Wscript.Arguments Object Jerry Lees explains a helpful VBScript trick. 8. Using VRDP to view...
Linux Deployment Guide for Soho or SME
We all know the basic configuration for a windows network with a windows server (or Samba Server) at the heart of the network with clients connecting to the server storing profiles and data folders on the server that's mapped to the clients at the time of log on. All work is safely stored on the...
We all know the basic configuration for a windows network with a windows server (or Samba Server) at the heart of the network with clients connecting to the server storing profiles and data folders on the server that's mapped to the clients at the time of log on. All work is safely stored on the...
