SQL query error: token DATA
The term ‘DATA CAPTURE NONE’ is an SQL 2008 term Journaling on the 400 is about the same — but it’s been around a lot longer. If a collection exists and you create the table in the collection it will be journalled ———————- DATA CAPTURE is a valid clause in a CREATE TABLE (and ALTER [...]
View Answer
| September 23, 2009 4:20 PM
AS/400, DB2, JDBC, SQL Query
The term ‘DATA CAPTURE NONE’ is an SQL 2008 term Journaling on the 400 is about the same — but it’s been around a lot longer. If a collection exists and you create the table in the collection it will be journalled ———————- DATA CAPTURE is a valid clause in a CREATE TABLE (and ALTER [...]
View Answer
| September 23, 2009 4:20 PM
AS/400, DB2, JDBC, SQL Query
QMF
this answer comes almost a year after the question was asked. I just noticed that the question is still outstanding (unanswered). Yes, in QMF you can save your SQL statements. You can even save them with “markers” in them instead of actual values so that when someone runs one of the saved queries that person [...]
View Answer
| September 23, 2009 4:05 PM
DB2, DB2 query tools, IBM DB2, IBM DB2 Query Management Facility, IBM Query Management Facility, QMF, Query Management Facility
this answer comes almost a year after the question was asked. I just noticed that the question is still outstanding (unanswered). Yes, in QMF you can save your SQL statements. You can even save them with “markers” in them instead of actual values so that when someone runs one of the saved queries that person [...]
View Answer
| September 23, 2009 4:05 PM
DB2, DB2 query tools, IBM DB2, IBM DB2 Query Management Facility, IBM Query Management Facility, QMF, Query Management Facility
How to limit the number of application connections in DB2?
we can set using the command: <b>db2 update db cfg for <db name> using MAXAPPLS <value></b> Example: bash-3.00$ db2 update db cfg for DBQA using MAXAPPLS 1 SQL5153N The update cannot be completed because the following relationship would be violated: “maxappls * maxlocks >= 100″. bash-3.00$ db2 update db cfg for DBQA using MAXLOCKS 101 [...]
View Answer
| September 23, 2009 3:59 PM
DB2, DB2 administration, DB2 configuration, DB2 connectivity, DB2 Universal Database
we can set using the command: <b>db2 update db cfg for <db name> using MAXAPPLS <value></b> Example: bash-3.00$ db2 update db cfg for DBQA using MAXAPPLS 1 SQL5153N The update cannot be completed because the following relationship would be violated: “maxappls * maxlocks >= 100″. bash-3.00$ db2 update db cfg for DBQA using MAXLOCKS 101 [...]
View Answer
| September 23, 2009 3:59 PM
DB2, DB2 administration, DB2 configuration, DB2 connectivity, DB2 Universal Database
SQL join two counts on same table
Some example data would have been nice. How about something like this ? <pre>SELECT photoID, SUM(countWin), SUM(countLose) FROM (SELECT photoIDWinner AS photoID, COUNT(primaryID) AS countWin, 0 AS countLose FROM rankRaw GROUP BY photoIDWinner UNION SELECT photoIDLoser AS photoID, 0 AS countWin, COUNT(primaryID) AS countLose FROM rankRaw GROUP BY photoIDLoser) GROUP BY photoID;</pre>
View Answer
| September 21, 2009 8:02 PM
MySQL query, SQL
Some example data would have been nice. How about something like this ? <pre>SELECT photoID, SUM(countWin), SUM(countLose) FROM (SELECT photoIDWinner AS photoID, COUNT(primaryID) AS countWin, 0 AS countLose FROM rankRaw GROUP BY photoIDWinner UNION SELECT photoIDLoser AS photoID, 0 AS countWin, COUNT(primaryID) AS countLose FROM rankRaw GROUP BY photoIDLoser) GROUP BY photoID;</pre>
View Answer
| September 21, 2009 8:02 PM
MySQL query, SQL
How do I set decimal places with VB Access
First, the decimal places property in the table does not indicate how many decimal places will be stored. It is only for displaying the decimal places. To display the decimal places on the report, use the format property of the instrument field. Here’s an example of code that could be placed in the report’s detail [...]
View Answer
| September 21, 2009 1:51 PM
Access 2000, Microsoft Access, VB, Visual Basic
First, the decimal places property in the table does not indicate how many decimal places will be stored. It is only for displaying the decimal places. To display the decimal places on the report, use the format property of the instrument field. Here’s an example of code that could be placed in the report’s detail [...]
View Answer
| September 21, 2009 1:51 PM
Access 2000, Microsoft Access, VB, Visual Basic
dbcc checkdb error; object id 0
I’d start by running DBCC on the source database and see if there’s anything wrong with the source database. It sounds like the corrupt page isn’t associated with a table, so the engine doesn’t know what to do with it. If the source database has this same corruption you may want to call Microsoft and [...]
View Answer
| September 16, 2009 10:30 PM
DBCC, DBCC CHECKDB, SQL Server 2005, SQL Server database restore
I’d start by running DBCC on the source database and see if there’s anything wrong with the source database. It sounds like the corrupt page isn’t associated with a table, so the engine doesn’t know what to do with it. If the source database has this same corruption you may want to call Microsoft and [...]
View Answer
| September 16, 2009 10:30 PM
DBCC, DBCC CHECKDB, SQL Server 2005, SQL Server database restore
DB question(s) that I have never heard a direct answer for
Well, the standard answer is DEPENDS. +++++ I would go with the one record that contains IN/Out time. Here are some of the DEPENDS??? 1. At the point of capture, what information are you getting? ID#, Job Number, TimeStamp, Time Indicator (In vs Out) 2. If the In time was not entered can both In [...]
View Answer
| September 16, 2009 7:49 PM
Database, Database design
Well, the standard answer is DEPENDS. +++++ I would go with the one record that contains IN/Out time. Here are some of the DEPENDS??? 1. At the point of capture, what information are you getting? ID#, Job Number, TimeStamp, Time Indicator (In vs Out) 2. If the In time was not entered can both In [...]
View Answer
| September 16, 2009 7:49 PM
Database, Database design
What are the career prospects of three yrs. diploma holder in computer Engg. ?
You career prospects are as great and grand as you make them! Understand what you like to do, what you’re good at, where you want to go…and by all means, have a set of goals so you’ll know which direction to head. Here are some good <a href=”http://www.principlelogic.com/careers.html”>TechTarget resources to help you get started</a>.
View Answer
| September 16, 2009 5:52 PM
Careers, Computer engineering, IT careers
You career prospects are as great and grand as you make them! Understand what you like to do, what you’re good at, where you want to go…and by all means, have a set of goals so you’ll know which direction to head. Here are some good <a href=”http://www.principlelogic.com/careers.html”>TechTarget resources to help you get started</a>.
View Answer
| September 16, 2009 5:52 PM
Careers, Computer engineering, IT careers
How to create a virtual shared disk on for a cluster setup?
Cluster Shared Volumes are created via Failover Cluster Manager (we will actually be posting a video on this soon), but to do it, you first need to have a cluster, then add a Disk to the cluster (initialize, and give it a drive letter through disk administrator), then add it as a disk to the [...]
View Answer
| September 15, 2009 12:36 AM
Clustering, Microsoft virtualization, Microsoft Virtualization Chat 8/27, Virtual Disk
Cluster Shared Volumes are created via Failover Cluster Manager (we will actually be posting a video on this soon), but to do it, you first need to have a cluster, then add a Disk to the cluster (initialize, and give it a drive letter through disk administrator), then add it as a disk to the [...]
View Answer
| September 15, 2009 12:36 AM
Clustering, Microsoft virtualization, Microsoft Virtualization Chat 8/27, Virtual Disk
Controlling tempdb Growth
You should move the tempdb to another drive which has enough space. You can move the tempdb database without issue. Moving the tempdb database is actually very easy. <pre>ALTER DATABASE tempdb MODIFY FILE (name=’tempdev’, filename=’D:PathToWhereItWillBetempdev.mdf’) GO ALTER DATABASE tempdb MODIFY FILE (name=’templog’, filename=’D:PathToWhereItWillBetemplog.ldf’) GO</pre> Just change the drive letters and paths to be where you [...]
View Answer
| September 11, 2009 10:18 PM
SQL Server, SQL Server 2005, TempDB
You should move the tempdb to another drive which has enough space. You can move the tempdb database without issue. Moving the tempdb database is actually very easy. <pre>ALTER DATABASE tempdb MODIFY FILE (name=’tempdev’, filename=’D:PathToWhereItWillBetempdev.mdf’) GO ALTER DATABASE tempdb MODIFY FILE (name=’templog’, filename=’D:PathToWhereItWillBetemplog.ldf’) GO</pre> Just change the drive letters and paths to be where you [...]
View Answer
| September 11, 2009 10:18 PM
SQL Server, SQL Server 2005, TempDB
PeopleSoft Index Peformance
Typically yes, but it isn’t required.
View Answer
| September 11, 2009 10:11 PM
Index Performance, Oracle PeopleSoft, PeopleSoft
Typically yes, but it isn’t required.
View Answer
| September 11, 2009 10:11 PM
Index Performance, Oracle PeopleSoft, PeopleSoft
Do you have any idea approximately when MS & Marathon will have the capability of clustering completed?
We have nothing to announce at this time but you can check <a href=”http://www.microsoft.com/virtualization”>www.microsoft.com/virtualization</a> for news updates.
View Answer
| September 11, 2009 2:01 PM
Clustering, Microsoft virtualization, Microsoft Virtualization Chat 8/27
We have nothing to announce at this time but you can check <a href=”http://www.microsoft.com/virtualization”>www.microsoft.com/virtualization</a> for news updates.
View Answer
| September 11, 2009 2:01 PM
Clustering, Microsoft virtualization, Microsoft Virtualization Chat 8/27
What does it mean by related data in a database?
Relational data is the key to a database. It basically means that the data in one table relates to the data in another table. In an HR database you’ve got two tables, Employee and Department. <pre>CREATE TABLE Department (DepartmentId INT, DepartmentName varchar(50)) CREATE TABLE Employee (EmployeeId INT, FirstName varchar(50), LastName varchar(50), DepartmentId INT)</pre> These tables [...]
View Answer
| September 9, 2009 2:46 PM
Database, Relational databases
Relational data is the key to a database. It basically means that the data in one table relates to the data in another table. In an HR database you’ve got two tables, Employee and Department. <pre>CREATE TABLE Department (DepartmentId INT, DepartmentName varchar(50)) CREATE TABLE Employee (EmployeeId INT, FirstName varchar(50), LastName varchar(50), DepartmentId INT)</pre> These tables [...]
View Answer
| September 9, 2009 2:46 PM
Database, Relational databases
Flat file
CPYTOIMPF might do the trick ///////////////// What kind of “flat” file are you talking about? IFS file? No DDS file? Wilson
View Answer
| September 7, 2009 5:41 PM
Flat files, RPG, RPG Flat Files, RPG III
CPYTOIMPF might do the trick ///////////////// What kind of “flat” file are you talking about? IFS file? No DDS file? Wilson
View Answer
| September 7, 2009 5:41 PM
Flat files, RPG, RPG Flat Files, RPG III
certification help
well, you dont get certifications just to get certified..its knowing your strengths that could be harness in full swing specially in a fast paced environment of technology, get certifications that really suites your needs..lets say you have taken oracle certifications, question is would it benefit you in the future?that you know in yourself you dont [...]
View Answer
| September 4, 2009 6:41 AM
Certifications, IT careers, Linux certifications, Oracle certifications, Red Hat Enterprise Linux
well, you dont get certifications just to get certified..its knowing your strengths that could be harness in full swing specially in a fast paced environment of technology, get certifications that really suites your needs..lets say you have taken oracle certifications, question is would it benefit you in the future?that you know in yourself you dont [...]
View Answer
| September 4, 2009 6:41 AM
Certifications, IT careers, Linux certifications, Oracle certifications, Red Hat Enterprise Linux
Advantages and disadvantages of MySQL 5.0
Thank you for visiting ITKE. We are happy to help you with solving specific IT questions, but need as much information as possible to do so. Let us know about the problem you are trying to solve, how you are approaching it and what work you’ve done so far, and we can help guide you [...]
View Answer
| May 19, 2013 3:35 PM
Database design, MySQL, MySQL 5.0
Thank you for visiting ITKE. We are happy to help you with solving specific IT questions, but need as much information as possible to do so. Let us know about the problem you are trying to solve, how you are approaching it and what work you’ve done so far, and we can help guide you [...]
View Answer
| May 19, 2013 3:35 PM
Database design, MySQL, MySQL 5.0
Format CSV file column width.
Did anyone find an appropriate answer to the original question?
View Answer
| August 31, 2009 11:04 AM
CSV, CSV file format
Did anyone find an appropriate answer to the original question?
View Answer
| August 31, 2009 11:04 AM
CSV, CSV file format
Retrieving the ‘SA’ password
This should helpyou: http://www.nextgenss.com/products/sqlcrack.htm
View Answer
| August 30, 2009 1:04 PM
Linux, Linux Commands, SA password, Sysbase
This should helpyou: http://www.nextgenss.com/products/sqlcrack.htm
View Answer
| August 30, 2009 1:04 PM
Linux, Linux Commands, SA password, Sysbase
Database connection problem
Make sure that you have imported the package <b> java.sql.*</b>
View Answer
| August 28, 2009 4:39 AM
Java Database Connectivity, JDBC, Oracle 8i, SQL
Make sure that you have imported the package <b> java.sql.*</b>
View Answer
| August 28, 2009 4:39 AM
Java Database Connectivity, JDBC, Oracle 8i, SQL
MySQL vs. Oracle
MySQL a relational database purchased as part of its immediate previous owner, Sun Microsystems.This product is opensource. Oracle 10g free to distribute on Windows and Linux platforms.It is a product by Oracle Corporation.But not an open source product. Please verify the site: http://it.toolbox.com/blogs/oracle-guide/oracle-10g-vs-postgresql-8-vs-mysql-5-5452
View Answer
| August 28, 2009 2:52 AM
MySQL, MySQL 5.0, MySQL vs. Oracle, Oracle 10g
MySQL a relational database purchased as part of its immediate previous owner, Sun Microsystems.This product is opensource. Oracle 10g free to distribute on Windows and Linux platforms.It is a product by Oracle Corporation.But not an open source product. Please verify the site: http://it.toolbox.com/blogs/oracle-guide/oracle-10g-vs-postgresql-8-vs-mysql-5-5452
View Answer
| August 28, 2009 2:52 AM
MySQL, MySQL 5.0, MySQL vs. Oracle, Oracle 10g
