Name of the csv file(s) already saved in a table myFileList.
myFileList Table contains values like crashData_MMYYYY_vN.csv, vehecleData_MMYYYY_vN.csv, casualtyData_MMYYYY_vN.csv etc with different versions and MMYYYY values.
Example: For January month, MM should be 01. For October, it should be 10.
For Base version value of ‘N’ should be 1 and can be incremental for the next versions, viz., v2, v3 etc.
The first version of a crash file loading for Jan 2013 should be named ‘crashData_012013_v1’.
Thanks in advance.
If you're just having problems with the `IF` clause...
Try something like:
Note that, because I've only put one statement in the THEN/ELSE parts, the BEGIN/END bits are unnecessary. I've left them in through force of habit - the number of times I've not written them and had something a bit odd happen...