• good PL/SQL user guide

    I am interested in a good reference guild for PL/SQL which explain all utilitity commands and configuration patterns and files. Your help is much appreciated.

    Hfeshari0 pointsBadges:
  • Database connectivity with c++

    How to connect backend(database to C++(front end) ?

    Mkaaa15 pointsBadges:
  • Whats a good tool/software to import (excel, csv) into IBM DB2

    Whats a good tool/software to import (excel, csv) into IBM DB2? Would be great if this tool/software is free or doesn't costs to much. thanks

    Geyes15 pointsBadges:
  • V8 CMP EDM Pool

    Strobe shows very high CPU in Module DSNGEDM Sections DSNGECMP & DSNGEPUF (which free expanded EDM Pool Storage) for dynamic SQL in a CICS Region. Is this an EDM Pool sizing issue?

    Winger19515 pointsBadges:
  • Dynamic sql with delete and commit

    Hi, I need to delete rows from different db2 tables in COBOL with commit in between after some 100 or 200 rows. Is there any away I can restrict my delete statement for some particular rows as in Select for fetch first 100 rows only. The values of table names will be known only during the execution...

    Sramki0 pointsBadges:
  • Unloading specific records in a foreign key, cascade format.

    Hi, We have DB2 version 8, os/390. I know how to use QMF and JCL. I would like to unload, to files, specific records that I would enter, by the key, in a where clause. The record would then cascade down to unload ALL tables, with a specified TBCREATOR name based on foreign keys. I would like the...

    Donnaw5 pointsBadges:
  • Selecting an area within security to start

    Hi, I'm studying for an MSc in Information Security from Royal Holloway University of London, I have a B.Engg. degree in computers and a PG Diploma in Networking and Communication as well as the CCSA and CCNA. I'm also studying for the CISSP. Now, with all these qualifications, could you please...

    Secmax0 pointsBadges:
  • ‘You are not authorized to access that database’ error message for Lotus Notes user

    I have a Lotus Notes user who keeps receiving the error message: "You are not authorized to access that database." when working with his local copy of his email file. To my knowledge, he is not using a different ID file. The first two times this happened, we deleted the local copy of his email file...

    Domino Ask The Experts435 pointsBadges:
  • Report -Conditional Format with multiple conditions: Access 2007

    I am trying to generate a report that will change the font to different color if of a date field but the total number of days will change if another field = ?. So basically if [TYPE] = CHILD then DATE()-30= (red font), and DATE()-31 BETWEEN DATE()- 60= (yellow font) and DATE()-61 BETWEEN DATE()-...

    Nichalos825 pointsBadges:
  • Microsoft Access and Oracle

    Can tables created in Access or Excel be imported into Oracle?

    Micheline foxxe10 pointsBadges:
  • what type of degree/training do you need.

    I am currently looking to get into becoming a DBA. Unfortunately even after many weeks of researching I cant find many clear answers to what I want to accomplish. I am looking to start out with a 2 year degree somewhere grab a few certifications that will greatly increase my job hunting, and...

    Mh865 pointsBadges:
  • Are the data warehousing,data-mining and document warehousing under the Database Management System?

    Are the data warehousing,data-mining and document warehousing under the Database Management System?

    Hanzter5 pointsBadges:
  • ,temporary files, on win02/03 servers in access(.ldb files) and excel are not deleting when applications are closed

    can someone provide a possible solution

    Wildbull5 pointsBadges:
  • URL link in PHP/MySQL script

    I am adding a URL within a table with PHP and a MySQL Database, my string doesn't show all of the URL, it cuts it off.

    Jviney35 pointsBadges:
  • Moving data from iSeries to DB2 on Windows

    I need to get data from a iSeries DB2 system to my Windows DB2 system. The DBA produced and sent me a savf file. How can I important that savf file into DB2?

    Claudek75 pointsBadges:
  • Syntax to reference a table on a database residing on another server

    I have the following insert statement: insert into Resident(Identifier_Type,Identifier,Full_Name,Dob,DL_Number,DL_State,Change_User,Change_Date,Change_PropID) select N'SS',Social,Full_Name,DOB,DL_Number,N'TX',Change_User,Change_Date,Change_PropID from N'haa-sql1.imisTest.dbo.Resident' I'm getting...

    MParkhouse5 pointsBadges:
  • Table size in SQL Sever 2000

    Please, I need a script to know the size of every tables in my DB. I found that my database is growing above what I expected,and I need to know the size of its tables.

    Yunior5 pointsBadges:
  • Stopping transactional replication from skipping a block of records

    Have you ever run into an instance in SQL 2005 where transactional replication is skipping a specific block of records? I have tried many troubleshooting techniques: dropped/created sub and pub, created new empty destination table, reinitialized and several others. New transactions come across just...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Convert OO Base to MSA

    Is there a way to convert an existing Open Office Base database to MS Access?

    Naomih15 pointsBadges:
  • Finding the appropriate settings for copying tables within databases

    I have a table in a database that has 104456 records. I would like to copy the data to another table within that database. When I execute the command “insert into ChangeInsuranceTxnHistory select * from ChangeInsuranceTxn”, the following error occurs: "Could not allocate space for object...

    SQL Server Ask the Experts2,585 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