Here are 2 dicts I created for the CUSTOMER file in the DEMO account. I didn't
try them with ODBC though.
They both work with the CATEGORIES_LIKED field in 9 of the CUSTOMER file.
:AE DICT CUSTOMER ALL_CATEGORIES CL_POS CATLINK
This one puts everything in one blob with the MV lines now separated
I also meant to add that you could have a dict per line:
002: EXTRACT(@RECORD,9,1,0)
002: EXTRACT(@RECORD,9,2,0)
002: EXTRACT(@RECORD,9,3,0)
Etc
Hth
Colin Alfke
Calgary, Canada
-Original Message-
From: Colin Alfke
Here are 2 dicts I created for the CUSTOMER file in the DEMO account.
We have that same issue with our ODBC connection and Access. We have
tried adding a field for a line counter, which works but is cheesy. We
also have one or two that we write twice, one MV and one SV. Neither
solution is that graceful.
Caryl
-Original Message-
From: [EMAIL PROTECTED]
field (like HS/ODBC
does), to tell you what order to sort in.
Cheers,
Wol
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Caryl Lange
Sent: 18 September 2008 14:35
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Wintegrate Query Builder
We have
Remember - in the SQL world the order of data in the file is defined as
unimportant. The MV's imply an order that is lost when converted to SQL.
You can either create an associated I-desc that has the mv position (instead
of actually adding the field for the line counter - which we actually have
Hi Colin,
Your idea sounds like it would fix my problem.
You can either create an associated I-desc that has the mv position
Can you show me an example?
I have built some simple I-desc's, but I'm pretty weak at it.
or use a dict that combines all of the MV's into one block.
This would be
Kevin, there are no issues in the versions you are using.
1. Has the import to Excel ever worked? If not you could try reinstalling the
host programs and ensure the machine type matches your host. (UniVerse Ideal
Flavor, Universe Pick Flavor, etc.)
2. Viewing in the Report Viewer also does an
Kevin:
Try sending it to the Report Viewer first then export it from there. I
think this will be easier.
Bill
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Kevin Michaelsen
Sent: Friday, February 18, 2005 6:11 AM
To: u2-users@listserver.u2ug.org
Hi Kevin,
I believe you are running into invalid dict items or dict items that
don't work in your query. It appears you were able to run the report to the
screen without a problem, is that true? In Query Builder, try changing the
output destination to Screen and see if it works.
Which version on wIntegrate and Excel are you using? I have found that it
does not work with all versions of Excel.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kevin Michaelsen
Sent: Friday, February 18, 2005 6:11 AM
To: u2-users@listserver.u2ug.org
I ran it to the screen with out any issue. I ran it to report viewer and
got a timed out error. So I don't think is has to do with the dictionary
items. Any other possibilities???
Kevin
At 09:37 AM 2/18/2005 -0800, you wrote:
Hi Kevin,
I believe you are running into invalid dict items
PROTECTED] Behalf Of Kevin Michaelsen
Sent: Friday, February 18, 2005 10:33 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] wIntegrate query builder question
I ran it to the screen with out any issue. I ran it to report viewer and
got a timed out error. So I don't think is has to do
Excel 2002 and wIntegrate version 4.2. Are there any know issues with those
versions.
Kevin
At 10:04 AM 2/18/2005 -0800, you wrote:
Which version on wIntegrate and Excel are you using? I have found that it
does not work with all versions of Excel.
-Original Message-
From: [EMAIL
Michaelsen [mailto:[EMAIL PROTECTED]
Sent: Friday, February 18, 2005 12:33 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] wIntegrate query builder question
I ran it to the screen with out any issue. I ran it to report viewer and
got a timed out error. So I don't think is has to do
To limit dictionary items in Query Builder
Create a record in WIN.PROGS called SERVICESUB which contains the name
of a subroutine you can write . The examples are WIN.SSUB and WIN.SSUB1 in the
WIN.PROGS file.
The wIntegrate host documentation sort of explains it.
u2-users mailing list
[EMAIL
I can't remember the exact details, I'll look it up when I get into the office
on Tuesday., but from what I remember you can modify the WIN.SERVER routine
with a subroutine call to filter dict items, it is documented somewhere, maybe
even in the program itself.
Create a user version of the file with just the items you want them to see.
VOC: FilenameForUsers
1: F
2: Original File name
3: D_CopyofDictforUsers
Could use CREATE.FILE DICT CopyofDictforUsers
Mike R.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
17 matches
Mail list logo