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