Re: SQL Question

[Robert Rogerson <rogersonra@xxxxxxxxx>]

Doug, can you post the whole statement you are trying?

Rob

On Fri, Dec 13, 2019 at 3:11 PM <DEnglander@xxxxxxxxxxxxxxx> wrote:

> My server is on V7R3.
>
> I am trying to create a table using SQL, with the default value of
> "SESSION_USER". This is listed in the V7R3 manual on page 142. No matter
> what I do, the DDL will not compile. As soon as I remove that one line,
> all is fine.
>
> syusersess  varchar(128)  not null with default session_user);
>
> This is the message I am getting:
>
> Position 62 Token ) was not valid. Valid tokens: . /.
>
> Is there a PTF needed to support this special register? Can it be used
> with a CREATE TABLE 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