sql is select DBILIB library, DBIFIL filename, DBIFMT format, DBIFLD field, DBIATR pf_lf, DBIILN byte, DBIITP as_type, DBITYP sql_type, DBIPOS rang, DBICLN Char, DBINLN Digit, DBINSC decimals, DBIDLN DateLen,DBITXT Text, DBIHDG colsHeader FROM QSYS.QADBIFLD WHERE DBILIB='QSYS' and DBIFIL='QADBIFLD' ORDER BY DBIPOS
LIBRARY FILENAME FORMAT FIELD PF_LF BYTE AS_TYPE SQL_TYPE RANG CHAR DIGIT DECIMALS DATELEN TEXT COLSHEADER
QSYS QADBIFLD QDBIFLD DBILIB PF 10 A CHAR 1 10


Library name LIBRARY NAME
QSYS QADBIFLD QDBIFLD DBIFIL PF 10 A CHAR 2 10


File name FILE NAME
QSYS QADBIFLD QDBIFLD DBIFMT PF 10 A CHAR 3 10


Format name FORMAT NAME
QSYS QADBIFLD QDBIFLD DBIFLD PF 10 A CHAR 4 10


Field name FIELD NAME
QSYS QADBIFLD QDBIFLD DBIATR PF 2 A CHAR 5 2


PF-physical,LF-logical,TB-table,VW-view,IX-index FILE ATTR
QSYS QADBIFLD QDBIFLD DBIREL PF 1 A CHAR 6 1


Relational file: Y=Yes,N=No RELATIONAL FILE
QSYS QADBIFLD QDBIFLD DBILFI PF 130 A VARCHAR 7 128


Long file name LONG FILE NAME
QSYS QADBIFLD QDBIFLD DBIOWN PF 10 A CHAR 8 10


User profile name of owner FILE OWNER
QSYS QADBIFLD QDBIFLD DBILFL PF 130 A VARCHAR 9 128


Long field name LONG FIELD NAME
QSYS QADBIFLD QDBIFLD DBILFQ PF 1 A CHAR 10 1


Long field name is quoted FIELD NAME QUOTED
QSYS QADBIFLD QDBIFLD DBIINT PF 10 A CHAR 11 10


Internal field name INTERNAL FIELD NAME
QSYS QADBIFLD QDBIFLD DBIILN PF 4 B INTEGER 12
9 0
Internal length in bytes INTERNAL LENGTH
QSYS QADBIFLD QDBIFLD DBIITP PF 1 A CHAR 13 1


Internal data type INTERNAL TYPE
QSYS QADBIFLD QDBIFLD DBITYP PF 8 A CHAR 14 8


Data type FIELD TYPE
QSYS QADBIFLD QDBIFLD DBIPOS PF 2 B SMALLINT 15
4 0
Field position within format FIELD POSITION
QSYS QADBIFLD QDBIFLD DBIFLN PF 4 B INTEGER 16
9 0
SQL length of field FIELD LENGTH
QSYS QADBIFLD QDBIFLD DBICLN PF 4 B INTEGER 17
9 0
Character field length CHAR LENGTH
QSYS QADBIFLD QDBIFLD DBICNC PF 4 B INTEGER 18
9 0
Character field number of characters CHAR NUMBER CHARACTERS
QSYS QADBIFLD QDBIFLD DBICCC PF 4 B INTEGER 19
9 0
Character field CCSID CHAR CCSID
QSYS QADBIFLD QDBIFLD DBINLN PF 2 B SMALLINT 20
4 0
Numeric field precision NUMERIC LENGTH
QSYS QADBIFLD QDBIFLD DBINSC PF 2 B SMALLINT 21
4 0
Numeric field scale NUMERIC SCALE
QSYS QADBIFLD QDBIFLD DBIRDX PF 2 B SMALLINT 22
4 0
Precision: 2=Binary, 10=Decimal NUMERIC PRECISION RADIX
QSYS QADBIFLD QDBIFLD DBIDLN PF 2 B SMALLINT 23
4 0
Date/Time field precision DATE TIME PRECISION
QSYS QADBIFLD QDBIFLD DBITXT PF 52 A VARCHAR 24 50


Field text FIELD TEXT
QSYS QADBIFLD QDBIFLD DBIHDG PF 62 A VARCHAR 25 60


Field headings COLUMN HEADINGS
QSYS QADBIFLD QDBIFLD DBINUL PF 1 A CHAR 26 1


Allow NULL value: Y-Yes,N-No ALW NULL
QSYS QADBIFLD QDBIFLD DBIUPD PF 1 A CHAR 27 1


Allow UPDATE: Y-Yes,N-No ALW UPD
QSYS QADBIFLD QDBIFLD DBIREM PF 2002 A VARCHAR 28 2000


Long field description LONG DESCRIPTION
QSYS QADBIFLD QDBIFLD DBIDFI PF 1 A CHAR 29 1


Default indicator: Y-Yes,N-No DFT
QSYS QADBIFLD QDBIFLD DBIDFT PF 2002 A VARCHAR 30 2000


Field default value DEFAULT VALUE
QSYS QADBIFLD QDBIFLD DBIFMP PF 2 B SMALLINT 31
2 0
Position of format in file FORMAT POSITION
QSYS QADBIFLD QDBIFLD DBILB2 PF 130 A VARCHAR 32 128


Library name LIBRARY NAME
QSYS QADBIFLD QDBIFLD DBITLN PF 130 A VARCHAR 33 128


UDT Long Name UDT LONG NAME
QSYS QADBIFLD QDBIFLD DBITLB PF 130 A VARCHAR 34 128


UDT Library Name UDT LIBRARY
debug
ALIGN =
DATABASE =
DB_CASE =
DB2INSTANCE =
DB2MSGS =
DB2PLAN =
DB2PLAN =
DB2SSID =
DB2SSID =
DefaultDBCp =
DSNAOINI =
DTW_APPLET_ALTTEXT =
DTW_ATTACHMENT_PATH =
DTW_CACHE_HOST =
DTW_CACHE_MACRO =
DTW_CACHE_MANAGEMENT_INTERVAL =
DTW_CACHE_PAGE =
DTW_CACHE_PORT =
DTW_CM_PORT =
DTW_COBOL_PARAMETER_BUFFER_SIZE =
DTW_COBOL_PARAMETER_BUFFER_SIZE =
DTW_CURRENT_FILENAME = /vcehttp/sqlquery/macro.txt
DTW_CURRENT_LAST_MODIFIED = Mon Oct 24 15:35:18 2005
DTW_DEFAULT_ERROR_MESSAGE =
DTW_DEFAULT_MACRO =
DTW_DEFAULT_MESSAGE =
DTW_DEFAULT_REPORT =
DTW_DIRECT_REQUEST =
DTW_DO_NOT_CACHE_MACRO =
DTW_EDIT_CODES =
DTW_ERROR_LOG_DIR = /VCEHTTPT/sqlQuery/
DTW_ERROR_LOG_LEVEL = ALL
DTW_HTML_TABLE =
DTW_INST_DIR =
DTW_LOB_DIR =
DTW_LOB_LIFETIME =
DTW_LOG_DIR =
DTW_LOG_LEVEL =
DTW_LOG_LEVEL =
DTW_MACRO_FILENAME = /vcehttp/sqlquery/macro.txt
DTW_MACRO_LAST_MODIFIED = Mon Oct 24 15:35:18 2005
DTW_MBMODE =
DTW_MBMODE =
DTW_MP_PATH = /sqlquery/CGI
DTW_MP_VERSION = IBM-AS/400-NET.DATA
DTW_OUTPUT_DIR =
DTW_PAD_PGM_PARMS =
DTW_PRINT_HEADER =
DTW_REMOVE_WS =
DTW_REMOVE_WS =
DTW_SAVE_TABLE_IN =
DTW_SET_TOTAL_ROWS =
DTW_SHOWSQL =
DTW_SMTP_CHARSET =
DTW_SMTP_SERVER =
DTW_SQL_ISOLATION =
DTW_SQL_NAMING_MODE =
DTW_STORE_PAGE =
DTW_TRACE_LOG_DIR = /VCEHTTPT/sqlQuery/
DTW_TRACE_LOG_LEVEL = APPLICATION
DTW_UNICODE =
DTW_UPLOAD_DIR =
DTW_USE_DB2_PREPARE_CACHE =
DTW_USE_DB2_PREPARE_CACHE =
DTW_VARIABLE_SCOPE =
EXEC_PATH =
FFI_PATH =
HTML_PATH =
INCLUDE_PATH =
LOCATION =
LOGIN =
MACRO_PATH =
NLIST =
Nn =
NULL_RPT_FIELD =
NUM_COLUMNS =
NUM_ROWS =
PASSWORD =
RETURN_CODE = 0
ROW_NUM =
RPT_MAX_ROWS =
SHOWSQL =
SQL_CODE = 0
SQL_STATE = 00000
START_ROW_NUM =
TOTAL_ROWS =
TRANSACTION_SCOPE =

 
AUTH_TYPE=Basic
CGI_ASCII_CCSID=819
CGI_EBCDIC_CCSID=297
CGI_MODE=%%EBCDIC%%
CGI_OUTPUT_MODE=%%EBCDIC%%
CLASSPATH=.:/QIBM/ProdData/HTTPA/java/lib/servlet.jar:/QIBM/ProdData/Java400/ext
CONTENT_LENGTH=0
DOCUMENT_NAME=/QSYS.LIB/VCEHTTP.LIB/DB2WWW.PGM
DOCUMENT_ROOT=/QIBM/UserData/HTTPA/htdocs
DOCUMENT_URI=/sqlquery/CGI
EGID=108
EUID=141
FSCP=297
GATEWAY_INTERFACE=CGI/1.1
GID=108
HOME=/
HOSTID=153.112.118.10
HOSTNAME=XXX.NET
HOSTTYPE=powerpc
HTTPS=OFF
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, deflate
HTTP_CONNECTION=Keep-Alive
HTTP_HOST=153.112.118.10
HTTP_USER_AGENT=Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)
IBM_CCSID_VALUE=297
IFS=


JOBNAME=809665/QTMHHTTP/QZSHSH
LINENO=1
LOGNAME=EB10168
MACHTYPE=powerpc-ibm-os400
NETCP=819
OPTIND=1
OSTYPE=os400
PATH=/bin:/usr/bin:/usr/ucb:/usr/bsd:/usr/local/bin
PATH_INFO=/vcehttp/sqlquery/macro.txt/xml2
PATH_TRANSLATED=/vcehttp/sqlquery/macro.txt/xml2
PPID=6596
PS1=$
PS2=>
PS3=#?
PS4=+
PWD=/QSYS.LIB/VCEHTTP.LIB
QIBM_CCSID=0
QIBM_DESCRIPTOR_STDIN=CRLN=Y
QIBM_MULTI_THREADED=N
QIBM_USE_DESCRIPTOR_STDIO=Y
QSH_REDIRECTION_TEXTDATA=Y
QSH_VERSION=V5R2M0
QUERY_STRING=SQL=DBILIB%40library,%40DBIFIL%40filename,%40DBIFMT%40format,%40DBIFLD%40field,%40DBIATR%40pf_lf,%40DBIILN%40byte,%40DBIITP%40as_type,%40DBITYP%40sql_type,%40DBIPOS%40rang,%40DBICLN%40Char,%40DBINLN%40Digit,%40DBINSC%40decimals,%40DBIDLN%40DateLen,DBITXT%40Text,%40DBIHDG%40colsHeader%40FROM%40QSYS.QADBIFLD%40WHERE%40DBILIB='QSYS'%40and%40DBIFIL='QADBIFLD'%40ORDER%40BY%40DBIPOS
RANDOM=10773
REFERER=http://153.112.118.10/sqlquery/XslDebugger.htm
REFERER_URL=http://153.112.118.10/sqlquery/XslDebugger.htm
REMOTE_ADDR=153.112.119.155
REMOTE_PORT=1786
REMOTE_USER=EB10168
REQUEST_METHOD=GET
REQUEST_URI=/sqlquery/CGI/xml2?SQL=DBILIB%20library,%20DBIFIL%20filename,%20DBIFMT%20format,%20DBIFLD%20field,%20DBIATR%20pf_lf,%20DBIILN%20byte,%20DBIITP%20as_type,%20DBITYP%20sql_type,%20DBIPOS%20rang,%20DBICLN%20Char,%20DBINLN%20Digit,%20DBINSC%20decimals,%20DBIDLN%20DateLen,DBITXT%20Text,%20DBIHDG%20colsHeader%20FROM%20QSYS.QADBIFLD%20WHERE%20DBILIB='QSYS'%20and%20DBIFIL='QADBIFLD'%20ORDER%20BY%20DBIPOS
RULE_FILE=conf/httpd.conf
SCRIPT_FILENAME=/QSYS.LIB/VCEHTTP.LIB/DB2WWW.PGM
SCRIPT_NAME=/sqlquery/CGI
SERVER_ADDR=153.112.118.10
SERVER_ADMIN=[no address given]
SERVER_NAME=XXX.COM
SERVER_PORT=80
SERVER_PROTOCOL=HTTP/1.1
SERVER_SIGNATURE=
SERVER_SOFTWARE=Apache
SHLVL=1
TERMINAL_TYPE=PIPELINE
UID=141
UNIQUE_ID=Jk2z6JlwdgoAAAAmABkAAABk