Tony,
I think it is a lot simpler to just go into SQL Server and run the
Import Export Wizard than writing a Basic program for every export.
And BTW DTS and SSIS are integral part of SQL Server and don't cost a
penny extra.
So if you have the tools already, why not use them?
I transfer the data
I use MS BizTalk
Works great and I can do real time updates to keep tables in line
And since I have worked with both Mecki and Symeon I thought I'd put my
ore in
Bob
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf
I Don't know if I'd call this method the simplest, each output file can only
be imported into one specific table and only those columns named. It also
requires that the exporter must know the table name and field names prior to
exporting.
While I'll agree, it is most like the fastest for
Wondering if anyone has seen this.
asjava.uniobjects.UniSubroutineException: Unknown Error [30102] Occurred
I suspect that this is a result of a typo. I had originally saved the
BASIC subroutine source file with a space in the name. WEB-BPGM get
ExportOrders. Then I cataloged it as
Example program (nb this has been posted before in this group - the group
is searchable at nabble )
* ANALYSEFILE
* By Symeon Breen - to analyse a data file and give a resume of what
attributes are used
* Usage - ANALYSEFILE {file name}
s...@sentence
IF Sen[1,4]=RUN THEN
I had already replied to the op - my point on the BCI was in response to
Gerd who wrote I even doubt that exporting data from UD files directly
into SQL Server tables is possible at all without some really fancy
programming in foreign tongues like C# or similar. I was just saying that
actually
I'm looking to dump the data in an easily parseble fashion such that I
can use it in a different environment.
What we have here is a difference in concept. While a relational
environment has a schema which must clearly define the database so that
the one big tool (SQL) is able to do all of
I'm also registered at Stack Overflow, participate occasionally,
and find it to be an excellent resource. ServerFault might
actually be more appropriate for a DBMS than StackOverflow.
Advantages that browser medium has over an email forum are that
people can come back to topics months or years
without shelling to unix to see if a .type1 exists in the file directory,
is there a way to tell a type 1 from a type 19 from within Universe?
I tried using FILEINFO(file, 3)
but both type 1 and type 19 return a value 4 (type 1)
George
George Gallen
Senior Programmer/Analyst
Accounting/Data
While email and digests and other features are integral parts of
some of the other media, I think the possibility for getting a
group as large as this to migrate is slim2none. RSS can replace
email digests, but people don't seem to understand RSS the way
they understand email, so again I
George,
Try using the STATUS statement...
STATUS FS FROM F.FILE ELSE ABORT
FILE.TYPE = FS21
Perry
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Thursday, January 21, 2010 12:48 PM
To: U2
Talking of SO - my ad serving company is about to start serving ads onto SO and
some other tech sites - i will point them out if they go live - all served from
asp.net using uniobjects with unidata as the main ad server.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
Evan, as others have said, you don't really want *all* the columns.
Some of what you're here calling columns are actually calculations. So for
example, in your database you might have a field that is BirthDate, and a
column name that actually says BirthDate as well (if you're lucky!). But
thanks...I looked at status (function that is), and didn't notice
there was also a status statement.
That should work
George
-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of Perry Taylor
Sent: Thursday,
Off Topic but has anyone else noticed the Trend for the last three
months is Help my boss, customer, friend wants to get ALL his columns, all
his data or all his junk out of U2, and I'm not worried about getting it back
in... I'm in the opposite boat, I want to leave it in there, and
I would probably start by making an index on the Part Number, based on an
I-descriptor with an expression like this:
CONVERT(OCONV(OCONV(PartNumber,'MC/N'),'MC/A'),'',PartNumber)
where PartNumber is a D-pointer to the raw data field that is the Part
Number. This will strip out all the
After an OPEN the STATUS() function returns the file type.
David Norman
Senior Software Engineer - SA Ambulance Service
ICT Services
SA Health
Government of South Australia
Box 3, GPO
Adelaide, South Australia 5001
*+61 8 8274 0384
* fax +61 8 8271 4844
*
Actually, the STATUS statement returns the file type,
The x=STATUS(#) function does not (or I couldn't figure it out) return the file
type after an open
but the STATUS statement, which works off the filehandle will return the file
type in pos 23
of the dynamic array that is returned.
That
OPEN 'TYPE19FILE' TO F THEN CRT STATUS() ;* = prints 19
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Friday, 22 January 2010 09:20
To: U2 Users List
Subject: Re: [U2] How can I tell a Type 1
hmm. I Didn't get the idea that was how it was used from
the manualimagine that.
I did test it, and it does work as shown.
Thanks
George
-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of Boydell, Stuart
Thanks to all who responded to the question.
As always, I'm being made to jump around different projects, so I may
get back to some of you in the near future.
Regards,
Dan
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On
I got this error when my subroutine was writing a record into a file
that had an indexed field that was built by SB+. The WRITE failed on
that account and the subroutine died most ingloriously.
-Kevin (mobile)
On Jan 21, 2010, at 8:54 AM, charles_shaf...@ntn-bower.com wrote:
Wondering if
On Unidata the MCB conversion returns alphanumerics only.
-Kevin (mobile)
On Jan 21, 2010, at 2:06 PM, Richard Lewis rbl...@gmail.com wrote:
I would probably start by making an index on the Part Number, based
on an
I-descriptor with an expression like this:
23 matches
Mail list logo
