Insert to a view has several limitations:
You cannot Insert multiple tables to a view with multiple
tables. Only one table at a time.
If a view is not showing all the fields and some of those
"un-seen" fields do not allow nulls then when you do an Insert to the
view it fails.
Garry L. Smith
Dir Info Systems
Charles McMurray Company
V# 559-292-5782 F# 559-346-6169
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Symeon Breen
Sent: Tuesday, February 17, 2009 1:44 PM
To: [email protected]
Subject: RE: [U2] OLEDB error
What is the actual sql command you are performing ?
It is a bit confusing as the error talks about an insert but it is a
select it is showing.
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Debra Fedchin
Sent: 17 February 2009 15:59
To: [email protected]
Subject: RE: [U2] OLEDB error
Yep
All permission's are set to PUBLIC
It is frustrating since most of the DOCS give examples of utilizing SQL
statements as if you attempting to manipulate Unidata data within the
Unidata server itself (duh -- now why would I be attempting to make
like more complicated for no good reason?) OR examples of how to EXTRACT
data from a SQL server into Unidata.
There are no clear examples of a standard SQL statement that would be
used on a Client to update exposed SQL Tables that have a parent/child
relationship (MV) -- and a statement that goes beyond a mere snipit that
would give you more than the smallest granular overview.
It's bad enough that the XML extract does not work as documented (non
standard and just plain butt ugly in regards to hierarchy!) without
adding further insult to injury. All I am trying to do is to update
FROM a client to Unidata without having to drop-kick to flat text files!
It ain't rocket science!
Horacio Pellegrino <[email protected]> Sent by:
[email protected]
02/12/2009 08:11 PM
Please respond to
[email protected]
To
[email protected]
cc
Subject
RE: [U2] OLEDB error
Username has permissions to create and insert granted?
HP
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Debra Fedchin
Sent: Wednesday, February 11, 2009 11:08 AM
To: [email protected]
Cc: [email protected]; '[email protected]'
Subject: [U2] OLEDB error
ok
Can someone tell me why I got this error?
Debug: OLEDB driver: Insert SQL='SELECT BIG_01_Invoice_Date,
BIG_02_Invoice_Num, BIG_03_PO_Date, BIG_04_PO_Num, BIG_05_Rel_Num,
BIG_07_Trans_Type, Benco_Host, CTT_01_CTT_Amt, DTM_01_Date_Qualifer,
DTM_02_Date_Shipped, Date_Processed, EDI810_ID, Mailbox, N1_BT_01_Code,
N1_BT_02_Name, N1_BT_03_Qualifier, N1_BT_04_ID, N3_BT_01_Address1,
N3_BT_02_Address2, N4_BT_01_City, N4_BT_02_State, N4_BT_03_Zip,
N4_BT_04_Country_Code, TDS_01_Amount, Trading_Partner, Vendor_Num FROM
daf.EDI_INVOICE_HDR_NF_SUB WHERE (0=1)'
Error: Couldn't insert row into table 'EDI_INVOICE_HDR_NF_SUB'.
Error: Error 0x80004005: "[Ardent][UniData ODBC Driver][IBM][SQL
Client][UNIDATA]Can not insert into view EDI_INVOICE_HDR_NF_SUB"
Now -- this table was created, had SQL.CONVERT run against it, followed
by going through VSG to create both Views and Subtables, all Privileges
have been set to PUBLIC
The error states that the table is a view when in fact it is a Subtable
=================================================
This communication (including any attachments) is intended only for use
by the
addressee(s) named herein and may contain legally privileged or
confidential information. If you are not the intended recipient or an
authorized representative of the intended recipient on this
communication, you are hereby notified that any dissemination or
distribution of this communication (or
attachments) is strictly prohibited. If you have received this
communication in error, please notify us immediately by e-mail and
permanently delete the communication and any attachments from your
system.
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
=================================================
This communication (including any attachments) is intended only for use
by the
addressee(s) named herein and may contain legally privileged or
confidential information. If you are not the intended recipient or an
authorized representative of the intended recipient on this
communication, you are hereby notified that any dissemination or
distribution of this communication (or
attachments) is strictly prohibited. If you have received this
communication in error, please notify us immediately by e-mail and
permanently delete the communication and any attachments from your
system.
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
