Identify Column in Data Load Log File

[gsbeaton]

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...

[flipside · Accepted solution]

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

[gsbeaton]

So obvious when you know!

Many thanks,

George