Load Where.

[bnelson111]

Currently I have a working Load where Statement as follows.

Where "SysDate" > '01/01/2015';

How do i add the following where it filter down unnecessary data.

Receipt Info.TxnType equal to 2 or 3 or 6

i have tried

Where "SysDate" > '01/01/2015' and Where [Receipt Info.TxnType] = 2,3,6;

Thanks Brett, Maybe i have had a brain freeze

[kaushiknsolanki]

Try,

Where "SysDate" > '01/01/2015' and match([Receipt Info.TxnType],2,3,6)

Regards,

Kaushik Solanki

[jagan]

Hi,

Try this

Where "SysDate" > '01/01/2015' and Match( [Receipt Info.TxnType], 2,3,6);

Regards,

Jagan.

[Peter_Cammaert]

If this is a WHERE clause in a LOAD statement, try with

:

WHERE (SysDate > '01/01/2015') AND Match(TxnType, 2, 3, 6);

If this is a SQL WHERE clause (e.g. used in a SELECT statement), please tell us what DBMS you're writting code for.

Peter

[Kushal_Chawda]

Hi

Use the where as below

where date(SysDate,'DD/MM/YYYY')>date#('01/01/2015','DD/MM/YYYY')

and match([Receipt Info.TxnType] ,'2','3','6')

[bnelson111]

Getting the following error

SQL##f - SqlState: S1000, ErrorCode: 4294757240, ErrorMsg: [DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Syntax error in SQL statement at or about "[Receipt Info.TxnType],2,3,6)" (10713)

SQL SELECT *

FROM PUB."PV_InvHistory"

Where "SysDate" > '01/01/2015' and match([Receipt Info.TxnType],2,3,6)

[bnelson111]

Getting the following error

SQL##f - SqlState: S1000, ErrorCode: 4294757240, ErrorMsg: [DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Syntax error in SQL statement at or about "[Receipt Info.TxnType],2,3,6)" (10713)

SQL SELECT *

FROM PUB."PV_InvHistory"

Where "SysDate" > '01/01/2015' and match([Receipt Info.TxnType],2,3,6)

[bnelson111]

Getting back the following error

SQL##f - SqlState: S1000, ErrorCode: 4294757240, ErrorMsg: [DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Syntax error in SQL statement at or about "[Receipt Info.TxnType],2,3,6)" (10713)

SQL SELECT *

FROM PUB."PV_InvHistory"

Where "SysDate" > '01/01/2015' and match([Receipt Info.TxnType],2,3,6)

[jagan]

Hi,

If you are using in Database the use IN()

SQL SELECT *

FROM PUB."PV_InvHistory"

Where "SysDate" > '01/01/2015' and [Receipt Info.TxnType] IN (2,3,6);

Regards,

jagan.

[Peter_Cammaert]

That is because the syntax we all suggested is for a LOAD statement, not for a SQL SELECT. You cannot mix parts of different script languages.

The WHERE clause should be put in Progress SQL, and that version may not have a match function. Does it have something comparable, or does it have the ...TxnType IN (2,3,6) set membership operator?

Peter