View previous topic :: View next topic
|
Author |
Message |
swapnadeep.ganguly
Active User
Joined: 21 Mar 2007 Posts: 203 Location: India
|
|
|
|
Hi,
I want to download from a db2 based table. For the same I am providing the file name with the following parameters.
Code: |
//UTIL EXEC DSNUTDH1,SYSTEM=TDH1,UID='PV5240A',UTPROC=''
//DSNUTDH1.SYSREC DD DSN=PV5240A.DB2.CARR.MKT.DTL,
// DISP=(NEW,CATLG,DELETE),
// DCB=(RECFM=FB,LRECL=108),
// SPACE=(CYL,(20,20),,,ROUND)
//*
//*
//DSNUTDH1.SYSLISTD DD DSN=PV5240A.DB2.CARR.DEFENIT,
// DCB=(RECFM=FB,LRECL=108,BLKSIZE=0,DSORG=PS),
// DISP=(NEW,CATLG,DELETE),UNIT=DISK,
// SPACE=(CYL,(10,10),RLSE)
//*
|
After the downloading is complete, I am trying to copy the data file into the GDG base whose definition is as follow:
Code: |
//STEP02 EXEC PGM=IEBGENER,COND=(0,LT)
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SYSIN DD DUMMY
//SYSUT1 DD DSN=PV5240A.DB2.CARR.MKT.DTL,DISP=(SHR,CATLG,DELETE)
//SYSUT2 DD DSN=PV5240A.DB2.CARR.MKT.BKUP(+1),
// DISP=(NEW,CATLG,DELETE),
// SPACE=(CYL,(20,20),,,ROUND),
// DCB=(RECFM=FB,LRECL=108)
/*
|
But when I try to execute the above job, the job abends with a MAXCC=12. In the spool I am getting the following error display:
Code: |
DATA SET UTILITY - GENERATE
IEB311I CONFLICTING DCB PARAMETERS
|
When i checked out the data file's parameters, I found that to be of VB instead of FB and its LRECL is 113 instead of 108. |
|
Back to top |
|
|
murmohk1
Senior Member
Joined: 29 Jun 2006 Posts: 1436 Location: Bangalore,India
|
|
|
|
Swapnadeep,
One of the possibel reasons for your error-
Quote: |
The output logical record length is different from the input logic
record length or the input record format is variable and the output
record format is fixed when editing is not specified. Refer to z/OS
DFSMSdfp Utilities, SC26-7414, section ''Changing Logical Record
Length'' under IEBGENER |
Verify your IP and OP file attributes. |
|
Back to top |
|
|
swapnadeep.ganguly
Active User
Joined: 21 Mar 2007 Posts: 203 Location: India
|
|
|
|
Hi Murali,
Can you please be a bit more ellaborative?
I have already specified that the type of data file(PV5240A.DB2.CARR.MKT.DTL) that I am creating is of the VB type with LRECL of 113.
But I mentioned it in my JCL to be of FB type with a LRECL of 108. |
|
Back to top |
|
|
murmohk1
Senior Member
Joined: 29 Jun 2006 Posts: 1436 Location: Bangalore,India
|
|
|
|
Swapnadeep,
You cannot SIMPLY convert FB to VB or vice-versa.
If you need to do this, search DFSORT forum.... you will get info on conversion. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
DSNUTDH1 will generate its own dcb parms, regardless of what you put in your jcl.............. |
|
Back to top |
|
|
swapnadeep.ganguly
Active User
Joined: 21 Mar 2007 Posts: 203 Location: India
|
|
|
|
Then the best method is to change the file into FB format with my required LRECL using the DFSORT.
Then shall i proceed to copy this changed file into my GDG? |
|
Back to top |
|
|
murmohk1
Senior Member
Joined: 29 Jun 2006 Posts: 1436 Location: Bangalore,India
|
|
|
|
Swapnadeep,
Quote: |
Then shall i proceed to copy this changed file into my GDG? |
Why do you need one more step? You can directly copy the data into GDG GENERATION using the SORT (during conversion itself). |
|
Back to top |
|
|
swapnadeep.ganguly
Active User
Joined: 21 Mar 2007 Posts: 203 Location: India
|
|
|
|
Please correct me if I am going wrong any where in the following piece of code:
Code: |
//STEP01 EXEC PGM=DFSORT,COND=(0,LT)
//SYSIN DD *
SORT FIELDS=(1,4,CH,A)
OUTFIL FNAMES=PV5240A.DB2.CARR.MKT.BKUP(+1),VTOF,OUTREC=(1,108)
//
|
|
|
Back to top |
|
|
murmohk1
Senior Member
Joined: 29 Jun 2006 Posts: 1436 Location: Bangalore,India
|
|
|
|
Swapnadeep,
Quote: |
OUTFIL FNAMES=PV5240A.DB2.CARR.MKT.BKUP(+1),VTOF,OUTREC=(1,108) |
Wrong. Go thru the outfil syntax. |
|
Back to top |
|
|
swapnadeep.ganguly
Active User
Joined: 21 Mar 2007 Posts: 203 Location: India
|
|
|
|
The synatx is:
SORT FIELDS=(7,8,CH,A)
OUTFIL FNAMES=FB1,VTOF,OUTREC=(5,76)
Now as per my understanding, FB1 stands for the output file name. Outrec specifies the LRECL.
Please correct me if i am wrong in my understanding. |
|
Back to top |
|
|
murmohk1
Senior Member
Joined: 29 Jun 2006 Posts: 1436 Location: Bangalore,India
|
|
|
|
Ok. |
|
Back to top |
|
|
swapnadeep.ganguly
Active User
Joined: 21 Mar 2007 Posts: 203 Location: India
|
|
|
|
So I have done the above piece of code correctly
i.e OUTFIL FNAMES=PV5240A.DB2.CARR.MKT.BKUP(+1),VTOF,OUTREC=(1,108) part is correct in syntax??? |
|
Back to top |
|
|
murmohk1
Senior Member
Joined: 29 Jun 2006 Posts: 1436 Location: Bangalore,India
|
|
|
|
I belive so. |
|
Back to top |
|
|
swapnadeep.ganguly
Active User
Joined: 21 Mar 2007 Posts: 203 Location: India
|
|
|
|
I am getting a system abend of 806. The details as obtained from spool is:
Code: |
CSV003I REQUESTED MODULE DFSORT NOT FOUND
CSV028I ABEND806-04 JOBNAME=Pv5240AA STEPNAME=STEP01
IEA995I SYMPTOM DUMP OUTPUT
SYSTEM COMPLETION CODE=806 REASON CODE=00000004 |
|
|
Back to top |
|
|
murmohk1
Senior Member
Joined: 29 Jun 2006 Posts: 1436 Location: Bangalore,India
|
|
|
|
Swapnadeep,
Quote: |
CSV003I REQUESTED MODULE DFSORT NOT FOUND |
Probably this might give some idea about the error. |
|
Back to top |
|
|
swapnadeep.ganguly
Active User
Joined: 21 Mar 2007 Posts: 203 Location: India
|
|
|
|
I am getting the idea that the module DFSORT is not available. So how can I proceed next?
Is this a system utility defined by IBM? |
|
Back to top |
|
|
murmohk1
Senior Member
Joined: 29 Jun 2006 Posts: 1436 Location: Bangalore,India
|
|
Back to top |
|
|
CICS Guy
Senior Member
Joined: 18 Jul 2007 Posts: 2146 Location: At my coffee table
|
|
|
|
swapnadeep.ganguly wrote: |
I am getting the idea that the module DFSORT is not available. So how can I proceed next?
Is this a system utility defined by IBM? |
Your shop may not have IBM's DFSORT, use the standard name of SORT and it should point to the availible version..... |
|
Back to top |
|
|
swapnadeep.ganguly
Active User
Joined: 21 Mar 2007 Posts: 203 Location: India
|
|
|
|
Hi,
I am using the following piece of code as per the forum
Code: |
//STEP01 EXEC PGM=SORT,COND=(0,LT)
//SORTIN DD DSN=N48FF9.DB2.CARR.MKT.DTL,DISP=SHR
//SORTOUT1 DD DSN=N48FF9.DB2.CARR.MKT.BKUP(+1),
// DISP=(NEW,CATLG,DELETE),
// RECFM=FB,LRECL=108,
// SPACE=(CYL,(20,20),,,ROUND)
//SYSIN DD *
SORT FIELDS=COPY
OUTFIL FNAMES=N48FF9.DB2.CARR.MKT.BKUP(+1),VTOF,OUTREC=(1,108)
/*
//SYSOUT DD SYSOUT=*
//SYSDUMP DD SYSOUT=*
|
But I am getting an abend. The error as described in the spool is:
Code: |
SYSIN :
SORT FIELDS=COPY
*
OUTFIL FNAMES=N48FF9.DB2.CARR.MKT.BKUP(+1),VTOF,OUTREC=(1,108)
*
WER275A NO KEYWORDS FOUND ON CONTROL STATEMENT
WER275A NO KEYWORDS FOUND ON CONTROL STATEMENT
WER211B SYNCSMF CALLED BY SYNCSORT; RC=0000 |
|
|
Back to top |
|
|
murmohk1
Senior Member
Joined: 29 Jun 2006 Posts: 1436 Location: Bangalore,India
|
|
|
|
Swapnadeep,
Dont you think you are repeating the OUTFIL syntax error again and again? |
|
Back to top |
|
|
CICS Guy
Senior Member
Joined: 18 Jul 2007 Posts: 2146 Location: At my coffee table
|
|
|
|
Swapnadeep,
You need at least one space in front of the control statement.
murmohk1 wrote: |
Dont you think you are repeating the OUTFIL syntax error again and again? |
Real helpful.... |
|
Back to top |
|
|
swapnadeep.ganguly
Active User
Joined: 21 Mar 2007 Posts: 203 Location: India
|
|
|
|
Murali,
Previously you had told that my understanding for the syntax of OUTFIL statement was correct. Can you please let me know exactly where i am going wrong? |
|
Back to top |
|
|
murmohk1
Senior Member
Joined: 29 Jun 2006 Posts: 1436 Location: Bangalore,India
|
|
|
|
Swapnadeep,
Quote: |
Previously you had told that my understanding for the syntax of OUTFIL statement was correct. |
In your prev example, FB1 is a ddname and not the actual OP file name. |
|
Back to top |
|
|
swapnadeep.ganguly
Active User
Joined: 21 Mar 2007 Posts: 203 Location: India
|
|
|
|
Thank you all.
I got the successful execution of the job. |
|
Back to top |
|
|
swapnadeep.ganguly
Active User
Joined: 21 Mar 2007 Posts: 203 Location: India
|
|
|
|
I have having one more issue regarding the above problem...
Some junk value are getting written into the backup file.
E.g. the following is the extract from the data file(Variable block file)
Code: |
***************************** Top of Data ******************************
³1920-01-012005-08-03 2005-08-03 9999-12-31National Accounts - SAM/CAD
³1920-01-012005-08-03 2005-08-03 9999-12-31NAG - Special Program
³1920-01-012005-08-03 2005-08-03 9999-12-31Specialty - GULF
³1920-01-012005-08-03 2005-08-03 9999-12-31National - Canada
|
However the extract from the GDG based Fixed block file is as under:
Code: |
***************************** Top of Data ******************************
É ³1920-01-012005-08-03 2005-08-03 9999-12-31National Accounts - SAM
É ³1920-01-012005-08-03 2005-08-03 9999-12-31NAG - Special Program
É ³1920-01-012005-08-03 2005-08-03 9999-12-31Specialty - GULF
É ³1920-01-012005-08-03 2005-08-03 9999-12-31National - Canada
|
Can you please let me know how can i remove these junk value from my file? |
|
Back to top |
|
|
|