Why do I see leading blanks in dates instead of zero?
Article ID: 129876
Updated On:
Products
PanAudit Plus
Easytrieve Report Generator
PAN/SQL
Issue/Introduction
Why do I see leading blanks in dates, like the REPORT TITLE date, instead of zero when using release 11.6?
Environment
Release:
Component: EZTRVE
Component: EZTRVE
Resolution
There is only one explanation if you see leading blanks instead of zero when using SYSDATE, or, for example, at the date in a default REPORT TITLE line, in release 11.6. It means NEWFUNC is set to N (compatibility mode, what means CA Easytrieve is actually using the CA Easytrieve 6.4 modules) and in the first 6.4 EZTPOPT module which will be found in your library concatenation, DATEMLC is set to B (the default).
The 6.4 DATEMLC option (z/OS only) specifies the leading character of the date placed at the top of the compiler listing and also stored in the system defined SYSDATE field. SYSDATE will also be used in a default REPORT TITLE line, for example.
You will see "11.6-C" in the compile listing title lines - the "C" means "Compatibility Mode" and NEWFUNC is set to N.
If NEWFUNC is N in the 11.6 EZOPTBL options table, check your concatenation and which EZTPOPT module will be used.
If you would like to change to leading zero, change DATEMLC to Z in this 6.4 options module, or use another EZTPOPT module where DATEMLC is set to Z already.
Native CA Easytrieve 11.6 (NEWFUNC set to Y) is always using a leading zero. There is no option to change this to blank.
The 6.4 DATEMLC option (z/OS only) specifies the leading character of the date placed at the top of the compiler listing and also stored in the system defined SYSDATE field. SYSDATE will also be used in a default REPORT TITLE line, for example.
You will see "11.6-C" in the compile listing title lines - the "C" means "Compatibility Mode" and NEWFUNC is set to N.
If NEWFUNC is N in the 11.6 EZOPTBL options table, check your concatenation and which EZTPOPT module will be used.
If you would like to change to leading zero, change DATEMLC to Z in this 6.4 options module, or use another EZTPOPT module where DATEMLC is set to Z already.
Native CA Easytrieve 11.6 (NEWFUNC set to Y) is always using a leading zero. There is no option to change this to blank.
Additional Information
https://comm.support.ca.com/kb/how-do-i-create-a-second-options-table/kb000026836
https://comm.support.ca.com/kb/can-i-print-sysdate-with-a-leading-blank-instead-of-zero/kb000031094
https://comm.support.ca.com/kb/what-should-i-know-about-installing-caeasytrieve-116c/kb000016247
https://comm.support.ca.com/kb/can-i-print-sysdate-with-a-leading-blank-instead-of-zero/kb000031094
https://comm.support.ca.com/kb/what-should-i-know-about-installing-caeasytrieve-116c/kb000016247
Feedback
Yes
No
Powered by
