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 hpellegri...@optonline.net Sent by: owner-u2-us...@listserver.u2ug.org 02/12/2009 08:11 PM Please respond to u2-users@listserver.u2ug.org To u2-users@listserver.u2ug.org cc Subject RE: [U2] OLEDB error Username has permissions to create and insert granted? HP -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Debra Fedchin Sent: Wednesday, February 11, 2009 11:08 AM To: u2-users@listserver.u2ug.org Cc: owner-u2-us...@listserver.u2ug.org; 'u2-users@listserver.u2ug.org' 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 u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org 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 u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Need help with associated select
I have a table with a MV status code and date field. I am trying to select just those records that have both status code A and B and when the date associated with code B is blank I tried SELECT TAB WITH STATUS = A AND STATUS = B AND ST_DATE = But this will select records which might have a blank date for status C I can do this with a LIST WHEN command, but I want the results in a list LIST TAB WITH F2 = A WHEN F2=B AND F3= F1 F2 F3 There must be a simple way to do this, but I'm just not getting it. Ideas? Thanks, Noah CONFIDENTIALITY NOTICE: This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Need help with SELECT limiting MV
I have a table with a MV status code and date field. I am trying to select just those records that have both status code A and B and when the date associated with code B is blank I tried SELECT TAB WITH STATUS = A AND STATUS = B AND ST_DATE = But this will select records which might have a blank date for status C I see the data properly with a LIST WHEN command, but I want the matching @IDs in a list LIST TAB WITH F2 = A WHEN F2=B AND F3= F1 F2 F3 There must be a simple way to do this, but I'm just not getting it. Ideas? Thanks, Noah CONFIDENTIALITY NOTICE: This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Need help with SELECT limiting MV
I haven't actually tried this...but you could create a new dictionary; e.g. 1 S 2 0 3 Status*Date 8 A;2:*:3 9 L 10 10 Then select where new dict = A*] and B* Mark -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Noah Hart Sent: Tuesday, February 17, 2009 11:27 AM To: u2-users@listserver.u2ug.org Subject: [U2] Need help with SELECT limiting MV I have a table with a MV status code and date field. I am trying to select just those records that have both status code A and B and when the date associated with code B is blank --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Need help with SELECT limiting MV
How about something like: SELECT TAB WITH STATUS = A AND WITH EVAL 'IF STATUS = B THEN IF ST_DATE = THEN 1 ELSE 0 ELSE 0 ' = 1 ' HTH, Bill __ From: Noah Hart n...@lipmantpa.com Sent: 2/17/2009 10:26 AM To: u2-users@listserver.u2ug.org Subject: [U2] Need help with SELECT limiting MV I have a table with a MV status code and date field. I am trying to select just those records that have both status code A and B and when the date associated with code B is blank I tried SELECT TAB WITH STATUS = A AND STATUS = B AND ST_DATE = But this will select records which might have a blank date for status C I see the data properly with a LIST WHEN command, but I want the matching @IDs in a list LIST TAB WITH F2 = A WHEN F2=B AND F3= F1 F2 F3 There must be a simple way to do this, but I'm just not getting it. Ideas? Thanks, Noah CONFIDENTIALITY NOTICE: This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
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: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Debra Fedchin Sent: 17 February 2009 15:59 To: u2-users@listserver.u2ug.org 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 hpellegri...@optonline.net Sent by: owner-u2-us...@listserver.u2ug.org 02/12/2009 08:11 PM Please respond to u2-users@listserver.u2ug.org To u2-users@listserver.u2ug.org cc Subject RE: [U2] OLEDB error Username has permissions to create and insert granted? HP -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Debra Fedchin Sent: Wednesday, February 11, 2009 11:08 AM To: u2-users@listserver.u2ug.org Cc: owner-u2-us...@listserver.u2ug.org; 'u2-users@listserver.u2ug.org' 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 u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org 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 u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/