Database Tag Directory

Browse Alphabetically:

Featured Database Questions

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

    ITKE409,090 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:
  • 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:
  • 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 to open dbf file?

    I am trying to load DBF files into SQL server within CLR (actually if just running the select statement outside, say within the SQLQuery window, i got the same result), but with the following error: Msg 7314, Level 16, State 1, Line 1 The OLE DB provider "VFPOLEDB" for linked server "MYDBF" does...

    eskilddam5 pointsBadges:
  • Should I learn DBA for my career?

    I have completed graduation in 2014. Then after did a networking course in hyderabad. I'm currently working as Help desk engineer. I want to learn DBA now to change my domain. Is it a right decision or not? Please suggest.

    achanderg375 pointsBadges:
  • iDB2 connection lifetime fails

    I'm getting an error on my connection string. The error says The connectiong property is invalid.  It also says it must be IsGeneric. Not sure what I'm missing and I'v searched IBM's site.. It was not much help.  The reason I want to put a lifetime on connection is to prevent object locks. I can...

    ToddN200045,545 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