• How to reduce the time taken to select the records from huge keyed physical file having 180 Million records

    Hi All, I have a report program which uses the OPNQRYF to select the records to generate a report based on user selection in display screen, but it is taking lot of time (20 to 30 minuates) to select the records and write write into output file. I am accessing keyed logical file based on physical...

    Mohan K695 pointsBadges:
  • Extend char length

    How do I extend char length in memo field?

    flattop10 pointsBadges:
  • How to make one column in a row longer than the others? (MS Word Tables)

    I have five columns in a row, I need to make one [the last] column longer than the rest. How can I make one column in a row longer than the others? Here is a pic to explain what I need to do (I used a photo editor): http://imageshack.us/photo/my-images/831/fixedtable.png/ This didn't work:...

    spamram20 pointsBadges:
  • Trigger

    What is the use of the trigger?

    swamy00725 pointsBadges:
  • Removing Duplicates

    I have 2 access tables. One has doctors and membership totals, the other has doctors and their addresses. When I join both in an inner join, the membership totals duplicate because of the doctors multiple addresses. Is there a way to have the membership total appear only once?

    Dash145 pointsBadges:
  • Database engine

    What are the databases other than Oracle which can be efficiently used with SAP?

    SINGHA15 pointsBadges:
  • File lock on DB2 AS/400

    How do I make a file lock on a DB2 file before accessing it, to ensure that is is not updated while I'm acccessing it ?

    train0125 pointsBadges:
  • STAR JOIN command in SPSS

    Does anyone know what the STAR JOIN command is doing in SPSS version 21? It is the new MERGE files command and I am having trouble with it. When a case from the active data set contains a value that is not in the keyed data set it just stops at that case and will not finish the command. With MATCH...

    IRspecialist20 pointsBadges:
  • word doc into smn for SAMSUNG Galaxy II

    How can I transfere a word.doc into smn(nmf/ or dif) in order to copy it on to my mobile phone

    carvoeiro5 pointsBadges:
  • Problem to storing records at SAP DB from MySQL

    I'm using JCO for connecting SAP through jsp-Servlet. I want to store all MySQL Records to SAP DB. What will I Do?

    Mavric10 pointsBadges:
  • SQL selecting multiple rows from same column based on different column values

    I have am joining a table (object_restrictions) that has three columns: (object_type), (object_restriction_ID) and (object_restriction). I would like to join the table on (object_restriction_id) but select multiple rows based on the value in the column (object_type) and have them listed as separate...

    edsonk4510 pointsBadges:
  • Access 2007 Sql Query

    Hi Team (Again).. further to an original post I am trying to get 2 further fields added to my Query / Report. BoxCount & AverageWeight Here is the existing query. SELECT Pickerid, Pickername, ROUND(SUM(totalweight), 2) AS PickersTotalWeight, SUM(totalweight)/ROUND(SUM(pickerhours)) AS...

    witsendestate225 pointsBadges:
  • Setting up my own private dropbox system

    I'm trying to setup my own dropbox system (for private use). I know what I want, but I don't know how I can make it work. I'm 'comfortable' with some technical things, but I'm no tech-genius, so setting up linux servers etc. is not something I can do :) Would be lovely if you could help me out with...

    Janbracke10 pointsBadges:
  • SPSS v. 21 STAR JOIN

    I have just started with version 21 and I have run into a major issue. Merge is no longer the MATCH CASES command. It is now STAR JOIN. There is something different that this command is doing. When merging, the command just stops when it runs into a keyed variable that has no match in the other...

    IRspecialist20 pointsBadges:
  • Take .csv files and show that on a subfile

    Hi all, I am pretty new to this type of requirement. There are some .csv fiels in AS400 IFS follder. When user choose to the option - upload from the IFS folder from the menu, I need to show those .csv files as a subfile. From that subfile, user can select the csv file with a 'U' to upload and the...

    RamvishakRamesh2,505 pointsBadges:
  • MS Access query

    I have a large table for a leasing database, and it includes a column for start dates and end dates of lease terms, and there are up to 11 lease terms. I am trying to write a query that will identify the current lease term, and then another query to identify the current rent rate based on which...

    kgonzales20 pointsBadges:
  • Access 2007

    I have a database that is supposed to generate the min, max & ave for two different sets of numbers. I have it actually working, but only up to a certain date of figures, I have no idea why these fields do not update when I enter new data. Please help

    3009196420 pointsBadges:
  • sql access/rights

    I am a local admin on the SQL server machine but do not have access to create a database and to browse other databases on the server. I have access to few databases but not all. Which SQL rights or role do i need to have a full access to the SQL server? Besides above, i should also have rights to...

    MCDBA10 pointsBadges:
  • access query criteria using LIKE operator and msgbox if no results

    I am using Access 2010. My query criteria looks like this: Like [ENTER THE FIRST LETTER OF THE SUBJECT] & "*"......so the user clicks the button and a box pops up with the above question. If the user types in a letter and there are no subjects that start with that letter it just opens a blank...

    draia10 pointsBadges:
  • Access query LIKE operator search with msgbox if not found

    Here is the SQL version of my query criteria: WHERE (((tblMain.Subject) Like [ENTER THE FIRST LETTER OF THE SUBJECT] & "*")); In my query criteria it looks like this: Like [ENTER THE FIRST LETTER OF THE SUBJECT] & "*". My question is, if the user enters a first letter that doesn't exist I...

    draia10 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