Identify Column in Data Load Log File

gsbeaton — Mon, 13 Oct 2014 14:04:44 GMT

Hi Folks,

Back after a while away. Good to see the forums still as lively as ever.

I'm analysing some log files at the moment and wondered if anyone knew what the second column was telling me. I can't find any information in the manual about this. It's not overly important, just curious (don't think it is a key as it jumps randomly as you can see).

Many thanks

George

13/10/2014 03:00:02: OdbcLoginTimeout -1

13/10/2014 03:00:02: OdbcConnectionTimeout -1

13/10/2014 03:00:02: ScriptWantsDbWrite false

13/10/2014 03:00:02: ScriptWantsExe false

13/10/2014 03:00:02: LogFile CodePage Used: 1200

13/10/2014 03:00:02: Reload Executed By ..\svc_qview

13/10/2014 03:00:02: Process Executing: QVB

13/10/2014 03:00:02: Process ID: 8996

13/10/2014 03:00:02: 0002 SET ThousandSep=','

13/10/2014 03:00:02: 0003 SET DecimalSep='.'

13/10/2014 03:00:02: 0004 SET MoneyThousandSep=','

13/10/2014 03:00:02: 0005 SET MoneyDecimalSep='.'

13/10/2014 03:00:02: 0006 SET MoneyFormat='£#,##0.00;-£#,##0.00'

13/10/2014 03:00:02: 0007 SET TimeFormat='hh:mm:ss'

13/10/2014 03:00:02: 0008 SET DateFormat='DD/MM/YYYY'

13/10/2014 03:00:02: 0009 SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]'

13/10/2014 03:00:02: 0010 SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'

13/10/2014 03:00:02: 0011 SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'

13/10/2014 03:00:02: 0015 ODBC CONNECT*XUserId*XPassword*

13/10/2014 03:00:02: 0022 Directory ..\Data Sources\QVD

13/10/2014 03:00:02: 0037 DataHistoryDate:

13/10/2014 03:00:02: 0038 LOAD VarName,

13/10/2014 03:00:02: 0039 Value

13/10/2014 03:00:02: 0040 FROM Hist...

Re: Identify Column in Data Load Log File

flipside — Mon, 13 Oct 2014 14:14:28 GMT

It's the line number in the script, I assume. You can see how it works if you use load script sub-routines or for .. next loops.

flipside

Re: Identify Column in Data Load Log File

gsbeaton — Mon, 13 Oct 2014 15:33:52 GMT

So obvious when you know!

Many thanks,

George

topic Re: Identify Column in Data Load Log File in QlikView

Identify Column in Data Load Log File

Re: Identify Column in Data Load Log File

Re: Identify Column in Data Load Log File