Database

UDS and DS

I know well Data Strucutre (DS) and its usage, how an UDS (Data Area Data Structure) is different from and ordinary DS, I just find to know by myself but I was unable to find it. Can any one help me in expalainigt this? Software/Hardware used: Iseries

What are the points to be taken care of when designing a database on Linux?

What are the points to be taken care of when designing a database on Linux? What are the different replication methods available?

SQL query help

Below is a list of the query that I am working on. There are part numbers that may be match to more than one module number. What I need is to show only the part numbers for the list. These part numbers I need a list of only one part number for each group. PartNo------ Module------ Numbers...

MySQL database size

Is there a limit on database size for MySQL? my database is getting on the large zise will this effect proformance? Software/Hardware used: linux server

New To the Industry

Hello, my name is Kristine and I am a first year student in IT field. My major is Networking communications and Information systems w/ a concentration in MS operating systems. I wanted to know if anyone had any websites i can go to or magazines I can subscribe to get learn about my new career.

multi-use of the database

Hello . I've developed a local website using xampp , and I want to access the mysql database in it to develop a J2SE application. Is it possible ? if so could you give me the right keywords to search since I kept trying every single word that could pop into my mind . Thank you very much . ...

SAP or Mainframe

hi.       I m fresher and want to go into specilaisation either to SAP or Mainframe.I have an aggreagte of 60% throughout my degree of B.E in I.T.  I am little bit confuse to which option to choose right now? So if anybody plaese help me to sort out this quetion  

Foreign key constraints support in MyISAM

Are foreign key constraints supported in MyISAM of MySQL? I have created a table using InnoDB, declaring the foreign key, and now I want to convert that table to MyISAM. Is it possible, and if so, how can I do it? Software/Hardware used: MySQL

The most-watched IT questions this week: Oct. 20, 2009

Here are the 5 most watched questions on ITKE: There's some great discussions going on ranging from SQL to diagnosing app crashes. Go answer a question now and take your shot at winning a TV, or check out the rest of the top 10 on the Community Blog: 1.ORA-31672 in oracle 11g tops the list, with...

get a anr record from databse by using max (one Field) and orderby (one filed) desc

Hi, I have a table. It can have multiple records for the key value. Ex secid   time       source 1       02:04    a 1      02:04    b 2 3 Now i want only one record of secid for a descending orderby of (source) and for a max time stamp. and later i will join the secid with...

Most popular blog posts this week

10. Removing old hardware after a P2V conversion Eric Siebert shares a long-held best practice regarding old server management. 9. The challenge of managing risk when IT budgets tighten Linda Tucci explains the challenges of a down economy -- and offers some tips on coming out ahead. 8. Ellison...

SQL related tables

I have 2 tables one with all my products and their accociated details and another with comments on the products. Product table 1 prodID, title, description, price Comments table 2 commID, prodID, comment I would like to export this to a single XML file, thus an XML element for each product from...

VB

Hi Experts in VB 6.0 Please Tell me how I code for combo just like Access form eg. In Access Form's Combo -- when we start type any letter then nearest matching data should be selected and auto also showing during typing in the combo box Question : Please give any idea for VB 6.0 Combo --- so when...

Transfer Data from one database to other.

Hi all, How to transfer datas from one database which has completelly different structure to other datebase with different structure? How to map these database? Is there any tool which does this? If so please suggest some free tool. Please help. Thank you all in advance.

The most-watched IT questions this week: Oct. 13, 2009

Here are the 10 most watched questions on ITKE: There’s some great discussions going on ranging from going green to how to create a new network. Go answer a question now and take your shot at winning a TV, or check out the rest of the top 10 on the Community Blog: 1. Going green: Are you feeling...

database

How to make an offline database that can be access through network

Different database & server collation

Hi, We have a database that is sitting on a SQL Server 2005 with different collation setting, the application connect to the database is running with out any issue. Have anyone had this same issue, if so how long has your application run with different database and server collation without...

Plans and Guidelines for a Web Application Project

Hello there fellow users, I have been entrusted with the task of designing and implementing a financial system for a charity foundation where I live. The charity foundation requires its work (addition and retrieval of records, for example) to be done online, using a web app. The app connects to a...

abt the server

is it possible to make my personal computer to act both as client and server for the purpous of doing project like php-mysql-apache and for deployinf j2ee also

ms sql query problem with a case statement

[strong]This code works: SELECT     passengers.*, passship.passship_name AS name, passship.passship_speed AS speed, passship.passship_size AS cargo, hyperjump.hops AS hops, ROUND((passengers.pass_engers * passengers.pass_price) / (hyperjump.hops * passship.passship_speed), 0) AS ptprofit...