Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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 Need DB2 query to fetch previous row ! Chandan1993 DB2 10 Sat Jun 03, 2017 10:43 am
No new posts DB2 Program abending without giving a... rahulgarg14 DB2 7 Mon May 29, 2017 8:10 pm
No new posts Getting error while opening a variabl... apandey1 COBOL Programming 5 Fri May 05, 2017 12:22 pm
No new posts Running an REXX EXEC implicitly sho7hills CLIST & REXX 3 Thu Apr 20, 2017 8:14 am
No new posts IDC2902I Error tzeche ABENDS & Debugging 2 Tue Mar 28, 2017 11:39 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us