DB2 Stored Procedure V4R4 without ILE C/400
We have an older iSeries running V4R4. We user Rumba/400 for AS400 access, and we’ve run into a problem using the Rumba ODBC driver for linked server access from our SQL server to our AS400 (The ODBC driver periodically fails when the linked server is used heavily). Because of this, we’ve been doing everything we [...]
Answer Question
| December 5, 2010 11:00 AM
AS/400, CLP, Database, DB2, DB2 Universal Database, Oracle, SQL, SQL Server
We have an older iSeries running V4R4. We user Rumba/400 for AS400 access, and we’ve run into a problem using the Rumba ODBC driver for linked server access from our SQL server to our AS400 (The ODBC driver periodically fails when the linked server is used heavily). Because of this, we’ve been doing everything we [...]
Answer Question
| December 5, 2010 11:00 AM
AS/400, CLP, Database, DB2, DB2 Universal Database, Oracle, SQL, SQL Server
Stored Procedures on AS/400
Greetings, I understand SQL stored procedures on the AS/400 generate C source code which is compiled to create a C ILE program object. I could use the same SQL statements in an RPGLE with embedded SQL program and use that to create a RPG stored procedure. Which of the two is more efficient? Thanks for [...]
Answer Question
| December 14, 2009 10:58 AM
Application development, AS/400, Database, DB2, DB2 Universal Database, Development, Oracle, PC/Windows Connectivity, RPG, RPGLE, SQL, SQL Server, Web development, Web development tools, WebSphere Studio
Greetings, I understand SQL stored procedures on the AS/400 generate C source code which is compiled to create a C ILE program object. I could use the same SQL statements in an RPGLE with embedded SQL program and use that to create a RPG stored procedure. Which of the two is more efficient? Thanks for [...]
Answer Question
| December 14, 2009 10:58 AM
Application development, AS/400, Database, DB2, DB2 Universal Database, Development, Oracle, PC/Windows Connectivity, RPG, RPGLE, SQL, SQL Server, Web development, Web development tools, WebSphere Studio
pl/sql ref cursor question
Hi, I’m trying to figure out if this is possible in Java OPTION 1 ================== 1. Obtain a ResultSet by querying a non-oracle database 2. Cast the resultSet into an OracleResultSet 3. Pass the OracleResultSet into a pl/sql stored procedure for processing OPTION 2 ================= 1. Obtain a ResultSet by querying a non-oracle database 2. [...]
Answer Question
| August 2, 2006 6:11 PM
Database, DB2, DB2 Universal Database, Oracle, SQL
Hi, I’m trying to figure out if this is possible in Java OPTION 1 ================== 1. Obtain a ResultSet by querying a non-oracle database 2. Cast the resultSet into an OracleResultSet 3. Pass the OracleResultSet into a pl/sql stored procedure for processing OPTION 2 ================= 1. Obtain a ResultSet by querying a non-oracle database 2. [...]
Answer Question
| August 2, 2006 6:11 PM
Database, DB2, DB2 Universal Database, Oracle, SQL
ORACLE NOT RECOGNIZING NEW RAM
We installed more memory on our Windows Enterprise Server but Oracle does not recognize the new memory. I know this because when I select ?host? from Enterprise Manager?s home page the host memory is listed as 2g and it should be 6g. If I try to use the new memory by increasing the sga_max_size Oracle [...]
Answer Question
| August 2, 2006 6:58 PM
Oracle, Oracle administration, Windows
We installed more memory on our Windows Enterprise Server but Oracle does not recognize the new memory. I know this because when I select ?host? from Enterprise Manager?s home page the host memory is listed as 2g and it should be 6g. If I try to use the new memory by increasing the sga_max_size Oracle [...]
Answer Question
| August 2, 2006 6:58 PM
Oracle, Oracle administration, Windows
Automatically Populating a Date Field in a Table
Can you please forward me an example of a trigger or some other means on how I can update a date field (e.g., DATE_COMPLETED) in a table when another field (e.g., EDITS_COMPLETED) within that same table has been populate with a particular value (YES)
Answer Question
| July 26, 2006 3:39 PM
Oracle
Can you please forward me an example of a trigger or some other means on how I can update a date field (e.g., DATE_COMPLETED) in a table when another field (e.g., EDITS_COMPLETED) within that same table has been populate with a particular value (YES)
Answer Question
| July 26, 2006 3:39 PM
Oracle
Using LIKE with Variable Value not Literal Value….INSTR not optional
I’m trying to build a search type select statement constrained by a users input…..variable(x) which forces the use of like in the selection processing: x := (whatever user enters); I have tried with no luck: Select * from personnel where lastname like ‘%x%’; Select * from personnel where lastname like “‘%” x “%’”; If you [...]
Answer Question
| July 24, 2006 9:24 AM
Oracle, SQL
I’m trying to build a search type select statement constrained by a users input…..variable(x) which forces the use of like in the selection processing: x := (whatever user enters); I have tried with no luck: Select * from personnel where lastname like ‘%x%’; Select * from personnel where lastname like “‘%” x “%’”; If you [...]
Answer Question
| July 24, 2006 9:24 AM
Oracle, SQL
ora-12154
I’m new to Oracle so forgive me if I don’t have all the terminology down, but I’ve installed Oracle 10g and I’m constantly getting an “ora-12154 Could not resolve the connect identifier” error at step 12 in database configuration assistant. I beleive it has something to do with the tnsnames.ora file and I’ve played around [...]
Answer Question
| July 20, 2006 12:58 PM
Oracle
I’m new to Oracle so forgive me if I don’t have all the terminology down, but I’ve installed Oracle 10g and I’m constantly getting an “ora-12154 Could not resolve the connect identifier” error at step 12 in database configuration assistant. I beleive it has something to do with the tnsnames.ora file and I’ve played around [...]
Answer Question
| July 20, 2006 12:58 PM
Oracle
HELP : I retrieve a blank page with UTL_HTTP in a request to a server which listen in a different Port than 80
Dear colleagues I have a problem because a developer form our team, has a problem to retrieve a webpage in Oracle Portal whit UTL_HTTP. If he attempts to retrieve a webpage (pending to Oracle Portal) by a PACKAGE whit the next sentence: URL_TABLE := utl_http.request_pieces(p_website, 99999, ‘<server.domain.com>:7778′) he received a blank page. If he attempts [...]
Answer Question
| July 12, 2006 1:44 PM
Oracle 9i, Oracle development
Dear colleagues I have a problem because a developer form our team, has a problem to retrieve a webpage in Oracle Portal whit UTL_HTTP. If he attempts to retrieve a webpage (pending to Oracle Portal) by a PACKAGE whit the next sentence: URL_TABLE := utl_http.request_pieces(p_website, 99999, ‘<server.domain.com>:7778′) he received a blank page. If he attempts [...]
Answer Question
| July 12, 2006 1:44 PM
Oracle 9i, Oracle development
Oracle Application or Database on its own server.
Which would increase performance more. Moving an Oracle demand planning and forcasting application or an Oracle database onto its own server and or a faster server? There is some debate among myself and a couple of coworkers. I feel that the workhorse of Oracle is the database and that it should be on its own [...]
Answer Question
| July 14, 2006 10:47 AM
Database, DB2, Oracle, Performance/Tuning, Windows
Which would increase performance more. Moving an Oracle demand planning and forcasting application or an Oracle database onto its own server and or a faster server? There is some debate among myself and a couple of coworkers. I feel that the workhorse of Oracle is the database and that it should be on its own [...]
Answer Question
| July 14, 2006 10:47 AM
Database, DB2, Oracle, Performance/Tuning, Windows
Running a script at specified runtime
I am creating an Oracle Developer form which will take the query created by the user and specified runtime (also by user) and saves it in two columns of a Oracle table. Is there a facility in oracle which can trigger off the saved query when the sysdate becomes equal to specified runtime? Thanks
Answer Question
| July 11, 2006 12:23 PM
Architecture/Design, Availability, Backup & recovery, Business Intelligence, Data/Application Integration, E-Business Suite, Installation, Migration, Oracle, Oracle 9i, Oracle administration, Oracle Business Applications, Oracle Database Versions, Oracle development, Performance/Tuning, Security, SQL, Windows
I am creating an Oracle Developer form which will take the query created by the user and specified runtime (also by user) and saves it in two columns of a Oracle table. Is there a facility in oracle which can trigger off the saved query when the sysdate becomes equal to specified runtime? Thanks
Answer Question
| July 11, 2006 12:23 PM
Architecture/Design, Availability, Backup & recovery, Business Intelligence, Data/Application Integration, E-Business Suite, Installation, Migration, Oracle, Oracle 9i, Oracle administration, Oracle Business Applications, Oracle Database Versions, Oracle development, Performance/Tuning, Security, SQL, Windows
cannot drop the user
Hi, I cannot drop the user. dorp user “USERA” cascade; ORA-01940: cannot drop a user that is currently connected But when I check v$session table. I do not see any USERA. This happens on me several times and every time when I face this, I need to restart my database. Is there any better method [...]
Answer Question
| July 13, 2006 5:23 PM
Oracle, Oracle administration
Hi, I cannot drop the user. dorp user “USERA” cascade; ORA-01940: cannot drop a user that is currently connected But when I check v$session table. I do not see any USERA. This happens on me several times and every time when I face this, I need to restart my database. Is there any better method [...]
Answer Question
| July 13, 2006 5:23 PM
Oracle, Oracle administration
Can’t login as Administrator
Hello Everybody, I can’t login to adminstrator profile in my standalone win 2000 adv server. I use this system for my study purposes. What happened actually is when I was shuting my system, it got powered off because of some UPS problem and the next time when I logged in using Administrator, it showed me [...]
Answer Question
| June 29, 2006 7:29 AM
Backup & recovery, Cabling, Data analysis, Data mining/analysis, Data warehousing applications, Database, DataCenter, DataManagement, DB2, Desktop management applications, Desktops, DHCP, DNS, Ecommerce applications, Enterprise Desktop, Exchange, Hardware, Hewlett-Packard, Hubs, Instant Messaging, Lotus Domino, Management, Microsoft Systems Management Server, Microsoft Windows, Network management software, Networking, Networking services, Oracle, OS, PC/Windows Connectivity, Power management, Routers, Security, Servers, Software, SQL Server, Switches, Systems management software, Tech support, Training
Hello Everybody, I can’t login to adminstrator profile in my standalone win 2000 adv server. I use this system for my study purposes. What happened actually is when I was shuting my system, it got powered off because of some UPS problem and the next time when I logged in using Administrator, it showed me [...]
Answer Question
| June 29, 2006 7:29 AM
Backup & recovery, Cabling, Data analysis, Data mining/analysis, Data warehousing applications, Database, DataCenter, DataManagement, DB2, Desktop management applications, Desktops, DHCP, DNS, Ecommerce applications, Enterprise Desktop, Exchange, Hardware, Hewlett-Packard, Hubs, Instant Messaging, Lotus Domino, Management, Microsoft Systems Management Server, Microsoft Windows, Network management software, Networking, Networking services, Oracle, OS, PC/Windows Connectivity, Power management, Routers, Security, Servers, Software, SQL Server, Switches, Systems management software, Tech support, Training
Exporting from Access to Outlook
I have some fields in an Access database that I want to use in Outlook. I want to take the First name, last name and email fields from this table and put them into my Contact List in Outlook. Is there an easy way to do this? I have tried exporting the db1 file and [...]
Answer Question
| June 21, 2006 2:10 PM
Database, DB2, Development, Exchange, Oracle
I have some fields in an Access database that I want to use in Outlook. I want to take the First name, last name and email fields from this table and put them into my Contact List in Outlook. Is there an easy way to do this? I have tried exporting the db1 file and [...]
Answer Question
| June 21, 2006 2:10 PM
Database, DB2, Development, Exchange, Oracle
What is the location of servlets?
I have not been successful in executing a servlet whose physical location is C:MyWorkMyProjectclassesmyServlet.class. In the jsp file I have <form action=”../classes.myServlet” method=”post”>. But, when I run the project within JDeveloper and when tried to execute the servlet, I get “The Page Cannot be Found” error. I can see the OC4JServer starts running and the [...]
Answer Question
| August 28, 2009 9:15 AM
Development, HTML, J2EE, Java, JSP, Oracle Business Applications, SQL, Web site design & management
I have not been successful in executing a servlet whose physical location is C:MyWorkMyProjectclassesmyServlet.class. In the jsp file I have <form action=”../classes.myServlet” method=”post”>. But, when I run the project within JDeveloper and when tried to execute the servlet, I get “The Page Cannot be Found” error. I can see the OC4JServer starts running and the [...]
Answer Question
| August 28, 2009 9:15 AM
Development, HTML, J2EE, Java, JSP, Oracle Business Applications, SQL, Web site design & management
Using Secure Shell (ssh)
I have to submit a remote command from the AS/400 to run on a UNIX system. I am told by security admin. that I can only use Secure Shell(ssh). Both the AS/400 and the UNIX server are within the firewall. I do not know where to start. Does OS/400 V5R3 have this capability? Do I [...]
Answer Question
| June 20, 2006 10:00 PM
AS/400, Database, DataCenter, DB2, Desktops, Development, E-business, Management, Microsoft Windows, Networking, Oracle, OS, Security, Servers, SQL Server
I have to submit a remote command from the AS/400 to run on a UNIX system. I am told by security admin. that I can only use Secure Shell(ssh). Both the AS/400 and the UNIX server are within the firewall. I do not know where to start. Does OS/400 V5R3 have this capability? Do I [...]
Answer Question
| June 20, 2006 10:00 PM
AS/400, Database, DataCenter, DB2, Desktops, Development, E-business, Management, Microsoft Windows, Networking, Oracle, OS, Security, Servers, SQL Server
How to execute iSQL*Plus script from Oracle Portal
I want to execute a SQL*Plus script which ask for parameters and updates an Oracle table from Portal. Any suggestions on how to do this? Thanks Bonita Graupe
Answer Question
| June 12, 2006 9:50 AM
Oracle
I want to execute a SQL*Plus script which ask for parameters and updates an Oracle table from Portal. Any suggestions on how to do this? Thanks Bonita Graupe
Answer Question
| June 12, 2006 9:50 AM
Oracle
Oracle 9i upgrades
I have an ORACLE_HOME installation /opt/oracle/9.2.0.4 and will upgrade this to 9.2.0.6 using the appropriate patchset. First running the Installer and then the sql scripts to update my database. When complete how do I change my ORACLE_HOME to reflect the new version e.g. 9.2.0.6 and what are the implications if any ?
Answer Question
| June 7, 2006 9:39 PM
Database, DB2, Oracle
I have an ORACLE_HOME installation /opt/oracle/9.2.0.4 and will upgrade this to 9.2.0.6 using the appropriate patchset. First running the Installer and then the sql scripts to update my database. When complete how do I change my ORACLE_HOME to reflect the new version e.g. 9.2.0.6 and what are the implications if any ?
Answer Question
| June 7, 2006 9:39 PM
Database, DB2, Oracle
SAVACTWAIT time on SAVLIB, etc.
Hi, Has anyone experimented with the SAVACTWAIT time on the SAVLIB command. The default on 120 second seems rather long. What I am looking for is a realistic value based on fact such as that if an object does not become available after 5 second the change that it will become available after 120 seconds [...]
Answer Question
| November 30, 2010 8:19 AM
Application security, AS/400, Backup & recovery, Data analysis, Database, DataCenter, DB2, DB2 Universal Database, Encryption, Exchange, Instant Messaging, Oracle, Secure Coding, Security
Hi, Has anyone experimented with the SAVACTWAIT time on the SAVLIB command. The default on 120 second seems rather long. What I am looking for is a realistic value based on fact such as that if an object does not become available after 5 second the change that it will become available after 120 seconds [...]
Answer Question
| November 30, 2010 8:19 AM
Application security, AS/400, Backup & recovery, Data analysis, Database, DataCenter, DB2, DB2 Universal Database, Encryption, Exchange, Instant Messaging, Oracle, Secure Coding, Security
Read Only Document Question
Scenario: We have a Word document that is our Facility Calendar. The secretary updates it as requested with meetings, seminars, etc. The problem: When someone else has the document open, she cannot save changes she makes. She then has to email everyone and tell them to close the document. Details: We will not use Outlook [...]
Answer Question
| May 27, 2006 6:02 PM
Automated, Billing and customer care, Billing Support Systems, Database, DataCenter, DB2, Desktop management applications, Desktops, Development, Functional, Help Desk, Management, Manufacturing applications, Microsoft Windows, Networking, Oracle, OS, Performance/Load, Security, Servers, Software, Software testing, Software testing tools, SQL Server, Storage, Tech support, Web
Scenario: We have a Word document that is our Facility Calendar. The secretary updates it as requested with meetings, seminars, etc. The problem: When someone else has the document open, she cannot save changes she makes. She then has to email everyone and tell them to close the document. Details: We will not use Outlook [...]
Answer Question
| May 27, 2006 6:02 PM
Automated, Billing and customer care, Billing Support Systems, Database, DataCenter, DB2, Desktop management applications, Desktops, Development, Functional, Help Desk, Management, Manufacturing applications, Microsoft Windows, Networking, Oracle, OS, Performance/Load, Security, Servers, Software, Software testing, Software testing tools, SQL Server, Storage, Tech support, Web
Oracle Reference to Table_Name, Column_Name, etc by reference to variable
Does Oracle prohibit reference to Table_Name, Column_Name, etc by reference to a declared variable? I am trying to create a simple routine to print documentation whenever any changes are made to the database using the following routine: DECLARE CURSOR Table_cursor is SELECT * FROM TABS WHERE table_name like upper(‘c%’) or table_name like upper(‘t%’) or table_name [...]
Answer Question
| September 16, 2008 3:15 PM
Oracle, Oracle 8i, Oracle development, SQL
Does Oracle prohibit reference to Table_Name, Column_Name, etc by reference to a declared variable? I am trying to create a simple routine to print documentation whenever any changes are made to the database using the following routine: DECLARE CURSOR Table_cursor is SELECT * FROM TABS WHERE table_name like upper(‘c%’) or table_name like upper(‘t%’) or table_name [...]
Answer Question
| September 16, 2008 3:15 PM
Oracle, Oracle 8i, Oracle development, SQL
