Installation of Oracle9i client
How to install Oracle9i client to c:program filesoracle and not to c:oracle on Windows Server 2003?
Answer Question
| March 10, 2005 2:24 AM
Database Management Systems, Oracle
How to install Oracle9i client to c:program filesoracle and not to c:oracle on Windows Server 2003?
Answer Question
| March 10, 2005 2:24 AM
Database Management Systems, Oracle
CLOB – Fetch out of sequence
I am inserting into a table which has a CLOB field. I insert a blank_clob and then try and retrieve the clob field again directly after insert. When I execute the select to retrieve the CLOB field I am getting ORA-01002: fetch out of sequence. The query looks like: select XML_DATA from XML_TABLE where SESSION_ID [...]
Answer Question
| March 3, 2005 10:48 AM
Database Management Systems, Development, J2EE, Java, Lifecycle development, Oracle, Oracle 10g, Oracle 8i, Oracle 9i, SQL, XML
I am inserting into a table which has a CLOB field. I insert a blank_clob and then try and retrieve the clob field again directly after insert. When I execute the select to retrieve the CLOB field I am getting ORA-01002: fetch out of sequence. The query looks like: select XML_DATA from XML_TABLE where SESSION_ID [...]
Answer Question
| March 3, 2005 10:48 AM
Database Management Systems, Development, J2EE, Java, Lifecycle development, Oracle, Oracle 10g, Oracle 8i, Oracle 9i, SQL, XML
F22 key on AS/400
Hello everyone, we have a couple of acountants onsite at a clients, and they are using an AS/400, they need to know how to access the F22 key, is this depending on the emulator they are using? or is there a way to access it?
Answer Question
| February 28, 2005 12:45 PM
Database Management Systems, DataCenter, Hardware, i5, iSeries, Networking, OS/400, Servers, tips and tricks, Tools
Hello everyone, we have a couple of acountants onsite at a clients, and they are using an AS/400, they need to know how to access the F22 key, is this depending on the emulator they are using? or is there a way to access it?
Answer Question
| February 28, 2005 12:45 PM
Database Management Systems, DataCenter, Hardware, i5, iSeries, Networking, OS/400, Servers, tips and tricks, Tools
Slow File sharing access in Win 98-2
Actually I have 2 questions: I have a small workgroup of 3 XP Pro systems, 2 win98 systems, 1 win 2000 server and a 16 port ethernet switch(100mbps). I have enabled the ICS in the server and each compter can access files/printers and internet with the help of DHCP. 1) When I access the win98 [...]
Answer Question
| February 16, 2005 4:54 AM
Bandwidth, Call Centers, Database Management Systems, DataCenter, Desktop management applications, Desktops, Development, DHCP, Disaster Recovery, DNS, ERP, FAT and NTFS, Graphical User Interfaces, Hardware, Help Desk, Information risk management, IT architecture, Knowledge management applications, Microsoft Windows, Network management software, Networking, Networking Equipment, Networking services, Office Applications, Operating system platforms, Performance/Tuning, Protocols, Security, Security management, Servers, Software, Switches, Systems management software, Tech support, Third-party services, Windows, Windows 2000 desktop, Windows 2000 Server, Windows 95/98, Windows client administration and maintenance, Windows Server 2003, X Windows System
Actually I have 2 questions: I have a small workgroup of 3 XP Pro systems, 2 win98 systems, 1 win 2000 server and a 16 port ethernet switch(100mbps). I have enabled the ICS in the server and each compter can access files/printers and internet with the help of DHCP. 1) When I access the win98 [...]
Answer Question
| February 16, 2005 4:54 AM
Bandwidth, Call Centers, Database Management Systems, DataCenter, Desktop management applications, Desktops, Development, DHCP, Disaster Recovery, DNS, ERP, FAT and NTFS, Graphical User Interfaces, Hardware, Help Desk, Information risk management, IT architecture, Knowledge management applications, Microsoft Windows, Network management software, Networking, Networking Equipment, Networking services, Office Applications, Operating system platforms, Performance/Tuning, Protocols, Security, Security management, Servers, Software, Switches, Systems management software, Tech support, Third-party services, Windows, Windows 2000 desktop, Windows 2000 Server, Windows 95/98, Windows client administration and maintenance, Windows Server 2003, X Windows System
Slow File sharing access in Win 98
Actually I have 2 questions: I have a small workgroup of 3 XP Pro systems, 2 win98 systems, 1 win 2000 server and a 16 port ethernet switch(100mbps). I have enabled the ICS in the server and each compter can access files/printers and internet with the help of DHCP. 1) When I access the win98 [...]
Answer Question
| August 26, 2011 4:54 AM
Bandwidth, Call Centers, Database Management Systems, DataCenter, Desktop management applications, Desktops, Development, DHCP, Disaster Recovery, DNS, ERP, FAT and NTFS, Graphical User Interfaces, Hardware, Help Desk, Information risk management, IT architecture, Knowledge management applications, Microsoft Windows, Network management software, Networking, Networking Equipment, Networking services, Office Applications, Operating system platforms, Performance/Tuning, Protocols, Security, Security management, Servers, Software, Switches, Systems management software, Tech support, Third-party services, Windows, Windows 2000 desktop, Windows 2000 Server, Windows 95/98, Windows client administration and maintenance, Windows Server 2003, X Windows System
Actually I have 2 questions: I have a small workgroup of 3 XP Pro systems, 2 win98 systems, 1 win 2000 server and a 16 port ethernet switch(100mbps). I have enabled the ICS in the server and each compter can access files/printers and internet with the help of DHCP. 1) When I access the win98 [...]
Answer Question
| August 26, 2011 4:54 AM
Bandwidth, Call Centers, Database Management Systems, DataCenter, Desktop management applications, Desktops, Development, DHCP, Disaster Recovery, DNS, ERP, FAT and NTFS, Graphical User Interfaces, Hardware, Help Desk, Information risk management, IT architecture, Knowledge management applications, Microsoft Windows, Network management software, Networking, Networking Equipment, Networking services, Office Applications, Operating system platforms, Performance/Tuning, Protocols, Security, Security management, Servers, Software, Switches, Systems management software, Tech support, Third-party services, Windows, Windows 2000 desktop, Windows 2000 Server, Windows 95/98, Windows client administration and maintenance, Windows Server 2003, X Windows System
Table Migration
I need to migrate Oracle8i table on Unix OS to Oracle9i on Window OS. Table and contents. 24×7 operation. Please Help!!!!!!! New DBA
Answer Question
| February 4, 2005 1:06 PM
Database Management Systems
I need to migrate Oracle8i table on Unix OS to Oracle9i on Window OS. Table and contents. 24×7 operation. Please Help!!!!!!! New DBA
Answer Question
| February 4, 2005 1:06 PM
Database Management Systems
Deleting journal receivers
HI, When I try to delete a journal receiver that hasn’t been saved, I get the “never fully saved” message even though I’m using DLTOPT(*IGNINQMSG) Does anyone have a piece of code that will get rid of receivers no matter what? E.G. not saved, remote, attached…… Thanks
Answer Question
| October 11, 2010 11:04 AM
Backup & recovery, Database Management Systems, DB2, DB2 administration, Hardware, i5, iSeries, OS/400, Performance/Tuning, Servers, tips and tricks, Tools
HI, When I try to delete a journal receiver that hasn’t been saved, I get the “never fully saved” message even though I’m using DLTOPT(*IGNINQMSG) Does anyone have a piece of code that will get rid of receivers no matter what? E.G. not saved, remote, attached…… Thanks
Answer Question
| October 11, 2010 11:04 AM
Backup & recovery, Database Management Systems, DB2, DB2 administration, Hardware, i5, iSeries, OS/400, Performance/Tuning, Servers, tips and tricks, Tools
Database choice for web application
I am building web applications, using ASP.NET, each of which must store/retrieve data to/from a set of central databases. I basically have a choice between using MS Access or SQL Server and could use some advice about which to go for or what criteria to apply. Bear in mind that there will be several databases [...]
Answer Question
| January 24, 2005 4:28 AM
Database Management Systems, DataCenter, Development, SQL Server, Web development tools, Web services
I am building web applications, using ASP.NET, each of which must store/retrieve data to/from a set of central databases. I basically have a choice between using MS Access or SQL Server and could use some advice about which to go for or what criteria to apply. Bear in mind that there will be several databases [...]
Answer Question
| January 24, 2005 4:28 AM
Database Management Systems, DataCenter, Development, SQL Server, Web development tools, Web services
Slow boot-up in win xp home edition
My notebook(40gb HDD, 256mb RAM)with win xp home edition has become dramatically slow in last 1-2 months. It takes more than 5 minutes to boot even after I removed everything from startup group using msconfig. The initial screen (win XP home) stays atleast 2-3minutes. How can I manage this? Is there something wrong with HDD [...]
Answer Question
| November 2, 2011 4:24 AM
Administration, Application software, Clarify Inc., Data analysis, Data center operations, Database Management Systems, DataCenter, Desktop management applications, Desktops, Disaster Recovery, ERP, FAT and NTFS, Graphical User Interfaces, Hardware, Help Desk, Information risk management, Installation, IT architecture, Microsoft Windows, Network management software, Networking, Operating system platforms, Power management, Registry, Servers, Service and support, Services, Software, Storage, System utilities, Tech support, Third-party services, Vendor support, Vulnerability Assessment & Audit, Windows, Windows 2000 desktop, Windows 95/98, Windows client administration and maintenance, Windows XP
My notebook(40gb HDD, 256mb RAM)with win xp home edition has become dramatically slow in last 1-2 months. It takes more than 5 minutes to boot even after I removed everything from startup group using msconfig. The initial screen (win XP home) stays atleast 2-3minutes. How can I manage this? Is there something wrong with HDD [...]
Answer Question
| November 2, 2011 4:24 AM
Administration, Application software, Clarify Inc., Data analysis, Data center operations, Database Management Systems, DataCenter, Desktop management applications, Desktops, Disaster Recovery, ERP, FAT and NTFS, Graphical User Interfaces, Hardware, Help Desk, Information risk management, Installation, IT architecture, Microsoft Windows, Network management software, Networking, Operating system platforms, Power management, Registry, Servers, Service and support, Services, Software, Storage, System utilities, Tech support, Third-party services, Vendor support, Vulnerability Assessment & Audit, Windows, Windows 2000 desktop, Windows 95/98, Windows client administration and maintenance, Windows XP
Triggers
Does the AS/400 have a cross-reference file or files that give the same kind of information about triggers as QADBFDEP and QADBFCST do for dependent files and constraints? If so, what is/are they called? Thanks
Answer Question
| October 19, 2009 2:35 PM
Architecture/Design, Database Management Systems, DB2, DB2 Implementation, i5, iSeries, OS/400, tips and tricks, Tools
Does the AS/400 have a cross-reference file or files that give the same kind of information about triggers as QADBFDEP and QADBFCST do for dependent files and constraints? If so, what is/are they called? Thanks
Answer Question
| October 19, 2009 2:35 PM
Architecture/Design, Database Management Systems, DB2, DB2 Implementation, i5, iSeries, OS/400, tips and tricks, Tools
Triggers
Does the AS/400 have a cross-reference file or files that give the same kind of information about triggers as QADBFDEP and QADBFCST do for dependent files and constraints? If so, what is/are they called? Thanks
Answer Question
| December 27, 2004 2:35 PM
Architecture/Design, Database Management Systems, DB2, DB2 Implementation, i5, iSeries, OS/400, tips and tricks, Tools
Does the AS/400 have a cross-reference file or files that give the same kind of information about triggers as QADBFDEP and QADBFCST do for dependent files and constraints? If so, what is/are they called? Thanks
Answer Question
| December 27, 2004 2:35 PM
Architecture/Design, Database Management Systems, DB2, DB2 Implementation, i5, iSeries, OS/400, tips and tricks, Tools
How to avoid SQL7008 error from DB2 on iSeries?
We are deploying a J2EE application on a Websphere 5.2 Application Server. This application accesses a DB2 database on an iSeries server which is not supporting transactions. We have already removed all transactions from the XML configuration files. We cannot find a way to configure the datasource resource on WAS to avoid an error from [...]
Answer Question
| December 20, 2004 6:17 PM
Database Management Systems, DB2, Development, J2EE, Java
We are deploying a J2EE application on a Websphere 5.2 Application Server. This application accesses a DB2 database on an iSeries server which is not supporting transactions. We have already removed all transactions from the XML configuration files. We cannot find a way to configure the datasource resource on WAS to avoid an error from [...]
Answer Question
| December 20, 2004 6:17 PM
Database Management Systems, DB2, Development, J2EE, Java
Monitor Internet Bandwidth
Good day, we are using windows2000 smallbusiness server in our organisation with Exchange,Dns and Isa server configured. 1. I want to monitor the internet usage by the users. 2. I want to take a report on monthly or daily basis how much mb/gb utilised By Each User. Thanks for u’r reply in advance.
Answer Question
| December 29, 2004 1:55 AM
Active Directory, Administration, Application management, Auditing, Availability, Backup, Backup & recovery, Bandwidth, Benchmarking, Bind, BroadVision, Business Objects, Call Centers, Clarify Inc., CLB, Client management, Clustering/High availability, Component Load Balancing, Content filtering, Corporate portal applications, Customer relationship management applications, Data analysis, Data center operations, Data mining/analysis, Data warehousing/Business intelligence, Database Management Systems, DataCenter, Datacenter Server, DB2 administration, Desktop security, Desktops, DHCP, Distributed File System, DNS, E-business, E-mail applications, ERP, Exchange, Exchange 2000, Exchange 2003, Exchange 5.5, Exchange Server ActiveSync, FAT and NTFS, Fault isolation, Firewalls, General Directories, Graphical User Interfaces, Handheld, Hardware, Help Desk, Information risk management, Integration/Connectivity, Intel servers, IT architecture, Knowledge management applications, Licensing, Lotus Domino, Mail protocols, Maintenance, Major Vendors, Microsoft Internet Information Server, Microsoft Windows, Monitoring, Netscape Mail, Network applications management, Network management software, Network monitoring, Network requirements, Network testing, Networking, Networking Equipment, Networking services, Office Applications, Operating system platforms, Operating systems, Outlook, PC/Windows Connectivity, Performance management, Performance/Tuning, Planning, Policies, POP3, Protocol analysis, Remote management, Reporting, ROI & cost justification, Routers, S/MIME, Security, Security management, Security products, Sendmail, Server consolidation, Server management, Server-based/Thin-client computing, Servers, Services, Software, Software distribution, Software Quality Assurance, Spam, Storage, System monitoring, System utilities, Tech support, Technical support, Third-party services, Vendor support, Virus protection, Web services, Windows, Windows 2000 desktop, Windows 2000 Server, Windows client administration and maintenance, Windows on Intel, Windows Server 2003
Good day, we are using windows2000 smallbusiness server in our organisation with Exchange,Dns and Isa server configured. 1. I want to monitor the internet usage by the users. 2. I want to take a report on monthly or daily basis how much mb/gb utilised By Each User. Thanks for u’r reply in advance.
Answer Question
| December 29, 2004 1:55 AM
Active Directory, Administration, Application management, Auditing, Availability, Backup, Backup & recovery, Bandwidth, Benchmarking, Bind, BroadVision, Business Objects, Call Centers, Clarify Inc., CLB, Client management, Clustering/High availability, Component Load Balancing, Content filtering, Corporate portal applications, Customer relationship management applications, Data analysis, Data center operations, Data mining/analysis, Data warehousing/Business intelligence, Database Management Systems, DataCenter, Datacenter Server, DB2 administration, Desktop security, Desktops, DHCP, Distributed File System, DNS, E-business, E-mail applications, ERP, Exchange, Exchange 2000, Exchange 2003, Exchange 5.5, Exchange Server ActiveSync, FAT and NTFS, Fault isolation, Firewalls, General Directories, Graphical User Interfaces, Handheld, Hardware, Help Desk, Information risk management, Integration/Connectivity, Intel servers, IT architecture, Knowledge management applications, Licensing, Lotus Domino, Mail protocols, Maintenance, Major Vendors, Microsoft Internet Information Server, Microsoft Windows, Monitoring, Netscape Mail, Network applications management, Network management software, Network monitoring, Network requirements, Network testing, Networking, Networking Equipment, Networking services, Office Applications, Operating system platforms, Operating systems, Outlook, PC/Windows Connectivity, Performance management, Performance/Tuning, Planning, Policies, POP3, Protocol analysis, Remote management, Reporting, ROI & cost justification, Routers, S/MIME, Security, Security management, Security products, Sendmail, Server consolidation, Server management, Server-based/Thin-client computing, Servers, Services, Software, Software distribution, Software Quality Assurance, Spam, Storage, System monitoring, System utilities, Tech support, Technical support, Third-party services, Vendor support, Virus protection, Web services, Windows, Windows 2000 desktop, Windows 2000 Server, Windows client administration and maintenance, Windows on Intel, Windows Server 2003
Sql Server Linked Server to iSeries
Hi everybody, I get the following exception [Non-interface error: CoCreate of DSO for MSDASQL returned 0×80040154] on an iSeries configured as Linked Server in MS-Sql Server everytime I attempt to execute a query (Read Only !) from any PC in a windows Workgroup exception for the PC on which SQL Server is installed. I repeat [...]
Answer Question
| November 26, 2004 6:03 AM
AS/400, Database Management Systems, Development, Microsoft Windows, Networking, SQL Server, Tech support
Hi everybody, I get the following exception [Non-interface error: CoCreate of DSO for MSDASQL returned 0×80040154] on an iSeries configured as Linked Server in MS-Sql Server everytime I attempt to execute a query (Read Only !) from any PC in a windows Workgroup exception for the PC on which SQL Server is installed. I repeat [...]
Answer Question
| November 26, 2004 6:03 AM
AS/400, Database Management Systems, Development, Microsoft Windows, Networking, SQL Server, Tech support
blanks (”) instead of NULL’s in SQL Server 2000
I have a development team that wants to represent all fields with no values with a ” (blank) instead of using the database standard of NULL. The team is coding in C#. I am told it is easier for them to code around blanks than NULL’s. Aside from taking up more space in the database [...]
Answer Question
| February 15, 2008 4:12 PM
Database Management Systems, Microsoft .NET
I have a development team that wants to represent all fields with no values with a ” (blank) instead of using the database standard of NULL. The team is coding in C#. I am told it is easier for them to code around blanks than NULL’s. Aside from taking up more space in the database [...]
Answer Question
| February 15, 2008 4:12 PM
Database Management Systems, Microsoft .NET
DB2/400 SQL Sub Query Performance?
Here is the problem. Table INVEHH is a (Events header table) with about 500 records and INVEHD (Event Details) with about 22 million records. These tables are on a DB2/400 database. 1) Original Query that takes forever: select EVENT, INUMBR, ISTORE, EVHYY, EVHMM, EVHDD from INVEHD where EVENT in (Select EVENT from INVEHH where (EVHYY*10000 [...]
Answer Question
| October 20, 2009 8:40 AM
Data warehousing/Business intelligence, Database Management Systems, DB2, DB2 Universal Database, UDB for iSeries/i5
Here is the problem. Table INVEHH is a (Events header table) with about 500 records and INVEHD (Event Details) with about 22 million records. These tables are on a DB2/400 database. 1) Original Query that takes forever: select EVENT, INUMBR, ISTORE, EVHYY, EVHMM, EVHDD from INVEHD where EVENT in (Select EVENT from INVEHH where (EVHYY*10000 [...]
Answer Question
| October 20, 2009 8:40 AM
Data warehousing/Business intelligence, Database Management Systems, DB2, DB2 Universal Database, UDB for iSeries/i5
Excel Help
What I have now is a simple excel spreadsheet to input numbers and info. What I want to do with it is make it a template and have one cell in the top left corner to add a new number in order each time a new user opens it. For example in the cell would [...]
Answer Question
| October 26, 2004 9:16 AM
Database Management Systems, DataCenter, Desktop management applications, Desktops, Development, Hardware, Microsoft Systems Management Server, Networking, Programming Languages, Security, Systems management software, Tech support, VBA, VBScript, Visual Basic
What I have now is a simple excel spreadsheet to input numbers and info. What I want to do with it is make it a template and have one cell in the top left corner to add a new number in order each time a new user opens it. For example in the cell would [...]
Answer Question
| October 26, 2004 9:16 AM
Database Management Systems, DataCenter, Desktop management applications, Desktops, Development, Hardware, Microsoft Systems Management Server, Networking, Programming Languages, Security, Systems management software, Tech support, VBA, VBScript, Visual Basic
Oracle In Linux
How can I able to get and work with Oracle in Linux platform. I am using RedHat Linux 9.0.
Answer Question
| June 15, 2010 1:41 AM
Administration, AMD PC hardware, Data warehousing/Business intelligence, Database Management Systems, DB2, Development, Hardware, Implementation, Installation/Upgrade, MySQL, Operating system platforms, Oracle, Oracle 8i, Oracle 9i, OS/390, Performance/Tuning, PostgreSQL, Security products, Servers, SQL, SQL Anywhere Studio/M-Business Anywhere/Avantgo, Standard Edition, Standard One Edition, Storage, Storage management, Tech support, UDB for mainframe, Unisys, z/OS
How can I able to get and work with Oracle in Linux platform. I am using RedHat Linux 9.0.
Answer Question
| June 15, 2010 1:41 AM
Administration, AMD PC hardware, Data warehousing/Business intelligence, Database Management Systems, DB2, Development, Hardware, Implementation, Installation/Upgrade, MySQL, Operating system platforms, Oracle, Oracle 8i, Oracle 9i, OS/390, Performance/Tuning, PostgreSQL, Security products, Servers, SQL, SQL Anywhere Studio/M-Business Anywhere/Avantgo, Standard Edition, Standard One Edition, Storage, Storage management, Tech support, UDB for mainframe, Unisys, z/OS
Db2 to Oracle porting
I am in the process of planning to port a running DB2 instance on an IBM Mainframe to Oracle 9i running on Unix. Has anyone done does this before ? If yes, what should I be looking out for ? Any particular advice ? Thanks and Regards, Debu
Answer Question
| October 13, 2004 3:37 PM
Database Management Systems, DB2, Oracle
I am in the process of planning to port a running DB2 instance on an IBM Mainframe to Oracle 9i running on Unix. Has anyone done does this before ? If yes, what should I be looking out for ? Any particular advice ? Thanks and Regards, Debu
Answer Question
| October 13, 2004 3:37 PM
Database Management Systems, DB2, Oracle
SQL Server ODBC Configuration
I’ve got an NT web server in our DMZ that can’t connect to an internal SQL Server 7 db on W2k box. Internally we have 2 domains. ODBC returns access denied/can’t find server. When I put the websrv inside our net, ODBC works fine. Other servers in DMZ can connect to db. What is going [...]
Answer Question
| October 4, 2004 11:58 AM
Database Management Systems, SQL Server, Tech support
I’ve got an NT web server in our DMZ that can’t connect to an internal SQL Server 7 db on W2k box. Internally we have 2 domains. ODBC returns access denied/can’t find server. When I put the websrv inside our net, ODBC works fine. Other servers in DMZ can connect to db. What is going [...]
Answer Question
| October 4, 2004 11:58 AM
Database Management Systems, SQL Server, Tech support
