Re: PeopleSoft SQR in DB2 env

[Bill Scollard <bill_scollard@TRANSCANADA.COM>]

I cannot assist with your SQL DB2 issue, but can point out that there may be some
issues at your site/computer related to dates as far as e-mail is concerned. It
appears that you mailed this dec 31 1969 @ 5:00PM

"Chi F. May" wrote:

> Need help!
> We are converting sqr programs from Oracle to DB2 environment:
> The code in Oracle is:
> BEGIN-SELECT
> TBL1.FLD1,
> TBL1.FLD2,
> $VAR_NAME,
> TBL1.FLD3
> FROM TBL1
> END-SELECT
>
> But the same code in DB2 will have error for $VAR_NAME as the following:
>
> (SQR 5528) DB2 SQL PREPARE/DECLARE error -418 in cursor 3:
>     DSNT408I SQLCODE = -418, ERROR:  A STATEMENT STRING TO BE PREPARED CONTAINS
>                          AN INVALID USE OF PARAMETER MARKERS
>     DSNT418I SQLSTATE   = 42610 SQLSTATE RETURN CODE
>     DSNT415I SQLERRP    = DSNXOOS SQL PROCEDURE DETECTING ERROR
>     DSNT416I SQLERRD    = -160  0  0  -1  0  0 SQL DIAGNOSTIC INFORMATION
>     DSNT416I SQLERRD    = X'FFFFFF60'  X'00000000'  X'00000000'  X'FFFFFFFF'
>                           X'00000000'  X'00000000' SQL DIAGNOSTIC
> Any solutions???

--
Bill Scollard
Systems Integrator
Gas Industry Systems FST
Rm 2414 TC-East
ph: (403)267-6379
fax (403)267-8773