You've now provided information that we didn't have before.
Given what you've said there, my recommendations:
1) *Delete everything* and start again.
2) Structure the SQL so it is easier to read for anyone on the list
3) Save each SQL in a file.
4) If you still have problems, publish the entirety of the *original*
SQLs in the order you ran them.
5) If you haven't installed iACS, install it and use it instead of STRSQL.
6) Try making your posts easier to read--maybe it's my old eyes but I
find them hard to comprehend. If English isn't your first language I'm
sorry, but you've got to help us a bit. Perhaps write them in an editor
and review them a bit before you post them.
7) You do know that in QRY/400 you can define new fields?
In "Define result fields" you can, say, define "theDate" as "field1 *
1000000 + field2*10000 + field3*100 + field4" and then use "theDate" in
"Select and sequence fields". "
On 7/3/2022 4:34 AM, jerry ven wrote:
Just missed to mention that the PF (file1) whose structure ( it's fields
sequence, data types,length and scale) i had shared earlier is formed
the join queries like below:-like
select a.fld1,b.fld2,a.fld2,a.fld3,a.fld4,a.fld5,a.fld6, from libx/filea1
a leftjoin libx/fileb1 b on digits(a.fld1) = trim(b.fld2) and b.fld1
then above sql query gives me filea2 in my library lib1.
then using this filea2 i create another SQL query like below:-
select * from lib1/filea2 A left join libx/filea3 B on
digits(a.fld2) = trim(b.filea3)
then i get file1 - for which i shared sql queries ,it's structure and SQL
queries for views on this file.
but the type of this file1 is 'Physical file ' only.
I hope these details should help to figure it out to find the record
discrepancy in this file1 and view V1 create on it ( i mean in my earlieri
post i shared those SQL Queries 1.,2.,3.,4.) for the same file file1 and
also shared it's structure.
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,
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.