My company is making few tests in order to use vectorwise for some projects, but we have the need to make some special inserts that im not able to reproduce in vector wise, this is the examle...
CREATE TABLE MYTABLE (
CLIENTNUM VARCHAR(20) NULL,
DATADATE DATE NULL,
TYPECLIENT VARCHAR(2) NULL,
TITTLENUMBER INTEGER NULL,
TOTAL DECIMAL(14,2) NULL,
PHISICALID INTEGER NOT NULL,
CONSTID INTEGER NOT NULL,
DATAID INTEGER NOT NULL,
PRIMARY KEY (DATAID, CONSTID, PHISICALID )
And the next would be the insert from a positional file:
COPY TABLE MYTABLE (
CLIENTNUM = CHAR(20)
DATADATE = CHAR(10)
TOTAL = CHAR(16)
PHISICALID = Sequence(1,1)
CONSTID = 1
DATAID = 1
RUNDATE = getDate()
And the last 4 columns are not in the file, should be added on runtime.
PHISICALID as some kind of sequence
CONSTID and DATA ID as a fixed constant num by now... who cares just a "1"
RNDATE should be the day of running that insert.
This would be data to insert as a example:
How can i make that insert work?
Thnk you in advance
PS: As further work, our file have the date as yyyyMMdd (Fixed the "yyy" typo), without any separators, if we can make that work would make me and my boss rly happy and we would end by buying the product.