• I’m not able to use hints in my tables

    I'm not able to use hints in my tables. TOAD is treating it as comment I think. Do I need to do some setting.????

    Vikas5 pointsBadges:
  • Hyperion Business Rules Error with XP

    We have recently gone on to XP and now we cannot connect to the Hyperion Business Rules designer. The error message is: You are unable to login to the server. com.ms.com.ComError: oracle/jdbc/driver/OracleDriver

    Karzmo5 pointsBadges:
  • Oracle 9i how to create dictionary managed tablespace

    Hi, How can i create database with SYSTEM as dictionary-managed in Oracle 9i?. DBCA creates by default a database with locally managed system tablespace. How can i change it? Thanks in advance.

    Pinki5 pointsBadges:
  • DDS or SQL

    We have an existing COBOL application using files defined in DDS format. We are considering to move from DDS to DDL for future development. What is the best strategy to take this approach?

    Uiiuo50 pointsBadges:
  • Binary Field

    How do I populate a binary field (field length of 9), buffer length of 4, with the value 10002- (right justified) I need to do this in an existing RPG ILE program. Help ?

    Piano510 pointsBadges:
  • HOW TO INCLUDE LOG IN INFORMATION IN AN SQL SCRIPT

    Please I have an SQL update statement which I want to put in an SQL script which users can run to update an oracle9i database running on a windows 2003 server.The statement is as follows: update jobs set JOBSTATE = 3 where APPID = 5 ; COMMIT; Exit I do not want users to be opening the script and be...

    IdongesitDaniel5 pointsBadges:
  • Lotus Notes and AS400 (DB2)

    I have a form in Notes where a user enters a reference number. When the user clicks the submit button I want to Validate their reference number against a table on our AS400. I am able to do this with an ODBC connection on my workstation but... MANAGEMNT does not want users to have any type of...

    Shooby15 pointsBadges:
  • Need your help with sql joins

    Hi there, I have two tables named articles and writers. articles table looks like this : article_id writer_id translator_id article_text writers table looks like this: id writer_name date_joined A few of the articles could be translated but mostly self written articles. The writer_id and...

    Oorsolli5 pointsBadges:
  • MS Access – Count of parent table items in a report

    I have an MS Access database with a parent table and a child table. Table A (the parent, an Order table) has a PartID field, an OrderDate field, and an CustomerID field. Table B (the child, Parts) has a PartID primary key field and a PartDescription field. A relationship joins the 2 tables on the...

    LegacyDave5 pointsBadges:
  • How to use subselect in a case statement

    Getting error... "Token EXISTS was not valid...." on case statement... ,case when g.GFGSTS = '2' and not exists (select a.GFTSEQ from GFTP010 a where a.GFCSQ# = g.GFCSQ# and a.GFGSTS = '3' ) then count(*) end as Void#

    Qpgmr5 pointsBadges:
  • File sort using qshell (this time with tags)

    Hi, I'm trying to use qshell to do a sort of a (non-keyed) DB2 database file to remove duplicate records. I use the following command :- sort -u /QSYS.LIB/$1.LIB/$2.FILE/$3.MBR | cat > /QSYS.LIB/$1.LIB/$2.FILE/$3.MBR Where $1 = Library name, $2 = File name, $3 = Member name. The command does a...

    Gilly40023,730 pointsBadges:
  • Access 2007 refrence look up

    Ok this question might sound kind of elementary but i just seem to be missing something. I have a drop down box, within that combo box i want to display choices which consist of 3 cap letters then a "-" Then what the letters stand for. when i choose a selection from the combo box i want it to...

    IT-Guy1509210 pointsBadges:
  • design a web database application

    i want to design a web database application to compile undergraduates results using php and MySql. can i get a worked example?

    Apeh0 pointsBadges:
  • programming for PHP and MySQL

    how do i get my login page to direct a user to an appropriate page depending on user username, password and domain previlidges from a database. am using php and mysql

    jed045 pointsBadges:
  • Linksys wireless-n router with VPN

    Linksys says that I cannot access the wireless Access Point

    Miguelwpratt5 pointsBadges:
  • oracle calculated item

    hi ihave alist of variables some of them calculated from others i recieved them from certain source in certain date and i have alist of indicatores which are calculated from the variables (for the same date,& source) but every indicator has diffrent equation & the user need to modify the equation f...

    Rosealzubi115 pointsBadges:
  • messaging and collaboration

    What is messaging and collaboration,how does it works,how to set it up ,where can it be implemented and how

    Eduado0 pointsBadges:
  • export oracle 8i database from unixserver

    I have oracle 8i database on unixserver. How i able to export the entire database or schema to windows Xp. plz suggest

    Smmd5 pointsBadges:
  • Access help

    I have a 10 digit predetermined ID number. What I want to do is when a new number (the number referred to above) is added to the database, information based on this number will appear. The producer is based on the first three digits, the owner is based on the first three and the last two, and so...

    Dabbsa5 pointsBadges:
  • Mainframe sunset

    Our user departments have been talking about getting off the mainframe over the last several years. Recently, our CIO informed department heads that we would discontinue the mainframe by the end of 2007. It is possible that these departments could decide, "we really didn?t mean it" and push back,...

    BlueKnight10 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