https://communities.sas.com/t5/SAS-Procedures/VARCHAR-in-db2-table/m-p/72412#M20988 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.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc.<BR /> <BR /> Suggested Google advanced search argument, this topic / post:<BR /> <BR /> db2 table load z/os site:sas.com Wed, 15 Sep 2010 20:43:53 GMT sbb 2010-09-15T20:43:53Z https://communities.sas.com/t5/SAS-Procedures/VARCHAR-in-db2-table/m-p/72411#M20987 Hi,<BR /> 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.<BR /> <BR /> Any suggestions are appreciated. Wed, 15 Sep 2010 19:41:37 GMT https://communities.sas.com/t5/SAS-Procedures/VARCHAR-in-db2-table/m-p/72411#M20987 deleted_user 2010-09-15T19:41:37Z https://communities.sas.com/t5/SAS-Procedures/VARCHAR-in-db2-table/m-p/72412#M20988 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.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc.<BR /> <BR /> Suggested Google advanced search argument, this topic / post:<BR /> <BR /> db2 table load z/os site:sas.com Wed, 15 Sep 2010 20:43:53 GMT https://communities.sas.com/t5/SAS-Procedures/VARCHAR-in-db2-table/m-p/72412#M20988 sbb 2010-09-15T20:43:53Z