Hi,
I am reading a column which is declared as char(60) from the source db2 table in SAS in os/z environment and creating a load file for another db2 table using SAS. In destination db2 table the same column is declared as VARCHAR(60). The db2 load utility fails and does not like this field in the load file. So my question is how to convert a character field to varchar field before i write to file.
What is the exact error message you are getting and it would be best shared as part of a SAS-generated log with your code fully revealed.
Scott Barry
SBBWorks, Inc.
Suggested Google advanced search argument, this topic / post:
db2 table load z/os site:sas.com
Ready to join fellow brilliant minds for the SAS Hackathon?
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.