Database Tag Directory

Browse Alphabetically:

Featured Database Questions

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

    ITKE406,440 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...

    ToddN200043,050 pointsBadges:
  • 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:

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