• MySQL: Reduce size of ibdata

    We have several production servers that have IBDATA files. These files are increasing daily. Actually, it's almost taken up 300 GB in space. The tables in the servers are InnoDB (most are read and write requests). Also, log file size is going up too. So basically, data continues to rise. Is there a...

    ITKE392,135 pointsBadges:
  • Using two same files from different libraries in a RPGLE program.

    Hi All, Please guide me for the following problem. I got stuck into it. I want to operate same file from two different libraries in a RPGLE program. Remember we are taking the file names at runtime. So we don?t know the structure of files. Like the record format name etc. Again somehow I retrieve...

    navinnegi45 pointsBadges:
  • What is arc viewing in databases?

    How does arc viewing connect to sampling points in data bases?

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

    ITKE392,135 pointsBadges:
  • Record format in DB2/400

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

    vishwaraj60 pointsBadges:
  • DB2 to Text File Conversion and Transfer

    I have created a Text File from my AS/400 DB2 table. I want to transfer this file from one iSeries system to another. How to do this?

    gvdsswami20 pointsBadges:
  • Reading a file twice in CL

    I declared a file in CL. I read all the records, i.e End Of File has reached. Now again i want to read he file from beginning within the same program.I tried with OVRDBF and POSDBF.But could not succeed.Can any body help me?

    Kumari0 pointsBadges:
  • Many to one relationship in Microsoft Access query

    I have the following tables: ISSUEREASONS(issueID, issueReason = "PNR Change"), Issues(issueID, partNumber), Parts(PartNumber, DDSID), PNR(PNR, DDSID, PNRChangeReason="PNR Change") where there is mostly all one to one relationships besides there is multiple PNR to DDSID. I need to query for both...

    tabooka15 pointsBadges:
  • Microsoft Access: How to create an entry form for a team event with up to 4 members on each entry form

    I am trying to create an entry form (order form) for a golf event. (There are 5 events per year.) Each event is a team event, involving 4 entrants (members.) So I want the entry form to have the event name once, but each of the four members' names on the entry form. I am having great difficulty...

    janeyr5 pointsBadges:
  • How do insert many images (BLOB) into a SQL Server table

    How do I insert several images (BLOB) in to a SQL Server table?

    cjohnNewVIc5 pointsBadges:
  • Advantages of database system over file systems

    What are the advantages of database system over file systems?

    Michael Tidmarsh45,225 pointsBadges:
  • Microsoft Access 2016 MSO – How to save data to Table A

    I don't know if the table has to be attached to the form to copy to the table and do I have to click save or does each record save when I reach the end of the row

    dannyboy14145 pointsBadges:
  • How to install Apache with MySQL and PHP on Linux CentOS?

    Hello, How can I install Apache with MySQL and PHP on Linux CentOS? Thank you!

    isophiawilson155 pointsBadges:
  • Open IT Forum: Tell us your must-read IT blog or Twitter feed & earn 50 knowledge points!

    We're always looking for great resources to share with the community, so here's your chance to share what's in your own bag of tricks! Share your favorite IT blogs or Twitter personalities, what they write about, or a link to a post that taught you something you'll never forget. Don't have a...

    MelanieYarbrough6,345 pointsBadges:
  • How to control AS/400 user profile from updating database?

    There are several user profiles created in our AS/400 server. I need to control some of specific set of user profiles from updating database. Is there any option to achieve this request? Example: Consider Profile1 and Profile2 created in AS/400 server. Profile1 should not have access to update the...

    ganeshpavi75 pointsBadges:
  • What test strategy can we use to test procedure and packages in two different databases

    Scenarios: Some code changes have happened to packages and procedure Here few table\views are replaced .by other table\view. They kept the old packages\proc in one database and modified packages\proc are moved to some other database. Here my question is which kind of testing QA team can perform?

    ramukl5 pointsBadges:
  • DBMS software for knowledge management

    What DBMS software would be recommendable for knowledge management for bureau of agriculture to manage the data for their irrigation projects.

    JalalJebelli5 pointsBadges:
  • Is DBMS_OUTPUT.PUT_LINE works in DB2 tool such as DBvisualizer instead of only in db2Command Line Processor?

    I ant to print output of stored procedure using dbms_output.put_line. I am using DBvisualizer tool.

    rockstar185 pointsBadges:
  • Informix SQL Update using an inner join

    I have a need to update 270,000 records with a particular flag. Using temporary tables and multiple update queries I have creating a staging table to put the original value and the new value. So the table structure is like this: ID ORIG_VALUE NEW_VALUE 1223 A B 1234 D A 1334 ... I'm struggling with...

    bloucks5 pointsBadges:
  • Migrate data from MySQL to SQL Server

    Hi all SQL Server experts, I'm new to SQL Server. Can you please help me out from I want to migrate data from MySQL to MS SQL. What steps do I need to follow? Can you please tell me in step-by-step? Thanks in advance.

    nasarbabu30 pointsBadges:

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