IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Processing table in eastrieve


IBM Mainframe Forums -> CA Products
Post new topic   This topic is locked: you cannot edit posts or make replies.
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
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
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
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
Reply with quote

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

Superior Member


Joined: 14 Mar 2007
Posts: 10833
Location: italy

PostPosted: Thu Jun 05, 2008 6:10 pm
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
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
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
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
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
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
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
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
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

Moderator Emeritus


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

PostPosted: Fri Jun 06, 2008 7:38 pm
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. View Bookmarks
All times are GMT + 6 Hours
Forum Index -> CA Products

 


Similar Topics
Topic Forum Replies
No new posts Read a flat file and update DB2 table JCL & VSAM 2
No new posts Search substring in internal table of... COBOL Programming 2
This topic is locked: you cannot edit posts or make replies. Write from flat file to db2 table Mainframe Interview Questions 5
No new posts Table Information - DB2 DB2 1
No new posts Converting S9(18) value to a decimal ... DFSORT/ICETOOL 6
Search our Forums:

Back to Top