Skip to Content
0
Former Member
Nov 15, 2010 at 06:50 PM

COMMAND AND PARAMETERS

111 Views

i have a command file

i need to have multiple parameters in the command. also need the option to select ALL values from the command parameter what is the syntax?

i have one parameter WHERE "FSLEDG"."ESRECO"={?ALLOWANCE STATUS}

i need to add a second one.

I add it to the WHERE "FSLEDG"."ESRECO"={?ALLOWANCE STATUS}

AND "FGLEDG"."EGDIVI"={?COMPANY}

i receive an error COLUMN AAA NOT IN SPECIFIED TABLES.

when i hardcode the value AND "FGLEDG"."EGDIVI"= AAA i dont receive an error.

SELECT

"FSLEDG"."ESTRCD",

"FSLEDG"."ESCUAM",

"FSLEDG"."ESIVDT",

"FSLEDG"."ESRECO",

"FGLEDG"."EGAIT1",

"FSLEDG"."ESCUNO",

"FGLEDG"."EGAIT7",

"FGLEDG"."EGVTXT",

"FCHACC"."EATX15",

"FGLEDG"."EGAIT3",

"FSLEDG"."ESCINO",

"FSLEDG"."ESDIVI",

"FGLEDG"."EGDIVI",

"FSLEDG"."ESDTP5",

"FGLEDG"."EGVSER"

FROM {oj ("I5M3AD"."M3DDBPRD"."FSLEDG" "FSLEDG" LEFT OUTER JOIN "I5M3AD"."M3DDBPRD"."FGLEDG" "FGLEDG" ON ((((("FSLEDG"."ESCONO"="FGLEDG"."EGCONO") AND ("FSLEDG"."ESDIVI"="FGLEDG"."EGDIVI")) AND ("FSLEDG"."ESVSER"="FGLEDG"."EGVSER")) AND ("FSLEDG"."ESVONO"="FGLEDG"."EGVONO")) AND ("FSLEDG"."ESYEA4"="FGLEDG"."EGYEA4")) AND ("FSLEDG"."ESJRNO"="FGLEDG"."EGJRNO")) LEFT OUTER JOIN "I5M3AD"."M3DDBPRD"."FCHACC" "FCHACC" ON (("FGLEDG"."EGCONO"="FCHACC"."EACONO") AND ("FGLEDG"."EGDIVI"="FCHACC"."EADIVI")) AND ("FGLEDG"."EGAIT3"="FCHACC"."EAAITM")}

WHERE "FSLEDG"."ESRECO"={?ALLOWANCE STATUS}

AND ("FGLEDG"."EGAIT1"='32400' OR "FGLEDG"."EGAIT1"='32500' OR "FGLEDG"."EGAIT1"='51725')

ORDER BY "FSLEDG"."ESCINO"