Regarding Native Stored Procedure - Input Data



IBM's flagship relational database management system

Regarding Native Stored Procedure - Input Data

Postby ramrajgkmf » Thu May 24, 2018 11:42 pm

Hi,
I have input data like below
A|B|C|D

i need to split the data with the delimiter(|) and insert the data into DB2 table 4 times as we have 4 different values.

how can we achieve this using Native Stored Procedure (NSP)? In COBOLwe will with the Unstring function for this,in the same way do we have any function for this split-up? or is there any other alternate way that we can achieve this.

Regards,
Ram
ramrajgkmf
 
Posts: 2
Joined: Mon Sep 06, 2010 11:49 am
Has thanked: 0 time
Been thanked: 0 time

Return to DB2

 


  • Related topics
    Replies
    Views
    Last post