Re: [sqr-users] SQR Using DB2

[harriaj@NU.COM]

> 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