SYBASE conversion

[Frosty the Coder]

List,

I've been assigned to convert BNA (Bureau of Nat'l Affairs)
Fixed Assest data to JDE.

The client has (around) 170 properties, each of which is in a separate ".cdb" (SYBASE database).

The software does _not_ seem to have an _easy_
way of getting at ALL the assets for ALL the companies.

I tried to open a ".cdb" using both ms-access
and ms-excel, but it wouldn't open. Has anyone
out there converted from SYBASE? If so, would
you give me some pointers on getting at the data?

TIA

Gene


Gene Piekarski, Jr

AS/400, B733, SP11.2, NT client
AS/400, B733, SP14, W2000 client
XE, SP15.1

 

[Zoltan_Gyimesi]

Hi Gene,

Excuse me my silly question.

Isn't any possibility at all in SYBASE to dump out data to a text file? I can not believe it.

Regards,

Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)

 

[Larry_Jones]

Gene,

you want a Sybase (the original SQL Server) ODBC driver. Check to see if you have one installed ... wait a minute ... tell me they didn't just "send" you the database files? or are you working on site?

Larry Jones
[email protected]
OneWorld XE, SP 15.1
HPUX 11, Oracle SE 8.1.6
Mfg, Distribution, Financials

 

[Frosty the Coder]

Zoltan,

The software doesn't really give me access
to RUN SYBASE, merely it runs it's own
apps using SYBASE as the DB.

There is an export function, when generating
reports. The problem w/that function is
that there are around 170 properties that
need to be converted. Each property
residing in its own .cdb

The "ASSET MASTER" export,
which lists all assets w/in a property,
truncs the cents off of BEGINNING BALANCE.

The "ASSET DETAIL" export, doesn't trunc the
cents, but only lists one asset per export.

I want to be able to get at the raw data, to
see if I can get ALL assets (for a property)
at ONE TIME, with cents.

I know I can do a TC, but I'd have to 2 TCs,
one to point at the correct iteration of the file,
and one that actually converts the data.
I'd also have to clean up the data prior to the TC.

I don't have the skill/time/permission to write my own
tool (like you have already done). Last, I really
want to know how to get at tables in other data sources.

Bottom line, I beat up on my boss, who "encouraged"
a CNC guy to setup the datasource and ODBC (something
else I'd like to know how to do).

I appreciate your, and Larry's, help (on this and
everything else). I'll let you know what happens
(after the CNC guy helps me on Monday).

Thanks (again)

Gene



Gene Piekarski, Jr

AS/400, B733, SP11.2, NT client
AS/400, B733, SP14, W2000 client
XE, SP15.1