Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

What is pipeline doing for?

4 posts in PB Infomaker Report Writer Last posting was on 1998-11-12 18:02:30.0Z
Pete Prada Posted on 1998-11-06 14:58:45.0Z
Newsgroups: sybase.public.infomaker.general
From: "Pete Prada" <pete@saionline.com>
Subject: What is pipeline doing for?
Date: Fri, 6 Nov 1998 08:58:45 -0600
Lines: 5
X-Newsreader: Microsoft Outlook Express 4.71.1712.3
X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3
Message-ID: <348_HOpDPyYC#GA.148@forums.powersoft.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6762
Article PK: 241748

I still confused using the pipeline. Has anyone experience this tool
before?? Can you tell me more detail, what is useful for this ???


Terry Dykstra Posted on 1998-11-06 16:17:01.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra" <tdykstra@cfol.ab.ca>
Subject: Re: What is pipeline doing for?
Date: Fri, 6 Nov 1998 09:17:01 -0700
Lines: 18
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <348_4tIlfbZC#GA.148@forums.powersoft.com>
References: <348_HOpDPyYC#GA.148@forums.powersoft.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6761
Article PK: 241747

The pipeline is used to move data from one database to another. We used it
a lot when we converted an application from Btrieve to Oracle. I use it too
to upload from an Excel spreadsheet into our Oracle system. You can use it
to extract 100 rows data from that 10 million row Oracle table to your local
SQLAnywhere. Anytime you need to move data, or need just a subset of data,
you can use it.

Terry Dykstra (TeamPS)

Pete Prada wrote in message ...
>I still confused using the pipeline. Has anyone experience this tool
>before?? Can you tell me more detail, what is useful for this ???
>
>
>


Pat Wright Posted on 1998-11-11 15:37:03.0Z
Newsgroups: sybase.public.infomaker.general
From: "Pat Wright" <Pwright@easydental.com>
Subject: Re: What is pipeline doing for?
Date: Wed, 11 Nov 1998 08:37:03 -0700
Lines: 32
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <348_MN$6p9XD#GA.151@forums.powersoft.com>
References: <348_HOpDPyYC#GA.148@forums.powersoft.com> <348_4tIlfbZC#GA.148@forums.powersoft.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6743
Article PK: 241729

Can it take data from a text file? And can it enter into more than one
table? or is it basically just importing like a Input Statment or Insert
statement.
Thanks

Pat
Pwright@easydental.com

Terry Dykstra wrote in message <4tIlfbZC#GA.148@forums.powersoft.com>...
>The pipeline is used to move data from one database to another. We used it
>a lot when we converted an application from Btrieve to Oracle. I use it
too
>to upload from an Excel spreadsheet into our Oracle system. You can use it
>to extract 100 rows data from that 10 million row Oracle table to your
local
>SQLAnywhere. Anytime you need to move data, or need just a subset of
data,
>you can use it.
>
>Terry Dykstra (TeamPS)
>
>
>Pete Prada wrote in message ...
>>I still confused using the pipeline. Has anyone experience this tool
>>before?? Can you tell me more detail, what is useful for this ???
>>
>>
>>
>
>


Terry Dykstra Posted on 1998-11-12 18:02:30.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra" <tdykstra@cfol.ab.ca>
Subject: Re: What is pipeline doing for?
Date: Thu, 12 Nov 1998 11:02:30 -0700
Lines: 45
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <348_hoa6nylD#GA.148@forums.powersoft.com>
References: <348_HOpDPyYC#GA.148@forums.powersoft.com> <348_4tIlfbZC#GA.148@forums.powersoft.com> <348_MN$6p9XD#GA.151@forums.powersoft.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6738
Article PK: 241728

The pipeline can read from a text file, provided you have a text ODBC driver
(from Microsoft, Intersolv).
It only inserts into one table, but it can read from any number of tables.
Essentially it is just an insert or update statement.
--
Terry Dykstra (TeamPS)
Canadian Forest Oil Ltd.

Pat Wright wrote in message ...
>Can it take data from a text file? And can it enter into more than one
>table? or is it basically just importing like a Input Statment or Insert
>statement.
>Thanks
>
>Pat
>Pwright@easydental.com
>
>Terry Dykstra wrote in message <4tIlfbZC#GA.148@forums.powersoft.com>...
>>The pipeline is used to move data from one database to another. We used
it
>>a lot when we converted an application from Btrieve to Oracle. I use it
>too
>>to upload from an Excel spreadsheet into our Oracle system. You can use
it
>>to extract 100 rows data from that 10 million row Oracle table to your
>local
>>SQLAnywhere. Anytime you need to move data, or need just a subset of
>data,
>>you can use it.
>>
>>Terry Dykstra (TeamPS)
>>
>>
>>Pete Prada wrote in message ...
>>>I still confused using the pipeline. Has anyone experience this tool
>>>before?? Can you tell me more detail, what is useful for this ???
>>>
>>>
>>>
>>
>>
>
>