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 Check if any Detail records and extra... V S Amarendra Reddy SYNCSORT 19 Mon May 08, 2017 8:54 pm
No new posts Join giving more records than expected Danielle.Filteau SYNCSORT 2 Thu Mar 09, 2017 3:28 am
No new posts TSO or command line utility to genera... kishpra JCL & VSAM 3 Thu Mar 09, 2017 1:11 am
No new posts Extract set of records matching on ac... bhaskar_kanteti DFSORT/ICETOOL 3 Mon Mar 06, 2017 7:19 am
No new posts Inserting records based on conditions vickey_dw DFSORT/ICETOOL 9 Wed Feb 22, 2017 1:33 pm


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