DataManagement

How do I confirm all the data moved from Source to target for different tables

With SQL. use the Select COUNT(*) option for each of the tables in both the source and target system. That will tell you if your record count is correct. * If you want to get to the record level, you can do a EXCEPTION JOIN

To retrieve data from a remote system

One of my clients used to use Sockets for communicating between an AS400 and a Unix box and that worked very well. I keep meaning to "have a go" with socket programming and have seen a lot of good press on Scott Klement's tutorial at http://www.scottklement.com/rpg/socktut/index.html Hope it...

Pb with notes database

First of all why dont you upgrade to ODS51 ???? Add the following parameter to the server's Notes.ini http://www-10.lotus.com/ldd/dominowiki.nsf/dx/create_r85_databases Second of all ,,, what is the problem you are sufrreing from ??

Is there dashboard/data mining software which is geared for a small business?

This might help if you are a developer. It easily graphs data and supports drill down. It's totally free and totally customizable if you have Excel. Beyond Excel

Crystal reports formula

In Field Explorer, select Running Total Field and click the New button to display the Create Running Total Field box Type in a name From the available Tables and Field list box, select the field to summarise From the Type of Summary drop down list, select the type of summary you want In the...

DECFLOAT - Internal Format

Hello, I am not sure what you mean by "visual format." I will take a guess that you want a floating point number to be returned to your application as a decimal number. Use the DECIMAL function. For example: CREATE TABLE TTEST (F_COL FLOAT); ...

"map drive" IFS

So if I understand correctly... - You have created "shares" using iSeries Navigator? (i.e. a share named "root" for the / directory, a share named "test" for /home/jdoe/test, and so on) - And using "net use X: \QS6555A8Aroot" or "net use Z: \QS6555A8Atest" in a DOS box on a client PC doesn't work? ...

Crystal Reports X

I have to do somthing similar, what I have done is Create a report with just the one field in it Group by the field so that all records of the same value are together Add a count of records per group in the group header Use a group selection to show groups where the count is greater than 1 This...

SUPRESSING THE GROUP HEADER IN CRYSTAL REPORTS

Why do you have a repeating header? Maybe I am not following, but it sounds like the identical message will repeat on every page, so why not just use page header. If I have totally missed the point (and I feel I must be) then in the supress record for the page header put inrepeatedgroupheader

Coding to prevent table overflows withing programs

We used that method back in the early seventies when memory was maxed out at 16k total. Instead of writing to an array (or table) you write to a file. The same exact information in the record as your table would have had. The index becomes the record number! There are far too many different ways of...

How to combine 2 linked Excel tables in access 2003 with same field names, using query?

For the linked table approach. Make a Union query in Access. Select EmployeeID, CustomerID, Address From LinkedTable1 Union All Select EmployeeID, CustomerID, Address From LinkedTable2 This should do what you are asking for. The All part of the union brings in records that might be the same in...

The request could not be submitted for background processing

I am running a CrystalReport 10 report thru ODBC to MS Sql 2000 db. There are Many subreports that are not running until I manually RESET teh SQL Query of Each SubQuery. IS there a Global Update for all subquery within a report?

Record Count Crystal Reports 2008

Lets say you have these 2 tables: CLIENT table with the columns ID, NAME, etc and CLIENT_ORDERS table with ID, ORD_ID, etc You want CLIENT.NAME, count of orders. something like this should work: SELECT C.NAME , COUNT(CO.ORD_ID) FROM CLIENT C , CLIENT_ORDERS CO WHERE C.ID = CO.ID GROUP BY...

db2/400

Try google Webquery, i series, console. Phil

DB2 UDB for iSeries: Using CPYTOIMPF to trim blanks

We recently got this suggestion from a reader: "You could try explicitly specifying: RCDDLM(*CRLF) in your CpyToImpF command. It works for me we're running OS/400 V5R2." -- Michelle ===================================================== If the field being transferred is a CHAR field, then...

STRQMQRY problem

Do you want to remove the prompt because it's always the same company? It looks like you want company 10 from your DCL statements... you can change the setvar to use the &COMP# rather than the &OSCOMP variable. ===================================================== You have &OSCOMP declared as a...

CPYTOPCD filename length limitation

The limit of up to 8 chars and up to 3 chars extension applies to all folders and documents in QDLS. This is the only area of the IFS that the CPYTOPCD command will access. You can use COPYTOSTMF to copy a database file to other areas of the IFS as an ASCII text file, where these limitations do...

Procedure Pointer

Indicators - D IndPtr s * Inz(%Addr(*In)) D Indicators s 1 Dim(99) Based(IndPtr) and if I want to set the indicators say In50 to In54, i would use %Subarr(Indicators:50:5) = '10101';

Workstation ID/IP Address

When you configure their sessions select "Specify workstation ID" then enter the device their device description in the field below. If they need to configure a second configuration if you want them to be able to open a second session and so on. Sound like a make work project to me though... ...

External DB2 Database link/trigger

Are you asking how to do this on the i5 or is there some other question i'm not seeing? ----- Appearantly part of my question disappeared somehow. I wanted to know if it is possible to connect from the i5 to an Oracle database and whether it is possible to have triggers on that external DB so if...