Error while performing full import
Either the table doesn’t exist, you’ve got the wrong schema, or you don’t have rights to use the object.
View Answer
| January 29, 2008 12:08 AM
Import, Oracle
Either the table doesn’t exist, you’ve got the wrong schema, or you don’t have rights to use the object.
View Answer
| January 29, 2008 12:08 AM
Import, Oracle
ms acess trouble
It is acting like there is a problem with the database connection. Do you know if the Access database is corrupted or are the tables being used by someone else? When you close VB, do you close the db connection? You may need to close and open you dataset inside VB to see the new [...]
View Answer
| January 24, 2008 5:24 PM
Microsoft Access, VB
It is acting like there is a problem with the database connection. Do you know if the Access database is corrupted or are the tables being used by someone else? When you close VB, do you close the db connection? You may need to close and open you dataset inside VB to see the new [...]
View Answer
| January 24, 2008 5:24 PM
Microsoft Access, VB
DDS or SQL
That is one broad topic! If you haven’t already done so, you may want to review <a href=”http://www.redbooks.ibm.com/abstracts/sg246393.html”>Modernizing IBM eServer iSeries Application Data Access – A Roadmap Cornerstone</a>, a redbook IBM put out a few years ago discussing the movement from DDS and traditional data management to SQL. One of the nice things is that, [...]
View Answer
| January 24, 2008 1:00 PM
COBOL, DDL, DDS, SQL
That is one broad topic! If you haven’t already done so, you may want to review <a href=”http://www.redbooks.ibm.com/abstracts/sg246393.html”>Modernizing IBM eServer iSeries Application Data Access – A Roadmap Cornerstone</a>, a redbook IBM put out a few years ago discussing the movement from DDS and traditional data management to SQL. One of the nice things is that, [...]
View Answer
| January 24, 2008 1:00 PM
COBOL, DDL, DDS, SQL
Oracle 9i how to create dictionary managed tablespace
Hi Pinki, Every Oracle database contains a tablespace named SYSTEM, which Oracle creates automatically when the database is created. The SYSTEM tablespace is always online when the database is open. To take advantage of the benefits of locally managed tablespaces, you can create a locally managed SYSTEM tablespace, or you can migrate an existing dictionary [...]
View Answer
| January 24, 2008 8:50 AM
Database, DBCA, Oracle 9i
Hi Pinki, Every Oracle database contains a tablespace named SYSTEM, which Oracle creates automatically when the database is created. The SYSTEM tablespace is always online when the database is open. To take advantage of the benefits of locally managed tablespaces, you can create a locally managed SYSTEM tablespace, or you can migrate an existing dictionary [...]
View Answer
| January 24, 2008 8:50 AM
Database, DBCA, Oracle 9i
Binary Field
Character fields have values such as 10002- (right justified). Binary fields have values that can represent -10002, but are not right justified or controlled in terms of where the sign is stored. If you have a field BinaryFld with is defined as ’9b 0′, which would mean a 4-byte buffer, then to set (or populate) [...]
View Answer
| January 23, 2008 10:03 PM
Binary fields, RPG ILE
Character fields have values such as 10002- (right justified). Binary fields have values that can represent -10002, but are not right justified or controlled in terms of where the sign is stored. If you have a field BinaryFld with is defined as ’9b 0′, which would mean a 4-byte buffer, then to set (or populate) [...]
View Answer
| January 23, 2008 10:03 PM
Binary fields, RPG ILE
HOW TO INCLUDE LOG IN INFORMATION IN AN SQL SCRIPT
Suggestion is somthing like the following: . ${HOME}/.profile …… sqlplus $ASQLUSER @$SQL_DEPOT/sqlplus_filename.sql …… if [ Check-ERROR-Condition-of-SQL-Output-File ] then echo “The Tariff Group Revert Back to Residential Type Customer for Antillia is not completed.” | mailx -s “A NTILLIA BOC ERROR $0″ $MAILTO exit; fi = = = = = = = = = = = [...]
View Answer
| January 23, 2008 8:16 PM
Database, Oracle, Oracle 9i, Scripting, SQL, Windows Server 2003
Suggestion is somthing like the following: . ${HOME}/.profile …… sqlplus $ASQLUSER @$SQL_DEPOT/sqlplus_filename.sql …… if [ Check-ERROR-Condition-of-SQL-Output-File ] then echo “The Tariff Group Revert Back to Residential Type Customer for Antillia is not completed.” | mailx -s “A NTILLIA BOC ERROR $0″ $MAILTO exit; fi = = = = = = = = = = = [...]
View Answer
| January 23, 2008 8:16 PM
Database, Oracle, Oracle 9i, Scripting, SQL, Windows Server 2003
Need your help with sql joins
You will want to join to the writers table twice. Once with an inner join for the author, and once with a left outer join for the translator. <pre>SELECT articles.article_id, writers.writer_name, trans.writer_name as translator_name FROM articles INNER JOIN writers on artciles.writer_id = writers.id LEFT OUTER JOIN writers as trans ON articles.translator_id = trans.id</pre>
View Answer
| January 22, 2008 1:26 AM
MySQL
You will want to join to the writers table twice. Once with an inner join for the author, and once with a left outer join for the translator. <pre>SELECT articles.article_id, writers.writer_name, trans.writer_name as translator_name FROM articles INNER JOIN writers on artciles.writer_id = writers.id LEFT OUTER JOIN writers as trans ON articles.translator_id = trans.id</pre>
View Answer
| January 22, 2008 1:26 AM
MySQL
How to use subselect in a case statement
Hi, It sounds like something isn’t implemented in the system you’re using. Your code works for me in Oracle 10 and also in SQL Server 2005. What are you using? There’s a faint chance that an error in the code you didn’t post is causing the problem. Post a complete SQL statement (as simple as [...]
View Answer
| January 17, 2008 5:04 PM
CASE statement, SQL, SQL Subselect
Hi, It sounds like something isn’t implemented in the system you’re using. Your code works for me in Oracle 10 and also in SQL Server 2005. What are you using? There’s a faint chance that an error in the code you didn’t post is causing the problem. Post a complete SQL statement (as simple as [...]
View Answer
| January 17, 2008 5:04 PM
CASE statement, SQL, SQL Subselect
MS Access – Count of parent table items in a report
It sounds like there is no “OrderID” field to count. With the current field list, an “Order” could be defined as Order Date combined with CustomerID, unless the same customer placed two Orders the same day. It would be possible to create Order:[OrderDate] & [CustomerID] as a calculated field in your report to group or [...]
View Answer
| January 17, 2008 4:41 PM
Access, Access multi-table reports, Access reports, Microsoft Access, Multi-table reports
It sounds like there is no “OrderID” field to count. With the current field list, an “Order” could be defined as Order Date combined with CustomerID, unless the same customer placed two Orders the same day. It would be possible to create Order:[OrderDate] & [CustomerID] as a calculated field in your report to group or [...]
View Answer
| January 17, 2008 4:41 PM
Access, Access multi-table reports, Access reports, Microsoft Access, Multi-table reports
What self study material would land me an Enterprise Architect job?
From Ed Tittel (IT Certification Guy) Besides the TOGAF, for which you have indeed identified the correct study materials, there are other credentials you might want to consider Enterprise Architecture Certification: http://www.enterprise-architecture.info/EA_Certification.htm Sun Certified Enterprise Architect: http://www.sun.com/training/certification/java/scea.xml Certificate in Federal Enterprise Archtiecture: http://www.ce.csueastbay.edu/certificate/enterprise_architecture/index.shtml Microsoft Certified Architect Programs: http://www.microsoft.com/learning/mcp/architect/default.mspx See also Enterprise Architecture Links at http://www.bredemeyer.com/Architect/ArchitectCertification.htm [...]
View Answer
| January 16, 2008 7:18 PM
Careers in networking, IT careers, Job training
From Ed Tittel (IT Certification Guy) Besides the TOGAF, for which you have indeed identified the correct study materials, there are other credentials you might want to consider Enterprise Architecture Certification: http://www.enterprise-architecture.info/EA_Certification.htm Sun Certified Enterprise Architect: http://www.sun.com/training/certification/java/scea.xml Certificate in Federal Enterprise Archtiecture: http://www.ce.csueastbay.edu/certificate/enterprise_architecture/index.shtml Microsoft Certified Architect Programs: http://www.microsoft.com/learning/mcp/architect/default.mspx See also Enterprise Architecture Links at http://www.bredemeyer.com/Architect/ArchitectCertification.htm [...]
View Answer
| January 16, 2008 7:18 PM
Careers in networking, IT careers, Job training
Do I have to get an MCP or MCSE before getting into Cisco certifications?
No you don’t have to get an MCP or MCSE before attempting a Cisco certification like the CCNA. The CCNA does not touch on anything Microsoft related. It’s strictly network fundamentals and concepts with topics on configuring Cisco routers & switches. From Ed Tittel (IT Certification Guy): The preceding poster is absolutely correct in asserting [...]
View Answer
| January 16, 2008 7:11 PM
Career development, Certifications, Cisco certifications, CompTIA A+, CompTIA Network+, IT, IT careers, MCP, MCSE, Networking, Networking certifications
No you don’t have to get an MCP or MCSE before attempting a Cisco certification like the CCNA. The CCNA does not touch on anything Microsoft related. It’s strictly network fundamentals and concepts with topics on configuring Cisco routers & switches. From Ed Tittel (IT Certification Guy): The preceding poster is absolutely correct in asserting [...]
View Answer
| January 16, 2008 7:11 PM
Career development, Certifications, Cisco certifications, CompTIA A+, CompTIA Network+, IT, IT careers, MCP, MCSE, Networking, Networking certifications
Access 2007 refrence look up
Make two columns in your combo box. The first is the three letters and the second is what they stand for. The properties of the combo box should be: ColumnCount=2, BoundColumn=1, ColumnWidths=.5″;1.5″ (these withds may need to be adjusted to show all info in the drop down) If the row source type is “Value List”, [...]
View Answer
| January 16, 2008 2:44 PM
Access, Microsoft Access, Microsoft Office, Microsoft Office 2007
Make two columns in your combo box. The first is the three letters and the second is what they stand for. The properties of the combo box should be: ColumnCount=2, BoundColumn=1, ColumnWidths=.5″;1.5″ (these withds may need to be adjusted to show all info in the drop down) If the row source type is “Value List”, [...]
View Answer
| January 16, 2008 2:44 PM
Access, Microsoft Access, Microsoft Office, Microsoft Office 2007
design a web database application
Unfortunately, most PHP (and other) programmers won’t just drop a code in on request. The most you could hope for (realistically) is for someone to help you fix bugs in your code. What you are asking is if we will take time to write a script that we won’t ever get credit for. Most programmers [...]
View Answer
| January 16, 2008 2:15 PM
MySQL, PHP
Unfortunately, most PHP (and other) programmers won’t just drop a code in on request. The most you could hope for (realistically) is for someone to help you fix bugs in your code. What you are asking is if we will take time to write a script that we won’t ever get credit for. Most programmers [...]
View Answer
| January 16, 2008 2:15 PM
MySQL, PHP
programming for PHP and MySQL
The simple solution would be to create a field on the database, and name it something like user_lvl in mysql, it would be something like this: <pre>ALTER TABLE `table_name` ADD `user_lvl` INT( 3 ) NOT NULL ;</pre> that gives you a field that will allow you to give people with a level attached to their [...]
View Answer
| January 15, 2008 10:37 PM
MySQL, PHP
The simple solution would be to create a field on the database, and name it something like user_lvl in mysql, it would be something like this: <pre>ALTER TABLE `table_name` ADD `user_lvl` INT( 3 ) NOT NULL ;</pre> that gives you a field that will allow you to give people with a level attached to their [...]
View Answer
| January 15, 2008 10:37 PM
MySQL, PHP
Cannot end RGZPFM on V5R4 (Journaled file)
You don’t mention how you have tried to end the job. Have you used ENDJOB with OPTION(*IMMED)? If so, have you also tried ENDJOBABN (End Job Abnormal)? After the reorg of the physical file is finished, the RGZPFM command will rebuild all of the logical files attached to the physical file. Also, if you are [...]
View Answer
| January 15, 2008 1:39 AM
AS/400, AS/400 performance, DB2 Universal Database, ENDJOB, Journaling (Exchange), Recovery, REUSEDLT, RGZPFM, RPG, V5R4
You don’t mention how you have tried to end the job. Have you used ENDJOB with OPTION(*IMMED)? If so, have you also tried ENDJOBABN (End Job Abnormal)? After the reorg of the physical file is finished, the RGZPFM command will rebuild all of the logical files attached to the physical file. Also, if you are [...]
View Answer
| January 15, 2008 1:39 AM
AS/400, AS/400 performance, DB2 Universal Database, ENDJOB, Journaling (Exchange), Recovery, REUSEDLT, RGZPFM, RPG, V5R4
oracle calculated item
Hi, Sorry, I don’t understand the question well enough to give you an anser. Can you give an example of what you want to do? For example, perhaps ten rows of data, including two or three computed columns (with the rules for computing those columns), and how the user might want to change the formulas [...]
View Answer
| January 14, 2008 4:04 PM
Database Management Systems, DB2, Oracle, Oracle 6i, USE DATABASE
Hi, Sorry, I don’t understand the question well enough to give you an anser. Can you give an example of what you want to do? For example, perhaps ten rows of data, including two or three computed columns (with the rules for computing those columns), and how the user might want to change the formulas [...]
View Answer
| January 14, 2008 4:04 PM
Database Management Systems, DB2, Oracle, Oracle 6i, USE DATABASE
messaging and collaboration
In the business world, messaging is similar to the “public” Instant Messaging products from the likes of AOL, Yahoo!, Microsoft, the main differences are that the Enterprise-class systems called EIM, include two additional features: 1 – all messages are encrypted from within the sending EIM client software and decrypted within the receiving client software 2 [...]
View Answer
| January 12, 2008 3:30 PM
AIM, Availability, Bandwidth, Billing and customer care, Billing Support Systems, Brightmail, Budgeting, Business Objects, Business/IT alignment, Career development, Certifications, Cognos, Compliance, CRM, Crystal Reports, Data analysis, Data mining/analysis, Data warehousing applications, DataCenter, DataManagement, Development, Enterprise Desktop, ERP, Exchange, Instant Messaging, Laws, Lifecycle development, Linux, MySQL, Network monitoring, Network protocols, Networking, Outsourcing, Regulations, Spam, standards, Training, Web development
In the business world, messaging is similar to the “public” Instant Messaging products from the likes of AOL, Yahoo!, Microsoft, the main differences are that the Enterprise-class systems called EIM, include two additional features: 1 – all messages are encrypted from within the sending EIM client software and decrypted within the receiving client software 2 [...]
View Answer
| January 12, 2008 3:30 PM
AIM, Availability, Bandwidth, Billing and customer care, Billing Support Systems, Brightmail, Budgeting, Business Objects, Business/IT alignment, Career development, Certifications, Cognos, Compliance, CRM, Crystal Reports, Data analysis, Data mining/analysis, Data warehousing applications, DataCenter, DataManagement, Development, Enterprise Desktop, ERP, Exchange, Instant Messaging, Laws, Lifecycle development, Linux, MySQL, Network monitoring, Network protocols, Networking, Outsourcing, Regulations, Spam, standards, Training, Web development
Logical file
A logical file does not contain data itself. It is only a view of the physical file it is built over. The physical file itself has the data or duplicate records. Kevin You do not have Key constraints on the PF or a LF on those columns.
View Answer
| January 10, 2008 4:08 PM
Database issues, iSeries, Logical File
A logical file does not contain data itself. It is only a view of the physical file it is built over. The physical file itself has the data or duplicate records. Kevin You do not have Key constraints on the PF or a LF on those columns.
View Answer
| January 10, 2008 4:08 PM
Database issues, iSeries, Logical File
export oracle 8i database from unixserver
You should be able to shutdown the Oracle database on the unix server and copy the files to the Windows XP server (probably via FTP) then attach the database to the Oracle database installed on your workstation. If you can’t shutdown the Oracle database then do a backup of the database and restore it on [...]
View Answer
| January 4, 2008 8:51 PM
Database, Oracle 8i, Windows XP
You should be able to shutdown the Oracle database on the unix server and copy the files to the Windows XP server (probably via FTP) then attach the database to the Oracle database installed on your workstation. If you can’t shutdown the Oracle database then do a backup of the database and restore it on [...]
View Answer
| January 4, 2008 8:51 PM
Database, Oracle 8i, Windows XP
Database
You might wish to visit the <a href=”http://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems”>comparison of relational database management systems</a> at Wikipedia. There are tables showing comparative information for all the most popular relational databases. Here is an excerpt: “The following tables compare general and technical information for a number of relational database management systems. Please see the individual products’ articles for [...]
View Answer
| January 3, 2008 4:51 PM
HSQL, MySQL
You might wish to visit the <a href=”http://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems”>comparison of relational database management systems</a> at Wikipedia. There are tables showing comparative information for all the most popular relational databases. Here is an excerpt: “The following tables compare general and technical information for a number of relational database management systems. Please see the individual products’ articles for [...]
View Answer
| January 3, 2008 4:51 PM
HSQL, MySQL
