RE: Sql View

That worked perfectly. Thanks Luis.

Jack

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Luis Rodriguez
Sent: Tuesday, July 22, 2014 9:08 AM
To: Midrange Systems Technical Discussion
Subject: Re: Sql View

Jack,

Create view mylib/myview as(
SELECT
A.*
, date(timestamp_field) as my_date
, time(timespamp_field) as my_time
FROM mylib/mytable A
)

HTH,

Luis


Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries
--



On Mon, Jul 21, 2014 at 7:18 PM, Jack Tucky <jacktucky@xxxxxxxxx> wrote:

I posted originally about adding edit codes to a table created using SQL.
I
understand that I can't do that.



How can I create a view that gives me separate date and time fields
for a time stamp? I would like all of the fields in the file and the
two new fields.



I've been googling but haven't figured it out yet.



Thanks, Jack







---
This email is free from viruses and malware because avast! Antivirus
protection is active.
http://www.avast.com
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.



---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com