date type in physical file

[casporov]

Hello,
my questions is abt date type in a physical file
if i want a field to be a date type...how can i specify the format of the date

thanks in advance

[Zdenko]

Re: date type in physical file

Hi

A            DATEFIELD       L         DATFMT(*EUR)

[casporov]

Re: date type in physical file

thanks...
but other than EUR wut choices are available???

[Zdenko]

Re: date type in physical file

Hi

http://publib.boulder.ibm.com/iseries/v5r2/ic2924/index.htm?info/rzakb/rzakbmst43.htm

[FaStOnE]

Re: date type in physical file

Actually .. you don't have to specify. If it's a date type, you can store it as a default (Usually *ISO) but, can retrieve the date in any format you want (*USA, *EUR, *ISO, etc...)

-R

[B.Hauser]

Re: date type in physical file

IMHO the date format should not be specified in a physical file.

A date is always stored in a 4-Byte binary value representing the calculated number of days since 01/01/0001.

Date formats are only necessary to make this binary value readeable. If no date format is specified in the physical file the binrary value is shown as *ISO format. (YYYY-MM-DD)

In RPG and all SQL interfaces there are options to determine the date format you want to use.

Birgitta

[iseriescobol]

Re: date type in physical file

For the COBOLers out there, don't forget to use the CVTOPT(*DATETIME *DATE *TIME *TIMESTAMP) compile options when using date and timestamp datatypes in a PF or LF. If not, the COPY DDS will give you funky results.

[Billw]

Re: date type in physical file

It's the same when compiling rpg4 (non-le) *datetime option on the compile command.