|
View previous topic :: View next topic
|
| Author |
Message |
CICS Guy
Senior Member
Joined: 18 Jul 2007
Posts: 2146
Location: At my coffee table
|
|
|
|
| swapnadeep.ganguly wrote: |
| I got the successful execution of the job. |
| swapnadeep.ganguly wrote: |
I have having one more issue regarding the above problem...
Some junk value are getting written into the backup file. |
If you post the sysout of the successful execution, we might be able to help find the junk....... |
|
| Back to top |
|
 |
swapnadeep.ganguly
Active User
Joined: 21 Mar 2007
Posts: 203
Location: India
|
|
|
|
The SYSOUT of the successful execution is as under:
| Code: |
SYSIN :
SORT FIELDS=COPY
OUTFIL FNAMES=SORTOUT1,VTOF,OUTREC=(1,108)
WER276B SYSDIAG= 652870, 3242611, 3242611, 4252489
WER164B 8,944K BYTES OF VIRTUAL STORAGE AVAILABLE, MAX REQUESTED,
WER164B 0 BYTES RESERVE REQUESTED, 3,122,272 BYTES USED
WER146B 20K BYTES OF EMERGENCY SPACE ALLOCATED
WER108I SORTIN : RECFM=VB ; LRECL= 113; BLKSIZE= 27998
WER110I SORTOUT1 : RECFM=FB ; LRECL= 108; BLKSIZE= 27972
WER405I SORTOUT1 : DATA RECORDS OUT 151; TOTAL RECORDS OUT 151
WER211B SYNCSMF CALLED BY SYNCSORT; RC=0000
WER416B SORTIN : EXCP'S=1,UNIT=3390,DEV=19C6,CHP=(92959798999A9B9D,1),VOL=SMS1B0
WER416B OUTFIL WAS USED FOR SORTOUT
WER054I RCD IN 151, OUT 151
WER169I RELEASE 1.2 BATCH 0427 TPF LEVEL 1.1
WER052I END SYNCSORT - N48FF9AA,STEP01,,DIAG=AA00,7144,822C,00CE,E2C2,4CEA,8268,A6E0
|
|
|
| Back to top |
|
|
murmohk1
Senior Member
.jpg)
Joined: 29 Jun 2006
Posts: 1436
Location: Bangalore,India
|
|
|
|
Swapnadeep,
| Quote: |
SORT FIELDS=COPY
OUTFIL FNAMES=SORTOUT1,VTOF,OUTREC=(1,108) |
Why are you copying first 4 bytes into the OP file? Try again by replacing '1' with '5' in the above outrec statement.
'108' is the record length thats gets copied from IP to OP. So you may to have adjust this when you change 1 to 5. |
|
| Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
DFSORT is NOT shipped as a valid name for invoking the DFSORT product. You should use PGM=ICEMAN or PGM=SORT. (Some sites assign DFSORT as an alias but your site obviously hasn't). The correct DFSORT job would be something like this:
| Code: |
//STEP01 EXEC PGM=ICEMAN,COND=(0,LT)
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN=... input file
//OUT DD DSN=... output file
//SYSIN DD *
SORT FIELDS=(1,4,CH,A)
OUTFIL FNAMES=OUT,VTOF,OUTREC=(1,108)
/*
|
Note that 1,108 would include the RDW from the VB records. You probably don't want that in your FB records. |
|
| Back to top |
|
|
Douglas Wilder
Active User
.jpg)
Joined: 28 Nov 2006
Posts: 305
Location: Deerfield IL
|
|
|
|
I think you want OUTREC=(1:5,108).
If you do not need to sort the file SORT FIELDS=COPY will work fine in place of SORT FIELDS=COPY.
Note that with length 108 you are still cutting off byte 109. Check to see if this contains needed data. |
|
| Back to top |
|
|
annujp
New User
.jpg)
Joined: 31 Aug 2005
Posts: 39
Location: St Paul,MN
|
|
|
|
Your sort card is correct. Your shop would not have DFSORT. That is the reason for the abend.
Try using EXEC PGM = SYNCSORT with the same sort card. That worked for me.
If you are sure you have DFSORT in your shop, you can try giving a steplib with the appropriate system load library.
Let me know if this helps.
Thanks
Anitha |
|
| Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
| Quote: |
| Your shop would not have DFSORT. That is the reason for the abend. |
No, the reason for the ABEND is the use of PGM=DFSORT. This is NOT a valid way to invoke DFSORT or Syncsort. PGM=SORT or PGM=ICEMAN is the correct way and will invoke the sort product at the site, which in this case happens to be Syncsort. PGM=SYNCSORT will work for Syncsort, but not DFSORT unless SYNCSORT is set up as an alias for DFSORT by the site. It's best to use PGM=SORT or PGM=ICEMAN neither of which requires that the site set up an alias. |
|
| Back to top |
|
|
CICS Guy
Senior Member
Joined: 18 Jul 2007
Posts: 2146
Location: At my coffee table
|
|
|
|
I am always amazed how people offer advice before reading enough of the thread to determine if the advice is correct or even needed....  |
|
| Back to top |
|
|
annujp
New User
Joined: 31 Aug 2005
Posts: 39
Location: St Paul,MN
|
|
|
|
There is no way to delete the messages after posting them. And its not immediately clear how many pages are there in the post.
It would be great if senior members do not ridicule people who are trying to help others. Also i dont see how a statement like this could help with the question asked in the forum.
Thanks
Anitha |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10888
Location: italy
|
|
|
|
| Quote: |
| ... Also i dont see how a statement like this could help with the question asked in the forum. |
It does not help with the current question,
but it might help to have in the future a better quality of answers,
dont' t You agree that 33 follow-on to convert a vb to a fb are really too much |
|
| Back to top |
|
|
CICS Guy
Senior Member
Joined: 18 Jul 2007
Posts: 2146
Location: At my coffee table
|
|
|
|
| annujp wrote: |
There is no way to delete the messages after posting them. And its not immediately clear how many pages are there in the post.
It would be great if senior members do not ridicule people who are trying to help others. Also i dont see how a statement like this could help with the question asked in the forum. |
Anitha,
If you would follow the thread to its current status, you would know if you are making a "stupid" statement or actually advising good help....
The choice is yours, either deal with it or not.....
My advice is to:
Read the entire thread before you post;
Think before you post;
Preview before you post;
And post when you have questions or potential solutions. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19243
Location: Inside the Matrix
|
|
|
|
Helo Anitha,
If you post something you are later not satisfied with, you can contact the moderator of that part of the forum or one of us "senior moderators" via PM and request a correction or removal of the post.
We "seniors" get ahead of ourselves sometimes also  |
|
| Back to top |
|
|
stodolas
Active Member
Joined: 13 Jun 2007
Posts: 631
Location: Wisconsin
|
|
|
|
| If you are getting junk values, are they really junk or are they packed? DB2 store numbers in some COMP format and most utilities unload them as such so they can be efficiently loaded into a different table, unless you specify otherwise. |
|
| Back to top |
|
|
swapnadeep.ganguly
Active User
Joined: 21 Mar 2007
Posts: 203
Location: India
|
|
|
|
Actually we are not having these datas in the tables. But they are appearing in the flat files.
E.g.: The table's first column is a date (say, 01-01-1999) but when we download this table into the file we are getting as " X01-01-1999" ie the first column in the file is space while the second column is X which is not present in the table.
Moreover, can you please let me know how I can remove this? |
|
| Back to top |
|
|
murmohk1
Senior Member
Joined: 29 Jun 2006
Posts: 1436
Location: Bangalore,India
|
|
|
|
Swapnadeep,
| Quote: |
The table's first column is a date (say, 01-01-1999) but when we download this table into the file we are getting as " X01-01-1999" ie the first column in the file is space while the second column is X which is not present in the table.
|
Use OUTREC for truncating the data as per your wish. |
|
| Back to top |
|
|
Douglas Wilder
Active User
Joined: 28 Nov 2006
Posts: 305
Location: Deerfield IL
|
|
|
|
I will repost my previous post because I believe it has your answer. The first 4 bytes are the length of the variable length record. To remove them use the following.
I think you want OUTREC=(1:5,108).
If you do not need to sort the file SORT FIELDS=COPY will work fine in place of SORT FIELDS=COPY.
Note that with length 108 you are still cutting off byte 109. Check to see if this contains needed data. |
|
| Back to top |
|
|
swapnadeep.ganguly
Active User
Joined: 21 Mar 2007
Posts: 203
Location: India
|
|
|
|
I think I cannot make myself clear to you Guru's.
My question is while we use the IBM Utility DSNUTILB, do we get a junk value in the first two columns of the generated dataset?
After following the method you all suggested, I was able to generate the file without the junk characters. |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10888
Location: italy
|
|
|
|
| Quote: |
| My question is while we use the IBM Utility DSNUTILB, do we get a junk value in the first two columns of the generated dataset? |
Why do You ask a question which You already replied by Yourself,
the original program, AS YOU SAID, creates a VB ( variable blocked ) dataset
what You consider JUNK ( garbage/useless things) is the most important component of VB organization...
THE LENGHT OF THE RECORD |
|
| Back to top |
|
|
|
|
