RE: [sqr-users] Record field names

["Alexander, Steve" <Steven.Alexander@sanjoseca.gov>]

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

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