<?xml
version="1.0"?>
<?xml-stylesheet type="text/xsl"
href="/sqlquery/htm/QuestionnerXml.xsl" ?>
<SQL>
<SELECT>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</SELECT>
<TABLE>
<COLS>
<COLNAME>LIBRARY</COLNAME>
<COLNAME>FILENAME</COLNAME>
<COLNAME>FORMAT</COLNAME>
<COLNAME>FIELD</COLNAME>
<COLNAME>PF_LF</COLNAME>
<COLNAME>BYTE</COLNAME>
<COLNAME>AS_TYPE</COLNAME>
<COLNAME>SQL_TYPE</COLNAME>
<COLNAME>RANG</COLNAME>
<COLNAME>CHAR</COLNAME>
<COLNAME>DIGIT</COLNAME>
<COLNAME>DECIMALS</COLNAME>
<COLNAME>DATELEN</COLNAME>
<COLNAME>TEXT</COLNAME>
<COLNAME>COLSHEADER</COLNAME>
</COLS>
<ROWS>
<ROW>
<CELL><LIBRARY>QSYS</LIBRARY></CELL>
<CELL><FILENAME>QADBIFLD</FILENAME></CELL>
<CELL><FORMAT>QDBIFLD</FORMAT></CELL>
<CELL><FIELD>DBILIB</FIELD></CELL>
<CELL><PF_LF>PF</PF_LF></CELL>
<CELL><BYTE>10</BYTE></CELL>
<CELL><AS_TYPE>A</AS_TYPE></CELL>
<CELL><SQL_TYPE>CHAR</SQL_TYPE></CELL>
<CELL><RANG>1</RANG></CELL>
<CELL><CHAR>10</CHAR></CELL>
<CELL><DIGIT></DIGIT></CELL>
<CELL><DECIMALS></DECIMALS></CELL>
<CELL><DATELEN></DATELEN></CELL>
<CELL><TEXT>Library
name</TEXT></CELL>
<CELL><COLSHEADER>LIBRARY
NAME</COLSHEADER></CELL>
</ROW>
<ROW>
<CELL><LIBRARY>QSYS</LIBRARY></CELL>
<CELL><FILENAME>QADBIFLD</FILENAME></CELL>
<CELL><FORMAT>QDBIFLD</FORMAT></CELL>
<CELL><FIELD>DBIFIL</FIELD></CELL>
<CELL><PF_LF>PF</PF_LF></CELL>
<CELL><BYTE>10</BYTE></CELL>
<CELL><AS_TYPE>A</AS_TYPE></CELL>
<CELL><SQL_TYPE>CHAR</SQL_TYPE></CELL>
<CELL><RANG>2</RANG></CELL>
<CELL><CHAR>10</CHAR></CELL>
<CELL><DIGIT></DIGIT></CELL>
<CELL><DECIMALS></DECIMALS></CELL>
<CELL><DATELEN></DATELEN></CELL>
<CELL><TEXT>File
name</TEXT></CELL>
<CELL><COLSHEADER>FILE
NAME</COLSHEADER></CELL>
</ROW>
<ROW>
<CELL><LIBRARY>QSYS</LIBRARY></CELL>
<CELL><FILENAME>QADBIFLD</FILENAME></CELL>
<CELL><FORMAT>QDBIFLD</FORMAT></CELL>
<CELL><FIELD>DBIFMT</FIELD></CELL>
<CELL><PF_LF>PF</PF_LF></CELL>
<CELL><BYTE>10</BYTE></CELL>
<CELL><AS_TYPE>A</AS_TYPE></CELL>
<CELL><SQL_TYPE>CHAR</SQL_TYPE></CELL>
<CELL><RANG>3</RANG></CELL>
<CELL><CHAR>10</CHAR></CELL>
<CELL><DIGIT></DIGIT></CELL>
<CELL><DECIMALS></DECIMALS></CELL>
<CELL><DATELEN></DATELEN></CELL>
<CELL><TEXT>Format
name</TEXT></CELL>
<CELL><COLSHEADER>FORMAT
NAME</COLSHEADER></CELL>
</ROW>
<ROW>
<CELL><LIBRARY>QSYS</LIBRARY></CELL>
<CELL><FILENAME>QADBIFLD</FILENAME></CELL>
<CELL><FORMAT>QDBIFLD</FORMAT></CELL>
<CELL><FIELD>DBIFLD</FIELD></CELL>
<CELL><PF_LF>PF</PF_LF></CELL>
<CELL><BYTE>10</BYTE></CELL>
<CELL><AS_TYPE>A</AS_TYPE></CELL>
<CELL><SQL_TYPE>CHAR</SQL_TYPE></CELL>
<CELL><RANG>4</RANG></CELL>
<CELL><CHAR>10</CHAR></CELL>
<CELL><DIGIT></DIGIT></CELL>
<CELL><DECIMALS></DECIMALS></CELL>
<CELL><DATELEN></DATELEN></CELL>
<CELL><TEXT>Field
name</TEXT></CELL>
<CELL><COLSHEADER>FIELD
NAME</COLSHEADER></CELL>
</ROW>
<ROW>
<CELL><LIBRARY>QSYS</LIBRARY></CELL>
<CELL><FILENAME>QADBIFLD</FILENAME></CELL>
<CELL><FORMAT>QDBIFLD</FORMAT></CELL>
<CELL><FIELD>DBIATR</FIELD></CELL>
<CELL><PF_LF>PF</PF_LF></CELL>
<CELL><BYTE>2</BYTE></CELL>
<CELL><AS_TYPE>A</AS_TYPE></CELL>
<CELL><SQL_TYPE>CHAR</SQL_TYPE></CELL>
<CELL><RANG>5</RANG></CELL>
<CELL><CHAR>2</CHAR></CELL>
<CELL><DIGIT></DIGIT></CELL>
<CELL><DECIMALS></DECIMALS></CELL>
<CELL><DATELEN></DATELEN></CELL>
<CELL><TEXT>PF-physical,LF-logical,TB-table,VW-view,IX-index</TEXT></CELL>
<CELL><COLSHEADER>FILE
ATTR</COLSHEADER></CELL>
</ROW>
<ROW>
<CELL><LIBRARY>QSYS</LIBRARY></CELL>
<CELL><FILENAME>QADBIFLD</FILENAME></CELL>
<CELL><FORMAT>QDBIFLD</FORMAT></CELL>
<CELL><FIELD>DBIREL</FIELD></CELL>
<CELL><PF_LF>PF</PF_LF></CELL>
<CELL><BYTE>1</BYTE></CELL>
<CELL><AS_TYPE>A</AS_TYPE></CELL>
<CELL><SQL_TYPE>CHAR</SQL_TYPE></CELL>
<CELL><RANG>6</RANG></CELL>
<CELL><CHAR>1</CHAR></CELL>
<CELL><DIGIT></DIGIT></CELL>
<CELL><DECIMALS></DECIMALS></CELL>
<CELL><DATELEN></DATELEN></CELL>
<CELL><TEXT>Relational
file: Y=Yes,N=No</TEXT></CELL>
<CELL><COLSHEADER>RELATIONAL
FILE</COLSHEADER></CELL>
</ROW>
<ROW>
<CELL><LIBRARY>QSYS</LIBRARY></CELL>
<CELL><FILENAME>QADBIFLD</FILENAME></CELL>
<CELL><FORMAT>QDBIFLD</FORMAT></CELL>
<CELL><FIELD>DBILFI</FIELD></CELL>
<CELL><PF_LF>PF</PF_LF></CELL>
<CELL><BYTE>130</BYTE></CELL>
<CELL><AS_TYPE>A</AS_TYPE></CELL>
<CELL><SQL_TYPE>VARCHAR</SQL_TYPE></CELL>
<CELL><RANG>7</RANG></CELL>
<CELL><CHAR>128</CHAR></CELL>
<CELL><DIGIT></DIGIT></CELL>
<CELL><DECIMALS></DECIMALS></CELL>
<CELL><DATELEN></DATELEN></CELL>
<CELL><TEXT>Long
file name</TEXT></CELL>
<CELL><COLSHEADER>LONG
FILE
NAME</COLSHEADER></CELL>
</ROW>
<ROW>
<CELL><LIBRARY>QSYS</LIBRARY></CELL>
<CELL><FILENAME>QADBIFLD</FILENAME></CELL>
<CELL><FORMAT>QDBIFLD</FORMAT></CELL>
<CELL><FIELD>DBIOWN</FIELD></CELL>
<CELL><PF_LF>PF</PF_LF></CELL>
<CELL><BYTE>10</BYTE></CELL>
<CELL><AS_TYPE>A</AS_TYPE></CELL>
<CELL><SQL_TYPE>CHAR</SQL_TYPE></CELL>
<CELL><RANG>8</RANG></CELL>
<CELL><CHAR>10</CHAR></CELL>
<CELL><DIGIT></DIGIT></CELL>
<CELL><DECIMALS></DECIMALS></CELL>
<CELL><DATELEN></DATELEN></CELL>
<CELL><TEXT>User
profile name of owner</TEXT></CELL>
<CELL><COLSHEADER>FILE
OWNER</COLSHEADER></CELL>
</ROW>
<ROW>
<CELL><LIBRARY>QSYS</LIBRARY></CELL>
<CELL><FILENAME>QADBIFLD</FILENAME></CELL>
<CELL><FORMAT>QDBIFLD</FORMAT></CELL>
<CELL><FIELD>DBILFL</FIELD></CELL>
<CELL><PF_LF>PF</PF_LF></CELL>
<CELL><BYTE>130</BYTE></CELL>
<CELL><AS_TYPE>A</AS_TYPE></CELL>
<CELL><SQL_TYPE>VARCHAR</SQL_TYPE></CELL>
<CELL><RANG>9</RANG></CELL>
<CELL><CHAR>128</CHAR></CELL>
<CELL><DIGIT></DIGIT></CELL>
<CELL><DECIMALS></DECIMALS></CELL>
<CELL><DATELEN></DATELEN></CELL>
<CELL><TEXT>Long
field name</TEXT></CELL>
<CELL><COLSHEADER>LONG
FIELD
NAME</COLSHEADER></CELL>
</ROW>
<ROW>
<CELL><LIBRARY>QSYS</LIBRARY></CELL>
<CELL><FILENAME>QADBIFLD</FILENAME></CELL>
<CELL><FORMAT>QDBIFLD</FORMAT></CELL>
<CELL><FIELD>DBILFQ</FIELD></CELL>
<CELL><PF_LF>PF</PF_LF></CELL>
<CELL><BYTE>1</BYTE></CELL>
<CELL><AS_TYPE>A</AS_TYPE></CELL>
<CELL><SQL_TYPE>CHAR</SQL_TYPE></CELL>
<CELL><RANG>10</RANG></CELL>
<CELL><CHAR>1</CHAR></CELL>
<CELL><DIGIT></DIGIT></CELL>
<CELL><DECIMALS></DECIMALS></CELL>
<CELL><DATELEN></DATELEN></CELL>
<CELL><TEXT>Long
field name is quoted</TEXT></CELL>
<CELL><COLSHEADER>FIELD
NAME
QUOTED</COLSHEADER></CELL>
</ROW>
<ROW>
<CELL><LIBRARY>QSYS</LIBRARY></CELL>
<CELL><FILENAME>QADBIFLD</FILENAME></CELL>
<CELL><FORMAT>QDBIFLD</FORMAT></CELL>
<CELL><FIELD>DBIINT</FIELD></CELL>
<CELL><PF_LF>PF</PF_LF></CELL>
<CELL><BYTE>10</BYTE></CELL>
<CELL><AS_TYPE>A</AS_TYPE></CELL>
<CELL><SQL_TYPE>CHAR</SQL_TYPE></CELL>
<CELL><RANG>11</RANG></CELL>
<CELL><CHAR>10</CHAR></CELL>
<CELL><DIGIT></DIGIT></CELL>
<CELL><DECIMALS></DECIMALS></CELL>
<CELL><DATELEN></DATELEN></CELL>
<CELL><TEXT>Internal
field name</TEXT></CELL>
<CELL><COLSHEADER>INTERNAL
FIELD
NAME</COLSHEADER></CELL>
</ROW>
<ROW>
<CELL><LIBRARY>QSYS</LIBRARY></CELL>
<CELL><FILENAME>QADBIFLD</FILENAME></CELL>
<CELL><FORMAT>QDBIFLD</FORMAT></CELL>
<CELL><FIELD>DBIILN</FIELD></CELL>
<CELL><PF_LF>PF</PF_LF></CELL>
<CELL><BYTE>4</BYTE></CELL>
<CELL><AS_TYPE>B</AS_TYPE></CELL>
<CELL><SQL_TYPE>INTEGER</SQL_TYPE></CELL>
<CELL><RANG>12</RANG></CELL>
<CELL><CHAR></CHAR></CELL>
<CELL><DIGIT>9</DIGIT></CELL>
<CELL><DECIMALS>0</DECIMALS></CELL>
<CELL><DATELEN></DATELEN></CELL>
<CELL><TEXT>Internal
length in bytes</TEXT></CELL>
<CELL><COLSHEADER>INTERNAL
LENGTH</COLSHEADER></CELL>
</ROW>
<ROW>
<CELL><LIBRARY>QSYS</LIBRARY></CELL>
<CELL><FILENAME>QADBIFLD</FILENAME></CELL>
<CELL><FORMAT>QDBIFLD</FORMAT></CELL>
<CELL><FIELD>DBIITP</FIELD></CELL>
<CELL><PF_LF>PF</PF_LF></CELL>
<CELL><BYTE>1</BYTE></CELL>
<CELL><AS_TYPE>A</AS_TYPE></CELL>
<CELL><SQL_TYPE>CHAR</SQL_TYPE></CELL>
<CELL><RANG>13</RANG></CELL>
<CELL><CHAR>1</CHAR></CELL>
<CELL><DIGIT></DIGIT></CELL>
<CELL><DECIMALS></DECIMALS></CELL>
<CELL><DATELEN></DATELEN></CELL>
<CELL><TEXT>Internal
data type</TEXT></CELL>
<CELL><COLSHEADER>INTERNAL
TYPE</COLSHEADER></CELL>
</ROW>
<ROW>
<CELL><LIBRARY>QSYS</LIBRARY></CELL>
<CELL><FILENAME>QADBIFLD</FILENAME></CELL>
<CELL><FORMAT>QDBIFLD</FORMAT></CELL>
<CELL><FIELD>DBITYP</FIELD></CELL>
<CELL><PF_LF>PF</PF_LF></CELL>
<CELL><BYTE>8</BYTE></CELL>
<CELL><AS_TYPE>A</AS_TYPE></CELL>
<CELL><SQL_TYPE>CHAR</SQL_TYPE></CELL>
<CELL><RANG>14</RANG></CELL>
<CELL><CHAR>8</CHAR></CELL>
<CELL><DIGIT></DIGIT></CELL>
<CELL><DECIMALS></DECIMALS></CELL>
<CELL><DATELEN></DATELEN></CELL>
<CELL><TEXT>Data
type</TEXT></CELL>
<CELL><COLSHEADER>FIELD
TYPE</COLSHEADER></CELL>
</ROW>
<ROW>
<CELL><LIBRARY>QSYS</LIBRARY></CELL>
<CELL><FILENAME>QADBIFLD</FILENAME></CELL>
<CELL><FORMAT>QDBIFLD</FORMAT></CELL>
<CELL><FIELD>DBIPOS</FIELD></CELL>
<CELL><PF_LF>PF</PF_LF></CELL>
<CELL><BYTE>2</BYTE></CELL>
<CELL><AS_TYPE>B</AS_TYPE></CELL>
<CELL><SQL_TYPE>SMALLINT</SQL_TYPE></CELL>
<CELL><RANG>15</RANG></CELL>
<CELL><CHAR></CHAR></CELL>
<CELL><DIGIT>4</DIGIT></CELL>
<CELL><DECIMALS>0</DECIMALS></CELL>
<CELL><DATELEN></DATELEN></CELL>
<CELL><TEXT>Field
position within format</TEXT></CELL>
<CELL><COLSHEADER>FIELD
POSITION</COLSHEADER></CELL>
</ROW>
<ROW>
<CELL><LIBRARY>QSYS</LIBRARY></CELL>
<CELL><FILENAME>QADBIFLD</FILENAME></CELL>
<CELL><FORMAT>QDBIFLD</FORMAT></CELL>
<CELL><FIELD>DBIFLN</FIELD></CELL>
<CELL><PF_LF>PF</PF_LF></CELL>
<CELL><BYTE>4</BYTE></CELL>
<CELL><AS_TYPE>B</AS_TYPE></CELL>
<CELL><SQL_TYPE>INTEGER</SQL_TYPE></CELL>
<CELL><RANG>16</RANG></CELL>
<CELL><CHAR></CHAR></CELL>
<CELL><DIGIT>9</DIGIT></CELL>
<CELL><DECIMALS>0</DECIMALS></CELL>
<CELL><DATELEN></DATELEN></CELL>
<CELL><TEXT>SQL
length of field</TEXT></CELL>
<CELL><COLSHEADER>FIELD
LENGTH</COLSHEADER></CELL>
</ROW>
<ROW>
<CELL><LIBRARY>QSYS</LIBRARY></CELL>
<CELL><FILENAME>QADBIFLD</FILENAME></CELL>
<CELL><FORMAT>QDBIFLD</FORMAT></CELL>
<CELL><FIELD>DBICLN</FIELD></CELL>
<CELL><PF_LF>PF</PF_LF></CELL>
<CELL><BYTE>4</BYTE></CELL>
<CELL><AS_TYPE>B</AS_TYPE></CELL>
<CELL><SQL_TYPE>INTEGER</SQL_TYPE></CELL>
<CELL><RANG>17</RANG></CELL>
<CELL><CHAR></CHAR></CELL>
<CELL><DIGIT>9</DIGIT></CELL>
<CELL><DECIMALS>0</DECIMALS></CELL>
<CELL><DATELEN></DATELEN></CELL>
<CELL><TEXT>Character
field length</TEXT></CELL>
<CELL><COLSHEADER>CHAR
LENGTH</COLSHEADER></CELL>
</ROW>
<ROW>
<CELL><LIBRARY>QSYS</LIBRARY></CELL>
<CELL><FILENAME>QADBIFLD</FILENAME></CELL>
<CELL><FORMAT>QDBIFLD</FORMAT></CELL>
<CELL><FIELD>DBICNC</FIELD></CELL>
<CELL><PF_LF>PF</PF_LF></CELL>
<CELL><BYTE>4</BYTE></CELL>
<CELL><AS_TYPE>B</AS_TYPE></CELL>
<CELL><SQL_TYPE>INTEGER</SQL_TYPE></CELL>
<CELL><RANG>18</RANG></CELL>
<CELL><CHAR></CHAR></CELL>
<CELL><DIGIT>9</DIGIT></CELL>
<CELL><DECIMALS>0</DECIMALS></CELL>
<CELL><DATELEN></DATELEN></CELL>
<CELL><TEXT>Character
field number of characters</TEXT></CELL>
<CELL><COLSHEADER>CHAR
NUMBER
CHARACTERS</COLSHEADER></CELL>
</ROW>
<ROW>
<CELL><LIBRARY>QSYS</LIBRARY></CELL>
<CELL><FILENAME>QADBIFLD</FILENAME></CELL>
<CELL><FORMAT>QDBIFLD</FORMAT></CELL>
<CELL><FIELD>DBICCC</FIELD></CELL>
<CELL><PF_LF>PF</PF_LF></CELL>
<CELL><BYTE>4</BYTE></CELL>
<CELL><AS_TYPE>B</AS_TYPE></CELL>
<CELL><SQL_TYPE>INTEGER</SQL_TYPE></CELL>
<CELL><RANG>19</RANG></CELL>
<CELL><CHAR></CHAR></CELL>
<CELL><DIGIT>9</DIGIT></CELL>
<CELL><DECIMALS>0</DECIMALS></CELL>
<CELL><DATELEN></DATELEN></CELL>
<CELL><TEXT>Character
field CCSID</TEXT></CELL>
<CELL><COLSHEADER>CHAR
CCSID</COLSHEADER></CELL>
</ROW>
<ROW>
<CELL><LIBRARY>QSYS</LIBRARY></CELL>
<CELL><FILENAME>QADBIFLD</FILENAME></CELL>
<CELL><FORMAT>QDBIFLD</FORMAT></CELL>
<CELL><FIELD>DBINLN</FIELD></CELL>
<CELL><PF_LF>PF</PF_LF></CELL>
<CELL><BYTE>2</BYTE></CELL>
<CELL><AS_TYPE>B</AS_TYPE></CELL>
<CELL><SQL_TYPE>SMALLINT</SQL_TYPE></CELL>
<CELL><RANG>20</RANG></CELL>
<CELL><CHAR></CHAR></CELL>
<CELL><DIGIT>4</DIGIT></CELL>
<CELL><DECIMALS>0</DECIMALS></CELL>
<CELL><DATELEN></DATELEN></CELL>
<CELL><TEXT>Numeric
field precision</TEXT></CELL>
<CELL><COLSHEADER>NUMERIC
LENGTH</COLSHEADER></CELL>
</ROW>
<ROW>
<CELL><LIBRARY>QSYS</LIBRARY></CELL>
<CELL><FILENAME>QADBIFLD</FILENAME></CELL>
<CELL><FORMAT>QDBIFLD</FORMAT></CELL>
<CELL><FIELD>DBINSC</FIELD></CELL>
<CELL><PF_LF>PF</PF_LF></CELL>
<CELL><BYTE>2</BYTE></CELL>
<CELL><AS_TYPE>B</AS_TYPE></CELL>
<CELL><SQL_TYPE>SMALLINT</SQL_TYPE></CELL>
<CELL><RANG>21</RANG></CELL>
<CELL><CHAR></CHAR></CELL>
<CELL><DIGIT>4</DIGIT></CELL>
<CELL><DECIMALS>0</DECIMALS></CELL>
<CELL><DATELEN></DATELEN></CELL>
<CELL><TEXT>Numeric
field scale</TEXT></CELL>
<CELL><COLSHEADER>NUMERIC
SCALE</COLSHEADER></CELL>
</ROW>
<ROW>
<CELL><LIBRARY>QSYS</LIBRARY></CELL>
<CELL><FILENAME>QADBIFLD</FILENAME></CELL>
<CELL><FORMAT>QDBIFLD</FORMAT></CELL>
<CELL><FIELD>DBIRDX</FIELD></CELL>
<CELL><PF_LF>PF</PF_LF></CELL>
<CELL><BYTE>2</BYTE></CELL>
<CELL><AS_TYPE>B</AS_TYPE></CELL>
<CELL><SQL_TYPE>SMALLINT</SQL_TYPE></CELL>
<CELL><RANG>22</RANG></CELL>
<CELL><CHAR></CHAR></CELL>
<CELL><DIGIT>4</DIGIT></CELL>
<CELL><DECIMALS>0</DECIMALS></CELL>
<CELL><DATELEN></DATELEN></CELL>
<CELL><TEXT>Precision:
2=Binary, 10=Decimal</TEXT></CELL>
<CELL><COLSHEADER>NUMERIC
PRECISION
RADIX</COLSHEADER></CELL>
</ROW>
<ROW>
<CELL><LIBRARY>QSYS</LIBRARY></CELL>
<CELL><FILENAME>QADBIFLD</FILENAME></CELL>
<CELL><FORMAT>QDBIFLD</FORMAT></CELL>
<CELL><FIELD>DBIDLN</FIELD></CELL>
<CELL><PF_LF>PF</PF_LF></CELL>
<CELL><BYTE>2</BYTE></CELL>
<CELL><AS_TYPE>B</AS_TYPE></CELL>
<CELL><SQL_TYPE>SMALLINT</SQL_TYPE></CELL>
<CELL><RANG>23</RANG></CELL>
<CELL><CHAR></CHAR></CELL>
<CELL><DIGIT>4</DIGIT></CELL>
<CELL><DECIMALS>0</DECIMALS></CELL>
<CELL><DATELEN></DATELEN></CELL>
<CELL><TEXT>Date/Time
field precision</TEXT></CELL>
<CELL><COLSHEADER>DATE
TIME
PRECISION</COLSHEADER></CELL>
</ROW>
<ROW>
<CELL><LIBRARY>QSYS</LIBRARY></CELL>
<CELL><FILENAME>QADBIFLD</FILENAME></CELL>
<CELL><FORMAT>QDBIFLD</FORMAT></CELL>
<CELL><FIELD>DBITXT</FIELD></CELL>
<CELL><PF_LF>PF</PF_LF></CELL>
<CELL><BYTE>52</BYTE></CELL>
<CELL><AS_TYPE>A</AS_TYPE></CELL>
<CELL><SQL_TYPE>VARCHAR</SQL_TYPE></CELL>
<CELL><RANG>24</RANG></CELL>
<CELL><CHAR>50</CHAR></CELL>
<CELL><DIGIT></DIGIT></CELL>
<CELL><DECIMALS></DECIMALS></CELL>
<CELL><DATELEN></DATELEN></CELL>
<CELL><TEXT>Field
text</TEXT></CELL>
<CELL><COLSHEADER>FIELD
TEXT</COLSHEADER></CELL>
</ROW>
<ROW>
<CELL><LIBRARY>QSYS</LIBRARY></CELL>
<CELL><FILENAME>QADBIFLD</FILENAME></CELL>
<CELL><FORMAT>QDBIFLD</FORMAT></CELL>
<CELL><FIELD>DBIHDG</FIELD></CELL>
<CELL><PF_LF>PF</PF_LF></CELL>
<CELL><BYTE>62</BYTE></CELL>
<CELL><AS_TYPE>A</AS_TYPE></CELL>
<CELL><SQL_TYPE>VARCHAR</SQL_TYPE></CELL>
<CELL><RANG>25</RANG></CELL>
<CELL><CHAR>60</CHAR></CELL>
<CELL><DIGIT></DIGIT></CELL>
<CELL><DECIMALS></DECIMALS></CELL>
<CELL><DATELEN></DATELEN></CELL>
<CELL><TEXT>Field
headings</TEXT></CELL>
<CELL><COLSHEADER>COLUMN
HEADINGS</COLSHEADER></CELL>
</ROW>
<ROW>
<CELL><LIBRARY>QSYS</LIBRARY></CELL>
<CELL><FILENAME>QADBIFLD</FILENAME></CELL>
<CELL><FORMAT>QDBIFLD</FORMAT></CELL>
<CELL><FIELD>DBINUL</FIELD></CELL>
<CELL><PF_LF>PF</PF_LF></CELL>
<CELL><BYTE>1</BYTE></CELL>
<CELL><AS_TYPE>A</AS_TYPE></CELL>
<CELL><SQL_TYPE>CHAR</SQL_TYPE></CELL>
<CELL><RANG>26</RANG></CELL>
<CELL><CHAR>1</CHAR></CELL>
<CELL><DIGIT></DIGIT></CELL>
<CELL><DECIMALS></DECIMALS></CELL>
<CELL><DATELEN></DATELEN></CELL>
<CELL><TEXT>Allow
NULL value: Y-Yes,N-No</TEXT></CELL>
<CELL><COLSHEADER>ALW
NULL</COLSHEADER></CELL>
</ROW>
<ROW>
<CELL><LIBRARY>QSYS</LIBRARY></CELL>
<CELL><FILENAME>QADBIFLD</FILENAME></CELL>
<CELL><FORMAT>QDBIFLD</FORMAT></CELL>
<CELL><FIELD>DBIUPD</FIELD></CELL>
<CELL><PF_LF>PF</PF_LF></CELL>
<CELL><BYTE>1</BYTE></CELL>
<CELL><AS_TYPE>A</AS_TYPE></CELL>
<CELL><SQL_TYPE>CHAR</SQL_TYPE></CELL>
<CELL><RANG>27</RANG></CELL>
<CELL><CHAR>1</CHAR></CELL>
<CELL><DIGIT></DIGIT></CELL>
<CELL><DECIMALS></DECIMALS></CELL>
<CELL><DATELEN></DATELEN></CELL>
<CELL><TEXT>Allow
UPDATE: Y-Yes,N-No</TEXT></CELL>
<CELL><COLSHEADER>ALW
UPD</COLSHEADER></CELL>
</ROW>
<ROW>
<CELL><LIBRARY>QSYS</LIBRARY></CELL>
<CELL><FILENAME>QADBIFLD</FILENAME></CELL>
<CELL><FORMAT>QDBIFLD</FORMAT></CELL>
<CELL><FIELD>DBIREM</FIELD></CELL>
<CELL><PF_LF>PF</PF_LF></CELL>
<CELL><BYTE>2002</BYTE></CELL>
<CELL><AS_TYPE>A</AS_TYPE></CELL>
<CELL><SQL_TYPE>VARCHAR</SQL_TYPE></CELL>
<CELL><RANG>28</RANG></CELL>
<CELL><CHAR>2000</CHAR></CELL>
<CELL><DIGIT></DIGIT></CELL>
<CELL><DECIMALS></DECIMALS></CELL>
<CELL><DATELEN></DATELEN></CELL>
<CELL><TEXT>Long
field description</TEXT></CELL>
<CELL><COLSHEADER>LONG
DESCRIPTION</COLSHEADER></CELL>
</ROW>
<ROW>
<CELL><LIBRARY>QSYS</LIBRARY></CELL>
<CELL><FILENAME>QADBIFLD</FILENAME></CELL>
<CELL><FORMAT>QDBIFLD</FORMAT></CELL>
<CELL><FIELD>DBIDFI</FIELD></CELL>
<CELL><PF_LF>PF</PF_LF></CELL>
<CELL><BYTE>1</BYTE></CELL>
<CELL><AS_TYPE>A</AS_TYPE></CELL>
<CELL><SQL_TYPE>CHAR</SQL_TYPE></CELL>
<CELL><RANG>29</RANG></CELL>
<CELL><CHAR>1</CHAR></CELL>
<CELL><DIGIT></DIGIT></CELL>
<CELL><DECIMALS></DECIMALS></CELL>
<CELL><DATELEN></DATELEN></CELL>
<CELL><TEXT>Default
indicator: Y-Yes,N-No</TEXT></CELL>
<CELL><COLSHEADER>DFT</COLSHEADER></CELL>
</ROW>
<ROW>
<CELL><LIBRARY>QSYS</LIBRARY></CELL>
<CELL><FILENAME>QADBIFLD</FILENAME></CELL>
<CELL><FORMAT>QDBIFLD</FORMAT></CELL>
<CELL><FIELD>DBIDFT</FIELD></CELL>
<CELL><PF_LF>PF</PF_LF></CELL>
<CELL><BYTE>2002</BYTE></CELL>
<CELL><AS_TYPE>A</AS_TYPE></CELL>
<CELL><SQL_TYPE>VARCHAR</SQL_TYPE></CELL>
<CELL><RANG>30</RANG></CELL>
<CELL><CHAR>2000</CHAR></CELL>
<CELL><DIGIT></DIGIT></CELL>
<CELL><DECIMALS></DECIMALS></CELL>
<CELL><DATELEN></DATELEN></CELL>
<CELL><TEXT>Field
default value</TEXT></CELL>
<CELL><COLSHEADER>DEFAULT
VALUE</COLSHEADER></CELL>
</ROW>
<ROW>
<CELL><LIBRARY>QSYS</LIBRARY></CELL>
<CELL><FILENAME>QADBIFLD</FILENAME></CELL>
<CELL><FORMAT>QDBIFLD</FORMAT></CELL>
<CELL><FIELD>DBIFMP</FIELD></CELL>
<CELL><PF_LF>PF</PF_LF></CELL>
<CELL><BYTE>2</BYTE></CELL>
<CELL><AS_TYPE>B</AS_TYPE></CELL>
<CELL><SQL_TYPE>SMALLINT</SQL_TYPE></CELL>
<CELL><RANG>31</RANG></CELL>
<CELL><CHAR></CHAR></CELL>
<CELL><DIGIT>2</DIGIT></CELL>
<CELL><DECIMALS>0</DECIMALS></CELL>
<CELL><DATELEN></DATELEN></CELL>
<CELL><TEXT>Position
of format in file</TEXT></CELL>
<CELL><COLSHEADER>FORMAT
POSITION</COLSHEADER></CELL>
</ROW>
<ROW>
<CELL><LIBRARY>QSYS</LIBRARY></CELL>
<CELL><FILENAME>QADBIFLD</FILENAME></CELL>
<CELL><FORMAT>QDBIFLD</FORMAT></CELL>
<CELL><FIELD>DBILB2</FIELD></CELL>
<CELL><PF_LF>PF</PF_LF></CELL>
<CELL><BYTE>130</BYTE></CELL>
<CELL><AS_TYPE>A</AS_TYPE></CELL>
<CELL><SQL_TYPE>VARCHAR</SQL_TYPE></CELL>
<CELL><RANG>32</RANG></CELL>
<CELL><CHAR>128</CHAR></CELL>
<CELL><DIGIT></DIGIT></CELL>
<CELL><DECIMALS></DECIMALS></CELL>
<CELL><DATELEN></DATELEN></CELL>
<CELL><TEXT>Library
name</TEXT></CELL>
<CELL><COLSHEADER>LIBRARY
NAME</COLSHEADER></CELL>
</ROW>
<ROW>
<CELL><LIBRARY>QSYS</LIBRARY></CELL>
<CELL><FILENAME>QADBIFLD</FILENAME></CELL>
<CELL><FORMAT>QDBIFLD</FORMAT></CELL>
<CELL><FIELD>DBITLN</FIELD></CELL>
<CELL><PF_LF>PF</PF_LF></CELL>
<CELL><BYTE>130</BYTE></CELL>
<CELL><AS_TYPE>A</AS_TYPE></CELL>
<CELL><SQL_TYPE>VARCHAR</SQL_TYPE></CELL>
<CELL><RANG>33</RANG></CELL>
<CELL><CHAR>128</CHAR></CELL>
<CELL><DIGIT></DIGIT></CELL>
<CELL><DECIMALS></DECIMALS></CELL>
<CELL><DATELEN></DATELEN></CELL>
<CELL><TEXT>UDT
Long Name</TEXT></CELL>
<CELL><COLSHEADER>UDT
LONG
NAME</COLSHEADER></CELL>
</ROW>
<ROW>
<CELL><LIBRARY>QSYS</LIBRARY></CELL>
<CELL><FILENAME>QADBIFLD</FILENAME></CELL>
<CELL><FORMAT>QDBIFLD</FORMAT></CELL>
<CELL><FIELD>DBITLB</FIELD></CELL>
<CELL><PF_LF>PF</PF_LF></CELL>
<CELL><BYTE>130</BYTE></CELL>
<CELL><AS_TYPE>A</AS_TYPE></CELL>
<CELL><SQL_TYPE>VARCHAR</SQL_TYPE></CELL>
<CELL><RANG>34</RANG></CELL>
<CELL><CHAR>128</CHAR></CELL>
<CELL><DIGIT></DIGIT></CELL>
<CELL><DECIMALS></DECIMALS></CELL>
<CELL><DATELEN></DATELEN></CELL>
<CELL><TEXT>UDT
Library Name</TEXT></CELL>
<CELL><COLSHEADER>UDT
LIBRARY</COLSHEADER></CELL>
</ROW>
</ROWS>
</TABLE>
<DEBUG>
<tracevar> ALIGN =
</tracevar><tracevar> DATABASE =
</tracevar><tracevar> DB_CASE =
</tracevar><tracevar> DB2INSTANCE =
</tracevar><tracevar> DB2MSGS =
</tracevar><tracevar> DB2PLAN =
</tracevar><tracevar> DB2PLAN =
</tracevar><tracevar> DB2SSID =
</tracevar><tracevar> DB2SSID =
</tracevar><tracevar> DefaultDBCp =
</tracevar><tracevar> DSNAOINI =
</tracevar><tracevar> DTW_APPLET_ALTTEXT =
</tracevar><tracevar> DTW_ATTACHMENT_PATH =
</tracevar><tracevar> DTW_CACHE_HOST =
</tracevar><tracevar> DTW_CACHE_MACRO =
</tracevar><tracevar> DTW_CACHE_MANAGEMENT_INTERVAL =
</tracevar><tracevar> DTW_CACHE_PAGE =
</tracevar><tracevar> DTW_CACHE_PORT =
</tracevar><tracevar> DTW_CM_PORT =
</tracevar><tracevar> DTW_COBOL_PARAMETER_BUFFER_SIZE =
</tracevar><tracevar> DTW_COBOL_PARAMETER_BUFFER_SIZE =
</tracevar><tracevar> DTW_CURRENT_FILENAME = /vcehttp/sqlquery/macro.txt
</tracevar><tracevar> DTW_CURRENT_LAST_MODIFIED = Mon
Oct 24 15:35:18 2005
</tracevar><tracevar> DTW_DEFAULT_ERROR_MESSAGE =
</tracevar><tracevar> DTW_DEFAULT_MACRO =
</tracevar><tracevar> DTW_DEFAULT_MESSAGE =
</tracevar><tracevar> DTW_DEFAULT_REPORT =
</tracevar><tracevar> DTW_DIRECT_REQUEST =
</tracevar><tracevar> DTW_DO_NOT_CACHE_MACRO =
</tracevar><tracevar> DTW_EDIT_CODES =
</tracevar><tracevar> DTW_ERROR_LOG_DIR = /VCEHTTPT/sqlQuery/
</tracevar><tracevar> DTW_ERROR_LOG_LEVEL = ALL
</tracevar><tracevar> DTW_HTML_TABLE =
</tracevar><tracevar> DTW_INST_DIR =
</tracevar><tracevar> DTW_LOB_DIR =
</tracevar><tracevar> DTW_LOB_LIFETIME =
</tracevar><tracevar> DTW_LOG_DIR =
</tracevar><tracevar> DTW_LOG_LEVEL =
</tracevar><tracevar> DTW_LOG_LEVEL =
</tracevar><tracevar> DTW_MACRO_FILENAME = /vcehttp/sqlquery/macro.txt
</tracevar><tracevar> DTW_MACRO_LAST_MODIFIED = Mon
Oct 24 15:35:18 2005
</tracevar><tracevar> DTW_MBMODE =
</tracevar><tracevar> DTW_MBMODE =
</tracevar><tracevar> DTW_MP_PATH = /sqlquery/CGI
</tracevar><tracevar> DTW_MP_VERSION = IBM-AS/400-NET.DATA
</tracevar><tracevar> DTW_OUTPUT_DIR =
</tracevar><tracevar> DTW_PAD_PGM_PARMS =
</tracevar><tracevar> DTW_PRINT_HEADER =
</tracevar><tracevar> DTW_REMOVE_WS =
</tracevar><tracevar> DTW_REMOVE_WS =
</tracevar><tracevar> DTW_SAVE_TABLE_IN =
</tracevar><tracevar> DTW_SET_TOTAL_ROWS =
</tracevar><tracevar> DTW_SHOWSQL =
</tracevar><tracevar> DTW_SMTP_CHARSET =
</tracevar><tracevar> DTW_SMTP_SERVER =
</tracevar><tracevar> DTW_SQL_ISOLATION =
</tracevar><tracevar> DTW_SQL_NAMING_MODE =
</tracevar><tracevar> DTW_STORE_PAGE =
</tracevar><tracevar> DTW_TRACE_LOG_DIR = /VCEHTTPT/sqlQuery/
</tracevar><tracevar> DTW_TRACE_LOG_LEVEL = APPLICATION
</tracevar><tracevar> DTW_UNICODE =
</tracevar><tracevar> DTW_UPLOAD_DIR =
</tracevar><tracevar> DTW_USE_DB2_PREPARE_CACHE =
</tracevar><tracevar> DTW_USE_DB2_PREPARE_CACHE =
</tracevar><tracevar> DTW_VARIABLE_SCOPE =
</tracevar><tracevar> EXEC_PATH =
</tracevar><tracevar> FFI_PATH =
</tracevar><tracevar> HTML_PATH =
</tracevar><tracevar> INCLUDE_PATH =
</tracevar><tracevar> LOCATION =
</tracevar><tracevar> LOGIN =
</tracevar><tracevar> MACRO_PATH =
</tracevar><tracevar> NLIST =
</tracevar><tracevar> Nn =
</tracevar><tracevar> NULL_RPT_FIELD =
</tracevar><tracevar> NUM_COLUMNS =
</tracevar><tracevar> NUM_ROWS =
</tracevar><tracevar> PASSWORD =
</tracevar><tracevar> RETURN_CODE = 0
</tracevar><tracevar> ROW_NUM =
</tracevar><tracevar> RPT_MAX_ROWS =
</tracevar><tracevar> SHOWSQL =
</tracevar><tracevar> SQL_CODE = 0
</tracevar><tracevar> SQL_STATE = 00000
</tracevar><tracevar> START_ROW_NUM =
</tracevar><tracevar> TOTAL_ROWS =
</tracevar><tracevar> TRANSACTION_SCOPE =
</tracevar><qshset><![CDATA[
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
]]></qshset>
</DEBUG>
</SQL>
xslsource
<?xml
version="1.0"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
version="1.0" xmlns:java="http://xml.apache.org/xslt/java"
exclude-result-prefixes="java">
<xsl:output method="xml" indent="yes"/>
<xsl:output encoding="ISO-8859-15"/>
<xsl:strip-space elements="*"/>
<xsl:template match="/">
<xsl:apply-templates select="SQL"/>
</xsl:template>
<xsl:template match="SQL">
<html>
<head>
<title>
<xsl:text>This
XSL shows a simple XML transformation</xsl:text>
</title>
</head>
<body>
<xsl:apply-templates
select="*"/>
</body>
</html>
</xsl:template>
<xsl:template match="SELECT">
<table
border="1"><tr><td><xsl:text>sql
is
</xsl:text></td><td><xsl:value-of
select="."/></td></tr></table>
</xsl:template>
<xsl:template match="TABLE">
<table border="3">
<xsl:apply-templates
select="*"/>
</table>
</xsl:template>
<xsl:template match="COLS">
<tr>
<xsl:apply-templates
select="*"/>
</tr>
</xsl:template>
<xsl:template match="COLNAME">
<th>
<xsl:value-of select="."/>
<xsl:apply-templates
select="*"/>
</th>
</xsl:template>
<xsl:template match="ROWS">
<xsl:text></xsl:text>
<xsl:apply-templates select="*"/>
</xsl:template>
<xsl:template match="ROW">
<tr>
<xsl:text></xsl:text>
<xsl:apply-templates
select="*"/>
</tr>
</xsl:template>
<xsl:template match="CELL">
<td>
<xsl:apply-templates
select="*"/>
</td>
</xsl:template>
<!-- colonne individuelle : pas de traitement
particulier -->
<xsl:template match="DEBUG">
<!-- masquer
--><xsl:text>debug</xsl:text>
<xsl:apply-templates select="*"/>
</xsl:template>
<xsl:template match="tracevar">
<br/>
<xsl:value-of select="."/>
<xsl:apply-templates select="*"/>
</xsl:template>
<xsl:template match="qshset">
<pre>
<xsl:value-of select="."/>
<xsl:apply-templates
select="*"/>
</pre>
</xsl:template>
</xsl:stylesheet>
xmlerror=
xmlresulttext=
<?xml version="1.0"
encoding="UTF-16"?>
<html>
<head>
<title>This XSL shows a simple XML
transformation</title>
</head>
<body>
<table border="1"><tr><td>sql
is </td><td>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</td></tr></table>
<table border="3">
<tr>
<th>LIBRARY</th>
<th>FILENAME</th>
<th>FORMAT</th>
<th>FIELD</th>
<th>PF_LF</th>
<th>BYTE</th>
<th>AS_TYPE</th>
<th>SQL_TYPE</th>
<th>RANG</th>
<th>CHAR</th>
<th>DIGIT</th>
<th>DECIMALS</th>
<th>DATELEN</th>
<th>TEXT</th>
<th>COLSHEADER</th>
</tr><tr><td>QSYS</td>
<td>QADBIFLD</td>
<td>QDBIFLD</td>
<td>DBILIB</td>
<td>PF</td>
<td>10</td>
<td>A</td>
<td>CHAR</td>
<td>1</td>
<td>10</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>Library name</td>
<td>LIBRARY
NAME</td>
</tr>
<tr><td>QSYS</td>
<td>QADBIFLD</td>
<td>QDBIFLD</td>
<td>DBIFIL</td>
<td>PF</td>
<td>10</td>
<td>A</td>
<td>CHAR</td>
<td>2</td>
<td>10</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>File name</td>
<td>FILE
NAME</td>
</tr>
<tr><td>QSYS</td>
<td>QADBIFLD</td>
<td>QDBIFLD</td>
<td>DBIFMT</td>
<td>PF</td>
<td>10</td>
<td>A</td>
<td>CHAR</td>
<td>3</td>
<td>10</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>Format name</td>
<td>FORMAT
NAME</td>
</tr>
<tr><td>QSYS</td>
<td>QADBIFLD</td>
<td>QDBIFLD</td>
<td>DBIFLD</td>
<td>PF</td>
<td>10</td>
<td>A</td>
<td>CHAR</td>
<td>4</td>
<td>10</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>Field name</td>
<td>FIELD
NAME</td>
</tr>
<tr><td>QSYS</td>
<td>QADBIFLD</td>
<td>QDBIFLD</td>
<td>DBIATR</td>
<td>PF</td>
<td>2</td>
<td>A</td>
<td>CHAR</td>
<td>5</td>
<td>2</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>PF-physical,LF-logical,TB-table,VW-view,IX-index</td>
<td>FILE
ATTR</td>
</tr>
<tr><td>QSYS</td>
<td>QADBIFLD</td>
<td>QDBIFLD</td>
<td>DBIREL</td>
<td>PF</td>
<td>1</td>
<td>A</td>
<td>CHAR</td>
<td>6</td>
<td>1</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>Relational file: Y=Yes,N=No</td>
<td>RELATIONAL
FILE</td>
</tr>
<tr><td>QSYS</td>
<td>QADBIFLD</td>
<td>QDBIFLD</td>
<td>DBILFI</td>
<td>PF</td>
<td>130</td>
<td>A</td>
<td>VARCHAR</td>
<td>7</td>
<td>128</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>Long file name</td>
<td>LONG
FILE
NAME</td>
</tr>
<tr><td>QSYS</td>
<td>QADBIFLD</td>
<td>QDBIFLD</td>
<td>DBIOWN</td>
<td>PF</td>
<td>10</td>
<td>A</td>
<td>CHAR</td>
<td>8</td>
<td>10</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>User profile name of owner</td>
<td>FILE
OWNER</td>
</tr>
<tr><td>QSYS</td>
<td>QADBIFLD</td>
<td>QDBIFLD</td>
<td>DBILFL</td>
<td>PF</td>
<td>130</td>
<td>A</td>
<td>VARCHAR</td>
<td>9</td>
<td>128</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>Long field name</td>
<td>LONG
FIELD
NAME</td>
</tr>
<tr><td>QSYS</td>
<td>QADBIFLD</td>
<td>QDBIFLD</td>
<td>DBILFQ</td>
<td>PF</td>
<td>1</td>
<td>A</td>
<td>CHAR</td>
<td>10</td>
<td>1</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>Long field name is quoted</td>
<td>FIELD
NAME
QUOTED</td>
</tr>
<tr><td>QSYS</td>
<td>QADBIFLD</td>
<td>QDBIFLD</td>
<td>DBIINT</td>
<td>PF</td>
<td>10</td>
<td>A</td>
<td>CHAR</td>
<td>11</td>
<td>10</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>Internal field name</td>
<td>INTERNAL
FIELD
NAME</td>
</tr>
<tr><td>QSYS</td>
<td>QADBIFLD</td>
<td>QDBIFLD</td>
<td>DBIILN</td>
<td>PF</td>
<td>4</td>
<td>B</td>
<td>INTEGER</td>
<td>12</td>
<td>
</td>
<td>9</td>
<td>0</td>
<td>
</td>
<td>Internal length in bytes</td>
<td>INTERNAL
LENGTH</td>
</tr>
<tr><td>QSYS</td>
<td>QADBIFLD</td>
<td>QDBIFLD</td>
<td>DBIITP</td>
<td>PF</td>
<td>1</td>
<td>A</td>
<td>CHAR</td>
<td>13</td>
<td>1</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>Internal data type</td>
<td>INTERNAL
TYPE</td>
</tr>
<tr><td>QSYS</td>
<td>QADBIFLD</td>
<td>QDBIFLD</td>
<td>DBITYP</td>
<td>PF</td>
<td>8</td>
<td>A</td>
<td>CHAR</td>
<td>14</td>
<td>8</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>Data type</td>
<td>FIELD
TYPE</td>
</tr>
<tr><td>QSYS</td>
<td>QADBIFLD</td>
<td>QDBIFLD</td>
<td>DBIPOS</td>
<td>PF</td>
<td>2</td>
<td>B</td>
<td>SMALLINT</td>
<td>15</td>
<td>
</td>
<td>4</td>
<td>0</td>
<td>
</td>
<td>Field position within format</td>
<td>FIELD
POSITION</td>
</tr>
<tr><td>QSYS</td>
<td>QADBIFLD</td>
<td>QDBIFLD</td>
<td>DBIFLN</td>
<td>PF</td>
<td>4</td>
<td>B</td>
<td>INTEGER</td>
<td>16</td>
<td>
</td>
<td>9</td>
<td>0</td>
<td>
</td>
<td>SQL length of field</td>
<td>FIELD
LENGTH</td>
</tr>
<tr><td>QSYS</td>
<td>QADBIFLD</td>
<td>QDBIFLD</td>
<td>DBICLN</td>
<td>PF</td>
<td>4</td>
<td>B</td>
<td>INTEGER</td>
<td>17</td>
<td>
</td>
<td>9</td>
<td>0</td>
<td>
</td>
<td>Character field length</td>
<td>CHAR
LENGTH</td>
</tr>
<tr><td>QSYS</td>
<td>QADBIFLD</td>
<td>QDBIFLD</td>
<td>DBICNC</td>
<td>PF</td>
<td>4</td>
<td>B</td>
<td>INTEGER</td>
<td>18</td>
<td>
</td>
<td>9</td>
<td>0</td>
<td>
</td>
<td>Character field number of
characters</td>
<td>CHAR
NUMBER
CHARACTERS</td>
</tr>
<tr><td>QSYS</td>
<td>QADBIFLD</td>
<td>QDBIFLD</td>
<td>DBICCC</td>
<td>PF</td>
<td>4</td>
<td>B</td>
<td>INTEGER</td>
<td>19</td>
<td>
</td>
<td>9</td>
<td>0</td>
<td>
</td>
<td>Character field CCSID</td>
<td>CHAR
CCSID</td>
</tr>
<tr><td>QSYS</td>
<td>QADBIFLD</td>
<td>QDBIFLD</td>
<td>DBINLN</td>
<td>PF</td>
<td>2</td>
<td>B</td>
<td>SMALLINT</td>
<td>20</td>
<td>
</td>
<td>4</td>
<td>0</td>
<td>
</td>
<td>Numeric field precision</td>
<td>NUMERIC
LENGTH</td>
</tr>
<tr><td>QSYS</td>
<td>QADBIFLD</td>
<td>QDBIFLD</td>
<td>DBINSC</td>
<td>PF</td>
<td>2</td>
<td>B</td>
<td>SMALLINT</td>
<td>21</td>
<td>
</td>
<td>4</td>
<td>0</td>
<td>
</td>
<td>Numeric field scale</td>
<td>NUMERIC
SCALE</td>
</tr>
<tr><td>QSYS</td>
<td>QADBIFLD</td>
<td>QDBIFLD</td>
<td>DBIRDX</td>
<td>PF</td>
<td>2</td>
<td>B</td>
<td>SMALLINT</td>
<td>22</td>
<td>
</td>
<td>4</td>
<td>0</td>
<td>
</td>
<td>Precision: 2=Binary, 10=Decimal</td>
<td>NUMERIC
PRECISION
RADIX</td>
</tr>
<tr><td>QSYS</td>
<td>QADBIFLD</td>
<td>QDBIFLD</td>
<td>DBIDLN</td>
<td>PF</td>
<td>2</td>
<td>B</td>
<td>SMALLINT</td>
<td>23</td>
<td>
</td>
<td>4</td>
<td>0</td>
<td>
</td>
<td>Date/Time field precision</td>
<td>DATE
TIME
PRECISION</td>
</tr>
<tr><td>QSYS</td>
<td>QADBIFLD</td>
<td>QDBIFLD</td>
<td>DBITXT</td>
<td>PF</td>
<td>52</td>
<td>A</td>
<td>VARCHAR</td>
<td>24</td>
<td>50</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>Field text</td>
<td>FIELD
TEXT</td>
</tr>
<tr><td>QSYS</td>
<td>QADBIFLD</td>
<td>QDBIFLD</td>
<td>DBIHDG</td>
<td>PF</td>
<td>62</td>
<td>A</td>
<td>VARCHAR</td>
<td>25</td>
<td>60</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>Field headings</td>
<td>COLUMN
HEADINGS</td>
</tr>
<tr><td>QSYS</td>
<td>QADBIFLD</td>
<td>QDBIFLD</td>
<td>DBINUL</td>
<td>PF</td>
<td>1</td>
<td>A</td>
<td>CHAR</td>
<td>26</td>
<td>1</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>Allow NULL value: Y-Yes,N-No</td>
<td>ALW
NULL</td>
</tr>
<tr><td>QSYS</td>
<td>QADBIFLD</td>
<td>QDBIFLD</td>
<td>DBIUPD</td>
<td>PF</td>
<td>1</td>
<td>A</td>
<td>CHAR</td>
<td>27</td>
<td>1</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>Allow UPDATE: Y-Yes,N-No</td>
<td>ALW
UPD</td>
</tr>
<tr><td>QSYS</td>
<td>QADBIFLD</td>
<td>QDBIFLD</td>
<td>DBIREM</td>
<td>PF</td>
<td>2002</td>
<td>A</td>
<td>VARCHAR</td>
<td>28</td>
<td>2000</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>Long field description</td>
<td>LONG
DESCRIPTION</td>
</tr>
<tr><td>QSYS</td>
<td>QADBIFLD</td>
<td>QDBIFLD</td>
<td>DBIDFI</td>
<td>PF</td>
<td>1</td>
<td>A</td>
<td>CHAR</td>
<td>29</td>
<td>1</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>Default indicator: Y-Yes,N-No</td>
<td>DFT</td>
</tr>
<tr><td>QSYS</td>
<td>QADBIFLD</td>
<td>QDBIFLD</td>
<td>DBIDFT</td>
<td>PF</td>
<td>2002</td>
<td>A</td>
<td>VARCHAR</td>
<td>30</td>
<td>2000</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>Field default value</td>
<td>DEFAULT
VALUE</td>
</tr>
<tr><td>QSYS</td>
<td>QADBIFLD</td>
<td>QDBIFLD</td>
<td>DBIFMP</td>
<td>PF</td>
<td>2</td>
<td>B</td>
<td>SMALLINT</td>
<td>31</td>
<td>
</td>
<td>2</td>
<td>0</td>
<td>
</td>
<td>Position of format in file</td>
<td>FORMAT
POSITION</td>
</tr>
<tr><td>QSYS</td>
<td>QADBIFLD</td>
<td>QDBIFLD</td>
<td>DBILB2</td>
<td>PF</td>
<td>130</td>
<td>A</td>
<td>VARCHAR</td>
<td>32</td>
<td>128</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>Library name</td>
<td>LIBRARY
NAME</td>
</tr>
<tr><td>QSYS</td>
<td>QADBIFLD</td>
<td>QDBIFLD</td>
<td>DBITLN</td>
<td>PF</td>
<td>130</td>
<td>A</td>
<td>VARCHAR</td>
<td>33</td>
<td>128</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>UDT Long Name</td>
<td>UDT
LONG
NAME</td>
</tr>
<tr><td>QSYS</td>
<td>QADBIFLD</td>
<td>QDBIFLD</td>
<td>DBITLB</td>
<td>PF</td>
<td>130</td>
<td>A</td>
<td>VARCHAR</td>
<td>34</td>
<td>128</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>UDT Library Name</td>
<td>UDT
LIBRARY</td>
</tr>
</table>debug<br
/> ALIGN =
<br /> DATABASE =
<br /> DB_CASE =
<br /> DB2INSTANCE =
<br /> DB2MSGS =
<br /> DB2PLAN =
<br /> DB2PLAN =
<br /> DB2SSID =
<br /> DB2SSID =
<br /> DefaultDBCp =
<br /> DSNAOINI =
<br /> DTW_APPLET_ALTTEXT =
<br /> DTW_ATTACHMENT_PATH =
<br /> DTW_CACHE_HOST =
<br /> DTW_CACHE_MACRO =
<br
/> DTW_CACHE_MANAGEMENT_INTERVAL =
<br /> DTW_CACHE_PAGE =
<br /> DTW_CACHE_PORT =
<br /> DTW_CM_PORT =
<br
/> DTW_COBOL_PARAMETER_BUFFER_SIZE =
<br
/> DTW_COBOL_PARAMETER_BUFFER_SIZE =
<br
/> DTW_CURRENT_FILENAME = /vcehttp/sqlquery/macro.txt
<br
/> DTW_CURRENT_LAST_MODIFIED = Mon
Oct 24 15:35:18 2005
<br
/> DTW_DEFAULT_ERROR_MESSAGE =
<br /> DTW_DEFAULT_MACRO =
<br /> DTW_DEFAULT_MESSAGE =
<br /> DTW_DEFAULT_REPORT =
<br /> DTW_DIRECT_REQUEST =
<br
/> DTW_DO_NOT_CACHE_MACRO =
<br /> DTW_EDIT_CODES =
<br
/> DTW_ERROR_LOG_DIR = /VCEHTTPT/sqlQuery/
<br
/> DTW_ERROR_LOG_LEVEL = ALL
<br /> DTW_HTML_TABLE =
<br /> DTW_INST_DIR =
<br /> DTW_LOB_DIR =
<br /> DTW_LOB_LIFETIME =
<br /> DTW_LOG_DIR =
<br /> DTW_LOG_LEVEL =
<br /> DTW_LOG_LEVEL =
<br
/> DTW_MACRO_FILENAME = /vcehttp/sqlquery/macro.txt
<br
/> DTW_MACRO_LAST_MODIFIED = Mon Oct
24 15:35:18 2005
<br /> DTW_MBMODE =
<br /> DTW_MBMODE =
<br
/> DTW_MP_PATH = /sqlquery/CGI
<br
/> DTW_MP_VERSION = IBM-AS/400-NET.DATA
<br /> DTW_OUTPUT_DIR =
<br /> DTW_PAD_PGM_PARMS =
<br /> DTW_PRINT_HEADER =
<br /> DTW_REMOVE_WS =
<br /> DTW_REMOVE_WS =
<br /> DTW_SAVE_TABLE_IN =
<br /> DTW_SET_TOTAL_ROWS =
<br /> DTW_SHOWSQL =
<br /> DTW_SMTP_CHARSET =
<br /> DTW_SMTP_SERVER =
<br /> DTW_SQL_ISOLATION =
<br /> DTW_SQL_NAMING_MODE =
<br /> DTW_STORE_PAGE =
<br
/> DTW_TRACE_LOG_DIR = /VCEHTTPT/sqlQuery/
<br
/> DTW_TRACE_LOG_LEVEL = APPLICATION
<br /> DTW_UNICODE =
<br /> DTW_UPLOAD_DIR =
<br
/> DTW_USE_DB2_PREPARE_CACHE =
<br
/> DTW_USE_DB2_PREPARE_CACHE =
<br /> DTW_VARIABLE_SCOPE =
<br /> EXEC_PATH =
<br /> FFI_PATH =
<br /> HTML_PATH =
<br /> INCLUDE_PATH =
<br /> LOCATION =
<br /> LOGIN =
<br /> MACRO_PATH =
<br /> NLIST =
<br /> Nn =
<br /> NULL_RPT_FIELD =
<br /> NUM_COLUMNS =
<br /> NUM_ROWS =
<br /> PASSWORD =
<br /> RETURN_CODE = 0
<br /> ROW_NUM =
<br /> RPT_MAX_ROWS =
<br /> SHOWSQL =
<br /> SQL_CODE = 0
<br /> SQL_STATE = 00000
<br /> START_ROW_NUM =
<br /> TOTAL_ROWS =
<br /> TRANSACTION_SCOPE =
<pre>
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
</pre>
</body>
</html>
xmlresulthtml=
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
debug
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
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
This tool is a free source text; you can redistribute it and/or modify it as much as you need. Just add as comment in the code a reference to this site : http://jplamontre.free.fr/jpltools.htm ... and send me an email Contact with "jpltools" in the subject (it's for my antispam rules). I will be happy to know what you have done with the jpltools. This tool is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY :
THIS TOOLBOX IS PROVIDED ''AS IS'' AND ANY EXPRESSED OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE PROVIDER OR ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS TOOLBOX, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.