Database Tag Directory

Browse Alphabetically:

Featured Database Questions

  • DB2/400: List of primary and foreign keys within schema

    How can I get a list of primary and foreign keys within schema in DB2/400?

    peterlk5 pointsBadges:
  • Certification sites for Synon?

    Hello, Please can anyone suggest some good certification sites or courses for Synon or DB2 400. Except the ones from IBM. Synon is more broadly needed!!

    Jammypune5 pointsBadges:
  • AS/400 – DB2/400 PF and LF have different identifiers for Synon

    Hi, AS/400 -DB2/400--> PF and LF have different identifiers for files generated in Synon. But for the Manually created files PF and LF have same file level identifiers. Please let me know why it goes like this. Any idea? Looking answer for this. Thanks P.Amutha

    As400pgmmer310 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:
  • Which is the best among DBA and CCNA for career in all aspects

    Hi all, presently I have one year of experience in the networking field. I want change my domain to DBA. Now I'm confused whether to continue with CCNA or to change to DBA. Please, can anyone suggest to me which will be the best for my career in all aspects? Please help me out

    Vedantham5 pointsBadges:
  • Oracle: Create database link to DBA tables

    In Oracle, can I create a database link to access several DBA tables from another user? I have to backup a table (in another tablespace) but I can't access it.

    ITKE1,015,970 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:
  • DBF corrupted database in Visual FoxPro

    Hey friends, I'm in great trouble here.I'm using Microsoft Visual FoxPro 9.0 on my Windows 7 machine. I had some DBF files which was created in MS Visual FoxPro. The files were undoubtedly valuable since they contained my crucial data related to my office work. The files are now invalidtherefore,...

    edward24dalton5 pointsBadges:
  • Changing career track for a DBA

    Hello, I am working in IT from last 6 years as an Oracle DBA. I worked in few small companies in my home town (home town is not a Oracle technology hub) to gain the experience as DBA and after I moved to metro and joined a big company as DBA. But due to some unavoidable family conditions I came...

    PranavPareek5 pointsBadges:
  • How to convert CSV file into DBF file

    Would I be able to convert my CSV file into a DBF file using Python? Perhaps a script would work for this? Thanks so much.

    ITKE1,015,970 pointsBadges:
  • Procedure to send reminder emails

    I tried executing the below script as procedure, but it throws error as in "PL/SQL: ORA-00942: table or view does not exist". This error is coming on line where I am using dba_users table along with a table in which I have stored the email_addresses. For e.g :- CURSOR c1 IS SELECT...

    sunshine125 pointsBadges:
  • Technical Support Team: Is this the Proper Name for our workgroup?

    I manage a 5 person team that has responsibilities in the following areas: Member Support handles all client contacts concerning errors/how-to/data issues with our applications and website. There are two Level 1 resources, two Level 2, and I am the Level 3 escalation point. We are either Leads,...

    MLee3D15 pointsBadges:
  • Any Certification for Mainframe Domain

    hi, i am mainframe domain in an IT Comany, i worked on COBOL, db2 ..etc can any one tell me, is there any certification for this specific domain?

    1768425 pointsBadges:
  • FoxPro 2.6 .DBF file lost

    My .DBF file is lost and I can see a .DIF file created in my database. How is .DIF file created from a .DBF file?

    urmila5 pointsBadges:
  • dBASE Program Result File

    Created a program to extract certain records from a file. What do I need to put in program to create a new file with the results?

    curley20165 pointsBadges:
  • What is the role of the DBA in the database management system?

    What is the role of the DBA in the database management system?

    NOORMOHD5 pointsBadges:
  • Database Admin…

    Will the real DBA please standup! Is there a forum just for DBAs? I got started in 1995 when a recruiter asked me if I wanted to be a DBA on an AS/400? Was I surprised! However, the shop that hired me did not understand what a DBA on AS/400 really did... nor did I. Well, I ended up doing security,...

    Znason460 pointsBadges:
  • MDX File not automatically linked to DBF

    USUALLY when you create an MDX on a DBF, that MDX will AUTOMATICALLY be used when one uses the DBF. However I am experiencing one DBF that will NOT link to its MDX when the DBF is used. I have to alter my programs to "SET INDEX TO" the MDX followed by "SET ORDER TO" For Example: USE PARAMS ORDER...

    Thanbor5 pointsBadges:
  • Dbase III files exported from Access

    In Access you can export data to a dbase III, dbase IV or dbase V file. However when I do this for a dbase III file and try and open it is dbase III plus software it says it is not a dbase III plus file. How can I open the file in dbase III plus? I could append it as a CSV file but I was hoping the...

    cornisht20 pointsBadges:
  • SQL error message when creating procedure containing three cursors

    I have created a procedure containing 3 cursor. It gives me the below error and when I add @delimiter ++; at start and end it gives message that "command processed" but doesn't show output. Any suggestions? [Error Code: -104, SQL State: 42601] DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601,...

    rockstar185 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.

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

Following