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
 

 

woking on a ims-db2 migration pgm

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
View previous topic :: :: View next topic  
Author Message
ashimer

Active Member


Joined: 13 Feb 2004
Posts: 551
Location: Bangalore

PostPosted: Fri Sep 24, 2004 9:02 am    Post subject: woking on a ims-db2 migration pgm
Reply with quote

I am woking on a ims-db2 migration pgm.
I am using the following query in my cursor


Select cols
From table
Where concat(key1,concat(key2,concat(key3,key4))) >= concat(:key1,concat(:key2,concat(:key3,:key4))) in pl1.
Can you plz suggest a better way so that I cud tune up my sql query.



thanks
ashish
Back to top
View user's profile Send private message

ovreddy

Active User


Joined: 06 Dec 2004
Posts: 211
Location: Keane Inc., Minneapolis USA.

PostPosted: Thu Dec 16, 2004 5:30 pm    Post subject: One way..
Reply with quote

Hi Ashish,

One way to combine more than two columns is you can use concatination operator ( || ) instead of CONCAT which is more compatible.

select cols from tab where col1 || col2 || col3 || col4 = :col1 || :col2 || :col3 || :col4;

Other wise you can create a function to do this...

Bye,
Reddy.
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 -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Db2 migration from V4/6 to V8/10 Venkatesh G DB2 1 Thu Jul 14, 2016 8:54 am
No new posts Data Migration from Fujitsu AIM/DB to... umakalikiri DB2 2 Fri Apr 15, 2016 12:26 pm
No new posts Fujitsu Cobol 85 to IBM Cobol (Any ve... umakalikiri COBOL Programming 4 Fri Apr 15, 2016 7:40 am
No new posts Natural/Adabas - Migration/Replatform Virendra Shambharkar Java & MQSeries 5 Tue Apr 05, 2016 2:37 pm
No new posts z/OS V2R2 Migration Impact on Existin... dexter.mozer All Other Mainframe Topics 4 Mon Feb 29, 2016 6:22 pm


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