Re: [sqr-users] SQR Using DB2

["Manoj Singh" <singh_manoj@india.com>]

Thanx Andrew for the information
----- Original Message -----
From: harriaj@NU.COM
To: "This list is for discussion about the SQR database reporting language  
from Hyperion Solutions." <sqr-users@sqrug.org>
Subject: Re: [sqr-users] SQR Using DB2
Date: Wed, 8 Dec 2004 12:02:33 -0500

> 
> > I have worked on SQR with sql server .But in my new assignment I
> > have to work on SQR with DB2 which I haven't worked on so can you
> > help me how to go about it
> 
> You will find few differences between Sql Server development and
> DB2.  Some of the function syntax is different, of course.
> 
> > .client is also on Unix platform.
> > Do I need to create system DSN and connect it to sqr like we use to
> 
> I am not certain if Unix can even use ODBC.  I think I heard new
> versions can.  If there are not other SQR programmers at your site,
> your best bet is to talk to the DB2 devlopers or DBAs and ask them
> for an understanding of how to connect to the server in general.  You
> will be able to translate that for SQR.
> 
> > how to compile SQR in
> > UNIX as in Windows NT we use to execute using sqrw.exe and passing
> 
> SQR syntax is Unix syntax.  You will find few differences except on
> flags that database specific or windows specific.  Go here for more
> info: http://www.ontko.com/sqr/sqrcard6.html#SQR_COMMAND_LINE
> 
> You would be well-served to become friendly with a unix developer
> at your work.
> 
> Andrew :)
> Reporting Hero
> X 3523
> 
> 
> 
> 
> **********************************************************************
> This e-mail, including any files or attachments transmitted with 
> it, is confidential and intended for a specific purpose and for use 
> only by the individual or entity to whom it is addressed.  Any 
> disclosure, copying or distribution of this e-mail or the taking of 
> any action based on its contents, other than for its intended 
> purpose, is strictly prohibited.  If you have received this e-mail 
> in error, please notify the sender immediately and delete it from 
> your system.  Any views or opinions expressed in this e-mail are 
> not necessarily those of Northeast Utilities, its subsidiaries and 
> affiliates (NU).  E-mail transmission cannot be guaranteed to be 
> error-free or secure or free from viruses, and NU disclaims all 
> liability for any resulting damage, errors, or omissions.
> **********************************************************************
> 
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users

-- 
India.com free e-mail - www.india.com. 
Check out our value-added Premium features, such as an extra 20MB for mail 
storage, POP3, e-mail forwarding, and ads-free mailboxes!

Powered by Outblaze

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