Java and Oracle
hi Sir, I have an application web based. using Oracle backend and Java front end. App server is in weblogic and Solaris os and two cpu with 8 applications. DB server is oracle 8.1.7 on Solaris This application is getting slow when number of threads are more ( like many users login and related activities) [...]
Answer Question
| November 10, 2005 2:18 AM
Database, DB2, Oracle, SQL
hi Sir, I have an application web based. using Oracle backend and Java front end. App server is in weblogic and Solaris os and two cpu with 8 applications. DB server is oracle 8.1.7 on Solaris This application is getting slow when number of threads are more ( like many users login and related activities) [...]
Answer Question
| November 10, 2005 2:18 AM
Database, DB2, Oracle, SQL
Question about a frequently changing column as primary key
Thank you for taking take to read my question. We have a live J2EE application using Oracle 8i. Now we are doing v2 to add some modules. We found it has a frequently changing column (status_code) as part of the composite primary keys in some major tables. We know it can cause future proformance issues, [...]
Answer Question
| December 12, 2005 9:27 AM
Data analysis, Database, DB2, Development, E-business, Ecommerce applications, J2EE, Java, Lifecycle development, Oracle, Programming Languages, SQL, Windows
Thank you for taking take to read my question. We have a live J2EE application using Oracle 8i. Now we are doing v2 to add some modules. We found it has a frequently changing column (status_code) as part of the composite primary keys in some major tables. We know it can cause future proformance issues, [...]
Answer Question
| December 12, 2005 9:27 AM
Data analysis, Database, DB2, Development, E-business, Ecommerce applications, J2EE, Java, Lifecycle development, Oracle, Programming Languages, SQL, Windows
Synchronizing expired merge subscription database with publication database
I had a merge subscription expire and now need to synchronize two disparate databases. How do I do so without overwriting the subscriber database with the publication snapshot? Thanks for any help you can give.
Answer Question
| October 28, 2005 11:08 AM
Data analysis, Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server, Updates from SearchSQLServer.com staff
I had a merge subscription expire and now need to synchronize two disparate databases. How do I do so without overwriting the subscriber database with the publication snapshot? Thanks for any help you can give.
Answer Question
| October 28, 2005 11:08 AM
Data analysis, Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server, Updates from SearchSQLServer.com staff
Reference a query object from another query
I want to be able to reference a db2 query from another query. Is this possible? For example: select table_data.field1, query_data.field1, query_data.field2 from table_data, query_data where table_data.field1 = table_data.field 1 In the above example, query_data is a db2 query that I have created so I am the object owner. I seem to only be able [...]
Answer Question
| November 3, 2005 2:28 PM
SQL
I want to be able to reference a db2 query from another query. Is this possible? For example: select table_data.field1, query_data.field1, query_data.field2 from table_data, query_data where table_data.field1 = table_data.field 1 In the above example, query_data is a db2 query that I have created so I am the object owner. I seem to only be able [...]
Answer Question
| November 3, 2005 2:28 PM
SQL
Need help in sloving some JOB Abends
Hi All, I am new to the mainframe application development environment.Can anyone help me how to solve JCL Abends like say SOC7,SOC4. regards, Aravind
Answer Question
| October 26, 2005 5:33 AM
390, COBOL, DB2, Development, Mainframe, Programming Languages, REXX, SQL, Update from Search390.com staff, zSeries
Hi All, I am new to the mainframe application development environment.Can anyone help me how to solve JCL Abends like say SOC7,SOC4. regards, Aravind
Answer Question
| October 26, 2005 5:33 AM
390, COBOL, DB2, Development, Mainframe, Programming Languages, REXX, SQL, Update from Search390.com staff, zSeries
Knowing the number of rows in a cursor
Hello everybody. Can somebody tell me if there is a way to know the number of rows returned or included in a cursor without having to cross the entire result set ? a function like “resultSetCount” or something like that ? I thought that %rowcount could work, but this returns the current row number, and [...]
Answer Question
| October 27, 2005 5:19 PM
Database, DB2, Oracle, SQL, Windows
Hello everybody. Can somebody tell me if there is a way to know the number of rows returned or included in a cursor without having to cross the entire result set ? a function like “resultSetCount” or something like that ? I thought that %rowcount could work, but this returns the current row number, and [...]
Answer Question
| October 27, 2005 5:19 PM
Database, DB2, Oracle, SQL, Windows
Deleting duplicate rows based on timestamps
Hello.. I’m quite new to MYSQL.. I have a table with two fields : tag_in and time_in, where time_in is a timestamp field.. Some rows have the same value for tag_in.. I’d like to neaten up the database in 2 ways: 1. Delete rows with duplicate tag_in but removing the one with the oldest timestamp [...]
Answer Question
| October 22, 2005 1:11 PM
Database, DB2, Oracle, SQL
Hello.. I’m quite new to MYSQL.. I have a table with two fields : tag_in and time_in, where time_in is a timestamp field.. Some rows have the same value for tag_in.. I’d like to neaten up the database in 2 ways: 1. Delete rows with duplicate tag_in but removing the one with the oldest timestamp [...]
Answer Question
| October 22, 2005 1:11 PM
Database, DB2, Oracle, SQL
Need help with max function within a left outer join
I need to search for a max timestamp of a column within a left outer join statement. I have tried many different combinations unsuccessfully.
Answer Question
| October 19, 2005 8:57 AM
Database, DB2, Oracle, SQL
I need to search for a max timestamp of a column within a left outer join statement. I have tried many different combinations unsuccessfully.
Answer Question
| October 19, 2005 8:57 AM
Database, DB2, Oracle, SQL
Help using oracle Analytical function.
I am trying to create a query that will do two parallel select from the data available. I want to write one select statement using analytical functions, What I want to do is as follows: I one single query I want to find out the count of the transactions in the last 7 days from [...]
Answer Question
| October 28, 2005 7:16 PM
Oracle, SQL, Windows
I am trying to create a query that will do two parallel select from the data available. I want to write one select statement using analytical functions, What I want to do is as follows: I one single query I want to find out the count of the transactions in the last 7 days from [...]
Answer Question
| October 28, 2005 7:16 PM
Oracle, SQL, Windows
AS/400 – iSeries SQL Update of on table with values from another joined table
I’ve use an SQL utility on the AS/400 call SEQUEL by ASC, that allows updating of values in one table from values in another joined table. The syntax is something like this: update set((a.fld1=b.fld1)(a.fld2=b.fld2)) from file1 a join file2 b on a.key1=b.key1 where a.key1='OnlyTheOneIWant' I no longer have access to the SEQUEL tool, and I’m [...]
Answer Question
| May 8, 2013 1:34 PM
AS/400, DB2 Universal Database, SQL
I’ve use an SQL utility on the AS/400 call SEQUEL by ASC, that allows updating of values in one table from values in another joined table. The syntax is something like this: update set((a.fld1=b.fld1)(a.fld2=b.fld2)) from file1 a join file2 b on a.key1=b.key1 where a.key1='OnlyTheOneIWant' I no longer have access to the SEQUEL tool, and I’m [...]
Answer Question
| May 8, 2013 1:34 PM
AS/400, DB2 Universal Database, SQL
ODBC Request from iSeries to Excel
I am trying to use an ODBC DSN I have created, that uses the iSeries Access for Windows Driver, to download data from a file in QUSRSYS, to Excel. I have to download from QUSRSYS because the file is IBM supplied. Note: QUSRSYS appears in QSYSLIBL system value. The problem I have is that unless [...]
Answer Question
| November 15, 2009 9:54 AM
AS/400, DB2 Universal Database, Microsoft Office, SQL
I am trying to use an ODBC DSN I have created, that uses the iSeries Access for Windows Driver, to download data from a file in QUSRSYS, to Excel. I have to download from QUSRSYS because the file is IBM supplied. Note: QUSRSYS appears in QSYSLIBL system value. The problem I have is that unless [...]
Answer Question
| November 15, 2009 9:54 AM
AS/400, DB2 Universal Database, Microsoft Office, SQL
SQL Server 2000
Receiving this error: Microosoft OLE DB Provider for SQL Server error ’80040E57′ string or binary data would be truncated. I know this error is caused by trying to insert too many characters into a definded column. How can I correct this error. Thanks Alice Morgan
Answer Question
| October 14, 2005 12:10 PM
SQL, SQL Server
Receiving this error: Microosoft OLE DB Provider for SQL Server error ’80040E57′ string or binary data would be truncated. I know this error is caused by trying to insert too many characters into a definded column. How can I correct this error. Thanks Alice Morgan
Answer Question
| October 14, 2005 12:10 PM
SQL, SQL Server
iseries prepared stored procedure call from ile rpg
how i call a dynamic(prepared) stored procedure from ILE RPG IV ?
Answer Question
| October 7, 2005 12:19 PM
DB2 Universal Database, RPG ILE, SQL
how i call a dynamic(prepared) stored procedure from ILE RPG IV ?
Answer Question
| October 7, 2005 12:19 PM
DB2 Universal Database, RPG ILE, SQL
Oracle 10G tuning statements
Do you know of any new tuning techniques, or things I should be aware of that have changed in version 10G in terms of tuning SQL or PL/SQL statements? Thanks.
Answer Question
| October 5, 2005 9:44 PM
Oracle, SQL, Windows
Do you know of any new tuning techniques, or things I should be aware of that have changed in version 10G in terms of tuning SQL or PL/SQL statements? Thanks.
Answer Question
| October 5, 2005 9:44 PM
Oracle, SQL, Windows
sql
Hi, Imagine such a table : prod_key item_key pack_key last_sale PE12343 2029 BC400 05/12/2003 LM10212 2029 BC400 04/08/2004 PE12000 1345 AD100 08/04/2005 LM34598 1345 AD100 13/07/2005 I want to get the following rows : LM10212 2029 BC400 04/08/2004 LM34598 1345 AD100 13/07/2005, which select the last sale on item_key and pack_key independently of the product_key, [...]
Answer Question
| September 30, 2005 2:16 AM
SQL
Hi, Imagine such a table : prod_key item_key pack_key last_sale PE12343 2029 BC400 05/12/2003 LM10212 2029 BC400 04/08/2004 PE12000 1345 AD100 08/04/2005 LM34598 1345 AD100 13/07/2005 I want to get the following rows : LM10212 2029 BC400 04/08/2004 LM34598 1345 AD100 13/07/2005, which select the last sale on item_key and pack_key independently of the product_key, [...]
Answer Question
| September 30, 2005 2:16 AM
SQL
Security/ Audit Check list for DB2
Hi, I’m in the process of hardening the DB2 in Linux and I’m looking for a checklist to help me make sure I don’t miss anypoint. Since I’m not an expert on DB2 I would like to have a starting point. I’m looking to make sure I don’t leave open doors and also I want [...]
Answer Question
| October 3, 2005 12:45 PM
Application security, Database, DB2, Encryption, Exchange, Instant Messaging, Oracle, Secure Coding, SQL
Hi, I’m in the process of hardening the DB2 in Linux and I’m looking for a checklist to help me make sure I don’t miss anypoint. Since I’m not an expert on DB2 I would like to have a starting point. I’m looking to make sure I don’t leave open doors and also I want [...]
Answer Question
| October 3, 2005 12:45 PM
Application security, Database, DB2, Encryption, Exchange, Instant Messaging, Oracle, Secure Coding, SQL
sql query ASAP
When DWTRXGRP.XGRPG_GROUP_TYPE_CODE in (“IE”,”IF”,”II”) use GRP_RRE.ELEM_VAL_TXT = 0011 for ELEM_ID = RATPOL now table DWTRXGRP is in schema1 and GRP_RRE is in schema2 UPDATE Schema1.GRP_RRE SET ELEM_VAL_TXT = `0011? WHERE ELEM_ID = `RATPOL? AND ## WHAT ABOUT Schema2.DWTRXGRP.XGRPG_GROUP_TYPE_CODE in (`IE?,?IF?,?II?) ##
Answer Question
| September 28, 2005 11:07 PM
SQL
When DWTRXGRP.XGRPG_GROUP_TYPE_CODE in (“IE”,”IF”,”II”) use GRP_RRE.ELEM_VAL_TXT = 0011 for ELEM_ID = RATPOL now table DWTRXGRP is in schema1 and GRP_RRE is in schema2 UPDATE Schema1.GRP_RRE SET ELEM_VAL_TXT = `0011? WHERE ELEM_ID = `RATPOL? AND ## WHAT ABOUT Schema2.DWTRXGRP.XGRPG_GROUP_TYPE_CODE in (`IE?,?IF?,?II?) ##
Answer Question
| September 28, 2005 11:07 PM
SQL
Windows or Web App for Data Update?
I need to create an app that will give the user a list of items that they can then check off to denote that they are copleted. I would prefer a scrollable grid where they can make multiple selections. I would prefer to create a Windows app, but don’t know which control to use. Can [...]
Answer Question
| September 23, 2005 4:36 PM
ASP, ASP.NET, Database, DB2, Desktops, Development, Management, Microsoft Windows, Oracle, OS, Programming Languages, Security, Servers, SQL, SQL Server, VB.NET, VBA, VBScript, Visual Basic, Web development tools, Web site design & management
I need to create an app that will give the user a list of items that they can then check off to denote that they are copleted. I would prefer a scrollable grid where they can make multiple selections. I would prefer to create a Windows app, but don’t know which control to use. Can [...]
Answer Question
| September 23, 2005 4:36 PM
ASP, ASP.NET, Database, DB2, Desktops, Development, Management, Microsoft Windows, Oracle, OS, Programming Languages, Security, Servers, SQL, SQL Server, VB.NET, VBA, VBScript, Visual Basic, Web development tools, Web site design & management
exporting data to a .csv file in a stored procedure
I need to write the results of a query to a .csv file and ftp it from a stored procedure. The query part is no problem but I can’t find anything on opening, writing to and ftp’ing the .csv file. Any ideas?
Answer Question
| September 26, 2005 11:43 AM
SQL, SQL Server
I need to write the results of a query to a .csv file and ftp it from a stored procedure. The query part is no problem but I can’t find anything on opening, writing to and ftp’ing the .csv file. Any ideas?
Answer Question
| September 26, 2005 11:43 AM
SQL, SQL Server
timestamp and comparing different tables
hello i’m quite a beginner at this stuff.. right now i have a very basic database: 2 tables: Table 1: Handheld_tags: 2 columns Column 1: tag_in varchar(16) Column 2: time_in timestamp Table 2: Registered_tags: 2 columns Column 1: tag_reg varchar(16) Column 2: time_reg timestamp 1. Now I’m loading the Registered_tags table with a text file [...]
Answer Question
| September 22, 2005 9:28 AM
SQL
hello i’m quite a beginner at this stuff.. right now i have a very basic database: 2 tables: Table 1: Handheld_tags: 2 columns Column 1: tag_in varchar(16) Column 2: time_in timestamp Table 2: Registered_tags: 2 columns Column 1: tag_reg varchar(16) Column 2: time_reg timestamp 1. Now I’m loading the Registered_tags table with a text file [...]
Answer Question
| September 22, 2005 9:28 AM
SQL
