-yr4def performance benefit?

[Norman Biggar]

I'm currently working on a program that dumps the contents of a database table into a delimited file for an external system which requires all dates to have a 4-digit year...

for each tablename:
    put stream sExtract unformatted
        tablename.integerfield "|"
        tablename.characterfield "|"
        tablename.datefield format "99/99/9999" "|"
        ...
        skip.
end.

Would I get any performance benefit by using the -yr4def client session parameter and removing the format option on my date fields?

 

[TomBascom]

It would be an interesting thing to test.

My guess: probably only a very minor improvement and at the risk that some day in the future someone will run the program without that parameter being set.

BTW, that should be "for each tablename NO-LOCK:..."

 

[Norman Biggar]

Thanks Tom,

Looks as though the hunt for elusive microseconds goes on.

BTW, that should be "for each tablename NO-LOCK:..."

:lol: Peer reviewers are always around, it would appear! :blush: