Trigger or something like that for Select sentence
I need a trigger or something which will be launch when i open a table with a “select” sentence…i know that triggers per se only work with “update, insert or delete” (ddl or dml) but i want to know if i can do something that works like a trigger but only when i do a [...]
Answer Question
| September 21, 2006 6:38 PM
SQL
I need a trigger or something which will be launch when i open a table with a “select” sentence…i know that triggers per se only work with “update, insert or delete” (ddl or dml) but i want to know if i can do something that works like a trigger but only when i do a [...]
Answer Question
| September 21, 2006 6:38 PM
SQL
error in connection between oracle8i&developer2000
I’m installing Oracle8i on Windows 2000 professional on NTFS partition and on the same machine I’m installing Developer 2000 or form6 in a different partition. When I try to connect Developer to Oracle, I get the error “TNS could not resolve.” Please provide a solution. Can I use Oracle8i Enterprise and Developer 2000 on the [...]
Answer Question
| February 4, 2009 4:46 AM
Architecture/Design, Availability, Backup & recovery, Database, DB2, Desktops, Interoperability, Management, Microsoft Windows, Oracle, Oracle 8i, Oracle administration, OS, Performance/Tuning, Servers, Software, SQL, SQL Server
I’m installing Oracle8i on Windows 2000 professional on NTFS partition and on the same machine I’m installing Developer 2000 or form6 in a different partition. When I try to connect Developer to Oracle, I get the error “TNS could not resolve.” Please provide a solution. Can I use Oracle8i Enterprise and Developer 2000 on the [...]
Answer Question
| February 4, 2009 4:46 AM
Architecture/Design, Availability, Backup & recovery, Database, DB2, Desktops, Interoperability, Management, Microsoft Windows, Oracle, Oracle 8i, Oracle administration, OS, Performance/Tuning, Servers, Software, SQL, SQL Server
career advice
i am a fresh graduate in petroleum engineering and wish to purse a course in sap, I have no experince in IT order than basic computer knowledge.I want a sap course that is related to my field (petroleum Eng) and also make me a consultant.I was looking at MM in sap until recently I met [...]
Answer Question
| September 18, 2006 6:16 PM
Basis, Career development, Certifications, CRM, Database, DB2, MySAP, Oracle, RPGLE, SAP, SAP careers, SQL, Training
i am a fresh graduate in petroleum engineering and wish to purse a course in sap, I have no experince in IT order than basic computer knowledge.I want a sap course that is related to my field (petroleum Eng) and also make me a consultant.I was looking at MM in sap until recently I met [...]
Answer Question
| September 18, 2006 6:16 PM
Basis, Career development, Certifications, CRM, Database, DB2, MySAP, Oracle, RPGLE, SAP, SAP careers, SQL, Training
please solve this query
Create Emp table containing an Empno column with the following sample data:- EMP ——- EMPNO ———– 1 5 9 14 20 25 Write a SELECT statement to display the range of missing numbers. Your output should be as follows:- MISSING ———— 2 ?- 4 6 ?-8 10 ?- 13 15 ?- 19 21 ?- 24 [...]
Answer Question
| September 5, 2006 4:04 AM
Database, DB2, Oracle, Oracle development, SQL
Create Emp table containing an Empno column with the following sample data:- EMP ——- EMPNO ———– 1 5 9 14 20 25 Write a SELECT statement to display the range of missing numbers. Your output should be as follows:- MISSING ———— 2 ?- 4 6 ?-8 10 ?- 13 15 ?- 19 21 ?- 24 [...]
Answer Question
| September 5, 2006 4:04 AM
Database, DB2, Oracle, Oracle development, SQL
Problem finding a column name.
The following SQL is giving me the message: Server: Msg 207, Level 16, State 3, Line 1 Invalid column name ‘ProductCode’. How can I correct this code. The column name does exist in the table. I also want to group by Product Code and not by Container Name. Thank you. SELECT a.ProductCode AS “Product Name”, [...]
Answer Question
| August 20, 2006 3:58 PM
SQL, T-SQL
The following SQL is giving me the message: Server: Msg 207, Level 16, State 3, Line 1 Invalid column name ‘ProductCode’. How can I correct this code. The column name does exist in the table. I also want to group by Product Code and not by Container Name. Thank you. SELECT a.ProductCode AS “Product Name”, [...]
Answer Question
| August 20, 2006 3:58 PM
SQL, T-SQL
Access Oracle/Sybase/Informix from RPG
Hi, I would like to access Oracle/Sybase/Informix directly from within an RPG program. This is something similar to ODBC but in reverse – my data source is external to the iSeries and my application and APIs, or called routines, internal in the iSeries. The access to the external database should: 1. Not employ another server. [...]
Answer Question
| November 28, 2011 8:29 AM
Application development, AS/400, Database, DataCenter, DB2, DB2 Universal Database, Oracle, RPG, RPGLE, SQL, Web development
Hi, I would like to access Oracle/Sybase/Informix directly from within an RPG program. This is something similar to ODBC but in reverse – my data source is external to the iSeries and my application and APIs, or called routines, internal in the iSeries. The access to the external database should: 1. Not employ another server. [...]
Answer Question
| November 28, 2011 8:29 AM
Application development, AS/400, Database, DataCenter, DB2, DB2 Universal Database, Oracle, RPG, RPGLE, SQL, Web development
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
Backup
Hi Guys How can i backup data base and the accounts settings in MS SQL Thanks in advance
Answer Question
| August 4, 2006 2:21 PM
SQL, SQL Server
Hi Guys How can i backup data base and the accounts settings in MS SQL Thanks in advance
Answer Question
| August 4, 2006 2:21 PM
SQL, SQL Server
WITH clause not working.
This is the first time I’m using the WITH clause, and am getting “missing expression”. I am rewriting a MUCH larger query, so much of the code below that seems extraneous is needed for the pieces that aren’t in there yet. Can anyone tell me what needs to be changed to make this work? WITH [...]
Answer Question
| August 7, 2006 11:23 AM
SQL
This is the first time I’m using the WITH clause, and am getting “missing expression”. I am rewriting a MUCH larger query, so much of the code below that seems extraneous is needed for the pieces that aren’t in there yet. Can anyone tell me what needs to be changed to make this work? WITH [...]
Answer Question
| August 7, 2006 11:23 AM
SQL
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
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
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
Trying to Load and Display Contents of a Bfile
I created a table with a key_value and Bfile column. Create a directory alias. Insert a row using the BFILENAME procedure. I said 1 row added. Tried to execute the PL/SQL code below. I get an “nonexistent directory or file error on Open”. What is wrong and how can I determine I insert a record [...]
Answer Question
| June 27, 2006 2:37 PM
SQL
I created a table with a key_value and Bfile column. Create a directory alias. Insert a row using the BFILENAME procedure. I said 1 row added. Tried to execute the PL/SQL code below. I get an “nonexistent directory or file error on Open”. What is wrong and how can I determine I insert a record [...]
Answer Question
| June 27, 2006 2:37 PM
SQL
SQL Alias visibility
We have found that creating an SQL alias works for accessing file members in embedded and interactive SQL. But if we create an ALIAS in our live libraries with the intention of keeping it for frequent use, how do we know it exists other than WRKOBJ? It doesn’t show up in DSPDBR. And is there [...]
Answer Question
| June 23, 2006 4:17 PM
Application development, DB2 Universal Database, SQL
We have found that creating an SQL alias works for accessing file members in embedded and interactive SQL. But if we create an ALIAS in our live libraries with the intention of keeping it for frequent use, how do we know it exists other than WRKOBJ? It doesn’t show up in DSPDBR. And is there [...]
Answer Question
| June 23, 2006 4:17 PM
Application development, DB2 Universal Database, SQL
Using xp_cmdshell
Hi, I am using xp_cmdshell in one of my stored procedures(database SQL server) to delete older files from a folder in another server. That server is mapped as a network drive on the sql server computer. But when I used this drive inside xp_cmdshell command and do a dir , the output I get is [...]
Answer Question
| May 15, 2008 12:29 PM
DataCenter, Desktops, Development, Hardware, Management, Microsoft Windows, OS, Security, Servers, SQL, SQL Server
Hi, I am using xp_cmdshell in one of my stored procedures(database SQL server) to delete older files from a folder in another server. That server is mapped as a network drive on the sql server computer. But when I used this drive inside xp_cmdshell command and do a dir , the output I get is [...]
Answer Question
| May 15, 2008 12:29 PM
DataCenter, Desktops, Development, Hardware, Management, Microsoft Windows, OS, Security, Servers, SQL, SQL Server
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
INSERT WITH SELECT (CAN’T SEEM TO FIND EXPLANATION)
Can someone please explain the INSERT syntax that is in the Oracle Database 10g SQL class. I can’t seem to find anyone who knows. An example of the statement that I don’t understand is: INSERT INTO (SELECT last_name, salary FROM EMPLOYEES WHERE department_id = 50) VALUES (… What is the SELECT statement in the INSERT [...]
Answer Question
| June 20, 2006 1:18 PM
SQL
Can someone please explain the INSERT syntax that is in the Oracle Database 10g SQL class. I can’t seem to find anyone who knows. An example of the statement that I don’t understand is: INSERT INTO (SELECT last_name, salary FROM EMPLOYEES WHERE department_id = 50) VALUES (… What is the SELECT statement in the INSERT [...]
Answer Question
| June 20, 2006 1:18 PM
SQL
Select single row
Hi, I have a sql server table which has fields like this productNO, Description, loc_quantity. one product can have multiple locations . Location has multiple columns for different location codes. Like Location_qty_11, Location_qty_40 like that. The table gets populated from other tables which puts null in the loc_qty column if it does not have any [...]
Answer Question
| June 20, 2006 1:03 PM
SQL, SQL Server
Hi, I have a sql server table which has fields like this productNO, Description, loc_quantity. one product can have multiple locations . Location has multiple columns for different location codes. Like Location_qty_11, Location_qty_40 like that. The table gets populated from other tables which puts null in the loc_qty column if it does not have any [...]
Answer Question
| June 20, 2006 1:03 PM
SQL, SQL Server
Convert cahr field to datetime
I am trying to select data for last six months . The date field has a character data type. And it has the format like CYYMM(century,year,month) example: march2006 is ’10603′. How can I select from that table the data for last six months. Please help.. Thanks in advance!
Answer Question
| June 3, 2006 5:24 PM
SQL
I am trying to select data for last six months . The date field has a character data type. And it has the format like CYYMM(century,year,month) example: march2006 is ’10603′. How can I select from that table the data for last six months. Please help.. Thanks in advance!
Answer Question
| June 3, 2006 5:24 PM
SQL
