• What is the difference between a logical file and view in DB2/400?

    What is the difference between logical file and View in DB2/400?

    rajeshece1,215 pointsBadges:
  • What is the difference between physical and logical reads in DB2/400?

    When we do DSPFD for a file it shows physical and logical reads. What is the difference between physical and logical reads?

    Kajeeva10 pointsBadges:
  • Display records in ascending order in DB2/400 physical file

    I have created one physical file with 1 key field. After that I added some data in that file. Records in the file are displayed in arrival order. While viewing the records using DSPPFM, STRSQL commands. As per my assumption, it should be ascending order. Why it is not displaying in ascending order?

    rajeshece1,215 pointsBadges:
  • What is the difference between DB2 and DB2/400?

    What is the difference between DB2 and DB2/400?

    Allampriya5 pointsBadges:
  • How to find indicator and relative record number fields in DB2/400

    In DB2/400, even after we delete record from file, the record exists until we are done with RGZPFM. The deleted record can be identified by a indication field with value "Y" or "N". How to see this indicator field? How to see the DB2/400 RRN (Relative record number) field? I tried with RUNQRY...

    BibinGeorge130 pointsBadges:
  • Access path and open data path in DB2/400

    When will an access path be created, and when will an open data path be created?

    TNKR130 pointsBadges:
  • Access 2007 creating a menu

    I have inherited an Access Database. There is a form that provides a menu for user access to the various functions such as adding, changing records and various reports. Originally the users would only see this menu form. I modified the form and now they see Access and all the various Access...

    LeChat80 pointsBadges:
  • Migrate application from UNISYS to AS/400

    How can we migrate an application currently running on the UNISYS platform to AS/400 platform. A major portion of the source application is in COBOL and uses the DMS-II database. This has been migrated to COBOL and RPG on AS/400 using the DB2/400 database.

    126170 pointsBadges:
  • SQL query to find out policy numbers

    There are 2 tables POLICY and NAME. The relationship between POLICY and NAME is only the policy number. and their relationship is like many to one. I mean several policy numbers can have same name in the name table with that many records. Now my question is to find out the policy numbers having the...

    Deyyam0 pointsBadges:
  • DBA’s on a project delivering a packaged solution.

    I am the test manager on a major implementation of the Guidewire Policy Centre product. I requested a DBA to join the project. They play a fundamental role in the whole process of ensuring quality. As testers we have no idea what is done to the database in respect of quality, duplication, bad...

    Eish5 pointsBadges:
  • VB6 with too many SQL Select Statements

    Hi Team, hope you can help me out here.. I have a VB6 form that is populated using VB6 and Access being the Repository. The problem is that I am opening and closing the Database for every query I have.. Approx 87 queries. In short I have 12 Rooms that I need stats for.. Ie Grades & Size...

    witsendestate225 pointsBadges:
  • Using Access query data in Excel

    I have a need to use some employee data that is contained in an Access database in a dashboard like application in Excel. I have tried several attempts at getting this data but have not had any success. I can move the entire file, but I really need to move only the data that meets some selection...

    Ronmcnaughton5 pointsBadges:
  • Backups failing due to VSS errors

    On a Windows Server 2003 standard SP2 virtual machine, set up for 3rd party (Syncsort) backup to run daily. this has been running for a while, but now every single one fails. If I go to event Viewer I get: EventID:12289 Volume Shadow Copy Service error: Unexpected error...

    Biyogi20 pointsBadges:
  • Query by character length in Access 2007

    I want to see all the records with 3 or less characters in a specific field. My field contains both text and numbers. How can I do this?

    Skb195510 pointsBadges:
  • SQL Query to return a single value for each record based on max FIELD, not max record

    I have a table with 12 date columns per record (D1 thru D12) and I want to select from each record, the max date of those columns (not the max of the records).  I know: select max(D1) from table1 will yield max of D1, but say I want D3 from record1, D1 from record2, etc (using the following...

    Schlingel0015 pointsBadges:
  • Relational Database

    What kind of tables are used in a membership database other than name & address.

    4jab15 pointsBadges:
  • Importing from an Excel worksheet to Access form

    I have set up my database in access including the form that I want to import my information into, however when I try to import from an excel worksheet into access, it changes all my field names to field 1,2,3 etc. Then when I look at the form page all my sections have the word #NAME? in them. How...

    Horses5 pointsBadges:
  • How do I run Excel Reports?

    Is is possible to run reports similar to how you run reports in Access in Excel 2007? If so, how?

    Lysprice5 pointsBadges:
  • Conversion from FileMaker Pro to Microsoft Access database

    How do you convert FileMaker Pro 7 database to an Access 2007 database file?

    Ccardona5 pointsBadges:
  • Fingerprint recognition in Java

    I want a programing source code for fingerprint recognition time and attendance payroll system in Java language. I also want the source code for capturing a fingerprint image and storing in MS Access in Java language for the same project.

    Anikketthakre5 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