• Multiple DELETE From Statements in Query Manager

    How do I enter more than one Delete from ...... where .. Statement from within Query Manager?

    Pb5410 pointsBadges:
  • can you explain what cluster shared volumes are? Is this a new file system?

    Can you explain what cluster shared volumes are?  Is this a new file system? This question is from the 7/30 Microsoft Virtualization Chat on ITKnowledgeExchange.com

    ITKE341,970 pointsBadges:
  • AS/400 SQL BLOBS

    I am trying to read data from a SQL table that contains a BLOB of 10MB.  Since the RPG field size is limited to 32KB, is this even possible?

    Newsqluser25 pointsBadges:
  • Access & iSeries AS400 Tbl and Query Issues Error Code 5001

    I am in Access and I have (A) a passthrough queries=(INMSP300) and (B) table queries=(dbo_ECC_APP.OEM),I want to join. In the dbo_ECC_APP.OEM there are number identifiers that have no associate number were in INMSP300 there are both and they are associated. So I need to have all the number in the...

    CompEng1,185 pointsBadges:
  • DB2 connection in VBscript

    I need to delete some records from a DB2 database on an AS400 using VBscript.

    Larksys5 pointsBadges:
  • We are runing V5R1 OS400, how do I write to CSV file

    We are trying to write a program that will take the output of a report, & put it on a CSV file. This file will the be sent via email to user(s). Please provide with steps to accomplish this including foldersetup, etc.

    Proy5 pointsBadges:
  • Why won’t my Access subform stay put?

    Hi, I have a main form with a subform below it. The subform supposed to be invisible and 5" from the top. When I click a button, it becomes visible and 0" from the top. When I double click the button, the subform is supposed to go back to being invisible and 5" from the top. For some reason,...

    Dataempress115 pointsBadges:
  • Access Query – Repeating fields

    I have a file of 70K names. Some are dups. I want to create a indicator in Access to flag when the name is repeated indicate 'Y' else 'N'. Any ideas on how to create a query to do this

    Dash145 pointsBadges:
  • Modify MS Access using iSeries RPGLE

    I have to intergrate a third party product that uses an MS Access database with my AS/400 machine and be able to both update the Access data as well as read data from the Access database to use on the 400. Does anyone know how I can do this?

    wkozerski20 pointsBadges:
  • Using MS Acess SQL Passthrough To AS400 to find wholes in number sequence between to files

    Below is a SQL statement from an Ms-access pass-through query that is pulling the info from an AS400 system. The Fields marked in bold are the two table that I need help with. This query returns the same part numbers form each of the two columns of cores because there are of differ tables. I know...

    CompEng1,185 pointsBadges:
  • ACCESS 2007 and SQL Server 2005 Schema Updates

    We have several clients with access to reports (provided via Views). The reports for each client are separated by being under a different SQL Server 2005 Schema. Obviously we can get each client to link to their Views but the client wants things to work like an ADP - that is, as reports are added,...

    NHSNick30 pointsBadges:
  • IBMDB2 runtime issues with HP 2730p laptop

    When displaying catalogue with IBM DB2 Runtime, a blank display appears.  It will not display the command windowl  This problem occurs only with the HP 2730p Tablet.

    Jmonroe700ing10 pointsBadges:
  • Looping to create new workbooks using a set “transaction” number

    I'm playing around a bit and can't figure out why the following code does not save a total of 5 files in My Documents(default) The files should be named in a sequence of 1 - 5 (In my Excel spreadsheet (A1)=1 and (A4)=5) The code works once through, but when ".SaveAs Filename:=Start" comes back...

    McNitro255 pointsBadges:
  • Excel to Access conversion

    Accounting came and asked me if a very complicated Excel spreadsheet that they are using for cash receipts could be "moved" into Access. I explained to them the difference between a spreadsheet and a database and that Access could definitely be used to better handle transactions etc. but it would...

    KSoniat610 pointsBadges:
  • How to add exchange cluster server to an exisiting exchange server?

    I have an existing exchange server 2003 working fine but to add redundancy I want to put new exchange server in cluster mode using the storage EMC CX300 (available). Please let me know how to proceed & what precautions to take & during this process how users will get effected or is that any way...

    BaseerM60 pointsBadges:
  • T-SQL query to ACESS 2007 database

    I need examples of T-SQL queries running on SQL Server 2005 that retrieve data from a MS ACCESS 2007 Table. Any explanations are appreciated. Thanks

    DamMan5 pointsBadges:
  • jasper server with sql server

    does jasper server allow you to use sql server as your database server..if yes can you guys help me out...im stuck with this for almost a week. thanks in advance...

    Skillszone10 pointsBadges:
  • AS400 File to MS Access by SQL Passthrough Query

    I am trying to joint more then one File (table) from the AS400 by using MS-Access passthrough query SQL. I have been able to create separate individual queries. Like I mentioned before. I have using the below statement: (Query One) SELECT INPFP100.PFPFAM,INPFP100.PFPLIN,INPFP100.PFDES FROM...

    CompEng1,185 pointsBadges:
  • Forced Date Routine Processing

    I’m trying to process a RUNDATE = 2009-08-07 into my COBOL code via a PARM-DATE Link. That date comes in… now I try to place it in the following piece of code: EXEC SQL SET :WS-PREV-WK = CHAR(DATE(TMP-DATE)- 7 DAYS) END-EXEC. What am I getting '0001-01-01' returned?

    A30TPX5 pointsBadges:
  • Form vs. table record order

    Why doesn't the record order for an MS Access form match the record order of the table (form keeps re-ordering the records)?

    Mcoopers75 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