RE: [sqr-users] Unix Sort...

["Peter Burton" <Peter_Burton@hyperion.com>]

Jagadish,

This is no SQR logic that will fit all conditions.

You need to 

1- Figure out what mail software you have on your machine.
2- Determine if it supports a command line interface to send mail.
3- What is the construct of the command line interface. 

After that is becomes easy.

If the vcommand line interface it simple then you create it an SQR
$Variable and then use the "CALL SYSTEM" command or the LET System()
function to process it.

If the command ine interface is complex then you need to first write a
small batch file (use OPEN/WRITE/CLOSE commands; procress it using "CALL
SYSTEM" command or the LET System() function; and then delete the batch
file with the LET Delete() function.

Peter

-----Original Message-----
From: sqr-users-bounces+peter_burton=hyperion.com@sqrug.org
[mailto:sqr-users-bounces+peter_burton=hyperion.com@sqrug.org] On Behalf
Of Jagadish Mucherla
Sent: Friday, November 17, 2006 8:06 AM
To: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.
Subject: Re: [sqr-users] Unix Sort...

Hi
  I need a sqr code to generate mail to the recipients can any one help
me?
Thanks
jagadish
jagadishmucherla@gmail.com

On 11/16/06, Alexander, Steven <Steven.Alexander@sanjoseca.gov> wrote:
>
> Folks, I've asked some tough questions in the past and got no
responses.
> Ram asked a question that seemed too easy and he got bashed.  I don't
> think
> this forum has a rule setting a strict range of questions that are
> permissable.  If you don't want to help someone, why go to the effort
of
> attacking him?
>
>
>
> -----Original Message-----
> From: sqr-users-bounces+steven.alexander=sanjoseca.gov@sqrug.org
> [mailto:sqr-users-bounces+steven.alexander=sanjoseca.gov@sqrug.org] On
> Behalf Of Sam Spritzer
> Sent: Friday, November 10, 2006 12:16 PM
> To: This list is for discussion about the SQR database reporting
> languagefrom Hyperion Solutions.
> Subject: Re: [sqr-users] Unix Sort...
>
> Send me some money and I'll send you the code.  I'll even throw in a
> bridge
> or two!
>
> ************************************************************
> "In the beginning, there was something...which exploded yet, they find
> nothing."
>
>
>
> ----- Original Message ----
> From: "Vaidyanathan, Ramakrishnan (GE, Corporate, consultant)"
> <ramakrishnan.vaidyanathan@ge.com>
> To: This list is for discussion about the SQR database
reportinglanguage
> from Hyperion Solutions. <sqr-users@sqrug.org>
> Sent: Friday, November 10, 2006 10:38:42 AM
> Subject: RE: [sqr-users] Unix Sort...
>
>
> poda goyale
>
> -----Original Message-----
> From: sqr-users-bounces+ramakrishnan.vaidyanathan=ge.com@sqrug.org
>
[mailto:sqr-users-bounces+ramakrishnan.vaidyanathan=ge.com@sqrug.org]On
> Behalf Of Bob Stone
> Sent: Friday, November 10, 2006 10:34 AM
> To: This list is for discussion about the SQR database reporting
> languagefrom Hyperion Solutions.
> Subject: RE: [sqr-users] Unix Sort...
>
>
> So if I have this analogy right, the pole is "google and SQRUG
archives"
> and the hook and line is 'CALL SYSTEM USING ***' ...what was the worm
> again?  maybe the MAN pages on Unix?
>
> Put them all together and now Ram can fish?  funny analogy.
>
> I agree with Clark and Richard.  Basically you're saying "well I've
> tried nothing and I'm all out of ideas."  Do some research with Google
> (great tool), the archives, some Unix documentation.  Most of your
> questions will probably answer themselves within a few hours. THEN if
> you get stuck or there's some related question once you get going
("what
> way is faster, has anybody done it this way, etc") then ask the group.
>
> Everyone joined this group to get help/tips on serious or tough
> questions, not to do someone else's work for them.
>
>
> -----Original Message-----
> From: sqr-users-bounces+bstone=fastenal.com@sqrug.org
> [mailto:sqr-users-bounces+bstone=fastenal.com@sqrug.org] On Behalf Of
> the dragon
> Sent: Friday, November 10, 2006 9:22 AM
> To: sqr-users@sqrug.org
> Subject: RE: [sqr-users] Unix Sort...
>
> search the sqrug archives for call system....   use the Unix man
> function
> for sort.... check the sqr language reference manual for call system
> using....
>
> There, I've taught you how to fish. :-D
>
> peace,
> clark 'the dragon' willis
>
>
> ----Original Message Follows----
>
> well..thats what iam also looking for...
>
> -----Original Message-----
>
> Better you should learn how to fish than merely get a fish, no?
>
> Do you have a unix command that does the sort you want?  This is where
I
> would start.
>
> Richard Knapp
> AITS - Reporting
> University of Missouri
> Locust Street Building
> Columbia, MO 65201
> 573-882-8856
> knappr@umsystem.edu
>
>
> -----Original Message-----
>
> Hi,
>
>     I want to sort a file using the unix sort command. I need to sort
a
> specific field alone. After sorting I need to write the sorted output
to
> another file.
> It would be gr8 if some one can give me a sample code in sqr to do
this.
>
> Thanks in Advance
> Ram
>
>
> _______________________________________________
> 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


If you have received this e-mail in error, please delete it and notify the 
sender as soon as possible. The contents of this e-mail may be confidential and 
the unauthorized use, copying, or dissemination of it and any attachments to 
it, is prohibited. Internet communications are not secure and Hyperion does 
not, therefore, accept legal responsibility for the contents of this message 
nor for any damage caused by viruses. The views expressed here do not 
necessarily represent those of Hyperion. For more information about Hyperion, 
please visit our Web site at: www.hyperion.com



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