PMS Information Systems
Welcome to PMS Information Systems - IBM i (AS/400) Forum !!!

Get Answers for all your queries on IBM i (AS/400).

How to make date processing is faster?

View previous topic View next topic Go down

How to make date processing is faster?

Post  maran on Fri Nov 30, 2012 12:24 am

The keyword VALIDATE(*NODATETIME), will make the data processing is faster.

A new H spec keyword, VALIDATE(*NODATETIME), is added for 6.1 and 7.1 The keyword indicates that date/time/timestamp validation will not necessarily be performed. A side-effect of this (and the reason for it) is that if validation is not required, there are some cases where d/t/z data can be treated as though it were alphanumeric data, making assignments and comparisons much faster.

avatar
maran
Admin

Posts : 442
Join date : 2009-07-24

View user profile http://pmsinformationsystem.forumotion.net

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum