RE: Converting VARCHAR fields

Would it help if you used %trim() on your fields?   
 
---------------------------------
Booth Martin
http://www.martinvt.com
---------------------------------
-------Original Message-------
 
From: RPG programming on the AS400 / iSeries
Date: 10/03/05 13:55:27
To: RPG programming on the AS400 / iSeries
Subject: RE: Converting VARCHAR fields
 
Hi,
      OK, I must still be missing something. I have tried all the
suggestions and my output file still shows the field as  *01138. This is my
new code:
 
H OPTION(*NODEBUGIO: *SRCSTMT)
D InEmp              S             25A   Varying
D WkEmp           S             25
D String          DS
D  Length                              5I 0
D  Data                             255
C                   EVAL      Data = InEmp
C                   EVAL      WkEmp = Data
 
Not using the DS doesn't seem to work either. I had
C                   EVAL      WkEmp = InEmp
 
Both ways, I still have unprintable characters at the beginning of the
field. From all I have read, this should be a no brainer.
I am calling this from SQL and the program has been made into a stored
procedure. This is the call statement:
CALL V64BPCSUSR/SVLBRNEW (246065, 10, X'0005F0F1F1F3F8')
 
I don't know if that is what is causing the problem or not. What am I doing
wrong?
 
<===================================================>
 
Terri Harteau
Felker Brothers Corporation
****************
"The happiest people don't necessarily have the best of everything.
They just make the best of everything!"
****************
 
 
 
 
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.
 
.