• 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:
  • Microsoft Access 2003 Report Footer Formula

    I have a formula ( =Avg(

    Cmaggio20 pointsBadges:
  • DB2 Web Query – Active Report Show Unreadbale Data

    I have a report contains some information about customer name. When I save the output type as HTML ,the result is pretty good. The problem is, it is not good when save as Active Report AHTML. In each columns contains customer name in Thai will display as garbage or alian. How do we control this ?...

    Liverpoolfc20 pointsBadges:
  • Using SQL and Postgre on the same machine

    We have a requirement in which we need to have our Microsoft SQL Server, as a database of tomcat servers, and our Postgre SQL, as database of jboss servers, on same machine. Are there any known conflicts or issues we should be aware of?

    SQL Server Ask the Experts2,585 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