insert into jemshdp12.cccaefp values(
'REFER',
'LINEBARGER LAW FIRM',
'ftp.publicans.com',
'anonymous',
'help@lgbs.com',
'\FF_Harris_CO_TX_JP',
'L'
)

SELECT 'JP 1-1', JEMSHDP11.CCCAEFP.* FROM JEMSHDP11.CCCAEFP WHERE SJYLTT LIKE '%LINEBARGER%'
UNION
SELECT 'JP 1-2', JEMSHDP12.CCCAEFP.* FROM JEMSHDP12.CCCAEFP WHERE SJYLTT LIKE '%LINEBARGER%'
UNION
SELECT 'JP 2-1', JEMSHDP21.CCCAEFP.* FROM JEMSHDP21.CCCAEFP WHERE SJYLTT LIKE '%LINEBARGER%'
UNION
SELECT 'JP 2-2', JEMSHDP22.CCCAEFP.* FROM JEMSHDP22.CCCAEFP WHERE SJYLTT LIKE '%LINEBARGER%'
UNION
SELECT 'JP 5-1', JEMSHDP51.CCCAEFP.* FROM JEMSHDP51.CCCAEFP WHERE SJYLTT LIKE '%LINEBARGER%'
UNION
SELECT 'JP 5-2', JEMSHDP52.CCCAEFP.* FROM JEMSHDP52.CCCAEFP WHERE SJYLTT LIKE '%LINEBARGER%'
UNION
SELECT 'JP 6-1', JEMSHDP61.CCCAEFP.* FROM JEMSHDP61.CCCAEFP WHERE SJYLTT LIKE '%LINEBARGER%'
UNION
SELECT 'JP 6-2', JEMSHDP62.CCCAEFP.* FROM JEMSHDP62.CCCAEFP WHERE SJYLTT LIKE '%LINEBARGER%'