Features of the TERADATA interface
Here
are some of the features of the ULTIM language that apply to the processing of TERADATA databases. Some are shown in the example below.
- Direct access by ULTIM to the fields definitions contained in the TERADATA database.
- Link with TERADATA through a SYMBOL statement supplied in the ULTIM control file.
- Automatic management of the link protocols to the databases.
- Call to TERADATA through standard SQL SELECT clauses.
- Parallel access to several tables.
Example of control file
SYMBOL PRODLINK = 'PROD%TDP1/SCOTT,1RCK2,''SALES'''
In
this example, PROD is the name of the database followed by the
"tdpid". Following are the username, its password and the
account-id.
Example
of
program
BEGIN
DEMO.
*
Description and reading of the data
FILES CUSTOMER(F, PRODLINK, TERADATA,
SELECT NAME,
ACCOUNT-NBR,
DIVISION,
LAST-PAYMENT,
BALANCE (P, 5.2, 10, @ED:$)
FROM
CUST
WHERE BALANCE NE 0
AND LAST-PAYMENT < 20150301).
PROCESS
EACH CUSTOMER .
* Report to be produced
OPTIONS
HEADING=AUTO, SPACING = 5.
REPORT
DIVISION, NAME, ACCOUNT-NBR, BALANCE(12,TOTAL), LAST-PAYMENT.
TITLE ACCOUNTS OUTSTANDING FOR MORE THAN 2 MONTHS AS OF MAY 1, 2015
CONTROL
SUBTOTALS=1.
END
Tabulated report produced by REPORT, TITLE and CONTROL statements
MAY 6, 2015 PAGE 1
ACCOUNTS OUTSTANDING FOR MORE THAN 2 MONTHS AS OF MAY
1, 2015
DIVISION ------NAME----- ACCOUNT
NBR BALANCE LAST PAYMENT
N-EAST LLOYD &
SONS
2369108
$34.94 2015/02/21
THE LAMP
SHOP
3246538
$199.00 2014/12/15
THE
LIGHTHOUSE
1071638
$2,189.10 2015/01/06
........................................... $2,423.04
N-WEST MVC
INC.
1387
$4,189.95 2015/01/28
PLANT
LIGHTING
9066489
$1,450.49 2015/02/12
QUALITY
SWITCH
9193257
$469.20 2015/02/16
ZEUSS
DISCOUNT
1479380
$964.99 2015/02/01
ZIGGER'S
2102981
$2,849.59 2014/11/01
........................................... $9,924.22
S-EAST ACME LITE
LTD.
843896
$360.47 2015/02/11
ELECTRIC
SHOP
2225751
$194.90 2014/12/21
LIGHTNING
LAMP
3178456
$475.20 2014/12/05
RUSSELL &
SONS 386660
$895.45 2015/01/12
TOP
SERVICES
3143486
$10.00 2015/02/01
........................................... $1,936.02 ........................................... $14,283.28
|