• 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:
  • How to know that the access list is working

    What command can I use to show that the access control list (<a href="http://searchsoftwarequality.techtarget.com/sDefinition/0,,sid92_gci213757,00.html" target="_blank">ACL</a>) is working?

    NetworkingATE1,545 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:
  • Meeting Invitation not updated in Calendar

    I have created a COM Program in MS Access using VBA code which will send meeting invitation. Invitees are getting my invitation and after accepting it is not updating their calender. How to do this. I attached a sample tag for the same. If you want complete code I can post the same. Thanks for any...

    Subbu2k990 pointsBadges:
  • Access – Bound sub form trying to set the value of an unbound field

    I have a bound sub form with a Datasheet view.. One of the fields on the form I want to be unbound, but still display the value of a field for row displayed. How do I show the value.

    TJay85 pointsBadges:
  • In DB2 when a select statement is executed, it is taking lot of time and the table is being locked.

    In DB2 when I'm giving a select statement its taking lot of time, the reason is like the table is a very huge table. As a result some times it is locking the table. Can any one help me for executing the select query with any option which would not lock the table. Thank you in advance.

    UmaGandreddi80 pointsBadges:
  • EDM Pool Usage

    I have a Cobol program which calls another DB2 program which in return executes a procedure. And this call happens more than thousands time...so EDM Pool getting filled up with pages which shuts down the DB2. Can you suggest what needs to be done to minimize the EDM Pool issue.

    Coolster015 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