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 Extracting DDL for all list of intere... Ashishpanpaliya DB2 5 Mon May 21, 2018 4:08 pm
No new posts Splitting one row into multiple Rows ... Rajan Moorthy DFSORT/ICETOOL 9 Mon May 14, 2018 10:58 pm
No new posts MXG - Processing Compressed DB2 SMF r... vasanthz All Other Mainframe Topics 2 Thu May 10, 2018 12:47 am
No new posts Extract the records with a PD field's... sudhakar84 DFSORT/ICETOOL 11 Mon Apr 02, 2018 7:26 pm
No new posts Merge 2 records sancraig16 SYNCSORT 19 Tue Mar 27, 2018 8:17 pm

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