Hi All,
I get the following Error message "
Started loading data
Connecting to LFS - EMEA
Connected
Item Master << PBFSTSS
Lines fetched: 715
Connecting to LFS - EMEA
Connected
Open Preadvice << PBESTSS
Lines fetched: 1.443
Connecting to LFS - EMEA
Connected
The following error occurred:
Connector reply error: SQL##f - SqlState: 37000, ErrorCode: 4294967192, ErrorMsg: [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0104 - Token . was not valid. Valid tokens: , FROM INTO.
The error occurred here:
SQL SELECT
TPKONZ,
TPFIRM,
TPPALN,
TPZUNV,
TPTTYP,
TPVSST,
TPNBER,
TPNREG,
TPNHOR,
TPNVER,
TPIDEN,
TPWENR,
TPBMEN,
TPQKZ,
TPLM,
TPDTA,
TPTIA,
TPAUSR,
FROM Z617D7F2.HE2DATV6.PBESTTP WHERE TPKONZ ='RTM' and TPFIRM ='110'
Data has not been loaded. Please correct the error and try loading again.
" when trying to load the following script.
SET ThousandSep='.';
SET DecimalSep=',';
SET MoneyThousandSep='.';
SET MoneyDecimalSep=',';
SET MoneyFormat='#.##0,00 €;-#.##0,00 €';
SET TimeFormat='hh:mm:ss';
SET DateFormat='DD.MM.YYYY';
SET TimestampFormat='DD.MM.YYYY hh:mm:ss[.fff]';
SET FirstWeekDay=0;
SET BrokenWeeks=0;
SET ReferenceDay=4;
SET FirstMonthOfYear=1;
SET CollationLocale='de-DE';
SET CreateSearchIndexOnReload=1;
SET MonthNames='Jan.;Feb.;März;Apr.;Mai;Juni;Juli;Aug.;Sep.;Okt.;Nov.;Dez.';
SET LongMonthNames='Januar;Februar;März;April;Mai;Juni;Juli;August;September;Oktober;November;Dezember';
SET DayNames='Mo.;Di.;Mi.;Do.;Fr.;Sa.;So.';
SET LongDayNames='Montag;Dienstag;Mittwoch;Donnerstag;Freitag;Samstag;Sonntag';
SET NumericalAbbreviation='3:k;6:M;9:G;12:T;15:P;18:E;21:Z;24:Y;-3:m;-6:μ;-9:n;-12:p;-15:f;-18:a;-21:z;-24:y';
// Item Master
LIB CONNECT TO 'LFS - EMEA';
[Item Master]:
LOAD
TZKONZ,
TZFIRM,
TZIDEN,
TZBRUT,
TZVLL,
TZVLB,
TZVLH,
DATE(DATE#(TZDTM,'YYYYMMDD')) as TZDTM, // formating LFS Date in Qlik Date
TIME(TIME#(TZTIM, If(len(Trim(TZTIM))=5,'hmmss','hhmmss'))) as TZTIM;// formating LFS Time in Qlik Time
SQL SELECT
TZKONZ,
TZFIRM,
TZIDEN,
TZBRUT,
TZVLL,
TZVLB,
TZVLH,
TZDTM,
TZTIM
FROM Z617D7F2.HE2DATV6.PBFSTSS WHERE TZKONZ = 'RTM' and TZFIRM = '110';
// Open Preadvice
LIB CONNECT TO 'LFS - EMEA';
[Open Preadvice]:
LOAD
SSKONZ,
SSFIRM,
SSSST,
SSIDEN,
SSZUNV,
SSWENR,
SSBMEN,
SSLM,
DATE(DATE#(SSDTBU,'YYYYMMDD')) as SSDTBU,// formating LFS Date in Qlik Date
SSQKZ;
SQL SELECT
SSKONZ,
SSFIRM,
SSSST,
SSIDEN,
SSZUNV,
SSWENR,
SSBMEN,
SSLM,
SSDTBU,
SSQKZ
FROM Z617D7F2.HE2DATV6.PBESTSS WHERE SSKONZ ='RTM' and SSFIRM ='110';
// Inbound Booking
LIB CONNECT TO 'LFS - EMEA';
[Inbound Booking]:
LOAD
TPKONZ,
TPFIRM,
TPPALN,
TPZUNV,
TPTTYP,
TPVSST,
TPNBER,
TPNREG,
TPNHOR,
TPNVER,
TPIDEN,
TPWENR,
TPBMEN,
TPQKZ,
TPLM,
DATE(DATE#(TPDTA,'YYYYMMDD')) as "TPDTA",// formating LFS Date in Qlik Date,
TIME(TIME#(TPTIA, If(len(Trim(TPTIA))=5,'hmmss','hhmmss'))) as "TPTIA",// formating LFS Time in Qlik Time,
TPAUSR;
SQL SELECT
TPKONZ,
TPFIRM,
TPPALN,
TPZUNV,
TPTTYP,
TPVSST,
TPNBER,
TPNREG,
TPNHOR,
TPNVER,
TPIDEN,
TPWENR,
TPBMEN,
TPQKZ,
TPLM,
TPDTA,
TPTIA,
TPAUSR,
FROM Z617D7F2.HE2DATV6.PBESTTP WHERE TPKONZ ='RTM' and TPFIRM ='110';
// Put Away
LIB CONNECT TO 'LFS - EMEA';
[Put Away]:
LOAD
TPKONZ,
TPFIRM,
TPPALN,
TPTTYP,
TPNBER,
TPNREG,
TPNHOR,
TPNVER,
DATE(DATE#(TPDTPP,'YYYYMMDD')) as "TPDTPP",// formating LFS Date in Qlik Date,
TIME(TIME#(TPTIPP, If(len(Trim(TPTIPP))=5,'hmmss','hhmmss'))) as "TPTIPP",// formating LFS Time in Qlik Time,
TPIDEN ,
TPBMEN,
TPLM,
TPUSER,
DATE(DATE#(TPDTTS,'YYYYMMDD')) as "TPDTTS",// formating LFS Date in Qlik Date,
TIME(TIME#(TPTITS, If(len(Trim(TPTITS))=5,'hmmss','hhmmss'))) as "TPTITS";// formating LFS Time in Qlik Time,
SQL SELECT
TPKONZ,
TPFIRM,
TPPALN,
TPTTYP,
TPNBER,
TPNREG,
TPNHOR,
TPNVER,
TPDTPP,
TPTIPP,
TPIDEN,
TPBMEN,
TPLM,
TPUSER,
TPDTTS,
TPTITS
FROM Z617D7F2.HE2DATV6.PHISTTP WHERE TPKONZ ='RTM' and TPFIRM ='110';
What I can not understand, if if load only
//Inbound booking or
// Put Away
it works fine, but both togehter doesn't work???
Much Obliged
