Problem with a WHERE statement

[somi]

Hello all,

I would like to filter all numbers smaller than 215855772 in the vorgang_status column directly in the script. However, the import to the view always breaks with the error message unknown command (where "vorgang_status" <= 215855772)...

Here is my script:

LOAD "ansprechpartner_dbid",
"bearbeiter_dbid",
"beleg_datum",
bezeichnung,
"vorgang_status",
zahlbetrag;
SQL SELECT "ansprechpartner_dbid",
"bearbeiter_dbid",
"beleg_datum",
bezeichnung,
"vorgang_status",
zahlbetrag
FROM pdserp."public"."pds_rechnung";
where "vorgang_status" <= 215855772;

Would appreciate a response.

Many greetings
Martin

[Kushal_Chawda · Accepted solution]

@somi  remove the semicolon(;) as highlighted in red

LOAD "ansprechpartner_dbid",
"bearbeiter_dbid",
"beleg_datum",
bezeichnung,
"vorgang_status",
zahlbetrag;
SQL SELECT "ansprechpartner_dbid",
"bearbeiter_dbid",
"beleg_datum",
bezeichnung,
"vorgang_status",
zahlbetrag
FROM pdserp."public"."pds_rechnung";
where "vorgang_status" <= 215855772;