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';
