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
 
Extracting National Character Records

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

New User


Joined: 21 Jun 2004
Posts: 33
Location: Andorra

PostPosted: Sun Sep 09, 2007 9:54 pm    Post subject: Extracting National Character Records
Reply with quote

I have to extract some records from around 400,000 records.

The condition is like :

the records which have National Characters only we need to retreive.

This record is 8 char field.The national characters can be at any position.

I tried LIKE statement which I got the result but the query is somewhat very long one and affecting the performance.

Could you please provide me simple query or any idea for this or any specific command is there.

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

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Sep 11, 2007 5:41 am    Post subject:
Reply with quote

Hello,

You could read the rows into some program code and parse the 8 bytes for the National Characters you are looking for.

Some things are better accomplished outside of SQL.

It might help if you clarify this
Quote:
somewhat very long one and affecting the performance.
What is "very long". What performance is being affected?
Back to top
View user's profile Send private message
Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA

PostPosted: Tue Sep 11, 2007 7:58 am    Post subject: Re: Extracting National Character Records
Reply with quote

sunojsm wrote:
I have to extract some records from around 400,000 records.

The condition is like :

the records which have National Characters only we need to retreive.

This record is 8 char field.The national characters can be at any position.

I tried LIKE statement which I got the result but the query is somewhat very long one and affecting the performance.

Could you please provide me simple query or any idea for this or any specific command is there.

Thanks
Sunoj


Instead of using LIKE try POSSTR or since the field is only 8 characters use SUBSTR to check each of the eight characters.
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 add sequence number for duplicate rec... SRUTHI DRAVIDAMANI COBOL Programming 10 Thu Feb 22, 2018 5:37 pm
No new posts how to add the amount for duplicate r... SRUTHI DRAVIDAMANI COBOL Programming 6 Wed Feb 21, 2018 7:21 pm
No new posts Merging records, but not all the time prino DFSORT/ICETOOL 17 Sat Feb 17, 2018 4:20 pm
No new posts Need all records with high key kalidasvs SYNCSORT 15 Fri Feb 09, 2018 10:38 pm
No new posts Why is SORT rearranging records that ... cschablow DFSORT/ICETOOL 4 Wed Jan 24, 2018 10:14 pm

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