• How to calculate logical file size

    Hi, I need to be able to estimate the size of a logical file (inc access path). I've tried creating this file and almost filled the machine up. This is logical has quite a lot of key fields. Does anyone know a simple way of estimating the size (IBM has a formula in the manuals, but I can't make out...

    Gilly40023,730 pointsBadges:
  • OLE DB using Library List

    Hi, Do any one use OLE DB to connect to iSeries? Is OLE DB capable of using Library List provided by Job Description? Because when I used it, I have to specify the library name / schema and object name. Please advice... Thank you

    TG50 pointsBadges:
  • moving program code between lpars.

    I was wondering as to the best way to enable my operations staff to move program code from a test lpar to the production lpar. Because of audit requirements I can't have the programers able to move the code themselves.

    Mstallings0 pointsBadges:
  • Using Visual Basic and Access – having problems with other programs sharing memory

    Hi folks I have written a Point of Sale program which uses an access database. The program runs beautifully at sites where the the computers are dedicated specifically to running the software, but I am having nightmares at sites where the clients allow their staff to play games, download all sorts...

    JulianF25 pointsBadges:
  • MS access 2007 about field names?

    I'm making a very Simple database. its has ID, last name. telephone no. Type of OS (Windows/Linux/Mac). MY QUESTION IS, If a person has all the 3 OS, and some has 2 OS, other has 1 OS, How do i make only 1 field name for the the 3 selection, and make a database, a table and query where 1 person has...

    Voxli15 pointsBadges:
  • The most-watched IT questions this week: March 9, 2010

    1. A member asks how they can apply GPOs to non-domain computers to make sure they don’t get on the corporate domain, and MrDenny, Technochic, Denwood, and SiThu help with a solution. 2. A member asks about business intelligence in a cloud environment. 3. A SQL Server reader asks how to monitor...

    Michael Morisy8,323 pointsBadges:
  • Assign default values to SQL VIEW columns

    I'm trying to assign default values to VIEW columns defined for left joined columns or columns created by aggregate functions. I've tried the ALTER TABLE after the VIEW was created but get an error that my VIEW is not a TABLE and the ALTER VIEW is not supported by DB2/400 v5r3.

    Tgee60 pointsBadges:
  • How to use PL/I command LIKE with DB2

    I wont to use PL/I comman like for using same structure twice. Compiler returns error : IBM7043I S 4.1 SQL0314N The host variable "xxxxxxxx" is incorrectly declared. SQLSTATE=00000 IBM7043I S 9.1 SQL0117N The number of values assigned is not the same as the number of specified or implied columns....

    Sccsofti5 pointsBadges:
  • Cannot end RGZPFM on V5R4 (Journaled file)

    Batch job RGZPFM on V5R4 not complete after 3 days. I issued an ENDJOB, and job is not completely ended 1.5 days later. The file is journaled and is very large. SBMJOB CMD(RGZPFM FILE(MYLIB/MYFILE) KEYFILE(*NONE) ALWCANCEL(*YES) LOCK(*SHRUPD)) How can I end this job? If MYFILE is damaged, I can...

    AS400DBA15 pointsBadges:
  • Logical file

    I created a logical file that used a select and values criteria. The file had duplicate records. When I created the same file with a higher security level, the file created without the duplicates. Does anyone know why I would have the duplicate records? The file was deleted ok so it didn't just...

    Bubbles120 pointsBadges:
  • bi-directional data synchronization on System i for db2 databases

    I would like to know what would be the best ways to have bi-directional data synchronization on System i between db2 databases . What are the best ways to synchronize data between DDS and SQL-defined files that belong to different applications?

    Aroyzen15 pointsBadges:
  • selecting a record from a table and printing ONE page report

    I have two tables that are joined in a query.  I have a form that points to one of the rows in the table.  I would like to print a single page report for the ONE row.  How do I do that from a multi-row form (with the appropriate row selected) into a MS Access Report?

    Michaeleemeyer15 pointsBadges:
  • VBA – Mail Merge Automation via Access

    Hi, I'm not sure why my code is not working.. I have code in vba in Access 03 which opens a word document which runs a mail merge process. When the code runs, it asks me what the Header Delimiters are.  I specified those in the export file as a comma for a field delimiter and <enter> as the...

    JK012450 pointsBadges:
  • Setting Up Access Parameters/Questions to user

    I am working with a very complex access database and my database knowledge is very minimal.  I am needing to make it so that when a user clicks to edit an orgainiaztions information with in the database the form that pops up will prompt them to either display all of the organiaztion types or let...

    MatileM5 pointsBadges:
  • Loading a new database from an Old one

    I am new to SSIS. We are running SQL Server 2008, and I have to load a new database from an old one which had a different structure. I'm not sure how to cope with PK's that are identities. For example, I have three tables: 1) Main table eg. A list of applications 2) Joiner table eg. A list of...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Best way to create a District/Precinct Map where districts change color based on MySQL or Access data

    I have a image of a city divided into 500+ subdivisions. I need to vusualize data by changing the color of a subdivision. Data can be in a MySQL Db, Access, whatever. Example: if subdivision 1 has completed a report, color of subdivision 1 = green, if not = red. The data is updated often and the...

    Vshilov5 pointsBadges:
  • Microsoft Access counting part of a field

    I have a field that I need to count per group. The field contains whole numbers and decemal numbers. I only want to count the whole numbers. The field is a text field, because there is a chance the actual text can be a value. I tried using IIf, but could only put one condition; the field is "[Key...

    RKJohn95 pointsBadges:
  • New Contest: Win the Nexus One Google Phone with your Knowledge Points!

    You're asking and answering questions already, so why not put those Knowledge Points to good use? Win a Nexus One, Google's new cell phone! It's unlocked, so you can sign on with the (select) carrier of your choice contract-free! Read all the details, but the short and long of it is that over the...

    Michael Morisy8,323 pointsBadges:
  • Converting Data in Excel to PF on DB2/400

    Hi All, I have data in the excel where each column equal to the field of a physical file. I want load this data into the PF on AS/400. Could any one let me know the process on how to do it. Thanks in advance

    rajsubhyd105 pointsBadges:
  • Microsoft Access 2003 Report Footer Formula

    I have a formula ( =Avg(

    Cmaggio20 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