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

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