• Setting run priority on prestart jobs

    We have several applications that query the iSeries through ODBC, so they all use the prestart job QZDAINIT. Is there a way to change the run priority on these jobs so that one application's queries can have a higher priority than another application's queries? Since each application's queries...

    GaryF60 pointsBadges:
  • Access Database – Colorize one word or letter

    How do I colorize one character in a field in a table? I want the letter "O" to be in red for one customer and blue for another customer in the same column but different rows.

    BethG5 pointsBadges:
  • Database connectivity using ActiveX control

    Provide a sample code to how by using VB 6.0 connectivity can be done by ActiveX(ADO) Control tool with the database SQL Server 2000

    Reena10 pointsBadges:
  • Database connectivity using Data Control

    Provide a sample code to how by using VB 6.0 connectivity can be done by Daat Control tool with the database SQL Server 2000

    Reena10 pointsBadges:
  • Correct Isolation level for SQL2005 Subscriber.

    Hello, I'm specifying a SQL 2005 Enterprise back-end to an OLTP application which has one main DB (200GB, could grow to 600GB), a subset of which will be replicated to a separate subscriber for running read-only queries. Here's the spec, any comments appreciated, especially around the use of read...

    SuperCoolMoss140 pointsBadges:
  • What are the drawbacks of these two techniques of Change Data Capture?

    Hi can anyone tell me the draw backs of these two techniques of change data capture? 1: Table Differencing 2: Change-Value Selection

    Mahr5 pointsBadges:
  • Microsoft Access 2007 Query/Report Calculated Fields

    I have a table with customer estimates and sales. I need a report to reflect the closure rate by total number of jobs within a given section (in this example subdivided by lead source). Each job can have multiple records. I need to get the % based on grouping estimates for specific jobs. (7...

    Reici10 pointsBadges:
  • Replace an Exsisting Table

    I want to make a Table in Access. I figured this out but how do I overwrite this table because obviously I don't want to make new tables again and again. Right now i have just implemented a simple table. Any help would be help. Thanks

    ProgrammingGal30 pointsBadges:
  • Minimize results in form.

    I am trying to create an issue tracker for my company. The problem is that I have many contacts for each customer(Each contact will have their own record in the "customer" table). What I would like to be able to do is when I enter a new issue, I will select my customer from a drop down box that is...

    Jvaniman15 pointsBadges:
  • Creating a query in MS Access 2003 that converts text data to numeric from a table that has links to it.

    Creating a query in MS Access 2003 that converts text data to numeric from a table that has links to it. I have an idea on how to convert the text data to numeric. The problem is that I want to take text data from one table then temporarily create another table where the converted data will be...

    SacramentoSil25 pointsBadges:
  • MS Access 2003 replacing a text string in a table with a specific number

    I am using MS Access 2003. I have two text strings, "no avail" and "not available", and empty data boxes in a table. I need to replace the "no avail" and "not available" strings with the number "-5" and the empty data boxes with "-1". Is there a way to do this in a table or a query? Also, the table...

    SacramentoSil25 pointsBadges:
  • Checkboxes with INSERT and DELETE actions

    I'm fairly novice with Access, though I know how to program in a variety of languages. I need to know how to do something in an MS Access 2003 Form. I have two tables:

    Trobertson5 pointsBadges:
  • AS400

    In DDS, Unique is file level keyword. Is there any specific key word for field level?

    rajeshece1,215 pointsBadges:
  • Indexes and abstracts in SQL Server

    In regards to a SQL Server, what is an index? Also, what is an abstract, and could you please explain the types of both of these items?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Query performance and tuning

    Hi, I wanted know as to what I can do to my query so that it improves in performance.RIght now it it taking 3-4 hrs because of the large no of records in the DB.If i remove the group by and order by clause for the same no of records it is fast but when it does sorting it hangs.But I need to do the...

    Mingley5 pointsBadges:
  • vb 6.0 conect with access to create a report

    i have created a table in access to manage the house rent.i want to create report only for particular customer rent detail. the customer id is retrived from the table and stored in combobox in one form.when i choose particular id from the combo box, the respective details of the particular id...

    Aapabirami5 pointsBadges:
  • Hide Header In Access Report

    Hi, I have a report built in Microsoft Access that has a page header and a header for one of my fields named JobNo. Well, I wanted to know if there is a way to not display the page header with the jobno header? I know there is a way to not show the page header with the report header but I haven't...

    RoadDust390 pointsBadges:
  • converting text string to numeric

    I am using Access 2003. I have a table with numbers that are shown as text data. I want to convert from text to numeric. Can this be done in a table or a query?

    SacramentoSil25 pointsBadges:
  • How to configure the database instance to respond slowly for any request?

    With default configuration settings at DB instance, the db server is responding quick. For my tests, i want the db server response to be slow. What configuration changes or anything else can be done so that the db instance will respond slowly (atleast take 1 minute time to execute). The request can...

    Saimadhu455 pointsBadges:
  • Scrolling Popup window by search in FoxPro 2.6

    I have a customer Master with Code & Name Fields. While entering data through Input screen I will type customer name and the program will go on filtering the name of the customer from the Master Data File and when I press Enter Key it will select the exact record from the master with Code. If there...

    CNE10 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