Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Transact-SQL (2000)  0149: Host reference must have a domain specificat

Author  Topic  warrentt Starting Member 1 Post Posted - 2008-01-28 : 15:31:53 I get the above message error when I run my query. The database is written in MUMS language for the our host system Mckesson Star. I'm using a GUI called KB SQL. Thanks for your help. Main query----- DECLARE :XPMTAMT NUMERIC 15,2),:XACCT INT(10) SET METHOD=HOST_OUT, FILE='/appl/fin/data/ptpmt_fuletter.csv', FORMAT = 'COMMA' SELECT NULL FROM FT_TRAN_HIST_TRAN_DT_INDX WHERE TRAN_CD = 'T9200' AND TRAN_DT BETWEEN 09012007 AND TODAY-1 AND ((NOTE_LINK@CMNT_TXT LIKE '%808%') OR (NOTE_LINK@CMNT_TXT LIKE '%810%') OR (NOTE_LINK@CMNT_TXT LIKE '%815%') OR (NOTE_LINK@CMNT_TXT LIKE '%820%') OR (NOTE_LINK@CMNT_TXT LIKE '%825%')) AND FIN_LINK@PAT_LST_PMT_DT > (TRAN_DT + 59) ORDER BY PAT_ACCT_NBR INITIAL SET :XPMTAMT = 0, :XACCT=0 WRITE 'GUAR_NBR','ACCT_NBR','GUAR_NAME','CMNT_TXT','TRAN_DT', 'PAT_LST_PMT_DT','PT_PMT','FC' BREAK AT PAT_ACCT_NBR SET :XACCT = PAT_ACCT_NBR RUN QB_WT_PT_PMT_AFTER_FU_SUBQUERY DETAIL FIN_LINK@GUAR_DEMOG_LINK@CORP_NBR,PAT_ACCT_NBR ,FIN_LINK@GUAR_DEMOG_LINK@PAT_NAME,NOTE_LINK@CMNT_TXT ,TRAN_DT ,FIN_LINK@PAT_LST_PMT_DT,CASH_LINK@TRAN_AMT,FIN_LINK@FIN_CLASS BREAK AFTER PAT_ACCT_NBR SET :XPMTAMT = 0, :XACCT = 0 --SubQuery SET SUBQUERY = 'YES' DECLARE :XPMTAMT NUMERIC(15,2) ,:XACCT (10) SELECT NULL FROM PATIENT_ACTG.FT_TRAN_HIST_TRAN_DT_INDX WHERE :XACCT = PAT_ACCT_NBR AND TRAN_TYPE = 'P' ORDER BY PAT_ACCT_NBR BREAK AT PAT_ACCT_NBR SET :XPMTAMT = CASH_LINK@TRAN_AMT