×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Hi everyone
We are on V7r3
Because we have users cut and paste information from e-mails etc. into a screen - this data is then stored into a file on our system
When an attempt is made to display this information in a screen - we have a problem
That problem is due to the fact that the data that was cut and pasted contains non-displayable characters
We are attempting to rectify this situation by using SQL TRANSLATE
When the following is used
exec sql
set :StringOut = TRANSLATE (:StringIn, ' ',
x'0001020304050607080910111213141516171819+
2021222324252627282930313233343536373839');
It works
Sringin contains the data with the non-displayable characters
Stringout contains the data with the non-displayable characters removed
However, when I change it the code to the following
Exec sql
set :StringOut = TRANSLATE (:StringIn, ' ', :NonDisplayableChars);
This compiles okay - but the this does not work - STRINGOUT is spaces
However
SQLCODE = -171
SQLSTATE = 42815
This translates to
THE DATA TYPE LENGTH OR VALUE OF ARGUMENT OF IS INVALID
Can anyone see what is wrong with the second method, as I would MUCH prefer to use a variable (personal preference)
Alan Shore
Solutions Architect
IT Supply Chain Execution
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.