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
 

 

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 Removing Duplicates based on certain ... chandracdac DFSORT/ICETOOL 8 Fri Dec 09, 2016 4:40 am
No new posts Limit duplicate records in the SORT pshongal SYNCSORT 6 Mon Nov 21, 2016 12:54 pm
No new posts How to split the records using the am... vnktrrd DFSORT/ICETOOL 24 Fri Oct 28, 2016 7:33 pm
No new posts Sort records based on numeric field. Alks SYNCSORT 2 Wed Oct 19, 2016 10:14 pm
No new posts abend sort based on count records in ... anatol DFSORT/ICETOOL 5 Mon Oct 17, 2016 10:10 pm


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