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

    ITKE436,030 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:
  • 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:
  • Access Database table validation

    Access database table validation: Set these validation the transaction type is limited to cash or credit card. How can I do that?

    onetimejibb25 pointsBadges:
  • Check if a column exists in SQL Server database

    In a SQL Server database, is there a way to check if a column exists in a table? This is what I came up with but it keeps returning false: IF EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'myTableName' AND COLUMN_NAME = 'myColumnName') Thanks!

    ITKE436,030 pointsBadges:
  • SQL Server 2008 R2 database isolation change

    I want to change my database isolation to read uncommitted in SQL server 2008 R2. Can someone tell me the exact process and how should I can achieve this?

    edwinjhoffer3,365 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.

Thanks! We'll email you when relevant content is added and updated.

Following