Mecki:
You need to when using the other stuff with UniData (non-telnet
connectivity). ECL doesn't always represent what happens through a UO
connection.
:COMPILE.DICT MYFILE
...should do the trick.
HTH,
Bill
Untitled Page
- Original Message -
*From:* mec...@gmx.net
*To:* u2-users@listserver.u2ug.org
*Date:* 3/5/2013 9:10 AM
*Subject:* Re: [U2] *** GMX Spamverdacht *** Re: I Descriptor no longer
working in UniSQL after UD upgrade
I don't know about compiling I-descriptors in UD.
Never done it and never needed to.
The dict is marked as MV and has an association as well.
It works just fine from ECL so when I type LIST PODET WITH PO_NBR =
"98587" SCHED_DEL_DATE U_RPT_DATE I get 2 dates in both columns as
expected.
But when I go to sql and try SELECT SCHED_DEL_DATE,U_RPT_DATE from
PODET_SCHED_DETAIL1 where PO_NBR = '98587' I get 2 scheduled dates but
only one report date (current date) in the first row while in the
second row it is null.
I found a work-around by using an Active-X control in my DTS package,
but I shouldn't have to do that.
I also noticed that I-descriptors calling a Basic subroutine don't
work any more through ODBC or OLE-DB even though they work in UniSQL.
Maybe in 7.2 I have to convert them into V-types?
I prefer I-types since I just don't seem to be able to get to grips
with the V-type syntax.
On 05/03/2013 13:52, David A. Green wrote:
Have your compiled your i-descriptor? Is it marked as MV?
David A. Green
(480) 813-1725
DAG Consulting
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki
Foerthmann
Sent: Tuesday, March 05, 2013 5:42 AM
To: U2 Users List
Subject: [U2] I Descriptor no longer working in UniSQL after UD upgrade
Hi
we upgraded from UD 5.2/Solaris to UD 7.2/RH about a month ago and so it
looked fine so far.
Now I had a call that there are purchase orders missing on a Cognos
report.
When I investigated I noticed that from the day of the upgrade I have
rows
in the table used for that report with missing dates.
The report is based on a SQL Server 2000 table that gets updated
every night
with Purchasing information from UD using DTS.
We want to track supplier performance so I take a snapshot of the
outstanding Purchase order deliveries every night and add them to this
table.
Each row also contains the date the snapshot was done.
Some order line have multiple deliveries so I created a I-type
dictionary
item using REUSE(@DATE).
This is mapped in the schema and was working just fine under 5.2 but now
there is only a date for the first multivalue.
I created a new subtable using the 7.2 VSG and the result is the same.
The dictionary works just fine from ECL but in SQL only the first row
has a
date and all others are null.
Any idea why this doesn't work anymore under UD 7.2?
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
