I just noticed that:-
it should be :-CREATE VIEW LIB1/V1 AS ( SELECT DIGITS((DEC(FIELD1*1000000)
(FIELD2*10000) + (FIELD3*100) + FIELD4,8,0)) AS MYDATE , A.* FROM
Just missed that pair of parentheses before DEC and after Field4,8,0.
Rest all steps should be fine to understand why there is is difference of
record counts in the view and file?
On Tue, 5 Jul 2022 at 00:46, Sam_L <lennon_s_j@xxxxxxxxxxx> wrote:
I cannot help further.
Maybe some else who volunteers on the list can help. And note that
there are now approximately 45 messages in this thread and volunteers
may not have the energy to scan prior messages.
As for typos, I will point out that I actually tried your create view
statement and it had syntax errors. (I know, what you posted it wasn't
the actual statement, but...) Again, this is why I suggest you start
over, keep track of your code, and post it.
I also said "On another front, I don't know how QRY/400 will treat a
view as input, which is why I pointed you to the "Define result fields"
approach for verification. if you are required to verify with QRY/400."
And "field1* 1000000) + ( field2*10000) + (field3*100) + field4)" is
cc 19 * 1000000 = 19000000
yy 98 * 10000 = 980000
mm 12 * 100 = 1200
dd 25 = 25
Add them together 19981215
Copying code you don't understand can be deathly dangerous!
Hope you solve your issue.
On 7/4/2022 2:44 PM, jerry ven wrote:
However i had already shared the structure of file1 in my earlier post
shared SQL queries on file1 and view (V1) created on it , also i hadshared
how i had joined other files to form this file1,,may be it might havebeen
not getting displayed properly due to some format issue while postingin my
Please find all these SQL queries and the file1's structure ( main
file (file1) on which view v1 was created and sql query was formed ) in,please
the below midrange link.
I was able to execute all these SQL queries without any typo error
help to let me know the reason for the different record counts for maincriteria.
file1 and in the view created on it for the same dates selection
*Note* - What is the reason to do this calculation like -(field1*
+ ( field2*10000) + (field3*100) + field4) for all these fields , Imean
how is this calculation has been done, could someone please elaborate it
here ( so that it form as CCYYMMDD) ?
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
Help support midrange.com by shopping at amazon.com with our affiliate
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.