Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
how to write this expression in our QV, I got the req from users and I need to covert it to QV
select A.CHECK_ERROR_NUMBER, A.CONTRACT_REFERENCE, B.NUMMSG, B.PRODUCTS, C.MESSAGE from RETAIL_EXPOSURE#CR A, TABLE_CONSTRAINTS B, ERROR_MESSAGES C |
Hi,
If the sql transaction works properly, there's no need to adjust almost anything. Obviously, previous to the following sentence, you should construct the connection string to the SQL Server and database.
Table1:
LOAD *;
SQL select
A.CHECK_ERROR_NUMBER,
A.CONTRACT_REFERENCE,
B.NUMMSG, B.PRODUCTS,
C.MESSAGE
From RETAIL_EXPOSURE#CR A, TABLE_CONSTRAINTS B, ERROR_MESSAGES C
Where
A.CHECK_ERROR_NUMBER = B.CONSTRAINT_ID
And A.CHECK_ERROR_NUMBER = '9846'
And CONTRACT_REFERENCE = 'MMJYQJYJYT'
And B.NUMMSG = C.NUMMSG
And B.TABLE_NAME = C.TABLE_NAME
And B.NUMMSG = '20034';
Regards.
Hi Raj,
were you finally able to load the data? If so, please mark the answer as correct to close the thread.
If not, do not hesitate to ask for further help
Cheers!