I am trying to join two files based on common field in wrkqry
in select records when i am trying to join based on select records and give condition like T01.fld1 EQ T02.FLD1
I get an error data types are not compatible. both fields are of 6 length but one is numeric and other is character.
Please advise how to get the join output based on these different data type fields specially in WRKQRY,however i know how to join them in join SQL query but i want to join them specially through WRKQRY only.
Pleople who are master in WRKQRY please advise how to make it possible in WRKQRY.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!