Database Tag Directory

Browse Alphabetically:

Featured Database Questions

  • Tuning DB2/400 queries on iSeries

    We are using lot of DB2/400 queries in our iSeries system. Are there any tools available on the market to tune them?

    AS400 - Ask the Expert485 pointsBadges:
  • Where to learn Oracle 9i

    I want to learn the Oracle 9i for get the job of DBA. For that, what website do I have to go to?

    Kaninfoway15 pointsBadges:
  • Logical files – V5R4

    Hi, we all know DSPDBR command on a PF will fetch all the dependent logical files. Can anybody tell me with a logical files name only known is it possible to fetch the Physical files name on whom it is dependent? Happy New Year and best wishes to all! Ram

    ten20081,150 pointsBadges:
  • What’s the difference between DB and DBA sounds?

    Can anyone tell me what is the difference between DB and DBA sounds?

    mohammadosamaa71615 pointsBadges:
  • DB2/400 to Oracle 10g

    I like to migrate a database which is in IBM DB2 /400 V5R3MO supported by windows platform (Source)using iseries navigator to Oracle 10g.In the source database there are few stored procedures and few triggers which I like to migrate from source to oracle too. So I like to know is Oracle migration...

    792755 pointsBadges:
  • What type of IT 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:
  • How do I copy a table from one database instance to another database instance?

    How do I copy a table from one database instance to another database instance?

    Lakshmimadhuri5 pointsBadges:
  • AS/400 ODBC

    Hi Our company uses AS/400 for our financial processing application. The users access the AS/400 through an emulator. They also access the application database through ODBC. They extract the data to excel sheets to create certain reports for their own purpose. Recently, one the data base files in...

    Pgsdeb20 pointsBadges:
  • How to find indicator and relative record number fields in DB2/400

    In DB2/400, even after we delete record from file, the record exists until we are done with RGZPFM. The deleted record can be identified by a indication field with value "Y" or "N". How to see this indicator field? How to see the DB2/400 RRN (Relative record number) field? I tried with RUNQRY...

    BibinGeorge130 pointsBadges:
  • Corrupt .dbf files

    Dear Sir/Madam, I am using a software bases on Clipper, i made all the entries and then I indexed. The program stopped working and closed. Since then I'm unable to retrieve the latest data from the .dbf files. Thanking you in advance.

    pliv8315 pointsBadges:
  • External DB2 Database link/trigger

    In Oracle I can register a database link to other data sources. For example, through ODBC I have registered DB2 as a database link. In this way I can read/insert/update from/into DB2 tables.

    r.otto810 pointsBadges:
  • Connect DBF by VB.NET

    How can I connect DBF By VB.NET?

    Pongkgkkk5 pointsBadges:
  • Convert AS/400 file to Excel and PDF

    I would like to transfer a PF data into Excel but my add-ins not working. Can you provide me any other ways to do that?

    As400programm10 pointsBadges:
  • How can I view the contents of a damaged DBF file?

    I want to view the contents of a dbf file but one column appears with "strange characters". It seems to be locked or encoded or encrypted. I can see the other columns with no problem. The problem exists only in one column. Is it possible to "unlock or decode or..." and view the contents of that...

    artuaslella5 pointsBadges:
  • Converting from RPGLE to DB2/400 SQL

    My shop just announced that it intends to convert from RPGLE on the ISeries 400 platform, to SQL, such that the procedures will be portable to other hardware platforms. What documentation to I need to acquire to train on writing SQL procedures; initially within DB2/400?

    SeaRancher5 pointsBadges:
  • Converting Data in Excel to PF on DB2/400

    Hi All, I have data in the excel where each column equal to the field of a physical file. I want load this data into the PF on AS/400. Could any one let me know the process on how to do it. Thanks in advance

    rajsubhyd105 pointsBadges:
  • Trigger for DB2 user administration

    Hi guys, I want to create trigger to avoid users updating records or when he update that data want to write one log file with his Login ID, time, date etc. Please help me. If these is possible using trigger then please tell me how? Thanks Amar

    Meetamar15855 pointsBadges:
  • Set up DB2 Web Query dashboard

    I would like to be able to set up a dashboard on a particular managers desktop, and demonstrate the features of DB2 Web Query. Does anyone know of a good web site that I could go to, that would show me how to do this? Alternatively, are there any books on the market that someone would recommend?

    Piano520 pointsBadges:
  • Add to Excel spreadsheet from System i

    I want to add data from a DB2 file to an Excel template that has a header row and totals certain columns without overwriting the header row or the totals.

    ljjk1225 pointsBadges:
  • How to recover my Oracle database in DBF?

    Hi everybody, I'm getting the following error on starting Oracle database through the enterprise manager console: ORA-01122: Database file 2 failed verification check ORA-01110: Datafile 2 'D:\oracle\oradata\new1\undotbs01.dbf' ORA-01200: Actual file size of 72733 is smaller than correct size of...

    OugustChshrien5 pointsBadges:

Browse Alphabetically:

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