Java Application Query Library for Pixel Production
Database
TEST DATA: ELECTRONICS
Query Test data by test number in the Test data FAILURE CODE table:
String[]
FlexTests_Lib.GetTestDataFAILURECODEByTN (Connection conn, String
Test_number)
Returns array dimension 5
of String
where
array
[0] is
Test number
array
[1] is
Failure code value
array
[2]
is Status
array
[3]
is
last modified date,
format "
DD/MM/YYYY"
array
[4]
is owner
If Test is not found in the
FAILURE CODE table, all the values of array are being set up
to "-1".
Query Test number by test data in the FAILURE CODE table:
String[]
FlexTests_Lib.GetTNByTestDataFAILURECODE(Connection
conn,
String
Failure_Code,
String Status,
String last_modified_start,
String
last_modified_stop,
String
owner)
Returns array of String
where
array[0] is the number of non-zero elements and
array[1]
-
array[n] are Test numbers found by query,
where n =
Integer.parseInt(array[0])
Maximum array dimension is set up to
1
000 000
Input parameter not participating in query must be set to "%".
Input parameters: Failure_Code and
Status
may
be set to "%"+<known
symbols>+"%".
Date format is "DD/MM/YYYY",
"today"
is acceptable.
If no Test found, array[0] = "0"
.
Query Test data by test number in the Test data CALIBRATION table:
String[]
FlexTests_Lib.GetTestDataCALIBRATIONByTN (Connection conn, String
Test_number)
Returns array dimension 11
of String
where
array
[0] is
Test number
array
[1] is
the value for the low capacitor
array
[2] is
the value for the hi+low capacitor
array
[3] is
first term of the cubic fit
array
[4] is
second term of the cubic fit
array
[5] is
third term of the cubic fit
array
[6] is
fourth term of the cubic fit
array
[7] is
difference between internal and external threshold
array
[8]
is Status
array
[9]
is
last modified date,
format "
DD/MM/YYYY"
array[10]
is owner
If Test is not found in the
CALIBRATION table, all the values of array are being set up
to "-1".
Query Test number by test data in the CALIBRATION table:
String[]
FlexTests_Lib.GetTNByTestDataCALIBRATION(Connection
conn,
String
Low_Cap_start,
String Low_Cap_stop,
String
Hi_Low_Cap_start,
String Hi_Low_Cap_stop,
String
Cubic_1_Fit_start,
String Cubic_1_Fit_stop,
String
Cubic_2_Fit_start,
String Cubic_2_Fit_stop,
String
Cubic_3_Fit_start,
String Cubic_3_Fit_stop,
String
Cubic_4_Fit_start,
String Cubic_4_Fit_stop,
String
Int_Ext_Diff_start,
String Int_Ext_Diff_stop,
String Status,
String last_modified_start,
String
last_modified_stop,
String
owner)
Returns array of String
where
array[0] is the number of non-zero elements and
array[1]
-
array[n] are Test numbers found by query,
where n =
Integer.parseInt(array[0])
Maximum array dimension is set up to
1
000 000
Input parameter not participating in query must be set to "%".
Input parameter: Status
may
be set to "%"+<known
symbols>+"%".
Date format is "DD/MM/YYYY",
"today"
is acceptable.
If no Test found, array[0] = "0"
.
Query
Test data by test number in the Test data MCC VDD table:
String[]
FlexTests_Lib.GetTestDataMCCVDDByTN (Connection conn, String
Test_number)
Returns array dimension 5
of String
where
array
[0] is
Test number
array
[1] is
VDD, V
array
[2]
is Status
array
[3]
is
last modified date,
format "
DD/MM/YYYY"
array
[4]
is owner
If Test is not found in the
MCC VDD table, all the values of array are being set up
to "-1".
Query Test number by test data in the MCC VDD table:
String[]
FlexTests_Lib.GetTNByTestDataMCCVDD(Connection
conn,
String
VDD_start,
String VDD_stop,
String Status,
String last_modified_start,
String
last_modified_stop,
String
owner)
Returns array of String
where
array[0] is the number of non-zero elements and
array[1]
-
array[n] are Test numbers found by query,
where n =
Integer.parseInt(array[0])
Maximum array dimension is set up to
1
000 000
Input parameter not participating in query must be set to "%".
Input parameter: Status
may
be set to "%"+<known
symbols>+"%".
Date format is "DD/MM/YYYY",
"today"
is acceptable.
If no Test found, array[0] = "0"
.