Posts: 13 Joined: Fri 10:54 am Has thanked: 0 time Been thanked: 0 time. How can indicate the o/p file as VB in Reformat fields? Bt when am using the above sysntax am unable to give the VB o/p file format. How to convert an FB file to VBI have 2 i/p files which are in VBI have to compare these two files for a perticular field and if match occures, I hav.įile 1 trans-idA Trans-idB 1-4 5-8-80 1234 4567 2345 6789 3456 9123 File B Trans-id 1- 17-20-4096 1234 3456 O/P FILE File C Trans-id 1-17-20-4096 4567 9123 I have used the below SORT join keys syntax JOINKEYS FILES=F1,FIELDS=(9,4,A) JOINKEYS FILES=F2,FIELDS=(21,4,A) REFORMAT FIELDS=(F2:5,16,F1:9,4,F2:25,4072) SORT FIELDS=COPY As the i/p files are in VB I have added 4 bytes. The VTOF or CONVERT and OUTREC operands of OUTFIL can be used to change. DFSORT can be used to do VB to FB conversion, when sorting, copying or merging.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |