RE: SQL, Insert data column into table

either way is valid

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of Rob Berendt
Sent: Tuesday, May 4, 2021 12:54 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: SQL, Insert data column into table

I believe that's without the underscore.
Test:
select current_date, field5, field6
from mylib.table2 where status = 'active'

Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 7310 Innovation Blvd, Suite 104
Ft. Wayne, IN 46818
Ship to: 7310 Innovation Blvd, Dock 9C
Ft. Wayne, IN 46818
http://www.dekko.com


-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Paul Therrien
Sent: Tuesday, May 4, 2021 12:39 PM
To: 'Midrange Systems Technical Discussion' <midrange-l@xxxxxxxxxxxxxxxxxx>
Cc: 'Carel' <coteijgeler@xxxxxxxxx>
Subject: RE: SQL, Insert data column into table

CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.

Insert into mylib.mytable ( field1, field2) select current_date, field5,

field6 from

table
(mylib.table2) where status = 'active';

Paul Therrien
paultherrien@xxxxxxxxxxxxxxxxxx
225-229-2491

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
midrangel@xxxxxxxxxxxxxxxxx
Sent: Tuesday, May 4, 2021 12:37 PM
To: 'Midrange Systems Technical Discussion' <midrange-l@xxxxxxxxxxxxxxxxxx>
Cc: 'Carel' <coteijgeler@xxxxxxxxx>
Subject: RE: SQL, Insert data column into table

Thank you Carel, however the current date does not exist in the "from" table
so what I'm perplexed about is how to get the date and put it in there. I
just don't know SQL well enough to add that column to the statement.

--
Jim Oberholtzer
Agile Technology Architects

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Carel
via MIDRANGE-L
Sent: Tuesday, May 4, 2021 11:25 AM
To: midrange-l@xxxxxxxxxxxxxxxxxx
Cc: Carel <coteijgeler@xxxxxxxxx>
Subject: Re: SQL, Insert data column into table

Use CURRENT DATE.


Op 4-5-2021 om 18:22 schreef midrangel@xxxxxxxxxxxxxxxxx:

Folks:



I have an SQL statement that's about:



Insert into mylib.mytable ( field1, field2) select field5, field6 from
table
(mylib.table2) where status = 'active';



Works well, but I need to insert the current date into the result
table, something like:



Insert into mylib.mytable ( currdate, field1, field2) select field5,
field6 from table (mylib.table2) where status = 'active';



What I don't know how to do is grab the current date and stuff it in

there.

There's no question in my mind it can be done but I am failing at
internet queries to find a method.









--

Jim Oberholtzer

Agile Technology Architects

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

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com

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

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com

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

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com