Different database & server collation
As long as you aren’t running queries that join tables between databases you can have a database in a different collation for ever. It doesn’t effect the length of time the database can be hosed on that instance. You could have each user database on the server have a different collation if you wanted to.
View Answer
| October 16, 2009 4:28 AM
Collation, SQL Server 2005
As long as you aren’t running queries that join tables between databases you can have a database in a different collation for ever. It doesn’t effect the length of time the database can be hosed on that instance. You could have each user database on the server have a different collation if you wanted to.
View Answer
| October 16, 2009 4:28 AM
Collation, SQL Server 2005
Transfer Data from one database to other.
Unless you file file descriptions for both systems and the field names care exactly the same, a tool is not going to be found that can do this. You need to define all your fields in the source system and the files they are comming from. Then do the same with the target system. Most [...]
View Answer
| October 15, 2009 12:21 PM
Database Management Systems, Database migration
Unless you file file descriptions for both systems and the field names care exactly the same, a tool is not going to be found that can do this. You need to define all your fields in the source system and the files they are comming from. Then do the same with the target system. Most [...]
View Answer
| October 15, 2009 12:21 PM
Database Management Systems, Database migration
abt the server
Check out XAMPP for the php/mysql/apache part and you should be able to put a j2ee solution into that. http://www.apachefriends.org/en/xampp.html
View Answer
| October 11, 2009 3:03 AM
Apache, MySQL, PHP
Check out XAMPP for the php/mysql/apache part and you should be able to put a j2ee solution into that. http://www.apachefriends.org/en/xampp.html
View Answer
| October 11, 2009 3:03 AM
Apache, MySQL, PHP
Updating a View
A true “view” automatically updates when the underlying data is updated. Also, in SQL Server an “indexed view” also refreshes automatically. If this is an Oracle materialized view, then the view definition can specify the refresh method for automatic refreshing (periodically on a timed basis or whenever an underlying table is changed). You would need [...]
View Answer
| October 9, 2009 3:23 PM
Data management and storage, Database, SQL, Updates, Views
A true “view” automatically updates when the underlying data is updated. Also, in SQL Server an “indexed view” also refreshes automatically. If this is an Oracle materialized view, then the view definition can specify the refresh method for automatic refreshing (periodically on a timed basis or whenever an underlying table is changed). You would need [...]
View Answer
| October 9, 2009 3:23 PM
Data management and storage, Database, SQL, Updates, Views
Master/Child Link problem in Subform
I just figured out the answer. I coded the command button to open the subform/child, instead of just making it visible. This bypassed the main form/parent and caused the problem. When I set the subform as invisible and made it visible when the command button was clicked, the foreign key was there. That way the [...]
View Answer
| October 9, 2009 3:21 PM
Microsoft Access, Microsoft Access subforms
I just figured out the answer. I coded the command button to open the subform/child, instead of just making it visible. This bypassed the main form/parent and caused the problem. When I set the subform as invisible and made it visible when the command button was clicked, the foreign key was there. That way the [...]
View Answer
| October 9, 2009 3:21 PM
Microsoft Access, Microsoft Access subforms
copy 1.2 GB mdb from pc to network
I would try using a program such as the windows xcopy or this third party xxcopy that can be found here: http://www.xxcopy.com/index.htm if your system does not have xcopy on it you can find it here: http://www.uv.tietgen.dk/staff/mlha/Download/dos/#XCOPY I have also had luck with robpcopy from Microsoft which is located here: http://www.microsoft.com/Downloads/details.aspx?FamilyID=9d467a69-57ff-4ae7-96ee-b18c4790cffd Any of these programs [...]
View Answer
| October 8, 2009 7:40 PM
Exchange MDB, MDB, Microsoft Access
I would try using a program such as the windows xcopy or this third party xxcopy that can be found here: http://www.xxcopy.com/index.htm if your system does not have xcopy on it you can find it here: http://www.uv.tietgen.dk/staff/mlha/Download/dos/#XCOPY I have also had luck with robpcopy from Microsoft which is located here: http://www.microsoft.com/Downloads/details.aspx?FamilyID=9d467a69-57ff-4ae7-96ee-b18c4790cffd Any of these programs [...]
View Answer
| October 8, 2009 7:40 PM
Exchange MDB, MDB, Microsoft Access
not a valid Query Management variable.
The query variable is invalid in the query and in the CL. In the QM Query, give the variable a meaningful name, preceded by an ampersand ie. &TRAN. in the CL, the SETVAR part of the STRQMQRY statement should read ((TRAN ‘FCT’)), where the QM Query variable is first WITHOUT THE AMPERSAND and the value [...]
View Answer
| October 8, 2009 12:39 AM
CL, CL programming, CL variables, QMQRY, Query Management Facility, STRQMQRY, V5R4, Variables
The query variable is invalid in the query and in the CL. In the QM Query, give the variable a meaningful name, preceded by an ampersand ie. &TRAN. in the CL, the SETVAR part of the STRQMQRY statement should read ((TRAN ‘FCT’)), where the QM Query variable is first WITHOUT THE AMPERSAND and the value [...]
View Answer
| October 8, 2009 12:39 AM
CL, CL programming, CL variables, QMQRY, Query Management Facility, STRQMQRY, V5R4, Variables
Why are naturl JOIN keywords not an option for producing a self-join?
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 13, 2013 3:20 PM
JOIN statement, SQL procedure
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 13, 2013 3:20 PM
JOIN statement, SQL procedure
Error 2282 in Microsoft Access
Do you have this <a href=”http://www.microsoft.com/downloads/details.aspx?FamilyID=4d951911-3e7e-4ae6-b059-a2e79ed87041&displaylang=en”> </a> installed? 2282 indicates that the software probably isn’t installed. When I get 2282 I call an error handling proceedure that installs the download on this linked page. Personally I perfer the <pre> DoCmd.SendObject acSendReport, REPORTNAME, acFormatPDF, TOADDRESS, CCADDRESS, BCCADDRESS, Subject, Message, False </pre> to send an email or [...]
View Answer
| October 6, 2009 4:00 PM
Access reports, Microsoft Access, Micrsoft Access reporting
Do you have this <a href=”http://www.microsoft.com/downloads/details.aspx?FamilyID=4d951911-3e7e-4ae6-b059-a2e79ed87041&displaylang=en”> </a> installed? 2282 indicates that the software probably isn’t installed. When I get 2282 I call an error handling proceedure that installs the download on this linked page. Personally I perfer the <pre> DoCmd.SendObject acSendReport, REPORTNAME, acFormatPDF, TOADDRESS, CCADDRESS, BCCADDRESS, Subject, Message, False </pre> to send an email or [...]
View Answer
| October 6, 2009 4:00 PM
Access reports, Microsoft Access, Micrsoft Access reporting
DB Web Interface
You can make it in just about anything you are comfortable with. ASP, C#, VB.NET all come to mind right off the bat.
View Answer
| October 5, 2009 6:15 PM
Database, Web site design & management
You can make it in just about anything you are comfortable with. ASP, C#, VB.NET all come to mind right off the bat.
View Answer
| October 5, 2009 6:15 PM
Database, Web site design & management
Working TRIGGER and TRANSACTIONS QUESTION
First, everything is in some kind of “transaction”. When you do a “Begin Transaction”, you are stating that everything up to the next “Commit” (or Rollback) is to be considered as a single transaction. If you execute a SQL statement when there is no “Begin Transaction” active, that single statement is itself a transaction. From [...]
View Answer
| October 1, 2009 9:07 PM
SQL Server 2005, SQL Trigger, Transactions Per Second, TRIGGER
First, everything is in some kind of “transaction”. When you do a “Begin Transaction”, you are stating that everything up to the next “Commit” (or Rollback) is to be considered as a single transaction. If you execute a SQL statement when there is no “Begin Transaction” active, that single statement is itself a transaction. From [...]
View Answer
| October 1, 2009 9:07 PM
SQL Server 2005, SQL Trigger, Transactions Per Second, TRIGGER
DB2 Web Query record count
Is this what you are looking for? your original query SELECT ….. FROM … WHERE … then follow up with SELECT COUNT(*) FROM … WHERE … use the same FROM and WHERE clauses and it will give you a count. Alternatively, does your product have access to the equivalent of the DB2 SQLCA? In the [...]
View Answer
| September 30, 2009 7:07 PM
DB2, DB2 Web Query
Is this what you are looking for? your original query SELECT ….. FROM … WHERE … then follow up with SELECT COUNT(*) FROM … WHERE … use the same FROM and WHERE clauses and it will give you a count. Alternatively, does your product have access to the equivalent of the DB2 SQLCA? In the [...]
View Answer
| September 30, 2009 7:07 PM
DB2, DB2 Web Query
Embedded SQL
Emp_Pat_Dept_Data is the name created with the create view, so you should be able to use it in SQL commands. If you use that view you will only see the fields in the view’s field list The fields will have the field names assigned in the view. Phil =============== Well, I don’t know why it [...]
View Answer
| September 29, 2009 7:20 PM
Embedded SQL, SQLRPGLE
Emp_Pat_Dept_Data is the name created with the create view, so you should be able to use it in SQL commands. If you use that view you will only see the fields in the view’s field list The fields will have the field names assigned in the view. Phil =============== Well, I don’t know why it [...]
View Answer
| September 29, 2009 7:20 PM
Embedded SQL, SQLRPGLE
Forms in Access 2007
There are multiple ways to solve your issue. If I understood correctly you want to insert records to a table based on click event of a button. 1. First design a table with fields you want to capture using this form. 2. Than design the unbound form where textbox are not linked to any table. [...]
View Answer
| September 29, 2009 3:55 PM
Access 2007, Access forms, Microsoft Access, SQL, Visual Basic
There are multiple ways to solve your issue. If I understood correctly you want to insert records to a table based on click event of a button. 1. First design a table with fields you want to capture using this form. 2. Than design the unbound form where textbox are not linked to any table. [...]
View Answer
| September 29, 2009 3:55 PM
Access 2007, Access forms, Microsoft Access, SQL, Visual Basic
Access for Windows 5.4
\yourservernameqibmProdDataCA400ExpressInstallImageSetup.exe or \yourserverIPqibmProdDataCA400ExpressInstallImageSetup.exe
View Answer
| September 25, 2009 7:16 PM
AS/400 printing, iSeries, Microsoft Access
\yourservernameqibmProdDataCA400ExpressInstallImageSetup.exe or \yourserverIPqibmProdDataCA400ExpressInstallImageSetup.exe
View Answer
| September 25, 2009 7:16 PM
AS/400 printing, iSeries, Microsoft Access
General question about Database Performance Management Software
by “database perf mgmt software” are you referring to database monitors? If so, then YES they are stand-alone in the sense that they do not need anything else in order to execute and also NO in the sense that they need information from the database (via journaling or SMF or something) in order to communicate [...]
View Answer
| September 24, 2009 4:18 PM
Access Database, Database performance, Performance management
by “database perf mgmt software” are you referring to database monitors? If so, then YES they are stand-alone in the sense that they do not need anything else in order to execute and also NO in the sense that they need information from the database (via journaling or SMF or something) in order to communicate [...]
View Answer
| September 24, 2009 4:18 PM
Access Database, Database performance, Performance management
Is it possible using Embedded SQL or something else in RPG to directly update and MS SQL DB
Minidach: Using JDBC, you can directly access an MS-SQL database. If you visit the SYstem i Network website and forums, you will find several articles, down-loadable code, etc. You MAY be able to access an MS-SQL database using IBM i DB2 SQL, but I have not personally done that. HTH Jon Juracich.
View Answer
| September 24, 2009 2:08 PM
AS/400, Embedded SQL, Microsoft SQL Server
Minidach: Using JDBC, you can directly access an MS-SQL database. If you visit the SYstem i Network website and forums, you will find several articles, down-loadable code, etc. You MAY be able to access an MS-SQL database using IBM i DB2 SQL, but I have not personally done that. HTH Jon Juracich.
View Answer
| September 24, 2009 2:08 PM
AS/400, Embedded SQL, Microsoft SQL Server
Difference between ODBC and JDBC?
ODBC is for microsoft and JDBC is for Java. JBDC is portable across platforms where ODBC is not. See the following for more information: Also, a quick Google search shows 32,900 hits for “Difference between ODBC and JDBC”. +++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Thank you. I have seen all of those in my search already. I guess I was [...]
View Answer
| April 19, 2013 1:45 PM
AS/400, Database, DB2, Development, Java applications, JDBC, ODBC, SQL
ODBC is for microsoft and JDBC is for Java. JBDC is portable across platforms where ODBC is not. See the following for more information: Also, a quick Google search shows 32,900 hits for “Difference between ODBC and JDBC”. +++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Thank you. I have seen all of those in my search already. I guess I was [...]
View Answer
| April 19, 2013 1:45 PM
AS/400, Database, DB2, Development, Java applications, JDBC, ODBC, SQL
DB2 indexes and Crystal Reports
One never specifically accesses a DB2 index. consider a SELECT statement – one specifies the columns and the table. DB2 may or may not use one or more indices to get you your answer, but you do not name an index.
View Answer
| September 23, 2009 8:00 PM
AS/400 DB2, Crystal Reports, Crystal Reports 8, DB2, Indexes, V5R1
One never specifically accesses a DB2 index. consider a SELECT statement – one specifies the columns and the table. DB2 may or may not use one or more indices to get you your answer, but you do not name an index.
View Answer
| September 23, 2009 8:00 PM
AS/400 DB2, Crystal Reports, Crystal Reports 8, DB2, Indexes, V5R1
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
