Navdeep Kaur
New Member
Hi all,
I am trying to generate a report in which varaible is used which takes data from a column of a table which is define with character datatye, when i am using this variable in put stream with format "X(30)" this is Showing only 8 character in the variable but I need all 30 character, i tried substring function also.
DEFINE STREAM st.
DEFINE VARIABLE v-des AS CHARACTER format "X(30)" NO-UNDO.
v-des = Substring(xyz.abc,1,30).
INPUT THROUGH VALUE("uname -s").
IMPORT v-os.
INPUT CLOSE.
IF v-os = "UnixWare" THEN DO:
OUTPUT STREAM st-output THROUGH VALUE('mail -s "** XYZ report **" ' + v-user).
END.
Put stream st v-des at 23.
I am trying to generate a report in which varaible is used which takes data from a column of a table which is define with character datatye, when i am using this variable in put stream with format "X(30)" this is Showing only 8 character in the variable but I need all 30 character, i tried substring function also.
DEFINE STREAM st.
DEFINE VARIABLE v-des AS CHARACTER format "X(30)" NO-UNDO.
v-des = Substring(xyz.abc,1,30).
INPUT THROUGH VALUE("uname -s").
IMPORT v-os.
INPUT CLOSE.
IF v-os = "UnixWare" THEN DO:
OUTPUT STREAM st-output THROUGH VALUE('mail -s "** XYZ report **" ' + v-user).
END.
Put stream st v-des at 23.