Re: SQL Question

[Bruce Vining <bruce.vining@xxxxxxxxx>]

Well I'm not going to worry about it, but looking at the PDF at
https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_73/db2/rbafzpdf.pdf?view=kc
its
page 142 would seem to be wildly different than your page 142.  In any
case, I believe you've got your answer.

On Mon, Dec 16, 2019 at 10:01 AM <DEnglander@xxxxxxxxxxxxxxx> wrote:

> Robert,
>
> Here is the SQL:
>
>
> create table reffilet(
>    sydate      date          not null with default current_date,
>    sytime      time          not null with default current_time,
>    syuser      varchar(18)   not null with default user,
>    sytimestmp  timestamp     not null
>                              with default current_timestamp,
>    syusersess  varchar(128)  not null with default session_user);
>
>
> If you comment out the last statement and make the definition of column
> sytimestmp the last statement, it runs.
>
>
> Bruce,
>
> The manual I am referring to is:
>
> IBM i
> Version 7.3
> Database
> Db2 for i SQL Reference
>
>
> Alan,
>
> I tried creating a new table with System i Navigator. For the field that
> is causing the issue, the SESSION_USER is not listed as one of the default
> values. I am assuming now that the manual is incorrect, or there is a PTF
> needed to allow usage of special register SESSION_USER, or maybe
> SESSION_USER is only allowed to be used in a SELECT statement.
>
> Thank you,
>
> Doug
>
>
> "CONFIDENTIALITY NOTICE:  This e-mail transmission (and/or the attachments
> accompanying it) contain confidential information belonging to the sender.
> The information is intended only for the use of the intended recipient.  If
> you are not the intended recipient, you are hereby notified that any
> disclosure, copying, distribution or the taking of any action in reliance
> on the contents of the information is strictly prohibited.  Any
> unauthorized interception of this transmission is illegal under the law.
> If you have received this transmission in error, please promptly notify the
> sender by reply e-mail, and then destroy all copies of the transmission."
> --
> 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@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com