Posted: Wed Dec 18, 2002 3:13 am Post subject: STATEMENT DEFINER ERROR
The Job below is just for testing, but I faced this problem "STATEMENT DEFINER ERROR @ the second COPY statement", when i executed this job. Can someone please tell me as to where am i going wrong.
Joined: 26 Nov 2002 Posts: 12376 Topics: 75 Location: San Jose
Posted: Wed Dec 18, 2002 4:20 am Post subject:
Rajvasan,
All your control cards should start after position 1. Here in your job you are dynamically creating the control cards.The first copy is creating a control card as follows.
Code:
OUTREC=(C'OUTFIL FNAMES=OUT,OUTREC=(1,4)',80:X)
which looks like after the creation
Code:
OUTFIL FNAMES=OUT,OUTREC=(1,4)
Note that your control cards starts now in position 1. That is the reason for your statement definition error. so change your control cards to be as follows:
Code:
OUTREC=(C' OUTFIL FNAMES=OUT,OUTREC=(1,4)',80:X)
Notice the space before outfil.
You can even code it as follows
Code:
OUTREC=(X,C'OUTFIL FNAMES=OUT,OUTREC=(1,4)',80:X)
Here I used X to denote a space and then followed by the actual statement.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum