Amy, Dawn, David,

Thank you all for your answers.  It was a missing VOC entry for a cataloged
Subroutine.  When I tried to select from command line using SQL SELECT I saw
the error and fixed it.

Thank you again for your help.

Have a lovely day.

Regards
Kafsat


-----Original Message-----
From: Amy Cook [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, 6 April 2004 12:02 AM
To: U2 Users Discussion List
Subject: RE: Unidata ODBC - Suborutine call form dictionary.

Also, once you check out David's suggestions below, verify first you can
execute the sql select at tcl before trying through the driver, i.e. 
 
: SQL SELECT SUBR_FIELD FROM MYVIEW_NF;
 
I've found this happen under two different situations....a dependency is the
most common. Sometime's it's as simple as recompiling the subroutine.

________________________________

From: [EMAIL PROTECTED] on behalf of Hona, David S
Sent: Mon 4/5/2004 12:08 AM
To: 'U2 Users Discussion List'
Subject: RE: Unidata ODBC - Suborutine call form dictionary.



Does your subroutine have any dependencies? COMMON variables? Such
previously open files, with the file variables stored in COMMON, etc., etc.

If it does, you need to either remove these dependencies or work around
them, some how...we've went through a similar exercise as yourself.

Regards,
David


-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of kafsat taiyus
Sent: Monday, April 05, 2004 4:16 PM
To: 'U2 Users Discussion List'
Subject: Unidata ODBC - Suborutine call form dictionary.



Hi,

We have published a Unidata File through ODBC view.  One of the dictionaries
published uses subroutine call to get data. The dictionary using subroutine
call, does not work from ODBC, the rest of the dictionaries work fine. Is
there anything we can do to fix it?

Regards
Kafsat
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users



This email and any attachments are confidential and intended solely for the
use of the person or entity to whom they are addressed. If you are not the
intended recipient, please do not disclose, store, copy or take any action
in reliance on it or them. If you have received this message in error,
please tell us by reply email (or telephone + 61 (0) 3 9274 9100) and delete
all copies on your system. Any opinion, advice or information in this email
is not necessarily that of the owners or officers of this company. Please
advise us immediately if you or your employer do not consent to email for
messages of this type. 

Retail Decisions has taken reasonable precautions to ensure that any
attachment to this email has been swept for viruses. However, we cannot
accept any liability for any damage sustained as a result of software
viruses, and would advise that you carry out your own virus checks before
opening any attachment. Please note that communications sent by or to any
person through our computer system may be viewed by other Retail Decisions
employees or officers strictly in accordance with law.
-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Reply via email to