SQL query through batch or Datacom Server for ABC table not returning data in Dataquery

Products

• Datacom
• Datacom/AD
• Datacom/DB

Issue/Introduction

The SQL query gets error:

DQ093E - URI=YES IS REQUIRED FOR SQL TO USE TABLE (DATACOM-NAME) ABC DBID 123

Other tables in same database 123 are successfully queried. Even ABC table can be accessed through Dataquery from other MUFs in the environment.

CXX report shows ABC table in all MUFs set to URI-REUSE NO.

Resolution

Reset your High-Speed Directory (HSD) Table in the MUF that has the error by following these steps:

1. Run this JCL using DDCFBLD:

//HSDRESET JOB ...                                                   
//*------------------------------------------------------------------
//*     Enter the HLQ of the CUSTOM DB 15.1 Files (CUSMAC/CUSPROC)   
//      SET  CUSHLQ=CAI.CHLQ                                         
//*                                                                  
//*------------------------------------------------------------------
//*                                                                  
//      JCLLIB ORDER=&CUSHLQ..CUSPROC                                
//*                                                                  
//*------------------------------------------------------------------
//*     Execute DDCFBLD to reset the HSD file                        
//*------------------------------------------------------------------
//HSDRESET EXEC PGM=DDCFBLD,REGION=0M                                
//         INCLUDE MEMBER=B15STLIB                                   
//         INCLUDE MEMBER=B15DDCXX                                   
//         INCLUDE MEMBER=B15DDOUT                                   
//*                                                                  
//SYSIN   DD DISP=SHR,DSN=&CUSHLQ..CUSMAC(USRACC)                    
//        DD DISP=SHR,DSN=&CUSHLQ..CUSMAC(HSDRST)                    
//                                                                   

2. When complete, you need to DBOC close and then open DB 123 in the problem CICS region.

3. Retry your online query.

Additional Information

DQ093E

HSD RESET - Resetting the HSD Table