Re: Date() function in SQL problem

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