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

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

Join the forum, it's quick and easy

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

Get Answers for all your queries on IBM i (AS/400).
PMS Information Systems
Would you like to react to this message? Create an account in a few clicks or log in to continue.

How to make date processing is faster?

Go down

date - How to make date processing is faster? Empty How to make date processing is faster?

Post  maran 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.

maran
maran
Admin

Posts : 442
Join date : 2009-07-24

https://pmsinformationsystem.forumotion.net

Back to top Go down

Back to top

- Similar topics

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