partiall Select with where condition

[#1]

Hello,

I wanted to load data via SQL-Select from an ODBC Database. The QlikView file already load all Data from the Database (this takes a very long time). And now I want to update the Data to the newest Version. There is an timstamp in the Table which I wanted to use like this:

SQL Select
...
FROM ...

where timestamp >= old timestamp which is already loaded in the file.

But theres an error: oldtimstamp is invalid in the used context

best regards
Ingo Placzek

[biester]

Try with a variable:

let oldtimestamp = .....

SQL select ....
FROM .....
where timestamp >= $(oldtimestamp) ....

Rgds,
Joachim

[#3]

hi, then he told me:

Invalid use of a column or OLAP function

[biester]

Would be helpful if you posted the script.

[#5]

add

Max

(Status.LASTOCCURRENCE) as oldLASTOCCURRENCE

resident

Status;

Status:

add

Load

*

,

week

(FIRSTOCCURRENCE) as Woche,

year

(FIRSTOCCURRENCE) as Jahr,

month

(FIRSTOCCURRENCE) as Monat,

day

(FIRSTOCCURRENCE) as Tag,

hour

(FIRSTOCCURRENCE) as Stunde,

minute

(FIRSTOCCURRENCE) as Minute;

Status:

SQL

SELECT

ACKNOWLEDGED,

ADVCORRCAUSETYPE,

ADVCORRSERVERNAME,

ADVCORRSERVERSERIAL,

AGENT,

ALERTGROUP,

ALERTKEY,

CAUSETYPE,

CLASS,

CORRSCORE,

CUSTOMER,

DELETEDAT,

DUPSERIAL,

DVAGENTOS,

DVAPPHBMAXAGE,

DVEVENTSTOESCAL,

DVEVTSTOESCAL,

DVITMAGENTMONSOURCE,

DVITMAGENTPOLICYID,

DVITMAGENTVER,

DVKLSTATUS,

EVENTID,

EXPIRETIME,

EXTENDEDATTR,

FIRSTOCCURRENCE,

FLASH,

FQMANAGER,

GRADE,

IDENTIFIER,

LASTMODIFIED,

LASTOCCURRENCE,

LOCALNODEALIAS,

LOCALOBJRELATE,

LOCALPRIOBJ,

LOCALROOTOBJ,

LOCALSECOBJ,

LOCALTERTOBJ,

LOCATION,

LOWESCL,

MANAGER,

NMOSCAUSETYPE,

NMOSDOMAINNAME,

NMOSENTITYID,

NMOSMANAGEDSTATUS,

NMOSOBJINST,

NMOSSERIAL,

NODE,

NODEALIAS,

ORIGINALSEVERITY,

OWNERGID,

OWNERUID,

PHYSICALCARD,

PHYSICALPORT,

PHYSICALSLOT,

POLL,

PROCESSREQ,

REMOTENODEALIAS,

REMOTEOBJRELATE,

REMOTEPRIOBJ,

REMOTEROOTOBJ,

REMOTESECOBJ,

REMOTETERTOBJ,

SERIAL,

SERVERNAME,

SERVERSERIAL,

SERVICE,

SEVERITY,

STATECHANGE,

SUMMARY,

SUPPRESSESCL,

TALLY,

TASKLIST,

"TYPE",

URL,

X733CORRNOTIF,

X733EVENTTYPE,

X733PROBABLECAUSE,

X733SPECIFICPROB

FROM

TG01885."REPORTER_STATUS"

where

FIRSTOCCURRENCE >= $(OLDLASTOCCURRENCE)

;

load

[#6]

this looks very bad. i copyed it out from qlikview

[biester]

Don't mix up columns and variables.

An example:

TABLE:
SQL SELECT MAX(DATUM) as COLUMN_MAXDAT from SQL_TABLE;

let VARIABLE_MAXDAT = peek('COLUMN_MAXDAT',0,'TABLE');

DATA:
SQL SELECT DATUM,RG_NR from SQL_TABLE where DATUM < '$(VARIABLE_MAXDAT)';

Rgds,
Joachim