Expression

[#1]

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
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'

[alex_millan]

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.

[alex_millan]

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!