View previous topic :: View next topic
|
Author |
Message |
karisurya
New User
Joined: 02 Aug 2007 Posts: 64 Location: Bangalore
|
|
|
|
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 |
|
|
aishwarya_20
New User
Joined: 19 Nov 2008 Posts: 57 Location: pune
|
|
|
|
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 |
|
|
karisurya
New User
Joined: 02 Aug 2007 Posts: 64 Location: Bangalore
|
|
|
|
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 |
|
|
aishwarya_20
New User
Joined: 19 Nov 2008 Posts: 57 Location: pune
|
|
|
|
Oh, Then i also don't have any other solution to run query in Spufi. |
|
Back to top |
|
|
aishwarya_20
New User
Joined: 19 Nov 2008 Posts: 57 Location: pune
|
|
|
|
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 |
|
|
karisurya
New User
Joined: 02 Aug 2007 Posts: 64 Location: Bangalore
|
|
|
|
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 |
|
|
aishwarya_20
New User
Joined: 19 Nov 2008 Posts: 57 Location: pune
|
|
|
|
I ran same type of query in spufi. It is working. For you also it should work. |
|
Back to top |
|
|
karisurya
New User
Joined: 02 Aug 2007 Posts: 64 Location: Bangalore
|
|
|
|
Please let me know if any of you have any other suggestions?
Thanks |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
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 |
|
|
|