Re: [sqr-users] Record field names

["Sudeep Vaidya" <sudeep.vaidya@patni.com>]

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