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.

problem

2 posts in PB Infomaker Report Writer Last posting was on 1999-06-04 14:50:44.0Z
Kiran Kodithala Posted on 1999-06-03 21:19:27.0Z
Newsgroups: sybase.public.infomaker.general
Date: Thu, 03 Jun 1999 16:19:27 -0500
From: Kiran Kodithala <kkodit1@uillinos.edu>
X-Mailer: Mozilla 4.5 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: problem
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 9
Message-ID: <348_3756F15F.A3D78AA@uillinos.edu>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.infomaker.general:6248
Article PK: 240184

hello;
I Want to import a text file into the SQL statement ; the text file
contains a large data and the table to be created /modified using this
data contains 12 columns.I could import the data into a report but could
not figure out how to convert a Report into Table. Please reply me as
soon as possible .
Thanks
Kiran


Terry Dykstra Posted on 1999-06-04 14:50:44.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra" <tdykstra@cfol.ab.ca>
Subject: Re: problem
Date: Fri, 4 Jun 1999 08:50:44 -0600
Lines: 27
X-Newsreader: Microsoft Outlook Express 4.72.3612.1700
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3612.1700
Message-ID: <348_ltTZQkpr#GA.313@forums.sybase.com>
References: <348_3756F15F.A3D78AA@uillinos.edu>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.infomaker.general:6246
Article PK: 240183

If your text file only has the data columns, you will have to build the
table manually. There are a few ways you can do this:
1) If your text file is in tab-delimited format and you are able to define a
primary / unique key, I would use the database painter to create a new
table. When you preview the empty table, you can use 'Rows, Import' to load
the text file straight into the table.
2) Else use the data pipeline. Define an ODBC Text datasource, which will
describe your text file. Then use the pipeline utility. The source will be
the ODBC Text datasource, the destination will be your own database
(sqlanywhere, ...).

--
Terry Dykstra (TeamSybase)
Canadian Forest Oil Ltd.

Kiran Kodithala wrote in message <3756F15F.A3D78AA@uillinos.edu>...
>hello;
> I Want to import a text file into the SQL statement ; the text file
>contains a large data and the table to be created /modified using this
>data contains 12 columns.I could import the data into a report but could
>not figure out how to convert a Report into Table. Please reply me as
>soon as possible .
>Thanks
>Kiran
>
>