Re: Date() function in SQL problem

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Show your code..

Charles

On Thu, Jun 9, 2022 at 10:17 AM Alan Cassidy <cfuture@xxxxxxxxxxx> wrote:

> I'm trying to create a View that will be used in a DS-array that will be
> defined in the DCL-DS statement as EXTNAME( <sql-view> ).
>
> But in creating the View I now get a compile error, SQL0170, that "the
> number of arguments for function DATE function not valid".
>
> That's after "tweaking" the code for the View.
>
> The View has date types that mostly originate in DDS-created physical
> files.
>
> When I used the View straight up, including various date fields, before
> in the DCL-DS as described above, it gave me an error that a member in
> the structure was "not compatible". But gives no more detail than that.
>
> I've tried using functions to compensate, not getting headway. I think I
> know which DDS field but can somebody tell me what the real problem
> probably is?
>
>
>
> --
> 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