|
Situation - I have a data file I want to load, but it has additional data that doesn't fit my table and if possible I don't want to have to change the table structure. So I look at the docs for LOAD TABLE and there we are - just what I need:
However, what ever I do, I don't seem to be able to have more that one column ignored. If I use filler() more than once I get a duplicate column error. Is there away of getting columns ignored without hitting the Column names cannot be repeated restriction ? Thanks v10.0.1 |
Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.
Follow this question
By Email:Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
- *italic* or _italic_
- **bold** or __bold__
- link:[text](http://url.com/ "title")
- image?
- numbered list: 1. Foo 2. Bar
- to add a line break simply add two spaces to where you would like the new line to be.
- basic HTML tags are also supported
Question tags:
question asked: 14 Dec '10, 17:27
question was seen: 1,696 times
last updated: 14 Dec '10, 17:27
Well, I'm quite sure that I have often used LOAD TABLE with several filler() columns in V10/v11 without any problem. So I guess the problem might have a different cause...
Please provide some sample code and version info
Just to confirm my first comment: Yes, with V10.0.1 and V11.0.1, we definetely have regularly used import procedures with several "filler()" arguments in one single LOAD TABLE statement.
I agree... I tried using filler() multiple times and it worked just fine in 10.0.1. I would need to see sample code in order to determine what problem you are running into.
Hi - thanks everybody for the feedback - how people describe is it is certainly how I expected it to work. I've worked around the problem for now (not hard just adding dummy columns) but I'll put together a demonstration of my problem that doesn't involve customer data and post it during the holidays.