[sqr-users] RE: Record field names - SQL Query

[<ravi.varma@wipro.com>]

Hi Anu,

Steve and sudeep are right; it is very easy to create one such utility.
You may try the below query which will give you the desired result in
Oracle.

Query: -  SELECT column_name FROM  all_tab_columns WHERE
           table_name = <TABLE Name> ORDER BY column_id

Sorry if I am trying to deviate you from the problem.

Regards,
Tej
Always keep your words soft and sweet, just in case you have to eat
them.


-----Original Message-----
From: Alexander, Steve [mailto:Steven.Alexander@sanjoseca.gov]
Sent: Monday, June 27, 2005 11:17 PM
To: 'This list is for discussion about the SQR database
reportinglanguagefrom Hyperion Solutions.'
Subject: RE: [sqr-users] Record field names

When you use PSRECFIELD, watch out for subrecords.  Anu's example,
ADDRESSES, has a subrecord.  When you find a subrecord, you have to go
back
to PSRECFIELD and look up the fields in the subrecord.  Also, subrecords
can
have subrecords, although that is rare.  Another possibility is to use
the
table that your database manager uses.  Ask your DBA.

-----Original Message-----
From: Sudeep Vaidya [mailto:sudeep.vaidya@patni.com]
Sent: Monday, June 27, 2005 11:13 AM
To: sqr-users@sqrug.org
Subject: Re: [sqr-users] Record field names


Anu,

I'm not aware of any such utility, but creating one would be an easy
job.
Just write a small SQR to fetch data from PSRECFIELD and PSRECFIELDDB,
and
provide the values to the where clause using the Run Control Record.
You can then write them on to a File as per your choice...

Ofcourse , you would need a Run control record and run control page.

should not take more than a couple of hours to create and test !

hope this helps

Sudeep


> Dattatraya,
>
> Example would be be ADDRESSES tables has various fields which I do not
> know
> about. After running the utility (may be record name can be entered as
a
> input), I should get output file as:
>
> address1,
> address2,
> address3,
> city,
> state,
> zip,
> country
>
> I hope this helps.
>
> Thanks for all your help.
>
> Regards,
> Anu
>
>>From: Dattatraya Shetty <datta_shetty@yahoo.com>
>>Reply-To: "This list is for discussion about the SQR database
>>reportinglanguage from Hyperion Solutions." <sqr-users@sqrug.org>
>>To: "This list is for discussion about the SQR database reporting
>>languagefrom Hyperion Solutions." <sqr-users@sqrug.org>
>>Subject: Re: [sqr-users] Record field names
>>Date: Thu, 23 Jun 2005 12:40:20 -0700 (PDT)
>>
>>Anu,
>>    If you can give and example that will be great.
>>
>>Datta.
>>
>>
>>--- Anu Bagde <anubagde@hotmail.com> wrote:
>>
>> >
>> > Hello Group,
>> >
>> >
>> > I am looking for an utility, which will read the record name and
list
>> > the
>> > record field names as output fiel in some way (space, comma or tab
>> > delimited). Is their some utility available that will do this?
>> >
>> > Thanks for any answers you have for this.
>> >
>> > Regards,
>> > Anu
>> >
>> > _________________________________________________________________
>> > Millions of marriage proposals.
>> > http://www.bharatmatrimony.com/cgi-bin/bmclicks1.cgi?74 Find your
>> > match on
>> > BharatMatrimony.com
>> >
>> >
>> > _______________________________________________
>> > sqr-users mailing list
>> > sqr-users@sqrug.org
>> > http://www.sqrug.org/mailman/listinfo/sqr-users
>> >
>>
>>
>>__________________________________________________
>>Do You Yahoo!?
>>Tired of spam?  Yahoo! Mail has the best spam protection around
>>http://mail.yahoo.com
>>
>>_______________________________________________
>>sqr-users mailing list
>>sqr-users@sqrug.org
>>http://www.sqrug.org/mailman/listinfo/sqr-users
>
> _________________________________________________________________
> Adore Arshad Warsi? http:/

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





Confidentiality Notice

The information contained in this electronic message and any attachments to 
this message are intended
for the exclusive use of the addressee(s) and may contain confidential or 
privileged information. If
you are not the intended recipient, please notify the sender at Wipro or 
Mailadmin@wipro.com immediately
and destroy all copies of this message and any attachments.

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