Page 1 of 1

Regarding Native Stored Procedure - Input Data

PostPosted: Thu May 24, 2018 11:42 pm
by ramrajgkmf
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