• Oracle OLAP degenerate dimension

    Hi, How to declare a dimension as degenerate dimension in oracle Analytic workspace manager(AWM) tool? Is there any other tool to achieve this or any manual process involved? Thanks in advance, Vinay

    VinayOLAP30 pointsBadges:
  • Tables, queries, and database with Visual Basic 6

    hi i am developing a visual basic application with (vb6.0)and have the following questions,1. how will i add a table in my application and then use one column to be getting data from another table. 2. can i make a query in .mdb and then run it in visual basic.how will i do it if its possible, i...

    Ndonye5 pointsBadges:
  • SQL Data Types Conversions

    I'm new to SQL. Anyone have a good example or link of converting from one data type to another. We are converting from an iSeries (AS400) to SQL-based ERP solution and we are having some difficulty with how to get data from numeric fields to date or "numeric" data types. Our iSeries ERP solution...

    MikeBaker5 pointsBadges:
  • How to use Store Procedure for multiple column database update?

    I created a store procedure to update a table based on values from another table using inner join. 15 records need to be updated but when the store procedure is executed no rows are updated bu the return value is 0.

    KjitSingh5 pointsBadges:
  • Database Management Systems

    what are the basic steps in implementing a database management system?

    Twa895 pointsBadges:
  • Small Business Server 2008 backup error message for Shadow Copy Service

    Using SBS 2008 and get the following error when doing a backup "A Volume Shadow Copy Service operation failed. Unknown error (0X800423F4)" The application event log shows event id: 12290 Any suggestions

    123456300 pointsBadges:
  • For 4 columns, I want just one to be “X”

    I want to have one culumn to be "X" like "4" - all the rest can be whatever number aside from "4". How do I do it?

    KC2420 pointsBadges:
  • SQL Server vs Oracle comparison

    what is the difference from sql and oracle in detailed?

    Geta5 pointsBadges:
  • How to create a Microsoft Access form that generates a spreadsheet with parametered values?

    Hello, I have a table that has this type of fields (almost 26,000): Cia Type Account Type Call flag Country Client code related main include China 5765 not related auxiliar not include USA 3372 related auxiliar excepted USA 981 related auxiliar include China 789 In access I need to create a Form...

    Codino10 pointsBadges:
  • How to implement One-to-One and One-to-Many class associations using VB.NET 2005?

    I have designed a solutions for a Student and Employee Management system using Object Oriented concepts and techniques. I'm doing this management system as a Graduate Project. Now I'm stuck in implementing the association relationships. Can anyone help me on this. Answers using code examples would...

    Obhasha0795 pointsBadges:
  • subform

    I have one table and a main form and a subform. All fields for these form are in this table. The subform is called from the main form via a command button. When I go to the main form and go to, say record 3, it displays the correct data, but when I use the command button to open the subform the...

    Donb5225 pointsBadges:
  • Mainframe batch DB2 table I-O monitoring

    Dear Sir or Madam: I can examine the excp counts for flat, VSAM, IMS files in the JCL batch JES JOB Log statistics, both while executing & when job has completed. How do you monitor that I/O for DB2 tables? Thank you, Michael Piccolo

    Pic40 pointsBadges:
  • Large DB, low capacity line, resync log-shipping options.

    Hello, We've a large SQL2000 DB which is 335GBs in size and a majority of tables are geographically replicated to a subscriber using transactional replication across a 10Mbit line. We're going through the process of converting the DBs' environment to SQL 2005. Unforetunately I think this means...

    SuperCoolMoss140 pointsBadges:
  • How can i make only one administrator to accsess database through C# application,and without registering this administrator in atable in the database?

    How can i make only one administrator to accsess database through C# application,and without registering this administrator in atable in the database?

    Hanafy5 pointsBadges:
  • SQL query to list databases that have a given table

    Hi all I need your help for creating some SQL query that returns the names of all databases that have a given table name. Ex. I'd like to run this query against the master database and search for all databases that have a table called "customers". Is it possible to do this, if yes how? Thanks in...

    alessandro.panzetta9,725 pointsBadges:
  • Database Access 2007

    Hi, I have created a database and created a query with some fields from my main table. Now I would like to add more fields but I can't any hint? When I go into my design mode those new fields do not apper?

    Ld23315 pointsBadges:
  • what is the max length for an sql cursor name?

    what is the max length for an embeded sql cursor name in RPG?

    TheMarkWTaylor5 pointsBadges:
  • Access Form Question

    Hi, I've studied Access for a couple years and can't seem to wrap my brain around the following: if a form and subform that has fields from multiple joined tables, how do you link the form with the subform so that the subform references the right record? I know the primary key of the parent table...

    Dataempress115 pointsBadges:
  • Reading an unknown file in RPG

    Hi All, I am working on a DBU like utility which will provide a maintainance screen for each file. I need to read the file in an rpg program but i dont know the program name till runtime. I can't declare the file in F specs as i dont know the file name. SQL is very bothering and is very heavy for...

    Detuli15 pointsBadges:
  • Oracle OLAP degenerate dimension

    HI, HI, Say, I want to create a data mart for sales Dimension: region,products Degenerate dimension: Order Number Measures: price,quantity Qyery: cross product A region B show order numbers where total quantity sold is more than 100000 How to achive this Oracle(11g) AWM or any other tool? How can I...

    VinayOLAP30 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following