Search results for query: *

So my solutions: while I maybe using too many commands... for now it got me the results: I was able to use the Add Command to create a new table. The add command was created under the DB2 database: SELECT Field1, Field2 FROM Database.Table WHERE Country IN (USA) // I could have used =, but I...

I agree with the information from the link you send. that is why i said the left outer join will not show the following records: Acct# Cntry PrceID RepID Acct# Cust_Name Address City 12242 USA 1546622 James 12242 Jon James 123 St. New City 54245 USA 5456573 James A2524...

SkipVought, I appreciate your help with this, but i was reviewing your results... and I don't believe a left out join will produce the result you mentioned. The left out join will only produced records found in the left table, assuming an enforced is not triggered.

:) I see your point... but with respect to this exercise, yes... if it is in the excel file, then It is a USA record... basically what I need to do is find out which account number in my excel file that is not in my DB2 database. the relationship between the excel file and the DB2 is 1 to many...

SkipVought... Here is how: The excel file contains only USA records, the DB2 database contains both USA and non-USA records. So, if I am able to use Add Command to create a new table with only USA records. Now I'm working with two tables that contains only USA records. by linking the...

Ummm... while I am having trouble doing it... Do you not believe that if I use the Add command (That is the Add Command in the Database Expert) to create a new table with the filtered information. Example: Say I create an SQL filter in the Add command to list only records in the USA in the DB2...

I am working on a DB2 database, and I need to compare data from an excel worksheet. The excel worksheet contains the account number along with other information. I am able to join the account number from the excel worksheet with the account field from one of the tables in the DB2 database...

I am having a hard time trying to understand what it is you are trying to accomplish. see if you can help me understand. what are the top 3 vendors from the table are based on? In other words, what makes them the top 3? I am also trying to understand the required layout results. I see that...

I have the following formula created if ((onLastRecord) or Next({data.acctnum}) <> ({data.acctnum})) Then 'STOP' Else ' ' Which puts the the word "STOP" at the end of account number line. an example of how this works is: 12345 12345 12345 12345 12345 STOP (stop tag is @ the end of the...