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" .