SMALLJUL - connect_cdc_sqdata - Latest

Connect CDC (SQData) Apply engine

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (SQData)
Version
Latest
ft:locale
en-US
Product name
Connect CDC (SQData)
ft:title
Connect CDC (SQData) Apply engine
Copyright
2026
First publish date
2000
ft:lastEdition
2026-03-04
ft:lastPublication
2026-03-04T14:06:44.769231
L1_Product_Gateway
Integrate
L2_Product_Segment
Data Integration
L3_Product_Brand
Precisely Connect
L4_Investment_Segment
Application Data Integration
L5_Product_Group
ADI - Connect
L6_Product_Name
Connect CDC

The SMALLJUL function returns a small Julian date from the given date in YYDDD format.

Category

Date / Time

Syntax
SMALLJUL([date]) 
Parameter and Description
Parameter Description
date OPTIONAL, if no date is given then the current date is implied

Example

Determine the Julian day from the current date and map the result to target field TGT_SMALL_JULDAY. Assume that the current date is January 31st, 2000..

TGT_SMALL_JULDAT = SMALLJUL()

Returns the value of 00031 and maps the result to the target field.