Search results for query: *

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

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

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

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

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