Storing a date as *mdy from an *outfile when executing strqmqry
I have a date coming in to a query in *iso format. when I put it into a date field it comes back as y/m/d despite the fact my datfmt is set to *mdy
Software/Hardware used:
iseries v5.3. sql.
Software/Hardware used:
iseries v5.3. sql.
ASKED:
November 14, 2012 5:47 PM
UPDATED:
November 14, 2012 7:39 PM
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
Michael Tidmarsh 
11,410 pts. ,
matis 75 pts.
11,410 pts. ,
matis 75 pts. To see all answers submitted to the Answer Wiki: View Answer History.
i have a date coming in to a query in *iso format.
What do you mean by “coming into a query in *iso format”? Firxt, where is it coming from? Is it coming from a Date field? If it is, it’s not in *ISO format. The *ISO format is only for presentation. Or is it a Char field with a date value? If it is, it’s not a ‘date’ and the format is irrelevant except for how your coding might parse it.
when i put it into a date field it comes back as y/m/d…
What do you mean by “it comes back”? Back to where?
…despite the fact my datfmt is set to *mdy
What do you mean by “[your] datfmt”? Is that a job DATFMT()? Is it in a program? Somewhere else?
Tom
The solution is temporary. There will be other problems. You can find a number of problems discussed in this forum and in just about any similar forum on the internet.
There are a number of plain SMTP free e-mail solutions that do not require use of SNDDST nor QDLS. Maybe the most common is Mime&Mail for IBM System i from Easy400. Java e-mail has also become fairly common, and other solutions exist. SMTP e-mail can also be done without any 3rd-party utilities by calling the native SMTP functions, but most sites prefer a utility.
SNDDST plus QDLS is a useful short-term function. For continuing long-term use, you need to use features that are appropriate to the task.
Tom
Ignore my previous comment… posted in wrong thread. — Tom