469,299 Members | 2,069 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,299 developers. It's quick & easy.

Re: SQL0104N An unexpected token error

You should format your code to understand what you wrote as your code.
Following is my favolit way of formatting.
I found a syntax error in the SELECT list by looking into this
formatted code.
,tab3 as (
select k2.*
, value(at.odp_fee_am,0) as odp_fee_am
, value(at.odp_int_am,0) as odp_int_am
, value(at.tot_tracked_uloc_bp_trans_ct,0) as
tot_tracked_uloc_bp_trans_ct
, value(at.tot_tracked_uloc_bp_trans_am,0) as
tot_tracked_uloc_bp_trans_am
, value(at.tot_tracked_uloc_rp_trans_ct,0) as
tot_tracked_uloc_rp_trans_ct
, value(at.tot_tracked_uloc_rp_trans_am,0) as
tot_tracked_uloc_rp_trans_am
, value(at.tot_uloc_trans_am,0) as tot_uloc_trans_am
, value(at.tot_uloc_trans_ct,0) as tot_uloc_trans_ct
, value(at.tot_tracked_uloc_chq_trans_ct,0) as
tot_tracked_uloc_chq_trans_ct
, value(at.tot_tracked_uloc_chq_trans_am,0) as
tot_tracked_uloc_chq_trans_am
, value(tot_tracked_uloc_bp_trans_ct,0)
+ value(tot_tracked_uloc_rp_trans_ct,0)
+ value(tot_tracked_uloc_chq_trans_ct,0) as
total_tracked_uloc_tran_ct
, value(tot_tracked_uloc_bp_trans_am,0) as
tot_tracked_uloc_bp_trans_am
+ value(tot_tracked_uloc_rp_trans_am,0)
+ value(tot_tracked_uloc_chq_trans_am,0) as
total_tracked_uloc_tran_am
from tab2 k2
left join
cap_acct_trans_stage at
on k2.cust_id = at.cust_id
and k2.efectv_dt = at.efectv_dt
)
Oct 28 '08 #1
0 1952

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Breck Carter | last post: by
2 posts views Thread by Mark McNary via DBMonster.com | last post: by
1 post views Thread by vkalvakota | last post: by
4 posts views Thread by Justin | last post: by
1 post views Thread by Justin | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by harlem98 | last post: by
1 post views Thread by Geralt96 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.