• AS/400 definitions and Password Change Century

    AS400 is new to me and i realy need help... I have 4 questions :) 1. What is the meaning when i see '1' on the column of 'Password Change Century'? 2. How can i see if ODBC is in use in AS400 and if it is in use, how can i see relevant definitions. 3. How can i see if DDM is in use in AS400 and if...

    AS400 - Ask the Expert485 pointsBadges:
  • Look at query results & pass a value to form in ACCESS 2003

    I need to be able to look at the results of a query & based on the values in one field (?) on a subform/table enter a Pass/Fail value to the main table. Here is a basic breakdown of what I have: t_Main: table defining dimensional layout requirements. There can be multiple parts of the same part...

    Rbrown3805985 pointsBadges:
  • Crystal Reports can’t connect to Access 2007

    We have just upgraded from Access 2003 to Access 2007 and CR-XI can not see the dB's. I think it is the new file extensions with Access 2007. Anyone know how I can connect and see the dB's.

    Rcsully6515 pointsBadges:
  • AS400/iSeries Queries on a schedule

    I have several queries that I run daily manually, I will like to know step by step how can I have my queries to run on a schedule using the SBMSCHJOB command, then I will like to export them to Excel or Access.

    Querys100 pointsBadges:
  • Code to upload CSV file to AS400

    I am looking for code to convert .CSV file to AS400 automatically. I need to automate this feature. Thanks in advance.

    Jazzcafe5 pointsBadges:
  • Clustering

    I am using Oracle 10g on Windows I would like create clustes for faster reterival. How can I create it(syntax) can you help me with an example. How does it effect the performance

    Vishwanathavn5 pointsBadges:
  • Setting run priority on prestart jobs

    We have several applications that query the iSeries through ODBC, so they all use the prestart job QZDAINIT. Is there a way to change the run priority on these jobs so that one application's queries can have a higher priority than another application's queries? Since each application's queries...

    GaryF60 pointsBadges:
  • Access Database – Colorize one word or letter

    How do I colorize one character in a field in a table? I want the letter "O" to be in red for one customer and blue for another customer in the same column but different rows.

    BethG5 pointsBadges:
  • Reporting problem when dates contain zeros in the same field

    Using AcuODBC and creating simple lists involving dates, ie, termination date in an employee file. When I select only records that (in this case) do NOT have a valid date in the TERM-DAT I select no records at all. The data is a signed decimal 8 characters with a valid sign. Crystal seems to not...

    Jelvis5 pointsBadges:
  • Database connectivity using ActiveX control

    Provide a sample code to how by using VB 6.0 connectivity can be done by ActiveX(ADO) Control tool with the database SQL Server 2000

    Reena10 pointsBadges:
  • Database connectivity using Data Control

    Provide a sample code to how by using VB 6.0 connectivity can be done by Daat Control tool with the database SQL Server 2000

    Reena10 pointsBadges:
  • Correct Isolation level for SQL2005 Subscriber.

    Hello, I'm specifying a SQL 2005 Enterprise back-end to an OLTP application which has one main DB (200GB, could grow to 600GB), a subset of which will be replicated to a separate subscriber for running read-only queries. Here's the spec, any comments appreciated, especially around the use of read...

    SuperCoolMoss140 pointsBadges:
  • What are the drawbacks of these two techniques of Change Data Capture?

    Hi can anyone tell me the draw backs of these two techniques of change data capture? 1: Table Differencing 2: Change-Value Selection

    Mahr5 pointsBadges:
  • Microsoft Access 2007 Query/Report Calculated Fields

    I have a table with customer estimates and sales. I need a report to reflect the closure rate by total number of jobs within a given section (in this example subdivided by lead source). Each job can have multiple records. I need to get the % based on grouping estimates for specific jobs. (7...

    Reici10 pointsBadges:
  • Replace an Exsisting Table

    I want to make a Table in Access. I figured this out but how do I overwrite this table because obviously I don't want to make new tables again and again. Right now i have just implemented a simple table. Any help would be help. Thanks

    ProgrammingGal30 pointsBadges:
  • Minimize results in form.

    I am trying to create an issue tracker for my company. The problem is that I have many contacts for each customer(Each contact will have their own record in the "customer" table). What I would like to be able to do is when I enter a new issue, I will select my customer from a drop down box that is...

    Jvaniman15 pointsBadges:
  • Creating a query in MS Access 2003 that converts text data to numeric from a table that has links to it.

    Creating a query in MS Access 2003 that converts text data to numeric from a table that has links to it. I have an idea on how to convert the text data to numeric. The problem is that I want to take text data from one table then temporarily create another table where the converted data will be...

    SacramentoSil25 pointsBadges:
  • Checkboxes with INSERT and DELETE actions

    I'm fairly novice with Access, though I know how to program in a variety of languages. I need to know how to do something in an MS Access 2003 Form. I have two tables:

    Trobertson5 pointsBadges:
  • AS400

    In DDS, Unique is file level keyword. Is there any specific key word for field level?

    rajeshece1,215 pointsBadges:
  • Query performance and tuning

    Hi, I wanted know as to what I can do to my query so that it improves in performance.RIght now it it taking 3-4 hrs because of the large no of records in the DB.If i remove the group by and order by clause for the same no of records it is fast but when it does sorting it hangs.But I need to do the...

    Mingley5 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.

Thanks! We'll email you when relevant content is added and updated.

Following