[sqr-users] SQR for ODBC Connectivity

[Bill Beckner <Bbeckner@icc.edu>]

We have recently upgraded to PeopleSoft Financials 8.42 and I'm having a bit
of trouble getting an SQR that previously worked before.

I've got a procedure that needs to connect to a different DB2 database and
SQRW gives me the following error:

Error on line 107:
   (SQR 3730) Incorrect arguments for BEGIN-SQL:
 [-Cnn] [ON-ERROR=procedure[(arg1[,argi]...)]]
BEGIN-SQL -DBDSN=FS84TST;UID=xxxxxx;PWD=*******

I compared the SQR Help file for the new SQR version (SQR for Peoplesoft
V8.42) to the previous version (SQR V4.3.4) and there is no difference in
the -DB parameters.  Did Peoplesoft, in their infinite wisdom, disable this
functionality?  Or am I completely clueless and I'm missing something in the
-DB syntax?

Thank in advance!!!!

--
William Beckner -- Stunt Programmer (Just call me "Bill")
Illinois Central College, Rm L141 -- East Peoria, IL  61635-0001
PH: (309) 694-8419 -- FAX: (309) 694-8995
"There are 10 types of people in the world...those that know binary and
those that don't."

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