Shell Programming and Scripting

.LOGON 
.EXPORT file=export.txt;
SELECT CAST(('' ||
(CAST('UD ' AS CHAR(3))) || 
(CAST(B.column1 AS CHAR(2))) ||
:
:
(CAST(B.columnN AS CHAR(6)),''))) AS CHAR(550)) (title '')
FROM Table1;
.EXPORT RESET;
.LOGOFF;

SELECT ColumnID, ColumnLength, ColumnType, ColumnName,
CASE
WHEN ColumnType = 'CF' THEN ColumnLength -- char
WHEN ColumnType = 'CV' THEN ColumnLength / 2 --varchar
WHEN ColumnType = 'I' THEN 11 --integer
WHEN ColumnType = 'I1' THEN 4 --byte integer
WHEN ColumnType = 'I2' THEN 6 --small integer
WHEN ColumnType = 'D' THEN 19 --decimal
WHEN ColumnType = 'F' THEN 19 --float
WHEN ColumnType = 'DA' THEN 10 --date
WHEN ColumnType = 'TS' THEN 19 -- timestamp
ELSE NULL
END
AS RealColumnLength
FROM dbc.COLUMNS
WHERE dbc.COLUMNS.tableName = 'YOUR_TABLE'
ORDER BY ColumnID