Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Getting DSNE603E Error when running query in Spufi

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
karisurya

New User


Joined: 02 Aug 2007
Posts: 64
Location: Bangalore

PostPosted: Wed Feb 18, 2009 3:22 pm    Post subject: Getting DSNE603E Error when running query in Spufi
Reply with quote

Hi,
When i try to run the following query in SPUFI i am getting DSNE603E
INPUT STATEMENT HAS UNBALANCED APOSTROPHES error.

SELECT *
FROM DB2XXXX.TBL1111
WHERE CONCAT(S_TYPE,S_NO) IN ('T99268','F99267');

When i execute the same query in QMF i am not getting any issues and query getting executed.

Can any one help me solving this problem?

Thanks,
Surya
Back to top
View user's profile Send private message

aishwarya_20

New User


Joined: 19 Nov 2008
Posts: 57
Location: pune

PostPosted: Wed Feb 18, 2009 3:27 pm    Post subject:
Reply with quote

Try with
SELECT *
FROM DB2XXXX.TBL1111
WHERE CONCAT(S_TYPE,S_NO) IN (''T99268','F99267'');
OR

SELECT *
FROM DB2XXXX.TBL1111
WHERE CONCAT(S_TYPE,S_NO) IN ('T99268F99267');
Back to top
View user's profile Send private message
karisurya

New User


Joined: 02 Aug 2007
Posts: 64
Location: Bangalore

PostPosted: Wed Feb 18, 2009 3:34 pm    Post subject:
Reply with quote

Sorry aishwarya, It dint help in solving the problem.

Actually when i tried your query in QMF it is showing as error in sql query.

Thanks
Back to top
View user's profile Send private message
aishwarya_20

New User


Joined: 19 Nov 2008
Posts: 57
Location: pune

PostPosted: Wed Feb 18, 2009 3:40 pm    Post subject:
Reply with quote

Oh, Then i also don't have any other solution to run query in Spufi.
Back to top
View user's profile Send private message
aishwarya_20

New User


Joined: 19 Nov 2008
Posts: 57
Location: pune

PostPosted: Wed Feb 18, 2009 3:50 pm    Post subject:
Reply with quote

Hi,
I have got the solution.

You can use following query:-
SELECT *
FROM DB2XXXX.TBL1111
WHERE CONCAT(S_TYPE,S_NO) IN ('T99268F99267');
Back to top
View user's profile Send private message
karisurya

New User


Joined: 02 Aug 2007
Posts: 64
Location: Bangalore

PostPosted: Wed Feb 18, 2009 4:04 pm    Post subject:
Reply with quote

aishwarya_20 wrote:
Hi,
I have got the solution.

You can use following query:-
SELECT *
FROM DB2XXXX.TBL1111
WHERE CONCAT(S_TYPE,S_NO) IN ('T99268F99267');


Whats the difference between this query and 1st one you given(2nd part of 1st query)
Back to top
View user's profile Send private message
aishwarya_20

New User


Joined: 19 Nov 2008
Posts: 57
Location: pune

PostPosted: Wed Feb 18, 2009 4:06 pm    Post subject:
Reply with quote

I ran same type of query in spufi. It is working. For you also it should work.
Back to top
View user's profile Send private message
karisurya

New User


Joined: 02 Aug 2007
Posts: 64
Location: Bangalore

PostPosted: Wed Feb 18, 2009 4:18 pm    Post subject:
Reply with quote

Please let me know if any of you have any other suggestions?

Thanks
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Wed Feb 18, 2009 4:50 pm    Post subject:
Reply with quote

Surya,

Try this,
Code:
SELECT *
FROM DB2XXXX.TBL1111
WHERE CONCAT(STRIP(S_TYPE,both),strip(S_NO,both)) like 'T99268F99267';


It would be very helpful if you give sample data.

Sushanth Bobby
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts query to fetch record which has only ... maxsubrat DB2 12 Mon Dec 11, 2017 5:03 pm
No new posts How to query MAXGENS of an existing P... Chuchulo Hatyzak JCL & VSAM 4 Wed Nov 22, 2017 10:23 pm
No new posts Native SQL Query kishpra DB2 1 Wed Nov 22, 2017 8:38 pm
No new posts Query on IEFBR14 with GDG Ashishpanpaliya JCL & VSAM 4 Tue Nov 07, 2017 8:34 pm
No new posts -502 Error - Cursor already open anand jeyapaul DB2 7 Sun Oct 29, 2017 4:22 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us