Database Tag Directory

Browse Alphabetically:

Featured Database Questions

  • 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:
  • 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:
  • Multiple SQL statements through OLE DB on DB2/400

    We have a third party application built on SharePoint, and we want to use DB2/400 on our System i for the application's backend database. The app uses ADO and OLE DB to query whatever database it links to, and the vendor has it working on a number of different databases, including DB2 on Windows...

    AndyFarrar15 pointsBadges:
  • How Would You Define Database Concepts?

    I am recruiting for a DBA for an ecommerce company and so far every candidate I have submitted to the HM has been rejected as they "do not understand database concepts". Circling round to the rejected candidates they all comment the HM is asking programming questions yet when I ask the HM and...

    tekhunter5 pointsBadges:
  • ASP.NET (web application) using AS/400 database

    Is it advisable to use ASP.NET (web application) using AS/400 database? How does it affect the AS/400 performance?

    imkhikoh5 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 file's name only known is it possible to fetch the Physical files's name on whom it is dependent?   happy new year n best wishes to all Ram

    ten20081,150 pointsBadges:
  • Need some help with queries in DB2

    Members on our team have a massive database that's housed in DB2 for i server that they are accessing through SQL Explorer. But the tables aren't very well documented and they're trying to do a few things with it.Search the entire database that look for tables with a column called "Remarks"Search...

    ITKE346,195 pointsBadges:
  • Looking to add a column to DB2/400 table

    I'm a beginner with AS/400 and I'm wondering if there's an SQL command on AS/400 to add a column to a table in a specific ordinal position (or moving an existing column to a different position)? Pointing me in the right direction would be great. Thanks!

    ITKE346,195 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...

    ITKE346,195 pointsBadges:
  • How do I update rows in DB2?

    How do I update rows in DB2. When I used SQL, I was able to go forward with this: update top (100) table1 set field1 = 1 This doesn't work in DB2. Any suggestions on what I should do instead?

    ITKE346,195 pointsBadges:
  • Sort process in COBOL/400

    Hi Group,I am trying to understand the significance of sorting in COBOL/400.Sorting is used for arranging records into a specific sequence so that sequential processing can be performed. But, for arranging records in a particular order I can as well create a logical file and process it; Why should...

    mvrkrishna555 pointsBadges:
  • LDA in COBOL/400.

    Hi Group,How to access LDA in COBOL/400 program?Regards,MVRK

    mvrkrishna555 pointsBadges:
  • Entering -ve values in PF using STRDFU.

    Hi Group,I created a PF and I need to enter -ve values in one of the field by using STRDFU.the field is defined in the following manner: SALES 5P 0 ALIAS(EP_SALES)Thanks & Regards,Rama Krishna

    mvrkrishna555 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

    As400pgmmer305 pointsBadges:
  • AS/400, RPG, ILE, DB2/400

    Hi Group, Please let me know.... How to analyze the DUMP of RPG in AS/400? What are the steps involved? Thanks & Regards, M

    mvrkrishna555 pointsBadges:
  • Copy a file of 20 million records to another file.

    Hi Group,I need a copy data from a file having 20 million records to another file. What could be best way to achieve this? One way is creating a duplicate object. Is there any other method?Regards,M

    mvrkrishna555 pointsBadges:
  • Query

    Hi Team, I have scenario with me. For that I need to create a query. The scenario is as follows: When My Location And Department is equal in the file I want to Multiply Quantity Column with Cost Column and Add it. Loc Dept Quantity Cost 1 10 10 2 1 10 10 3 1 10 11 5 2 10 10 7 For above example in...

    ankit2002770 pointsBadges:
  • iDB2 connection String permenant solution

    I have a DB2 connection string to our i-Series that works. "DataSource=10.10.10.10;userid=LIVEXML;password=LIVE1;DefaultCollection=DATALIB031;" We have been developing a lot of apps and web services that use this type of connection. My problem is when our i-Series software is upgraded (about every...

    ToddN200011,100 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