VB to VB copy with conditions.
Posted: Fri Sep 04, 2015 2:46 pm
Hi,
I have one requirement. I want to extract only specific fields based on some criteria from VB file to another VB file.
I want to extract the records which are having salary greater than 200000 or Designation as Quality Engineer to Variable block file.
But it writes all the records from inout to output. Can you please guie on this.
I have one requirement. I want to extract only specific fields based on some criteria from VB file to another VB file.
Code: Select all
Field name Length Type Starting Positions
Exepno 7 Numeric 1
Exename 20 Character 10
Salary 8 Float(9(6)v99) 32
Designation 20 Character 41
Code: Select all
SORT FIELDS=(45,20,CH,A)
INCLUDE COND=((36,8,PD,GE,200000),OR,
(45,20,CH,EQ,C'QUALITY ENGINEER'))