objects table, columns talbe, types table equivalent to Oracle

Please help me to know the equivalent of MS SQL Server 2000 to Oracle:--to get the information about the objects--e.g. CustOrdersOrders stored procedure -- @CustomerID parameter-- nchar typeDECLARE @objectName AS VARCHAR(100)DECLARE @objectID AS INTEGERSET @objectName = 'CustOrdersOrders'SET @object ...

Newbie question - Using the MPCLI command with Service Processors.

For the different types of Service Processors: ISMP, IPMI, ASM, RSA I and RSA II,I have so far, managed to connect only to the RSA processors.Can someone please advise on how to connect to the other types of service processors?We have some servers where the event logs are full and they don't have RS ...

Where do I get PivotTable Service

I have installed SQL Server Enterprise Edition on a win2K server. I have also installed analysis services. I can see the analysis server running as a service but I dont see Pivot Table Service. Is there a separate install for this ? Is there a Pivot Table Services In the first place ? ...

Structured types

Does DB2 EveryPlace supports Structured types (table inheritance) as DB2 UDB does ? ...

Types tables?

I am in the process of re-writing our in-house app.The current structure has about 40 tables that end in "Types", such as RopeTypes, OrderTypes, ShippingTypes, CustomerTypes, etc.My question is, do I keep the structure how is has been with all these tables, or should I create a "Types ...

Access 2000 Table design

While using Access 2000 for a couple of years now, I am still a high-end newbie, low-end intermediate user.I have a question, over attheaccessweb.com they have an article about Never using Lookup Fields and why.I would like to know though, IF you don't use a lookup field, how do you accomplish the t ...

Reference table and insert problem

A couple of question from a newcomer...1) I have created two table in MySQL... one table called "brand_name" has three columns (id, name, type_id) and the other table called "types" has two columns (id, type).How do I make type_id in "brand_name" table to reference onto ...

ActionPerformed no reload of table

HelloThe ActionPerformed will not unload the viewPort to load the new viewPort that holds a table.is there a way to reload the table?The first actionPerformed supplies the table but the next will not remove table and add the new one.package view.content.panels.guide;import java.awt.event.ActionEvent ...

HTML table cell won't stay fixed, css text goes outside bounds

I've got a table on my page with three columns.The first column, I want to be resizeable based on the window size (it's a spacer column to "indent" what's in the other columns.The second column contains text formatted with a CSS p class. I want to be able to set the width of this column so ...

2 challenging SQL questions

HiI need to produce a SQL report and there are two requirement from the company which I have question to complete with. The script can be created by SQL or PL/SQL. It's quite urgent, can someone help me1. Create a table HOUSEKEEPING which can be used to record when each room is cleaned. Cleaning may ...

One to many (duplicates)

I have a query with two tables that ends up with duplicates. I'm not sure how to explain, but one table will have multiple types of service for each account, but the other table only has one line for each account. How can I get the data to display all the data but only leave the duplicate lines with ...

Help designing tables

HiI am new in this forum. Excuse me for my English, but I am learning and for me is very difficult to write in English. As you are supposing I need help in the designing of some tables, perhaps a little orientation. I am working in a project about a group of cities, and development indicators (???) ...

Oracle Create column which is small collection of integers (or strings)

Oracle 9i (10g later), JDK 1.4.2, WebLogic 8.1.4.I'm looking for a way to define a column in Oracle (which I can see through JDBC and Hibernate) that represents a small collection of integers or strings (up to 3 values). I'll need to have a Hibernate query that checks whether a value is IN that coll ...

DB2 and java getTables

Sorry for the Java/DB2 cross post, I wasnt sure who would be best ask.Hi I am having a problem getting db tables from a DB2 mainframe over ODBC (I have to use ODBC).I connect with the below code and write out the table and column names rather than getting the correct table and column names for this ...

Dialer virus (seems to be in Italien)

[TEX]HiJust come back from work and my son has managed to get a virus on our home PC. It pops up every so often as a dialer but after a few failed attempts to dial out it disappears. The error message it comes up with at this point seems to be in Italien I think! Anyway I post my Hijack log below if ...

MySQL Trying to JOIN 2 rows into 1 and sort it.... DETAILED!

Okay.. in the past.. I've been told to post whatever SQL I got... so here it goes I'm trying to make it so that we can have pages like "Suggestions for Home, Suggestions for Business start up, Suggestions for Computers" and they can include both a business type and a business service. I'm ...

foreign key conflict - why?

Getting the following error:INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK_templates_types'. The conflict occurred in database 'coolit', table 'types', column 'id'....when I run this SP:CREATE PROCEDURE template_addnew @tmpXnet int, @tmpName varchar(100), @tmpPDF varchar(150), @t ...

MemberProperties Value OWC10

I'm looking for a solution to get the value of a current member's property in OWC 10 (Pivot Table Service).There are ways to set the caption and create new properties but there seems to be no way o get the value of a property programmatically.I need the value to pass variables over to a custom Drill ...

data modeling tool

Sorry for the commercial, but this really might be of interest to the DB2 community. ModelRight has just released a version of its data modeling tool that includes support for DB2 LUW. It provides in-depth support for DB2 LUW - including many DB2 LUW - specific features like Bufferpools, Database Pa ...

data modeling tool

Sorry for the commercial, but this really might be of interest to the DB2 community. ModelRight has just released a version of its data modeling tool that includes support for DB2 LUW. It provides in-depth support for DB2 LUW - including many DB2 LUW - specific features like Bufferpools, Database Pa ...

Slow loading of internet, Please help!

I've got this problem of internet loading very very slowly. Tried scanning whole computer with Ad-Aware SE (latest definitions) with critical items to removed, which I did.Tried scanning with AVG8, this is wat I've found, Trojan horse Generic9.XKD and many Tracking cookies, path to file are all user ...

MySQL connect 2 tables

ok i have a table that is a equipment service history type thing TABLE `service` ( `ID` int(11) NOT NULL auto_increment, `serial_number` int(11) NOT NULL, `work_performed` text NOT NULL, `date_work_performed` text NOT NULL, `tech_name` text NOT NULL, PRIMARY KEY (`ID`), ) ENGINE=MyISAM and i have on ...

Identity column question

Trying to create a custom dts package that imports data from excel spreadsheet to db. One of the issues is that the columns in the main entity tables are not identity columns. So how do you get the appropriate PK?Well I thought the following would work but it doesn't. Any ideas?Basically trying to u ...

Challenging "products' availability according to attributes" design

(I have placed a TXT attachment in case this message doesn't display correctly)Dear Sirs:In our current project there is a situation related to the attributes available for our products: There are certain conditions they should meet.Please let me explain using the following example.Suppose that our ...

Knowledge Base Database

Im designing a database for information for my company(currently in Access). It will contain all the services thecompnay provides and the contacts for each service essentially a knowledge base. Its mainly to be used in the call centre to know where to place calls.I have a Service table and a contact ...

Database Design Question

Question 1:I have a contacts table which holds different types of contacts. I contact can only have 1 type. I have a contact types table and store the id of the contact type in the contacts table. I also have another table (table 1 for example) that has a 1 to many relationship with a contact. A con ...

Alternative to GROUP_CONCAT

Here is my problem:I have a db of events with categories and locations. A form w/ checkboxes inserts into 2 tables the following:Table 1: event(id, title, date, description, contact)Table 2: event_search (only foreign keys)(event_id,location_id,type_id)2 other tables are listing the locations and th ...

Forming a list from different tables

I have created tables which are something like belowTable: airplanereg_nbr md_name1 Skylane2 Skyhawk3 Citation 4 CaravanTable: serviceservice_nbr reg_nbr date_service11 1 8-JUL-0412 2 14-JUL-0413 3 15-JUL-0414 4 9-OCT-04 15 5 10-JUN-04Table: maintain (person_nbr,service_nbr,reg_nbr are all primary k ...

Symantec Email Proxy!

guys. So I saw some posts on here from years back about people having trouble with this. Basically Symantec Email Proxy keeps popping up saying stuff like "your email message was unable to be sent..." its some kind of trojan or virus. Can anyone help?Here is my Hijack ThisLogfile of Trend ...

MySQL SELECT with GROUP BY

I want to group by the result from two tables together with a count. Please raise questions if anything is unclear and see table CREATE/INSERTS below. 1) I have three tables 2) The table (ticket) only holds ID for the ticket and a reference to a row in either the service table or service_esc table. ...

Offering Free Email to Site Members?

I hope this is the most appropriate forum for this question. I read them all very carefully. Hopefully I chose correctly.I want to give my site members the option to sign up for free Email accounts at mydomain.com. Can anyone recommend a company that offers this service? I'm not looking for hardware ...

Data Organization: 2 Business Cases

So I am constructing a new structure for a business that does international business. The goal is to store country-specific identification numbers (generally gov't related) by user. For example VAT registrations in the EU or Social Security is the US. Governements generally issue IDs for personal us ...

Oracle Expert Connection Issues

I have set up oracle management server for my oracle 9i databases, and it seems to work perfectly now. I have set preferred credentials for each database and I never have a problem connecting to them. However, when I go into Oracle Expert within enterprise manager and attempt to collect info on one ...

Reclaiming "white space" from tables

We are running ORACLE 10g on LINUX, and many of our ORACLE databases are SAP databases.We are experiencing serious space issues as our SAP databases are growing at a much faster rate than was anticipated.Currently I am looking at trying to relieve this pressure for ever increasing space requirements ...

call to DatabaseMetaData.getTables returns an object with garbage inside instead of tables

I'm trying to use DB2 Express-C as a POC for a project where it is the persistance mechanism/data store for Open For Business (Apache open source project) and one of the things that the ofbiz project does is try to retrieve the tables and if they do not exist create them.Well when using the native d ...

How to change Administration Explorer from schema driven view

A coworker recently installed Data Studio and is having trouble configuring it to look the same as all the other developers. Their Administration Explorer displays the unique schema's beneath the database name. Mine displays the database object types (table, index, etc), which is the more traditiona ...

Oracle Select from ALL_SDO_GEOM_METADATA causes swapping

I'm using ORACLE Spatial 8.1.7I have a table SERVICE containing services(points) like hospital,petrol station, restaurants, ...This table contains a column postal_code, where some postal codesare set others are NULL;Another table POSTALDISTRICT contain the shapes of postaldistricts(polygons)and thei ...

Data Stage Command Line Actions

quite often we need to delete from DataStage Projects all or part of the Jobs, Routines, Shared Containers, Stage Types, Table definitions.We do this using the Data Stage Manager GUI. This is quite time consuming. Are there command line commands to do this ?(For importing and compiling we found appr ...

MySQL Help using multiple JOIN's

i have been trying to get this figured out but i just cant do it. I have not done any complex JOIN's for a while.... i have 5 tables: -appointments -companies -companytypes -contacts -contacttypes in the table `appointments` i have 4 fields that hold ID's that link to `companies` and `contacts`. `co ...

DB2 and Java getTables problem

Sorry for the DB2/Java cross post, I was not sure who could best answer my question)Hi I am having a problem getting db tables from a DB2 mainframe over ODBC (I have to use ODBC).I connect with the below code and write out the table and column names rather than getting the correct table and column n ...

Undefined index error

I'm trying to build a CMS with PHP and MySQL. I'm at the testing stage but I'm getting the following error when I try to use the supplier form to enter data into my tables (I also get a similar error when trying to enter data into the garment_types form):Notice: Undefined index: supplier in /Applica ...

ListBox Properties

Okay - so here's the newbie at it again!When I wrote my program in Access... it was very easy to link my ListBox to the table/query in my database, because everything was relative to the database already open.So, I've got issues trying to get this to work with just VB.I have the form setting DB as D ...

How to get Column Name as a Commandlink

/*i created one database using access which is having tables product,orders,orderdetails.As soon as page is loaded i will display the all tables in combobox.And as soon as i selected table name the correspon table should be displayed on the page.But to implement further for sorting i need that colum ...

Cascading delete

I can't figure out how to specify an 'on delete cascade'. Here are my table defs. As is, I can not delete a record from the categories table because I get an error message 'The record cannot be deleted or changed because table 'Types' includes related records.' My intention is for the records in the ...

C/C++ SQLColAttribute () Returns 0 for SQL_DESC_LENGTH attribute with MySQL ODBC 3.51.23

Following is the code snippet: //-------------------------------------------------------------------------- SQLHANDLE m_hEnv; SQLHANDLE m_hDbc ; SQLHANDLE m_hStmt; SQLRETURN r; m_hEnv = SQL_NULL_HENV; SQLRETURN r = SQLAllocHandle(SQL_HANDLE_ENV,SQL_NULL_HANDLE,&m_hEnv); r= SQLSetEnvAttr(m_hEnv, ...

DB design question

I was designed a database for our datacenter to keep track of the servers. I have designed four tables equipment, support pack, software and service level.Here is my scenario.1. Each of the equipment here could be a router, switch, a server or storage device.2. Depending on the OS, some of the softw ...

Aggregates and Performance

Anybody have a rule of thumb for balance between using aggregates and optimizing performance (i.e. number of rows, traffic levels, types of aggregates/queries, etc.)? I've had previous apps hit the wall with aggregate queries called 1+ times a seconds on tables with 10k-100k's of records.I'm debatin ...

LEFT join problem...

I have 4 tables, each defined as:CREATE TABLE service_data_text (data text NOT NULL,service_field int UNSIGNED NOT NULL,id int UNSIGNED NOT NULL,rid bigint UNSIGNED NOT NULL AUTO_INCREMENT,PRIMARY KEY (rid));The only difference between the tables is the datatype of the 'data' field (it varies from i ...

MySQL Insert Trigger

I got a little problem (my english is not so good, sorry) I want to write a Trigger for the table service_customer_user. On Insert the Trigger have to take the new values and search for a definition on the table service and write this definition to another table customer_user. Ok, now more Details: ...

MySQL How to pass a comma delimited list to SP for IN condition

I've got a SP that will accept a single value string passed for use in a SP SQL statement where LIKE condition. I want to change the LIKE to IN and pass a comma delimited string of values and can't figure out how to make it work. Can anyone help. If the answer is using prepared statements can you pr ...