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 Join in SQL Query vickey_dw DB2 2 Tue Jan 17, 2017 12:15 am
No new posts OO COBOL compile error Virendra Shambharkar COBOL Programming 3 Tue Jan 10, 2017 6:05 pm
This topic is locked: you cannot edit posts or make replies. MQ setup query mohitsaini Java & MQSeries 4 Sun Jan 08, 2017 1:53 am
No new posts DB2 query Using Recursion, Converting... smilewithashu2 DB2 1 Tue Jan 03, 2017 12:50 pm
No new posts SQL query to run through list of valu... Ni3-db2 DB2 14 Wed Dec 14, 2016 9:52 am


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