All Stories
sql
-- Adminer 4.7.0 MySQL dump SET NAMES utf8; SET time_zone = '+00:00'; SET foreign_key_checks = 0; SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO'; USE `test`; DELIMITER ;; DROP PROCEDURE IF EXISTS `process_smartorders`;; CREATE PROCEDURE `process_smartorders`(IN `tick_value` decimal(10,3), IN `stockname` varchar(20)) BEGIN DECLARE l_stk…
Teradata Date Handling with Sample Queries
Teradata Date Handling: For Developer, handling the date is a very tedious task. the date format must be checked before inserting the date in the table. there are many ways to handle it. Sample table: CREATE VOLATILE TABLE SAMPLE_DATE, NO…
Change Capture Stage in Datastage
The change Capture stage in DataStage allows to Capture the Change in two source datasets(before and after) and mark the difference in one of the output column. The comparison is made by key columns specified in properties. The changes are…
Teradata connector Stage in Datastage
The Teradata Connector stage in DataStage allows to read and write records to the Teradata tables. The Teradata Connector stage has many capabilities and Better than earlier Teradata stages. Teradata API, Teradata Enterprise, Teradata Load and Teradata Multiload stages are depreciated,…
Remove duplicate Stage in Datastage : Quick Example
The Remove duplicate Stage in Datastage allows dropping duplicate records from the input data links.It can have one input and one output link. It also enable us to retain first or last record from the duplicates. Mandatory: The data source…