[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
- Subject: RE: [sqr-users] SQLBase SQLCOM error 6204
- From: <Rajib.Sengupta@conagrafoods.com>
- Date: Thu, 11 Mar 2004 11:40:24 -0600
- Cc:
- Delivery-date: Thu, 11 Mar 2004 12:41:26 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
- Thread-index: AcQHgJevDQXPpfE5SaqTGjoi+0RA/gADmLlg
- Thread-topic: [sqr-users] SQLBase SQLCOM error 6204
Thanks all.
We have solved it. The problem was not from DB2 connection- infact when you use
centura connection it goes via SQLBASE product to DB2.
What happened that while installing the new machines somehow one sqc which was
required for the database connection got deleted. We had put it back and
everything is working fine.
Rajib
-----Original Message-----
From: Suman Buddharaju [mailto:SBUDDHA@dot.state.tx.us]
Sent: Thursday, March 11, 2004 9:46 AM
To: Sengupta, Rajib (Contractor); 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