[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

RE: [sqr-users] SQLBase SQLCOM error 6204

Remove the comma after REPRINT_RUNCTL.RUN_CNTL_ID.

By the way, you are selecting the two columns whose values you already know
and use in the where clause.  Unless you just want to know whether the row
exists, you probably meant to select additional columns.

-----Original Message-----
From: Suman Buddharaju [mailto:SBUDDHA@dot.state.tx.us]
Sent: Thursday, March 11, 2004 7:46 AM
To: Rajib.Sengupta@conagrafoods.com; sqr-users@sqrug.org
Subject: Re: [sqr-users] SQLBase SQLCOM error 6204


Looks like the SQR you are using may not be the DB2 version of SQR.  For
some reason it is thinking
you are connecting to a SQLBase database.  In your SQR bin directory
there will be a file called 'version' .  
what does the file say.



>>> Rajib.Sengupta@conagrafoods.com 3/11/2004 9:36:39 AM >>>
Hello All,
We are running SQR V 4 on windows 2000 using centura connection to
connect to DB2 database. We are having a strange problem while trying to
run any sqr on a client machine in any new installation :
The error is as following from the sqrerr.log:

(SQR 5528) SQLBase SQLCOM error 6204 in cursor 1:
   A name is an undefined name

SQL: select REPRINT_RUNCTL.OPRID, REPRINT_RUNCTL.RUN_CNTL_ID,
     FROM PS_SS_RUN_REPRINT  REPRINT_RUNCTL WHERE
     REPRINT_RUNCTL.OPRID       = :1 AND   REPRINT_RUNCTL.RUN_CNTL_ID =
:2
     WITH UR 
Error at: select

Our SQR manual is not doing much help. They don't have anything about
the error 6204.

Please let me know whether any one of you have ever come accross this
error message.
Thanks,
Rajib

Rajib Sengupta
Systems Analyst and Team Lead
Peoplesoft Financial Consultant
Conagra Business Systems
Phone: 402-595-5749


_______________________________________________
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