Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Processing table in eastrieve

 
Post new topic   This topic is locked: you cannot edit posts or make replies.    IBMMAINFRAMES.com Support Forums -> CA Products
View previous topic :: :: View next topic  
Author Message
chandrarkar

New User


Joined: 27 May 2008
Posts: 24
Location: india

PostPosted: Thu Jun 05, 2008 5:45 pm    Post subject: Processing table in eastrieve
Reply with quote

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
Back to top
View user's profile Send private message

Manuneedhi K

Active User


Joined: 07 May 2008
Posts: 115
Location: Chennai

PostPosted: Thu Jun 05, 2008 5:58 pm    Post subject:
Reply with quote

Can you provide sample of the input data after sort.
Back to top
View user's profile Send private message
chandrarkar

New User


Joined: 27 May 2008
Posts: 24
Location: india

PostPosted: Thu Jun 05, 2008 6:05 pm    Post subject:
Reply with quote

HI

the sample code after sort is

Code:
 NNNNVNNNNNYNY40not known     
 NNNNVNYNNNYNY40not known     
 NNNNYNYINNNNY* not known     
 NYNNVNYNNNYNY40not known     
NNNNNNNNNNNYNN  not known     
NNNNNVNNNNNYNY60not known     
NYYNNVNYINNYNY40not known     
YNNYNVNYNNNNNY60not known     
YNNYNVNYNNNYNY60not known     
YNNYNVYYNNNYNY60not known     
YNYNNVNNNNNYNY40not known     
YYYYYYYYIYYYYY  not known     
5YYYYNYNYYNYY900Not Known     
9NNNNNNNNNNYNN40not known     
NNNNNNNNNNNNNY90cap90-cbr req 
NNNNNNNNNNNYNN40cap40-scn auth


thank u
Back to top
View user's profile Send private message
Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA

PostPosted: Thu Jun 05, 2008 6:10 pm    Post subject:
Reply with quote

That's not in sequence!
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10308
Location: italy

PostPosted: Thu Jun 05, 2008 6:10 pm    Post subject: Reply to: Processing table in eastrieve
Reply with quote

sorry to be picky, it does not look very sorted to me icon_biggrin.gif
Back to top
View user's profile Send private message
chandrarkar

New User


Joined: 27 May 2008
Posts: 24
Location: india

PostPosted: Thu Jun 05, 2008 6:13 pm    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA

PostPosted: Thu Jun 05, 2008 6:21 pm    Post subject:
Reply with quote

Is the file a variable record length?
Back to top
View user's profile Send private message
chandrarkar

New User


Joined: 27 May 2008
Posts: 24
Location: india

PostPosted: Thu Jun 05, 2008 6:25 pm    Post subject:
Reply with quote

yes its a VB(80 800)
Back to top
View user's profile Send private message
Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA

PostPosted: Thu Jun 05, 2008 6:44 pm    Post subject:
Reply with quote

chandrarkar wrote:
yes its a VB(80 800)

Sorting 1,16,ch,a sorts on the record length and 12 characters of data, try 5,16,ch,a.
Back to top
View user's profile Send private message
chandrarkar

New User


Joined: 27 May 2008
Posts: 24
Location: india

PostPosted: Thu Jun 05, 2008 6:56 pm    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
chandrarkar

New User


Joined: 27 May 2008
Posts: 24
Location: india

PostPosted: Thu Jun 05, 2008 10:25 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
lcmontanez

New User


Joined: 19 Jun 2007
Posts: 50
Location: Chicago

PostPosted: Thu Jun 05, 2008 11:36 pm    Post subject:
Reply with quote

sync processing require both files to be sort by the key.
Back to top
View user's profile Send private message
chandrarkar

New User


Joined: 27 May 2008
Posts: 24
Location: india

PostPosted: Fri Jun 06, 2008 12:05 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Jun 06, 2008 7:38 pm    Post subject: Reply to: Processing table in eastrieve
Reply with quote

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

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

d.sch.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   This topic is locked: you cannot edit posts or make replies.    IBMMAINFRAMES.com Support Forums -> CA Products All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Insert a Row_number into table useit DB2 2 Tue Sep 19, 2017 1:07 pm
No new posts how to see when the last read access ... Mike 1304 DB2 1 Tue Sep 12, 2017 7:52 pm
No new posts PC (UTF-8) -> z/OS (EBCDIC) -> ... prino All Other Mainframe Topics 4 Fri Sep 01, 2017 1:47 am
No new posts Adding a userid to SMTP Security table Yolanda Harvey JCL & VSAM 1 Sun Aug 13, 2017 6:16 pm
No new posts Loading data to table gives wrong for... Raghu navaikulam DB2 19 Thu Jul 13, 2017 2:11 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us