Notifications

30 views

Description

You have a JDBC data source that sets the Query value to "All Rows from Table" or has it set to "Specific SQL" with this example SQL:

SELECT * FROM Employee

If you select "Test Load 20 Records" or select "Load All Records" from the Related Links the SQL query sent is the same for both options.

In other words selecting "Test Load 20 Records" does not send SQL that limits the number of records to be returned to 20.

When selecting "Test Load 20 Records" the system just loads the first 20 records into the import set table, but the SQL query is the same as when selecting "Load All Records"

Using the example of Query = "Specific SQL":

SELECT * FROM Employee

If selecting "Test Load 20 Records" or "Load All Records" and the mid server agent log is checked the query will be the same (SELECT * FROM Employee):

04/23/20 14:19:03 (581) Worker-Standard:JDBCProbe-d23246e61b5c1c5055ca64a6bc4bcbe9 Worker starting: JDBCProbe source: b82c25784f02260061d96bd18110c765
04/23/20 14:19:03 (914) Worker-Standard:JDBCProbe-d23246e61b5c1c5055ca64a6bc4bcbe9 Waiting for connection semaphore
04/23/20 14:19:03 (914) Worker-Standard:JDBCProbe-d23246e61b5c1c5055ca64a6bc4bcbe9 Obtained connection semaphore
04/23/20 14:19:03 (914) Worker-Standard:JDBCProbe-d23246e61b5c1c5055ca64a6bc4bcbe9 SELECT * FROM Employee
04/23/20 14:19:03 (918) Worker-Standard:JDBCProbe-d23246e61b5c1c5055ca64a6bc4bcbe9 Enqueuing: /u01/mid_server/agent/work/monitors/ECCSender/output_s/ecc_queue.171a8e888eb0000001.xml
04/23/20 14:19:03 (924) Worker-Standard:JDBCProbe-d23246e61b5c1c5055ca64a6bc4bcbe9 Enqueuing: /u01/mid_server/agent/work/monitors/ECCSender/output_s/ecc_queue.171a8e888ef0000001.xml
04/23/20 14:19:03 (925) Worker-Standard:JDBCProbe-d23246e61b5c1c5055ca64a6bc4bcbe9 Worker completed: JDBCProbe source: b82c25784f02260061d96bd18110c765 time: 0:00:00.334
04/23/20 14:19:03 (956) ECCSender.1 Sending ecc_queue.171a8e888eb0000001.xml
04/23/20 14:19:04 (126) ECCSender.1 Sending ecc_queue.171a8e888ef0000001.xml

If you want to place a limit on how many rows are returned it will be necessary to set Query = "Specific SQL" and modify the SQL to only return a limited number of rows based on the syntax of the database type being queried.

Release or Environment

Applies to any release.

Article Information

Last Updated:2020-04-24 07:33:40
Published:2020-04-24