DB2 query results in Hex format -- Need Character/String
<p>I have a query that I can run on a DB2 table using my python SQL tester, and it returns the string values I'm looking for.<br>
However, when I run it directly on my database it returns a hex value.  Any help in getting the results as a character string would be greatly appreciated!<br>
Here is the field definition:</p>

<pre><code>ORCTL      CCDATA         243      A   14  256 Order Control File Data 
</code></pre>

<p>My query on the iSeries is:</p>

<pre><code>select ccdata from ORCTL where ccctlk = 'BUYRAK'
</code></pre>