Recent content by paulnlk4

Hi, I am trying to do a Multi-load and the table is defined as follows: CREATE SET TABLE addr ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL ( ADDR_ID VARCHAR(22) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL, ADDR_SYS_SRC_ID SMALLINT NOT NULL, ADDR_USG_TYP...

Hi, I have found the solution. Thanks, Paul

Hi, This is related to Financial Industry. In actual business, a person may have opened a account in a particular branch/office, then due to some personal reason transferred the account to a new branch/office. After some months/years, the account was again transferred to the branch where the...

This SQL works! Thanks Dieter, Paul [2thumbsup]

Once Again, I want to drop records the following kinds of records: Only those records need to be deleted which have duplicate Accounts with different Status codes and want to drop the one which has a Status of 8. If the 2 same Account numbers have 2 and 3 as Status Codes then I want to retain...

Hi, I don't want to drop records which contain only Status with 08. Only those records need to be deleted which have duplicate Status. For Example the following rows exist: Account # Status 1 2 1 8 2 8 Result I want to see is: Account # Status 1...

Hi, I am not that experienced in SQL. Please help me. I have the following scenario: Within a table there is a possibility of having duplicate account numbers with different status Example: Account # Status 1 03 1 08 2 05 3...

Hi All, I am in the process of designing a load system to satisfy our business needs. In our shop we use Fastloads, Multi-loads(source is one file and target is one table), BTEQ's, etc. For example: I have the following 2 files: 1) Credit file - Contains APPL-ID as the key. 2) Product file...

Thanks tdatgod, as your name suggests, u r my saviour...Paul

Hello, Is there a statement in Teradata which can accomplish the following: Insert records into a table if the record does not exist, however if the record exists, then update the record. Is there a statement like 'Insert with Update' option in TD. I heard of something similar in DB2...

All, As in most companies I have Windows-NT workstation installed on my laptop. Teradata is on NCR. To access data we have 3 ways: 1) BTEQ - Used by submitting Host jobs 2) MS-ACCESS - Popularly used by our user community. 3) Interagate - Used by developers like me in our company. I...

Hello folks, I have exported a file using the Export functionality available in Interagate. This data has been exported from our production server and the data is in a comma delimited flat file. Can I use Interagate to import records from this flat file into my tables in test server. I...

Thanks Bill, I think you have answered by question.

Bill, No, there are no multiple records in the same month. Only one per month with the same AC_NUM, however what I want to do is post the difference between current months AMT and the previous months AMT in the DIFF column. For eg: If AC_NUM did not exist in Nov, 2001 and in Dec, 2001 the AMT...

To get difference between 2 rows and the resultant value into the latest row’s column. Folks, Here is how the data looks like: Loan_table AC_NUM DATE AMT DIFF 0001 12-31-2001 1000 0 0001 01-31-2002 3000 2000 In the above table, what I need to do is get the value from the AMT column...