Data Pull Error

[RichardLee]

I've got the follwoing Error

The following error occurred:

Connector reply error: SQL##f - SqlState: HY000, ErrorCode: 7200, ErrorMsg: [iAnywhere Solutions][Advantage SQL][ASA] Error 7200: AQE Error: State = S0000; NativeError = 2158; [SAP][Advantage SQL Engine]Scalar function not found: Null -- Location of error in the SQL statement is: 194 (line: 8 column: 89)

Could anyone help me please the data I'm trying to pull Takes over 1hr and I need to shorten the time by only pulling todays information.

LOAD
'UK' as [Branch],
'UK'&'-'&"QD_KEY" as [OrdKey],
"QD_KEY",
Date(if("QD_DATE">=Today(),"QD_DATE",Null()),'DD/MM/YYYY') as "QD_DATE",
"QD_TIME",
"QD_USER",
"QD_NAME",
trim("QD_NOTES") as Notes;
SQL SELECT "QD_KEY",
"QD_DATE",
"QD_TIME",
"QD_USER",
"QD_NAME",
"QD_NOTES"

FROM "\\********\fgho\Apps\Gtrak3\Data\FIREHO.add".OPT310D where "QD_DATE" <> Null();

[Chip_Matejowsky · Accepted solution]

Hello @RichardLee,

So that error isn't a Qlik error per se, as it is the error that Qlik is receiving from the source.  Suggest that you work with your internal DBA or contact Advantage Database support regarding the error https://devzone.advantagedatabase.com/dz/webhelp/advantage10/index.html?error_2158_scalar_function_n...

Best Regards