Database Tag Directory

Browse Alphabetically:

Featured Database Questions

  • 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:
  • We’re looking to add a field description in a DB2/400 file

    My partner and I have a set of files on an AS/400 system but we don't have DDS for (the files were created in SQL). We would like to add field descriptions but we're struggling to find how to do this in AS/400.Could someone tell me how we can add a field description? Is directly updating...

    ITKE440,595 pointsBadges:
  • Record format in DB2/400

    How to check file name using record format in DB2/400?

    vishwaraj60 pointsBadges:
  • How to become an Oracle DBA

    I am a fresher and graduated in electrical and electronics engineering but I want to settle in the IT industry. What skills I need to develop to become an Oracle DBA? Thanks!

    tomcatafroz5 pointsBadges:
  • FoxPro 2.6 DBFS Security

    in my absence others open my dbfs (eg sales.dbf) in my computer. How to lock the dbfs and how to unlock it for my use.

    Mrvsp5 pointsBadges:
  • Difference between logical join file vs. view

    What is the difference between a Logical Join file and a view in DB2/400?

    RBauer92525 pointsBadges:
  • DBF to FDF

    I am wondering if anyone can help me out with converting a DBF file to FDF to be imported into a PDF document. OR a direct way to import DBF into a PDF?

    Drokkenian25 pointsBadges:
  • What should I do to regain access to dbf files?

    I have some database files. Title .dbf damaged. I think that my files are damaged or do not you? What should I do to regain access?

    gualuska10 pointsBadges:
  • [SQL0029] INTO clause missing from embedded statement.

    HI, I have written lots of RPG/ILE & CL & COBOL programs in iSeries. I never worked on procedures & UDF. Now I'm learning these. I'm trying to create a procedure. This is the code. It's compiled without any errors. While running I got the below error. CREATE FUNCTION SUS.REWT(p_value...

    HABBIE895 pointsBadges:
  • How can I become a DBA?

    I'm in a 2nd year CS engineering student and want to be a DBA. How shall I proceed?

    HritikaMehta5 pointsBadges:
  • How do I open a .DBF file to a tab in my worksheet?

    I need a macro that will open a .DBF file to a tab in my worksheet. Is this possible? If so, can you show me the code needed and if not would you have any alternative suggestions? Thank you

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