Doubts regarding speed in data access
The fastest possible way is to use a compiled language, with this logic flow: Have a large, static array of record buffers Open the input as a streamed (Unix or OS/400) or double-buffered (zOS) file. Loop Read a record Leave the loop if EOF Validate the record If passed Store its values into the array [...]
View Answer
| March 10, 2006 1:59 AM
Database, DB2, Java/J2EE, Oracle, SQL, Windows
The fastest possible way is to use a compiled language, with this logic flow: Have a large, static array of record buffers Open the input as a streamed (Unix or OS/400) or double-buffered (zOS) file. Loop Read a record Leave the loop if EOF Validate the record If passed Store its values into the array [...]
View Answer
| March 10, 2006 1:59 AM
Database, DB2, Java/J2EE, Oracle, SQL, Windows
Capture screen w/scrolling marquee
Not easy – screen captures are just that – still pictures. 1 – try ‘Screen Grab Pro’ and capture as many screens as possible during marquee transit. 2 – Macromedia ‘Captivate’ and create a Flash movie. 3 – Streaming video capture to a ‘Windows Media Format’. Good Luck.
View Answer
| March 7, 2006 4:07 PM
Billing and customer care, Billing Support Systems, Call Centers, Career development, CRM, Data analysis, Data mining/analysis, Data warehousing applications, Database, DataCenter, DataManagement, DB2, Desktop management applications, Desktops, Development, E-business, Hardware, IBM, Lifecycle development, Management, Microsoft Windows, NCR, Networking, Oracle, OS, Project management, Sales force automation applications, Security, Servers, Software, Software Quality Assurance, SQL Server, Storage, Tech support, Web services, Web Services Standards
Not easy – screen captures are just that – still pictures. 1 – try ‘Screen Grab Pro’ and capture as many screens as possible during marquee transit. 2 – Macromedia ‘Captivate’ and create a Flash movie. 3 – Streaming video capture to a ‘Windows Media Format’. Good Luck.
View Answer
| March 7, 2006 4:07 PM
Billing and customer care, Billing Support Systems, Call Centers, Career development, CRM, Data analysis, Data mining/analysis, Data warehousing applications, Database, DataCenter, DataManagement, DB2, Desktop management applications, Desktops, Development, E-business, Hardware, IBM, Lifecycle development, Management, Microsoft Windows, NCR, Networking, Oracle, OS, Project management, Sales force automation applications, Security, Servers, Software, Software Quality Assurance, SQL Server, Storage, Tech support, Web services, Web Services Standards
Numeric values search from alphanumeric column of DB2
You can try this: Select columns from table where numeric value of columncolumn between numeric1 and numeric2 Note: values of numeric1 and numeric2 depend of the type you are using integer, smallint, decimal, etc
View Answer
| March 7, 2006 9:11 AM
Database, DB2, Oracle
You can try this: Select columns from table where numeric value of columncolumn between numeric1 and numeric2 Note: values of numeric1 and numeric2 depend of the type you are using integer, smallint, decimal, etc
View Answer
| March 7, 2006 9:11 AM
Database, DB2, Oracle
Updating Access Database Structure At Run-Time
I use a seperate access program to update the front ends. The prog has one form with one button on it called “Install Upgrade”. This button then runs VBA code or Queries to update either the FE or BE tables etc. Below is an example of the VBA to add a new field. Function AddNumField() [...]
View Answer
| March 7, 2006 6:09 AM
Database, DB2, Development, Oracle, Visual Basic
I use a seperate access program to update the front ends. The prog has one form with one button on it called “Install Upgrade”. This button then runs VBA code or Queries to update either the FE or BE tables etc. Below is an example of the VBA to add a new field. Function AddNumField() [...]
View Answer
| March 7, 2006 6:09 AM
Database, DB2, Development, Oracle, Visual Basic
Oracle Client 7.3.4 installation on Windows server 2003
I believe there is no work around for this 7.3.4 client on win2K. Why you need 7.x old client? if you want to handle OCI with 8i client, you should install 8i client and select custom install.
View Answer
| March 1, 2006 10:04 PM
Oracle, Windows
I believe there is no work around for this 7.3.4 client on win2K. Why you need 7.x old client? if you want to handle OCI with 8i client, you should install 8i client and select custom install.
View Answer
| March 1, 2006 10:04 PM
Oracle, Windows
Locked objects, Stored Procedures, Triggers, etc
The follwoing sql will help: select b.username username, c.sid sid, c.owner object_owner, c.object object, b.lockwait, a.sql_text SQL from v$sqltext a, v$session b, v$access c where a.address=b.sql_address and a.hash_value=b.sql_hash_value and b.sid = c.sid and c.owner != ‘SYS’ /
View Answer
| March 1, 2006 9:54 PM
Migration, Oracle, Oracle administration
The follwoing sql will help: select b.username username, c.sid sid, c.owner object_owner, c.object object, b.lockwait, a.sql_text SQL from v$sqltext a, v$session b, v$access c where a.address=b.sql_address and a.hash_value=b.sql_hash_value and b.sid = c.sid and c.owner != ‘SYS’ /
View Answer
| March 1, 2006 9:54 PM
Migration, Oracle, Oracle administration
Zebra printer will not print CORRECTLY through Oracle application(s)
is there a printer font that is missing from the oracle program?
View Answer
| February 27, 2006 9:40 AM
Aspen Technology, Baan, Billing and customer care, Billing Support Systems, Database, DataCenter, DB2, Desktop management applications, Desktops, Development, Distribution/logistics applications, Hardware, i2 Technologies, IBM, Interoperability, Management, Manufacturing applications, Manugistics, Microsoft .NET, Microsoft BizTalk Server, Microsoft Internet Information Server, Microsoft Windows, NCR, Online transaction processing, Oracle, Oracle Application Server, Oracle Manufacturing, OS, PeopleSoft, Printers, QAD, SalesLogix, SAP, SAS Institute, SDRC/EDS, Security, Servers, Siebel, SQL Server, Supply chain management applications, Tech support, Windows
is there a printer font that is missing from the oracle program?
View Answer
| February 27, 2006 9:40 AM
Aspen Technology, Baan, Billing and customer care, Billing Support Systems, Database, DataCenter, DB2, Desktop management applications, Desktops, Development, Distribution/logistics applications, Hardware, i2 Technologies, IBM, Interoperability, Management, Manufacturing applications, Manugistics, Microsoft .NET, Microsoft BizTalk Server, Microsoft Internet Information Server, Microsoft Windows, NCR, Online transaction processing, Oracle, Oracle Application Server, Oracle Manufacturing, OS, PeopleSoft, Printers, QAD, SalesLogix, SAP, SAS Institute, SDRC/EDS, Security, Servers, Siebel, SQL Server, Supply chain management applications, Tech support, Windows
Installing Oracle 8i and 10g on Same machine
Install 8i first. When you install 10g, it should install into its own home. The main point is that while the 10g client will talk to both 10g and 8i, the 8i won’t necessarily play nice with the 10g.
View Answer
| February 24, 2006 6:44 AM
Oracle, Windows
Install 8i first. When you install 10g, it should install into its own home. The main point is that while the 10g client will talk to both 10g and 8i, the 8i won’t necessarily play nice with the 10g.
View Answer
| February 24, 2006 6:44 AM
Oracle, Windows
adding partition to existing non-partitioned table
Hello: The ‘AS SELECT…’ clause should be the last part of the CREATE TABLE … PARTITION. Try this: create table quote_header_test partition by range (ordered_date) partition less_jul2004 values less than (to_date(’01-JUL-2004′,’MON-DD-YYYY’)) as select * from quote_header; Good Luck
View Answer
| February 8, 2006 6:42 AM
Database, DB2, Oracle, SQL
Hello: The ‘AS SELECT…’ clause should be the last part of the CREATE TABLE … PARTITION. Try this: create table quote_header_test partition by range (ordered_date) partition less_jul2004 values less than (to_date(’01-JUL-2004′,’MON-DD-YYYY’)) as select * from quote_header; Good Luck
View Answer
| February 8, 2006 6:42 AM
Database, DB2, Oracle, SQL
Database Implementation
In order for you to decide on a Database Software Implementation requires that you fully understand the business needs and what the Database should provide to them. I would recommend that you try to understand the general aspects of business needs before you actually implement a Database Software or Project. Be careful, More functions and [...]
View Answer
| February 8, 2006 4:53 AM
Database, DB2, Oracle, Project management
In order for you to decide on a Database Software Implementation requires that you fully understand the business needs and what the Database should provide to them. I would recommend that you try to understand the general aspects of business needs before you actually implement a Database Software or Project. Be careful, More functions and [...]
View Answer
| February 8, 2006 4:53 AM
Database, DB2, Oracle, Project management
Oracle Sql Tuning
This linke will provide some useful informaton: http://asktom.oracle.com/pls/ask/f?p=4950:8:8488073385483584370::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:8764517459743
View Answer
| February 3, 2006 2:39 PM
Database, DB2, Oracle, Windows
This linke will provide some useful informaton: http://asktom.oracle.com/pls/ask/f?p=4950:8:8488073385483584370::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:8764517459743
View Answer
| February 3, 2006 2:39 PM
Database, DB2, Oracle, Windows
Updating a CLOB
Why the complicated join if the carriage return is at the end of the clob just update scbdesc a set a.scbdesc_text_narrative = dbms_lob.substr(a.scbdesc_text_narrative,dbms_lob.length(a.scbdesc_text_narrative )-1 ,1 ) where dbms_lob.substr(a.scbdesc_text_narrative,1,dbms_lob.length(a.scbdesc_text_narrative )-1 ) = chr(10); ********************* NOTE:the dbms_lob.substr parameters are lenght,offset whereas the substr function parameters are offset,length ********************* that’s your problem
View Answer
| February 3, 2006 7:57 AM
Oracle
Why the complicated join if the carriage return is at the end of the clob just update scbdesc a set a.scbdesc_text_narrative = dbms_lob.substr(a.scbdesc_text_narrative,dbms_lob.length(a.scbdesc_text_narrative )-1 ,1 ) where dbms_lob.substr(a.scbdesc_text_narrative,1,dbms_lob.length(a.scbdesc_text_narrative )-1 ) = chr(10); ********************* NOTE:the dbms_lob.substr parameters are lenght,offset whereas the substr function parameters are offset,length ********************* that’s your problem
View Answer
| February 3, 2006 7:57 AM
Oracle
Oracle boolean data type questions
> 1) From a comparison perspective, which provides better performance? Comparison > of a number (1,0) or string (Y/N) It won’t make a difference. > 2) Which method takes up less storage? They both take 1 byte. > 3) Results will be mapped into a J2EE data structure supporting a boolean datatype. > Which method [...]
View Answer
| January 26, 2006 6:35 PM
Database, DB2, Oracle
> 1) From a comparison perspective, which provides better performance? Comparison > of a number (1,0) or string (Y/N) It won’t make a difference. > 2) Which method takes up less storage? They both take 1 byte. > 3) Results will be mapped into a J2EE data structure supporting a boolean datatype. > Which method [...]
View Answer
| January 26, 2006 6:35 PM
Database, DB2, Oracle
16 bit application connection to ORACLE 9
Ive had a similar problem with the 16bit ODBC drivers for SQL server. Thunking will work ok with older releases, but not with newer versions of drivers. In addition, it becomes more and more difficult to get 16bit ODBC to work on Windows XP machines. There is very limited (if any) support for 16bit ODBC [...]
View Answer
| January 25, 2006 10:48 AM
Development, Oracle, Windows
Ive had a similar problem with the 16bit ODBC drivers for SQL server. Thunking will work ok with older releases, but not with newer versions of drivers. In addition, it becomes more and more difficult to get 16bit ODBC to work on Windows XP machines. There is very limited (if any) support for 16bit ODBC [...]
View Answer
| January 25, 2006 10:48 AM
Development, Oracle, Windows
AMD vs. Intel: Data Warehouse Servers and Consolidated Database Servers …
We manage several DBs of the size you are discussing. Although the intel based platforms are OK, for the size and performance you are mentioning for the DW, we run all of ours on Sun systems. We use V880s for this application. A V400 series might do the trick with only 200 to 400 users. [...]
View Answer
| January 25, 2006 9:01 AM
Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server
We manage several DBs of the size you are discussing. Although the intel based platforms are OK, for the size and performance you are mentioning for the DW, we run all of ours on Sun systems. We use V880s for this application. A V400 series might do the trick with only 200 to 400 users. [...]
View Answer
| January 25, 2006 9:01 AM
Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server
Oracle 9i export unsuccessful since patch update.
You must run the CATEXP.SQL or CATALOG.SQL script to install the views and give privileages to the EXP_FULL_DATABASE role. I would start with CATEXP.SQL since that seems to be the only thing that doesn’t work. Apparently that got missed in you upgrade. CATALOG.SQL eventually executes CATEXP.SQL after doing many other tasks.
View Answer
| January 24, 2006 2:29 PM
Oracle
You must run the CATEXP.SQL or CATALOG.SQL script to install the views and give privileages to the EXP_FULL_DATABASE role. I would start with CATEXP.SQL since that seems to be the only thing that doesn’t work. Apparently that got missed in you upgrade. CATALOG.SQL eventually executes CATEXP.SQL after doing many other tasks.
View Answer
| January 24, 2006 2:29 PM
Oracle
Query Regarding Crystal Reports
If you are running Crystal Reports client you can export to what they call Record Style (Column with Spaces) format. File — Export — Select the export format. It is worded a little differantly depending on the version of Crystal Reports. Just look for it. This may not be an option depending on how you [...]
View Answer
| January 21, 2006 10:49 AM
Business/IT alignment, Database, DB2, Development, Oracle
If you are running Crystal Reports client you can export to what they call Record Style (Column with Spaces) format. File — Export — Select the export format. It is worded a little differantly depending on the version of Crystal Reports. Just look for it. This may not be an option depending on how you [...]
View Answer
| January 21, 2006 10:49 AM
Business/IT alignment, Database, DB2, Development, Oracle
DataBase Administration
It really depends on how you use the data. If there are foreign keys to of from these tables to other tables that he is NOT moving – then you’re going to lose any hope of maintaining integrity. If these tables are frequently accessed in the same session, then you’ll have to switch to db [...]
View Answer
| January 20, 2006 1:08 PM
Oracle, SQL, Windows
It really depends on how you use the data. If there are foreign keys to of from these tables to other tables that he is NOT moving – then you’re going to lose any hope of maintaining integrity. If these tables are frequently accessed in the same session, then you’ll have to switch to db [...]
View Answer
| January 20, 2006 1:08 PM
Oracle, SQL, Windows
Developer to Data Architect
What was your question?
View Answer
| January 20, 2006 8:45 AM
Development, J2EE, Java, Lifecycle development, Oracle, SQL
What was your question?
View Answer
| January 20, 2006 8:45 AM
Development, J2EE, Java, Lifecycle development, Oracle, SQL
Is there an IBM Tool to Rebind Plans/Collections
Unless I misunderstood, it is easy. Just run this job step to rebind all packages in a collection: //BATCHDSN EXEC PGM=IKJEFT1B,PARM=’DSN S(DB2P)’ //SYSTSPRT DD SYSOUT=* //SYSPRINT DD SYSOUT=* //SYSTSIN DD * REBIND PACKAGE(collection.*.(*)) The first * means “all packages”, the second “all versions” within this collection. In fact, you can replace collection by * as [...]
View Answer
| January 20, 2006 7:07 AM
390, Database, DB2, Mainframe, Oracle
Unless I misunderstood, it is easy. Just run this job step to rebind all packages in a collection: //BATCHDSN EXEC PGM=IKJEFT1B,PARM=’DSN S(DB2P)’ //SYSTSPRT DD SYSOUT=* //SYSPRINT DD SYSOUT=* //SYSTSIN DD * REBIND PACKAGE(collection.*.(*)) The first * means “all packages”, the second “all versions” within this collection. In fact, you can replace collection by * as [...]
View Answer
| January 20, 2006 7:07 AM
390, Database, DB2, Mainframe, Oracle
