RE: [sqr-users] CLOBs

[Elaine Liu <Eliu@icc.edu>]

Hi Richard,
Perhaps, I did not explain my question clear enough. Either DB2 or Oracle
table's space can be increased. After we are creating or/and increasing
table spaces, where and what is the name of table actual those store data ?I
can create a new database - table container and table spaces and such, or I
can increase table space when it is needed, but I am wondering where those
data store into.....( the fist space and after resized) 

Thanks anyway, 
Elaine 

-----Original Message-----
From: sqr-users-bounces+eliu=icc.edu@sqrug.org
[mailto:sqr-users-bounces+eliu=icc.edu@sqrug.org] On Behalf Of Knapp,
Richard
Sent: Monday, August 08, 2005 2:01 PM
To: This list is for discussion about the SQR database reportinglanguage
from Hyperion Solutions.
Subject: RE: [sqr-users] CLOBs


Hi Elaine,

I'm sorry.  Almost all my experience is with Oracle.  In Oracle there
are tablespace files that can be increased.  Hoping this will help.

Richard Knapp
Database Programmer/Analyst
Institutional Research and Planning
University of Missouri System
573-882-8856
knappr@umsystem.edu

-----Original Message-----
From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org
[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of
Elaine Liu
Sent: Monday, August 08, 2005 10:52 AM
To: 'This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.'
Subject: RE: [sqr-users] CLOBs

Hi Richard,
I am current leaning/assistant an DBA, while creating table space and
new
database, we are wondering where those table space store into. I would
appreciate any input from you. We are using DB2.

Thank you,
Elaine 


-----Original Message-----
From: sqr-users-bounces+eliu=icc.edu@sqrug.org
[mailto:sqr-users-bounces+eliu=icc.edu@sqrug.org] On Behalf Of Knapp,
Richard
Sent: Monday, August 08, 2005 9:18 AM
To: This list is for discussion about the SQR database reportinglanguage
from Hyperion Solutions.
Subject: RE: [sqr-users] CLOBs


I dealt with this problem once but can't find the code.  I think all
that was necessary was to get the clob into a variable and then split it
"manually" into the line lengths needed.

Richard Knapp
Database Programmer/Analyst
Institutional Research and Planning
University of Missouri System
573-882-8856
knappr@umsystem.edu
-----Original Message-----
From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org
[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of
Jolene Osei
Sent: Monday, August 08, 2005 8:29 AM
To: sqr-users@sqrug.org
Subject: Re: [sqr-users] CLOBs

Morning Melody

Thanks for the reply.  I want to extract the course descriptions in the
SCBDESC table.  I have to order the report by subject and course.
I have a problem of the description not wrapping around correctly. This
is the example that I am using as a test.

Select to_char(scbdesc_text_narrative) "Course Description"
    from  scbdesc
    where scbdesc_subj_code = 'ACC'
   and scbdesc_crse_numb = '100';


Course Description
------------------------------------------------------------------------
--------
This is an introductory course to the Accounting cycle. The course is
designed t
o provide the student with a basic understanding of fundamental
bookkeeping conc
epts and procedures. Emphasis is placed on procedures, techniques, and
applicati
ons of generally accepted accounting principles.  This course will meet
the need
s of the small business owner or employee. It is required for
Accounting majors.

****************************************************

Hope to hear from you Melody.  I have run out of ideas. Thanks 

Jolene

 

>>> Melody.Sayles@alaska.edu 8/5/2005 12:47:49 PM >>>
What's your question? I've had two recent report projects that used
CLOB's.

Melody

Jolene Osei wrote:

> Hi
>
> Has anyone worked with the tables having CLOB fields.  I am creating
a
> report where by I have to extract from a CLOB field.  Has anyone
worked
> with this kind of a field?  I am working with Banner tables and this
> CLOB issue is new to us.
>
> Please help if you can
>
> Jolene
>
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org 
> http://www.sqrug.org/mailman/listinfo/sqr-users 





_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users