Re: [sqr-users] (no subject)

[Arun Kumar <arunkumar13@yahoo.com>]

what is the error message?


----- Original Message ----
From: "Kaz.Narayanan@averydennison.com" <Kaz.Narayanan@averydennison.com>
To: Shashidhar Rao A <shdhra@yahoo.com>
Cc: sqr-users@sqrug.org
Sent: Tuesday, April 17, 2007 6:05:08 PM
Subject: Re: [sqr-users] (no subject)


Sashi,
Thanks for the correction. After placing the SQL, It is working. However, 
this line of SQL is still erroring out.. Could you please help?

BEGIN-SELECT
VMANA.AD_ACCOUNT_TREENOD,       &VMANA.AD_ACCOUNT_TREENOD,
SUM(VMANA.POSTED_TOTAL_AMT)     &VMANA.POSTED_AMOUNT_AM



        LET $THE_NODE = &VMANA.AD_ACCOUNT_TREENOD
        LET $POSTED_AMOUNT_AM = &VMANA.POSTED_AMOUNT_AM
        LET #POSTED_AMOUNT_AM = TO_NUMBER($POSTED_AMOUNT_AM)
        LET #ROUND_NBR    = EDIT((#POSTED_AMOUNT_AM/1000),'0000000000') 
        LET #SELECT_TOTAL = #SELECT_TOTAL +  #POSTED_AMOUNT_AM 
        LET #SELECT_ROUND = #SELECT_ROUND + #ROUND_NBR



FROM PS_AD_ADGLI003_WRK  VMANA
WHERE   VMANA.OPRID       =  $PRCS_OPRID
        AND VMANA.SEQ_NBR < 999999999 
        AND VMANA.RUN_CNTL_ID  = $PRCS_RUN_CNTL_ID
        AND VMANA.AD_PRODUCT_TREENOD = $REC_ENTITY
        AND 
SUBSTRING(VMANA.AD_ACCOUNT_TREENOD,1,LEN(VMANA.AD_ACCOUNT_TREENOD-1 )) IN 
('LNDOWN','LNDIMP','BLDOWN','BLDLSE','MCHOWN','MCHLSE','LSEIMP','CIP','CRPFA') 

        VMANA.PERIOD = 0 

GROUP BY VMANA.AD_ACCOUNT_TREENOD
END-SELECT


K.M.Narayanan
AVERY DENNISON
Corporate IT & Services
(702) 968-5727 -  Work
(702) 332-7118  -  Cell




Shashidhar Rao A <shdhra@yahoo.com>
04/17/2007 02:41 PM

        To:     Kaz.Narayanan@averydennison.com
        cc: 
        Subject:        Re: [sqr-users] (no subject)


Place the order by and group by clauses in the first column and
also try to check the values of $AND-CLAUSE and $IN_YEAR variables.

Regards,
shashi

Kaz.Narayanan@averydennison.com wrote:
Hello,

I posted this message yesterday.
Could some one help em here?

Thanks
Regards
KM Narayanan

Hello,

I am doing a select in an SQR where we use SQL server.
My codes is as follows:

BEGIN-SELECT
A.PRODUCT 
A.ACCOUNT 
A.DEPTID 
SUM(A.POSTED_TOTAL_AMT) &MAIN_POSTED_TOTAL_AMT

FROM PS_LEDGER A, PS_BUS_UNIT_TBL_GL A1
WHERE A.LEDGER IN ('ACTUALS','MGMT_ADJMT')
[$AND-CLAUSE]
AND A.FISCAL_YEAR = $IN_YEAR
AND A.ACCOUNTING_PERIOD [$WHERE_PERIOD] 
AND A.PRODUCT <> ' '
AND A.ACCOUNT <> ' '
AND A.BUSINESS_UNIT = A1.BUSINESS_UNIT
AND ((A.CURRENCY_CD = ' ' AND A.ACCOUNT LIKE '0%') 
OR (A.CURRENCY_CD = A1.BASE_CURRENCY)) 
GROUP BY A.PRODUCT,A.ACCOUNT,A.DEPTID 
ORDER BY A.PRODUCT,A.ACCOUNT,A.DEPTID 
END-SELECT



I get the following error when I try to execute....
SQR 5528) ODBC SQL dbftch error 3926 in cursor 30: [Microsoft][SQL Native 
Client][SQL Server]The transaction active in this session has been 
committed or aborted by another session. (SQR 5528) ODBC SQL dbftch error 
3971 in cursor 30: [Microsoft][SQL Native Client][SQL Server]Server failed 


to resume the transaction, desc: 7a00000004. Error on line 394: (SQR 3725) 


Bad return fetching row from database. 


I execute the same SQL in Microsoft SQL server studio, It works fine....
Can Someone help me?
Regards

K.M.Narayanan



- -----------------------------------------------------------------
The information transmitted is intended only for the person or entity to 
which it is addressed and may contain confidential and/or privileged 
material. Any review, retransmission, dissemination or other use of, or 
taking of any action in reliance upon, this information by persons or 
entities other than the intended recipient is prohibited. If you received 
this in error, please contact the sender and delete the material from any 
computer.

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

Ahhh...imagining that irresistible "new car" smell?
Check out new cars at Yahoo! Autos. 


--------------------------------
The information transmitted is intended only for the person or entity
to which it is addressed and may contain confidential and/or
privileged material. Any review, retransmission, dissemination or
other use of, or taking of any action in reliance upon, this
information by persons or entities other than the intended recipient
is prohibited. If you received this in error, please contact the
sender and delete the material from any computer.


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

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

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