DB2 WebQuery for System i problem
Hi! Our server has already installed with DB2 web query. I have checked the basic things in licensed programs like QWEBQRC77(*lib) , MRADMIN(*usrprf)…everything is there. But when I try to start web query, the command is not available and also in license programs the web query shown like *INSTALLED(not *Compatible). We are using V6R1 version. [...]

Answer Question   |  June 18, 2013  6:42 AM
AS/400, AS/400 commands, DB2 Web Query

MySQL stored procedure debugger tool
Hi, I am looking for a MySQL stored procedure debugger tool for Ubuntu (Unix). Can someone help?

Answer Question   |  June 11, 2013  6:21 AM
MySQL, MySQL Stored Procedures, Ubuntu

24 hr clock in Microsoft Access
Microsoft Access allows you to open your table in datasheet view, select FIELDS from TABLE TOOLS and select from the drop down MORE FIELDS and then select TIME 24 so you can use military time. Problem is when you attempt to type in military time, it shows a calendar on the side and only allows [...]

Answer Question   |  June 5, 2013  8:08 PM
Microsoft Access, Microsoft Access features

Create Button to Open Specific Form
I have a continuous subform. I have added a command button beside each record on the subform to open another form, which is specific to that record. Every time I use the control wizard to make the button, the record I want is not opened. My relationship is Continuous ID to Button Number. I am [...]

Answer Question   |  May 22, 2013  2:27 PM
Access 2007, Access 2007 forms

Application retirement and database archiving
Hi! I have a constantly developing application and i want to archive its DB. The DB tables structures constantly change. My idea is to develop non changing core structures (tables) of production tables. It will be something like physical DataMart. For example if I have client information in Application DB, in DataMart I will have only [...]

Answer Question   |  May 22, 2013  10:06 AM
Application acceleration, Archive, Database, Database archiving, ETL, ILM

ITKE Discussion tool bar
It’s been a few weeks since I had the discussion tool bar. ITKE development can not replicate the problem. Did you experience this problem? How did you resolve it? Thanks Phil 5/7/13 .. added tags that have nothing to do with this task but might get some attention

Answer Question   |  May 7, 2013  1:37 AM
AS/400, Database, Development, itke discussion tool bar, Networking, Security

I want to assemble a workstation and I don’t know which correct board to use
I have this task of assembling a workstation, and I have been thinking of what model of system motherboard to use, and what Intel processor type to use and the type of media card to use The workstation is going to be used to hold large amount of data, and stores some high resolution media [...]

Answer Question   |  April 26, 2013  2:50 PM
Data Center, Database, Networking

Database audit trail
If database audit trail is not enabled or DBA is having write access on it, then how we can make sure of the integrity of the data in the database?

Answer Question   |  April 16, 2013  6:55 AM
Database, DBA

Object-Relational database
I find it always challenging to drop types and tables in object-relational DB Schema. Almost invariably, ORA 02303 exception is thrown. Is there some hidden facts about this?

Answer Question   |  April 14, 2013  10:28 AM
Database

Can I create a view in SQL Server 2008 selecting data from an Intersystems Cachè Database?
Can I create a view in SQL Server 2008 selecting data from an Intersystems Cachè Database? I need to access data in an Intersystems Cachè Database from an SQL Server database. Can I do a select in SQL Server from a table in another DBMS system? How can I do it? Data is in a [...]

Answer Question   |  April 2, 2013  2:22 PM
Cache, Database, InterSystems, SQL Server

webservice and iDB2 connections slow on startup
We have a web service running on a SQL server sending data to our I-Series using a DB2 connection. The first time the service is run to submit an order, there is a long delay before it is submitted. On repeated orders it much quicker. Is there something we can do to speed up the [...]

Answer Question   |  April 1, 2013  2:11 PM
AS 400, DB2 connectivity, i series, SQL Server

Make a table
How do you make a table?

Answer Question   |  April 1, 2013  9:44 PM
tables

E-voting website
I intend to develop an internet voting website for my department to help with the departmental elections. How do I go about the programming aspect and the core part of database?

Answer Question   |  March 27, 2013  11:07 AM
Database, Database administration

SharePoint 2010 Capabilities
Using SharePoint 2010 can I create a page with a template of fields that users can fill out (system change requests) and submit generating an email to a dist list? I also want the page to store the request information, so those can check back on status of their system request changes. I have read [...]

Answer Question   |  March 27, 2013  1:03 AM
Microsoft Access, Microsoft SharePoint

JDBC in SQL
Need example to retrieve data from JDBC in SQL?

Answer Question   |  March 26, 2013  5:27 PM
JDBC, SQL

How to merge all MDB files
I have more than 100 Access 2003 .MDB files and all the files have same structures and tables. I want to merge all to one MDB file.

Answer Question   |  March 22, 2013  4:47 PM
MDB, Microsoft Access

Can in-memory computing handle big data demands?
Big data may have met its match as in-memory computing has become one of the top 10 strategic technology trends of 2013, according to Gartner. Used by Google and Twitter, this approach allows easier access to data and provides better analysis. Do you think in-memory computing can handle big data demands?

Answer Question   |  April 2, 2013  1:28 PM
Big Data, In-Memory Database

Hiding table tabs
With basic hide when statement I am able to view one or more tabs based on selection. My problem is when I have all but one tab hidden and print there is extra space that represents the other tabs. for example I have a tab table with 6 rows and only row 1 is in [...]

Answer Question   |  March 21, 2013  4:26 PM
TabControl, Table Functions, tables

Export/Import database with large blobs in MySQL
Hi, we are having trouble exporting and importing databases with blobs in mysql. We have a development environment and a production environment both running mysql-5.0.45 and want to dump databases with blobs from one to the other. We have tried with many options but nothing works. When importing the databases mysql partially imports data and [...]

Answer Question   |  March 18, 2013  6:59 PM
blobs, Database, MySQL, mysql import, mysqldump

Best way to set up longitudinal database
Trying to create a database with enrolled student information and want to query students enrolled for a specific semester who then returned for a different semester – but on a larger scale – who were retained 2nd year, 3rd year, 4th year, etc. Trying to have all my semester data in one table and some [...]

Answer Question   |  March 14, 2013  2:25 AM
Microsoft Access, Microsoft Access database