Currently I am using following to update date column in Teradata on Mainframe platform.
- There is one Job which copies the date stored in a DATASET in YYYYMMDD format to SNAP_DT.TXT file on DATASTAGE EE server. - Another Job then takes SNAP_DT.TXT file as a source, and Multi-Load this field to Teradata table: CURRENT_SNP_DATE.
Everything works, but DBA suggested its inappropriate use of Multi-Load, as there is only One solum in CURRENT_SNP_DATE table and its getting updated only once in a month with one record (YYYYMMDD field), and suggested to use BTEQ as a SYSIN (Insert/update) instead.
Here is a new requirement:
-In one JCL Job, I want to accept input from Dataset in YYYYMMDD format, and take that input into BTEQ (as a SYSIN using INSERT) to update CURRENT_SNP_DATE table.
Please provide sample of JCL, and BTEQ (SQL). how would I incorporate these changes as BTEQ, instead of Multi-Load. I am a beginner, so please assist as much as you can.
I appreciate your time, and assistance in advance.