Processing table in eastrieve

chandrarkar · New User Joined: 27 May 2008 Posts: 24 Location: india

HI ALL,

I have a table declared as
FILE INPUT TABLE 1000
[color=darkblue]********************************
ARG 01 16 A
DESC 17 44 A [/color]

the error its showing while processing the table was
A007 TABLE INPUT IS NOT IN SEQUENCE - INPUT

but i had sorted the records of the input by using the SYNCSORT control card

SORT FIELDS=(1,16,CH,A)
SUM FIELDS=NONE

BUT even then it is giving the same error.
can anyone suggest the correct solution

thank you

Manuneedhi K · Posted: Thu Jun 05, 2008 5:58 pm

Can you provide sample of the input data after sort.

chandrarkar · New User Joined: 27 May 2008 Posts: 24 Location: india

HI

the sample code after sort is

Craq Giegerich · Posted: Thu Jun 05, 2008 6:10 pm

That's not in sequence!

enrico-sorichetti · Posted: Thu Jun 05, 2008 6:10 pm

sorry to be picky, it does not look very sorted to me

chandrarkar · New User Joined: 27 May 2008 Posts: 24 Location: india

if u can see the above control card i have used,it has sorted them as i have coded it.
i have sorted the chars 1-16 only because thats the argument that's to be used as argument for the table.
can some one provide me the sol..

thank u

Craq Giegerich · Posted: Thu Jun 05, 2008 6:21 pm

Is the file a variable record length?

chandrarkar · New User Joined: 27 May 2008 Posts: 24 Location: india

yes its a VB(80 800)

Craq Giegerich · Posted: Thu Jun 05, 2008 6:44 pm

chandrarkar · New User Joined: 27 May 2008 Posts: 24 Location: india

i have used what u have given and its working.
might i forgot the fact that the first 4 bytes stores the record info

thanks for ur help

chandrarkar · New User Joined: 27 May 2008 Posts: 24 Location: india

i am not clear with if matched i think i have to check the processing tomo.
both the files have to be sorted i guess.
and i was thinking like that is more a one to one processing.
like
FILEA FILEB
A A
B B
C D
D C

A and A match so it matches
Same with B and C doesnt satisy
SO DOESNT MATCH.and while coming to D IN FILEA the pointer is pointing to C in FILEB . so i have an ambiguity as for will it match or not.
if it matches then its sure that the FILEB is bieng read from the top again.

lcmontanez · New User Joined: 19 Jun 2007 Posts: 50 Location: Chicago

sync processing require both files to be sort by the key.

chandrarkar · New User Joined: 27 May 2008 Posts: 24 Location: india

i tried using "matched" and found that
both the files should be soted before using "matched"

FILEA - HAS NO DUPS(THINK ITS THE MASTER)
FILEB - HAS DUPS

BOTH FILES SHOULD BE SORTED BEFORE USING MATCHED

NOW MY REQUIREMENT IS GETTING SATISFIED WHEN I USE "IF MATCHED (FILEA(KEY1)+
(FILEB(KEY2)) "
FOR EVERY KEY IN FILEB WE HAVE MANY DUP KEYS IN FILEB.
SO ITS ABLE TO MATCH WHEN USING THE ABOVE LOGIC.

EVEN IF THE FILE ORDER IN "IF MATCHED()()" IS CHANGED ITS NOT ABLE TO DO IT.

dick scherrer · Posted: Fri Jun 06, 2008 7:38 pm

This topic locked as it duplicates "need help in easytrieve-multiple reading of sequential file".

http://ibmmainframes.com/viewtopic.php?t=31286

d.sch.