Dear All,
I’m doing some basic tests with JDBC connections with jBase (TAFC Major 09.0
, Minor 0.0 on Red Hat Enterprise Linux Server release 5.5, jDK 1.6).
Given below is the java code to extract the F_BATCH table which works fine.
The question for me is how to differentiate the relative Multi values & sub
values within the record.
Eg. I need to know the multi value & sub value position of the extracted
record like below.
RECORD<6,6> = ‘EB.PRINT’
RECORD<11,6,1> = ‘ENQ COMP.D.DAILY’
RECORD<11,6,2> = ‘ENQ COMP.D.DIETZ’
How I can do this mapping with the data received from the JDBC connection.
Java Code :
* stat = cx.createStatement();*
* ResultSet rs = stat.executeQuery("SELECT
BATCH_PROCESS,JOB_NAME, K_DATA FROM F_BATCH_JBL");*
* *
* //Obtain the meta data associated to the result set to print
the no. of columns*
* ResultSetMetaData rsMetaData = rs.getMetaData();*
* System.out.println("Number of columns: " +
rsMetaData.getColumnCount());*
* *
* //Fetch all rows and display the first column *
* *
* while(rs.next()) {*
* System.out.println("Record : " + rs.getString("BATCH_PROCESS")
+ " - Job Name: " + rs.getString("JOB_NAME") + " - Data : " +
rs.getString("K_DATA"));*
* *
Full view of the actual record:
BATCH PROCESS..... SG1/AM.COMP.BATCH
------------------------------------------------------------------------------
6. 1 JOB.NAME....... AM.COMP.HIST.DET.UPD
6. 2 JOB.NAME....... AM.COMP.HIST.UPD
12. 2 JOB.STATUS..... 0 READY
6. 3 JOB.NAME....... AM.COMP.HIST.UPD.POST
6. 4 JOB.NAME....... AM.COMP.YLY.UPD
6. 5 JOB.NAME....... AM.COMP.YLY.UPD.POST
6. 6 JOB.NAME....... EB.PRINT
11. 6. 1 DATA........ ENQ COMP.D.DAILY
11. 6. 2 DATA........ ENQ COMP.D.DIETZ
6. 7 JOB.NAME....... EB.PRINT
11. 7. 1 DATA........ ENQ COMP.HM.DAILY
11. 7. 2 DATA........ ENQ COMP.HM.DIETZ
Output of the program :
Record : SG1/AM.COMP.BATCH - Job Name: AM.COMP.HIST.DET.UPD - Data :
Record : SG1/AM.COMP.BATCH - Job Name: AM.COMP.HIST.DET.UPD - Data :
Record : SG1/AM.COMP.BATCH - Job Name: AM.COMP.HIST.DET.UPD - Data :
Record : SG1/AM.COMP.BATCH - Job Name: AM.COMP.HIST.DET.UPD - Data :
Record : SG1/AM.COMP.BATCH - Job Name: AM.COMP.HIST.DET.UPD - Data :
Record : SG1/AM.COMP.BATCH - Job Name: AM.COMP.HIST.DET.UPD - Data : ENQ
COMP.D.DAILY
Record : SG1/AM.COMP.BATCH - Job Name: AM.COMP.HIST.DET.UPD - Data : ENQ
COMP.D.DIETZ
Record : SG1/AM.COMP.BATCH - Job Name: AM.COMP.HIST.DET.UPD - Data : ENQ
COMP.HM.DAILY
Record : SG1/AM.COMP.BATCH - Job Name: AM.COMP.HIST.DET.UPD - Data : ENQ
COMP.HM.DIETZ
Record : SG1/AM.COMP.BATCH - Job Name: AM.COMP.HIST.UPD - Data :
Record : SG1/AM.COMP.BATCH - Job Name: AM.COMP.HIST.UPD - Data :
Record : SG1/AM.COMP.BATCH - Job Name: AM.COMP.HIST.UPD - Data :
Record : SG1/AM.COMP.BATCH - Job Name: AM.COMP.HIST.UPD - Data :
Record : SG1/AM.COMP.BATCH - Job Name: AM.COMP.HIST.UPD - Data :
Record : SG1/AM.COMP.BATCH - Job Name: AM.COMP.HIST.UPD - Data : ENQ
COMP.D.DAILY
Record : SG1/AM.COMP.BATCH - Job Name: AM.COMP.HIST.UPD - Data : ENQ
COMP.D.DIETZ
Record : SG1/AM.COMP.BATCH - Job Name: AM.COMP.HIST.UPD - Data : ENQ
COMP.HM.DAILY
Record : SG1/AM.COMP.BATCH - Job Name: AM.COMP.HIST.UPD - Data : ENQ
COMP.HM.DIETZ
Record : SG1/AM.COMP.BATCH - Job Name: AM.COMP.HIST.UPD.POST - Data :
Record : SG1/AM.COMP.BATCH - Job Name: AM.COMP.HIST.UPD.POST - Data :
Record : SG1/AM.COMP.BATCH - Job Name: AM.COMP.HIST.UPD.POST - Data :
Record : SG1/AM.COMP.BATCH - Job Name: AM.COMP.HIST.UPD.POST - Data :
Record : SG1/AM.COMP.BATCH - Job Name: AM.COMP.HIST.UPD.POST - Data :
Record : SG1/AM.COMP.BATCH - Job Name: AM.COMP.HIST.UPD.POST - Data : ENQ
COMP.D.DAILY
Record : SG1/AM.COMP.BATCH - Job Name: AM.COMP.HIST.UPD.POST - Data : ENQ
COMP.D.DIETZ
Record : SG1/AM.COMP.BATCH - Job Name: AM.COMP.HIST.UPD.POST - Data : ENQ
COMP.HM.DAILY
Record : SG1/AM.COMP.BATCH - Job Name: AM.COMP.HIST.UPD.POST - Data : ENQ
COMP.HM.DIETZ
Record : SG1/AM.COMP.BATCH - Job Name: AM.COMP.YLY.UPD - Data :
Record : SG1/AM.COMP.BATCH - Job Name: AM.COMP.YLY.UPD - Data :
Record : SG1/AM.COMP.BATCH - Job Name: AM.COMP.YLY.UPD - Data :
Record : SG1/AM.COMP.BATCH - Job Name: AM.COMP.YLY.UPD - Data :
Record : SG1/AM.COMP.BATCH - Job Name: AM.COMP.YLY.UPD - Data :
Record : SG1/AM.COMP.BATCH - Job Name: AM.COMP.YLY.UPD - Data : ENQ
COMP.D.DAILY
Record : SG1/AM.COMP.BATCH - Job Name: AM.COMP.YLY.UPD - Data : ENQ
COMP.D.DIETZ
Record : SG1/AM.COMP.BATCH - Job Name: AM.COMP.YLY.UPD - Data : ENQ
COMP.HM.DAILY
Record : SG1/AM.COMP.BATCH - Job Name: AM.COMP.YLY.UPD - Data : ENQ
COMP.HM.DIETZ
Record : SG1/AM.COMP.BATCH - Job Name: AM.COMP.YLY.UPD.POST - Data :
Record : SG1/AM.COMP.BATCH - Job Name: AM.COMP.YLY.UPD.POST - Data :
Record : SG1/AM.COMP.BATCH - Job Name: AM.COMP.YLY.UPD.POST - Data :
Record : SG1/AM.COMP.BATCH - Job Name: AM.COMP.YLY.UPD.POST - Data :
Record : SG1/AM.COMP.BATCH - Job Name: AM.COMP.YLY.UPD.POST - Data :
Record : SG1/AM.COMP.BATCH - Job Name: AM.COMP.YLY.UPD.POST - Data : ENQ
COMP.D.DAILY
Record : SG1/AM.COMP.BATCH - Job Name: AM.COMP.YLY.UPD.POST - Data : ENQ
COMP.D.DIETZ
Record : SG1/AM.COMP.BATCH - Job Name: AM.COMP.YLY.UPD.POST - Data : ENQ
COMP.HM.DAILY
Record : SG1/AM.COMP.BATCH - Job Name: AM.COMP.YLY.UPD.POST - Data : ENQ
COMP.HM.DIETZ
Record : SG1/AM.COMP.BATCH - Job Name: EB.PRINT - Data :
Record : SG1/AM.COMP.BATCH - Job Name: EB.PRINT - Data :
Record : SG1/AM.COMP.BATCH - Job Name: EB.PRINT - Data :
Record : SG1/AM.COMP.BATCH - Job Name: EB.PRINT - Data :
Record : SG1/AM.COMP.BATCH - Job Name: EB.PRINT - Data :
Record : SG1/AM.COMP.BATCH - Job Name: EB.PRINT - Data : ENQ COMP.D.DAILY
Record : SG1/AM.COMP.BATCH - Job Name: EB.PRINT - Data : ENQ COMP.D.DIETZ
Record : SG1/AM.COMP.BATCH - Job Name: EB.PRINT - Data : ENQ COMP.HM.DAILY
Record : SG1/AM.COMP.BATCH - Job Name: EB.PRINT - Data : ENQ COMP.HM.DIETZ
Record : SG1/AM.COMP.BATCH - Job Name: EB.PRINT - Data :
Record : SG1/AM.COMP.BATCH - Job Name: EB.PRINT - Data :
Record : SG1/AM.COMP.BATCH - Job Name: EB.PRINT - Data :
Record : SG1/AM.COMP.BATCH - Job Name: EB.PRINT - Data :
Record : SG1/AM.COMP.BATCH - Job Name: EB.PRINT - Data :
Record : SG1/AM.COMP.BATCH - Job Name: EB.PRINT - Data : ENQ COMP.D.DAILY
Record : SG1/AM.COMP.BATCH - Job Name: EB.PRINT - Data : ENQ COMP.D.DIETZ
Record : SG1/AM.COMP.BATCH - Job Name: EB.PRINT - Data : ENQ COMP.HM.DAILY
Record : SG1/AM.COMP.BATCH - Job Name: EB.PRINT - Data : ENQ COMP.HM.DIETZ
Thanks for the Help.
Best regards,
Samith
--
Please read the posting guidelines at:
http://groups.google.com/group/jBASE/web/Posting%20Guidelines
IMPORTANT: Type T24: at the start of the subject line for questions specific to
Globus/T24
To post, send email to [email protected]
To unsubscribe, send email to [email protected]
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en
